Seller's Agent in 2025
Kelly Kryder
Howard Hanna SB Real Estate
(574) 707-0131
49 in this area
109 Total Sales
17540 Dublin Dr Granger, IN 46530
Estimated Value: $2,229,992 - $3,343,000
5
Beds
8
Baths
12,334
Sq Ft
$243/Sq Ft
Est. Value
Highlights
- Fitness Center
- Gated Community
- Fireplace in Bedroom
- Adams High School Rated A-
- 2.66 Acre Lot
- Partially Wooded Lot
About This Home
As of June 2025Step into over 12,000 sq. ft. of custom luxury nestled in the highly sought gated community of Shamrock Hills.This home exudes timeless elegance and modern comforts.The grand foyer welcomes you to this expansive open-concept living space, drenched in natural light. The remarkable living room showcases one of the eight meticulously crafted fireplaces throughout the home.The adjacent gourmet kitchen boasts top-of-the-line appliances, adorned with luxurious marble countertops, butler pantry, and features a cozy hearth room.Five well-appointed bedrooms, including two luxurious primary suites with spa-like ensuite bathrooms.The home office boasts 18' ceilings that includes floor to ceiling windows.The walk out lower level includes a sleek wet bar, your very own theater room, well-appointed wine cellar, home gym, hearth room and two baths. A stunning pool, outdoor covered kitchen, expansive stone patio, fireplace and outdoor TVs ensure entertainment is always at your fingertips.
Last Agent to Sell the Property
Howard Hanna SB Real Estate Brokerage Phone: 574-207-7777 Listed on: 06/02/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $20,879
Year Built
- Built in 2000
Lot Details
- 2.66 Acre Lot
- Lot Dimensions are 429x280
- Property has an invisible fence for dogs
- Landscaped
- Level Lot
- Irrigation
- Partially Wooded Lot
HOA Fees
- $239 Monthly HOA Fees
Parking
- 5 Car Attached Garage
- Driveway
Home Design
- Brick Exterior Construction
- Limestone
Interior Spaces
- 2-Story Property
- Wet Bar
- Built-In Features
- Bar
- Tray Ceiling
- Cathedral Ceiling
- Living Room with Fireplace
- Dining Room with Fireplace
- 8 Fireplaces
- Pull Down Stairs to Attic
- Laundry on main level
Kitchen
- Breakfast Bar
- Kitchen Island
Flooring
- Wood
- Carpet
- Stone
- Slate Flooring
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Bedroom
- Split Bedroom Floorplan
- En-Suite Primary Bedroom
- Whirlpool Bathtub
- Steam Shower
Finished Basement
- Walk-Out Basement
- Fireplace in Basement
- Stone or Rock in Basement
- 2 Bathrooms in Basement
Outdoor Features
- Balcony
- Covered Patio or Porch
Schools
- Swanson Elementary School
- Edison Middle School
- Clay High School
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Private Company Owned Well
- Well
- Septic System
Listing and Financial Details
- Assessor Parcel Number 71-04-17-179-002.000-003
Community Details
Overview
- Shamrock Hills Subdivision
Amenities
- Community Fire Pit
- Elevator
Recreation
- Fitness Center
- Community Pool
Security
- Gated Community
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jun 2, 2025
Closed on
May 29, 2025
Sold by
Sharon L Bohn 2011 Revocable Trust and Bohn Kevin J
Bought by
Sumrall Andrew
Seller's Agent
Kelly Kryder
Howard Hanna SB Real Estate
Buyer's Agent
Stephen Bizzaro
Howard Hanna SB Real Estate
List Price
$3,150,000
Sold Price
$3,150,000
Views
10
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$157,577
Avg. Annual Appreciation
-5.00%
Original Mortgage
$2,520,000
Outstanding Balance
$2,500,257
Interest Rate
6.81%
Mortgage Type
New Conventional
Estimated Equity
$501,491
Purchase Details
Closed on
May 11, 2012
Sold by
Bohn Kevin J and Bohn Sharon L
Bought by
Sharon L Bohn 2011 Revocable Trust
Purchase Details
Closed on
Mar 27, 2012
Sold by
Sharon L Bohn Trust
Bought by
Bohn Kevin J and Bohn Sharon L
Purchase Details
Closed on
May 6, 2011
Sold by
Bohn Kevin J and Bohn Sharon L
Bought by
Bohn Trust
Purchase Details
Closed on
Feb 4, 2011
Sold by
Bohn Kevin J and Bohn Sharon L
Bought by
Bohn Sharon L and The Sharon L Bohn 2011 Revocable Trust
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
Average Home Value in this Area
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sumrall Andrew | -- | Meridian Title | |
| Sharon L Bohn 2011 Revocable Trust | -- | None Available | |
| Bohn Kevin J | -- | -- | |
| Bohn Trust | -- | -- | |
| Bohn Kevin J | -- | Metropolitan Title In Llc | |
| Bohn Sharon L | -- | None Available |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Sumrall Andrew | $2,520,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 06/02/2025 06/02/25 | Sold | $3,150,000 | 0.0% | $255 / Sq Ft |
| 06/02/2025 06/02/25 | Pending | -- | -- | -- |
| 06/02/2025 06/02/25 | For Sale | $3,150,000 | -- | $255 / Sq Ft |
Source: Indiana Regional MLS
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 |
|---|---|---|---|---|
| 2025 | $24,811 | $2,999,700 | $261,200 | $2,738,500 |
| 2024 | $30,885 | $1,981,200 | $261,200 | $1,720,000 |
| 2023 | $30,837 | $3,209,000 | $906,600 | $2,302,400 |
| 2022 | $22,842 | $1,726,900 | $351,400 | $1,375,500 |
| 2021 | $20,879 | $1,559,800 | $60,800 | $1,499,000 |
| 2020 | $19,531 | $1,454,900 | $55,900 | $1,399,000 |
| 2019 | $15,716 | $1,478,200 | $56,200 | $1,422,000 |
| 2018 | $19,815 | $1,501,700 | $49,400 | $1,452,300 |
| 2017 | $20,521 | $1,479,800 | $49,400 | $1,430,400 |
| 2016 | $31,183 | $2,193,300 | $44,100 | $2,149,200 |
| 2014 | $15,229 | $1,109,000 | $31,800 | $1,077,200 |
Source: Public Records
Agents Affiliated with this Home
-
Kelly Kryder
-
Stephen Bizzaro
Buyer's Agent in 2025
Stephen Bizzaro
Howard Hanna SB Real Estate
(574) 207-7777
81 in this area
304 Total Sales
Map
Source: Indiana Regional MLS
MLS Number: 202520631
APN: 71-04-17-179-002.000-003
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Based on information submitted to the MLS GRID
Nearby Homes
- 51527 Summer Hill Dr
- 51132 Pheasant Run Dr
- 51479 Ironwood Rd
- 17202 Pencross Dr
- 18008 Erin Ct
- 29929 Ridge Cove
- 18146 Lisbon Dr
- 51181 Kerry Glen Dr
- 17768 Ashford Hills Ct
- 17652 Village Trace Ct
- 18101 Burton Dr
- 18316 Munich Ponds Dr
- 51321 Hidden Pines Ct
- 18350 Brussels Dr
- 17343 Turnbury Ct
- 50670 Tarrington Way
- 18335 Donegal Dr
- 18416 Donegal Dr
- 17925 Buckland Dr
- 50513 Mercury Dr
- 17480 Dublin Dr
- 17580 Saint Patricks Ct
- 17535 Dublin Dr
- 17575 Dublin Dr Unit 49
- 51301 Shamrock Hills Dr
- 17686 Saint Patricks Ct
- 51445 Shamrock Hills Dr
- 17635 Saint Patrick Ct
- 17635 Saint Patricks Ct
- 17683 Saint Patricks Ct
- 51310 Shamrock Hills Dr
- 51231 Shamrock Hills Dr
- 17675 Saint Patricks Ct
- 17683 Saint Patrick Ct
- 17530 Dannybrook Dr
- 17690 Saint Patricks Ct
- 17689 St Patricks Ct
- 51481 Shamrock Hills Dr
- 17689 Saint Patricks Ct
- 17640 Dannybrook Dr
Your Personal Tour Guide
Ask me questions while you tour the home.