NOT LISTED FOR SALE

51116 Shamrock Hills Ct Granger, IN 46530

Estimated Value: $1,567,000 - $1,674,399

6 Beds
7 Baths
7,581 Sq Ft
$213/Sq Ft Est. Value

Last Sold January 10, 2024

Last sale price $1,500,000 $198 Per Sq Ft

Est. 8% increase in value since last sale

Current estimated payment $10,337/month

301 Days on Market

Highlights

  • 141 Feet of Waterfront
  • 2.59 Acre Lot
  • Lake Property
  • Gated Community
  • Open Floorplan
  • Fireplace in Bedroom

About This Home

As of January 2024

Discover the Epitome of Luxury Living in Shamrock Hills Upscale Gated Granger Subdivision.This Dreamy Custom English Tudor Home is Timeless & Thoughtfully Designed. Offering Exceptional One-Of-A Kind Exterior & Interior Amenities, Boasting 6 Bedroom,7 Bathrooms,5 Fireplaces & Finished Walk-Out Lower Level! Nestled on an Exquisite 2.59 Acre Waterfront Cul-de-sac lot. The Manicured Yard,Tranquil Patio & Firepit is Surrounded by Colorful Seasonal Plantings that Create this Enchanting Atmosphere & Perfect Outdoor Entertining! Artisan patterened all Brick Exterior,Slate roof. Grand Foyer. This Exquisite Property Delivers today's "MUST HAVES" Spacious Rooms and High Ceilings on each Floor. Captivating Sunsets from Welcoming rooms-Glorious Kitchen -Stunning Dining Room,Great Room flows to the 4 Season Sunroom w/ Wet Bar opens to the Office/Den thru Spectacular 9 ft Rosewood Leaded Glass Antique doors! Luxurious Primary Suite! Show Case Living Room. The Lower Level Walk-out features Familyroom,Craftroom/6th Ensuite & Irish Pub & Kitchenette,Gym,Game Room.Summer Fun in the Gazebo w/Cable & Electric!. Only Minutes to Notre Dame & All Services

Last Agent to Sell the Property

Bobbie Vanosdal

Weichert Rltrs-J.Dunfee&Assoc. Listed on: 10/13/2022

Weichert Rltrs-J.Dunfee&Assoc.

Last Buyer's Agent

Kelly Kryder

Howard Hanna SB Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $19,930

Year Built

  • Built in 1997

Lot Details

  • 2.59 Acre Lot
  • Lot Dimensions are 141 x 432
  • 141 Feet of Waterfront
  • Backs to Open Ground
  • Cul-De-Sac
  • Property has an invisible fence for dogs
  • Level Lot
  • Irrigation

HOA Fees

  • $229 Monthly HOA Fees

Parking

  • 4 Car Attached Garage
  • Heated Garage
  • Circular Driveway

Home Design

  • Tudor Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Slate Roof
  • Limestone

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Built-in Bookshelves
  • Built-In Features
  • Bar
  • Chair Railings
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Tray Ceiling
  • Vaulted Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Double Pane Windows
  • Insulated Windows
  • Pocket Doors
  • Entrance Foyer
  • Great Room
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • 5 Fireplaces
  • Formal Dining Room
  • Water Views
  • Home Security System
  • Laundry on main level

Kitchen

  • Kitchenette
  • Eat-In Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Kitchen Island
  • Stone Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Disposal

Flooring

  • Wood
  • Carpet
  • Stone
  • Slate Flooring
  • Ceramic Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Bedroom
  • En-Suite Primary Bedroom
  • Cedar Closet
  • Walk-In Closet
  • Jack-and-Jill Bathroom
  • In-Law or Guest Suite
  • Double Vanity
  • Whirlpool Bathtub
  • Bathtub With Separate Shower Stall

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Fireplace in Basement
  • 1 Bathroom in Basement
  • 1 Bedroom in Basement
  • Natural lighting in basement

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Energy-Efficient Insulation
  • Energy-Efficient Thermostat

Outdoor Features

  • Sun Deck
  • Lake Property
  • Lake, Pond or Stream
  • Enclosed Patio or Porch

Location

  • Suburban Location

Schools

  • Darden Primary Center Elementary School
  • Edison Middle School
  • Clay High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • High-Efficiency Furnace
  • Heating System Uses Gas
  • Generator Hookup
  • Private Company Owned Well
  • Well
  • Septic System
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 71-04-17-203-002.000-003

Community Details

Overview

  • Shamrock Hills Subdivision

Additional Features

  • Community Fire Pit
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$19,930

Year Built

