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 Price

6beds

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

Single Family

Home type

333.46

Price / sqft

2006

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

Square Feet
  • 8346

Bedrooms
  • 6

Bathrooms
  • 8

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Baseboard

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    Yes

  • Fuel Type:

    Oil

Basement
  • Has Basement:

    No

  • Basement Type:

    Partial

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 130680

Water
  • No

Sewer
  • No

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    4

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • Yes

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • 2

Style
  • Conventional

Exterior
  • Brick

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • 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

percent-home-icon

Average Home Price in 45242

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$2,499,525

-- Beds

6 Baths

7,199 Sqft

129,286 Lot (sqft)

Sold 10/26/2026

$2,795,000

6 Beds

8 Baths

8,346 Sqft

130,680 Lot (sqft)

Sold 10/13/2026

$3,395,000

5 Beds

7 Baths

8,417 Sqft

130,724 Lot (sqft)

Sold 10/13/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
2,795,000
$
Down payment
559,000
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
16,770
$
HOA (Monthly)
0
$
PMI
0
$
$18,093
Your Payment
Total Monthly Payment:$18,093
Percent of Income:310%
Affordable:No

Details for 5 STONE SNAIL LN

Property Debt

Foreclosure Contact Details