Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$2,795,000
Listing Price6beds
8baths
8,346sqft
130,680sqft lot
5 Stone Snail Ln, Cincinnati, OH 45242
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
Beautiful custom built home privately situated on 3 acre wooded lot in Indian Hill with multi-generational floor plan, 16.28 kW solar system, whole house audio system, professional landscaping, 3 new HVAC systems, new paint, flooring and light fixtures throughout, walking path, storage shed, and finished walk-out lower level. First floor features formal study with 14' ceiling, and built in bookcases, formal living room with 15' ceiling and gas fireplace, formal dining room with butler's pantry and wainscoting, gourmet eat-in kitchen with high end appliances and granite counter tops, family room with 12' coffered ceiling, wet bar and gas fireplace, 14 x 18 solarium with 14' cathedral ceiling and gorgeous view, and primary suite with 12' ceiling, luxury bath and walk-in closet. 2nd floor features 3 bedrooms, 3 full bathrooms and loft area. Finished LL features bar area, family room, office, bedroom, bathroom, exercise room and guest suite with full bath, kitchen and access to garage.
Interior Details
8346
6
8
Has Heating:
Yes
Heating Type:
Baseboard
Has Cooling:
Yes
Cooling Type:
Central
Has Fuel:
Yes
Fuel Type:
Oil
Has Basement:
No
Basement Type:
Partial
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
130680
No
No
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
4
No
No
No
No
Yes
No
No
Construction Details
Conventional
Brick
N/A
N/A
N/A
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2019
$23,971
$193,200
$412,650
--%
$605,850
2018
$24,019
$193,200
$412,650
--%
$605,850
2017
$22,843
$193,200
$412,650
--%
$605,850
2016
$20,023
$201,663
$326,750
--%
$528,413
2015
$20,102
$201,663
$326,750
--%
$528,413
2013
$20,907
$203,700
$330,050
--%
$533,750
2012
$20,892
$203,700
$330,050
--%
$533,750
Average Home Price in 45242
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$2,499,525
$2,499,525
-- Beds
6 Baths
7,199 Sqft
129,286 Lot (sqft)
Sold 10/26/2026
$2,795,000
$2,795,000
6 Beds
8 Baths
8,346 Sqft
130,680 Lot (sqft)
Sold 10/13/2026
$3,395,000
$3,395,000
5 Beds
7 Baths
8,417 Sqft
130,724 Lot (sqft)
Sold 10/13/2026