Built in 1997

Lot Details

0

HOA Fees

$229 per month

Parking

4

Listing Details

  • Class: RESIDENTIAL
  • Property Sub Type: Site-Built Home
  • Waterfront: Yes
  • Year Built: 1997
  • Age: 26
  • Style: Two Story
  • Architectural Style: Tudor
  • Total Number of Rooms: 15
  • Total Number of Rooms Below Grade: 5
  • Bedrooms: 6
  • Number Above Grade Bedrooms: 5
  • Total Bathrooms: 7
  • Total Full Bathrooms: 5
  • Total Number of Half Bathrooms: 2
  • Legal Description: SHAMROCK HILLS PHASE TWO SEC ONE LOT 17 |
  • Parcel Number ID: 71-04-17-203-002.000-003
  • Platted: Yes
  • Amenities: 1st Bdrm En Suite, Alarm System-Security, Bar, Breakfast Bar, Built-In Speaker System, Built-In Bookcase, Built-in Desk, Cable Ready, Ceiling-9+, Ceiling-Tray, Ceiling Fan(s), Ceilings-Beamed, Ceilings-Vaulted, Chair Rail, Closet(s) Cedar, Closet(s) Walk-in, Countertops-Stone, Crown Molding, Deck Open, Deck on Waterfront, Disposal, Eat-In Kitchen, Firepit, Foyer Entry, Jet Tub, Generator Ready, Guest Quarters, Irrigation System, Kitchen Island, Natural Woodwork, Open Floor Plan, Pantry-Walk In, Patio Covered, Patio Open, Pocket Doors, Porch Enclosed, Porch Florida, Six Panel Doors, Twin Sink Vanity, Utility Sink, Wet Bar, Kitchenette, Stand Up Shower, Tub and Separate Shower, Tub/Shower Combination, Formal Dining Room, Garage-Heated, Great Room, Main Floor Laundry, Custom Cabinetry, Jack & Jill Bath
  • Cross Street: Dublin Dr.
  • Improvmnts In Last5 Yrs: Yes
  • Location: City/Town/Suburb, Lake, Near College Campus, Gated Community
  • Number Below Grade Bedrooms: 1
  • Sp Lp Percent: 85.71
  • County Zoning: Unknown
  • Year Taxes Payable: 2022 pay 2023
  • Special Features: None
  • Stories: 2

Interior Features

  • Total Sq Ft: 9359
  • Total Finished Sq Ft: 7581
  • Above Grade Finished Sq Ft: 5611
  • Below Grade Finished Sq Ft: 1970
  • Above Grade Unfinished Sq Ft: 754
  • Below Grade Sq Ft: 1024
  • Price Per Sq Ft: 267.33
  • Basement: Yes
  • Basement Foundation: Daylight, Full Basement, Walk-Out Basement, Finished
  • Basement Material: Poured Concrete
  • Number Of Fireplaces: 5
  • Fireplace: Dining Rm, Family Rm, Living/Great Rm, Rec Rm, 1st Bdrm, Gas Log, Wood Burning, Basement, Three +, Gas Starter
  • Fireplace: Yes
  • Flooring: Hardwood Floors, Carpet, Slate, Tile, Stone, Ceramic Tile
  • Living Great Room: Dimensions: 18x14, On Level: Main
  • Kitchen: Dimensions: 20x17, On Level: Main
  • Breakfast Room: Dimensions: 13x11, On Level: Main
  • Dining Room: Dimensions: 18x14, On Level: Main
  • Family Room: Dimensions: 22x19, On Level: Main
  • Den: Dimensions: 20x13, On Level: Main
  • Recreation Room: Dimensions: 26x15, On Level: Lower
  • Extra Room: Irish Pub, Dimensions: 25x17, On Level: Lower
  • Bedroom 1: Dimensions: 19x20, On Level: Upper
  • Bedroom 2: Dimensions: 13x12, On Level: Upper
  • Bedroom 3: Dimensions: 17x12, On Level: Upper
  • Bedroom 4: Dimensions: 16x14, On Level: Upper
  • Bedroom 5: Dimensions: 17x12, On Level: Upper
  • Other Room1: Conservatory /Sunroom, Dimensions: 19x17, On Level: Lower
  • Other Room 2: 6th Bedroom-Hobby, Dimensions: 20x14, On Level: Lower
  • Other Room 3: Gym, Dimensions: 13x11, On Level: Lower
  • Main Level Sq Ft: 3114
  • Number Below Grade Bathrooms: 1
  • Number of Below Grade Full Bathrooms: 1
  • Number of Main Level Half Bathrooms: 2
  • Total Below Grade Sq Ft: 2994

Exterior Features

  • Exterior: Brick, Limestone
  • Roof Material: Slate
  • Outbuilding1: None
  • Fence: Invisible
  • Water Frontage: 141
  • Water Name: Shamrock Lake

Garage/Parking

  • Driveway: Circular, Concrete
  • Garage Type: Attached
  • Garage Number Of Cars: 4
  • Garage Size: Dimensions: 37x53
  • Garage Sq Ft: 1961
  • Garage: Yes

Utilities

  • Cooling: Central Air
  • Heating Fuel: Gas, Forced Air
  • Sewer: Septic
  • Water Utilities: Well
  • Hvac: Ceiling Fan, High Efficiency Furnace, Zoned Air Condtioning, Zoned Heating
  • Laundry: Dimensions: Mainx7, On Level: 9
  • Water Type: Lake
  • Well Size: 4 Inches
  • Well Type: Private

Condo/Co-op/Association

  • Association Restrictions: Yes
  • Association Fees: 2749
  • Association Fees Frequency: Annually

Schools

  • School District: South Bend Community School Corp.
  • Elementary School: Darden Primary Center
  • Middle School: Edison
  • High School: Clay
  • Elementary School: Darden Primary Center

Lot Info

  • Lot Description: Cul-De-Sac, Level, Waterfront, 0-2.9999, Lake, Water View, Waterfront-Level Bank
  • Lot Dimensions: 141 x 432
  • Estimated Lot Sq Ft: 112820
  • Estimated Lot Size Acres: 2.59
  • Lot Number: 17

Green Features

  • Energy Efficient: HVAC, Insulation, Thermostat/Controllers
  • Energy Efficient Windows/Doors: Double Pane Windows, Insulated Glass Windows

Tax Info

  • Annual Taxes: 19930.44
  • Total Assessed Value: 1544600
  • Exemptions: Homestead, Supplemental
  • Tax Code: Tax Code 02-Clay

Multi Family

  • Water Access: Frontage Lot

MLS Schools

  • High School: Clay
  • Middle School: Edison
  • School District: South Bend Community School Corp.

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 13, 2022
Closed on
Feb 1, 2024
Sold by
Rozzi William B and Rozzi Lora R
Bought by
Bevacqua Peter P and Bevacqua Tiffany
Seller's Agent
Bobbie Vanosdal
Weichert Rltrs-J.Dunfee&Assoc.
Buyer's Agent
Kelly Kryder
Howard Hanna SB Real Estate
List Price
$1,750,000
Sold Price
$1,500,000
Premium/Discount to List
-$250,000
-14.29%
Views
898
Current Estimated Value
$1,616,800

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$116,800
Avg. Annual Appreciation
4.46%

Purchase Details

Listed on
Oct 13, 2022
Closed on
Jan 8, 2024
Sold by
Rozzi William B and Rozzi Lora R
Bought by
Bevacqua Peter P and Bevacqua Tiffany
Seller's Agent
Bobbie Vanosdal
Weichert Rltrs-J.Dunfee&Assoc.
Buyer's Agent
Kelly Kryder
Howard Hanna SB Real Estate
List Price
$1,750,000
Sold Price
$1,500,000
Premium/Discount to List
-$250,000
-14.29%
Views
898
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Bevacqua Peter P $1,500,000 Metropolitan Title
Bevacqua Peter P -- Metropolitan Title
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/10/2024 01/10/24 Sold $1,500,000 -14.3% $198 / Sq Ft
08/10/2023 08/10/23 Pending -- -- --
10/13/2022 10/13/22 For Sale $1,750,000 -- $231 / Sq Ft
Source: Indiana Regional MLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $18,428 $1,489,200 $267,400 $1,221,800
2023 $18,380 $1,453,300 $260,100 $1,193,200
2022 $19,930 $1,544,600 $267,400 $1,277,200
2021 $18,398 $1,426,900 $49,300 $1,377,600
2020 $16,881 $1,311,600 $45,300 $1,266,300
2019 $13,400 $1,319,100 $45,500 $1,273,600
2018 $16,917 $1,322,200 $45,500 $1,276,700
2017 $17,911 $1,331,900 $45,500 $1,286,400
2016 $18,430 $1,347,900 $45,500 $1,302,400
2014 $12,903 $956,000 $32,800 $923,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Indiana Regional MLS

MLS Number: 202242640

Indiana Regional MLS

APN: 71-04-17-203-002.000-003