Spacious 4 Bedroom home with full finished basement includes: wet bar, rec room, theater room, bedroom & full bath and plenty of storage space. 2 story great room with fireplace, formal dining & living, sun room and office on main level. Kitchen with 42" cabinets, center island and breakfast area. Master suite has large sitting area, walk-in closet and private bath. Home sits on neighborhood trail with community pool and amenities near by. Golf course community. Riviera collection series.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
4
Baths
3.5
Stories
2
Lot width
90 ft.
Lot depth
120 ft.
Lot size
0.25 Acres
Year renovated
2003
Sq. Ft.
5,763
Year built
2003
Style
Single Family Residential
County
Hamilton County
APN
291103001018000022
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
R1/PD
Low Density Single Family Residential-Planned Development Overlay District
Low Density Single Family Residential: The purpose of the R-1 District is to permit the establishment of moderate low density single family residential areas.; Planned Development Overlay: This district is intended to provide flexibility in specific locations for development that is in the public interest and would not otherwise be permitted pursuant to this ordinance. Such flexibility is provided to achieve certain comprehensive plan policies, accommodate rapid changes in design and technology in the construction industry, and address new and varied demands in the housing and commercial markets, all in a manner that will be consistent with the objectives of the City and the Townships. Encourage a more creative approach in land and building site planning. Encourage an efficient, aesthetic, and desirable use of open space. Promote variety in the physical development pattern of the community. Achieve flexibility and provide incentives for development that will produce a wider range of choice in satisfying the changing urban needs. Encourage renewal of older areas where new development and restoration are needed to revitalize the area. Permit special consideration of property with unique features, such as historical significance, unusual topography, landscape amenities, size, and shape. Recapture bypassed land so poorly planned and developed as to be a public liability. Simplify processing of development proposals for developers and the Commission by providing for concurrent review of land use, subdivision, public improvements and site considerations.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Housing-Senior
Office
Public service
Fire house
Police station
Post office
Cemetery
Park & open space
Sep 16, 2003 • Final
Sewer connection conversion - residential
Plumbing
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Information
Parking Features: Attached, Concrete, Garage Door Opener
Garage Spaces: 3
Has Garage
Interior
Virtual Tour
Interior Sq. Ft. Information
Building Area Total: 5392
Living Area: 3482
Main Level Sq. Ft.: 1910
Upper Level Sq. Ft.: 1572
Lower/Basement Level Sq. Ft (Finished): 1719
Bedroom Information
Primary Bedroom Description: Sinks Double,Tub Full with Separate Shower,Sitting Room,Suite,Closet Walk in
Interior Features: Attic Access, Built In Book Shelves, Raised Ceiling(s), Vaulted Ceiling(s), Walk-in Closet(s), Wood Work Painted, Pantry, Wet Bar
Appliances: Dishwasher, Disposal, MicroHood, Electric Oven, Refrigerator, Gas Water Heater, Water Softener Owned
Areas Interior: Great Room - 2 Story
Exterior
Building Information
Percent Optional Level Finished: 75+%
Exterior Features
Patio And Porch Features: Deck Main Level, Covered Porch
Pool Information
Pool Features: Community, Association
Property Information
Ownership Interest Types: Mandatory Fee
Other Equipment: Security Alarm Paid, Smoke Alarm, Theater Equipment
Property Type: Residential
Property Sub Type: Single Family Residence
Land Information
Acres: 1/4-1/2 Acre
Lot Information
Lot Size Acres: 0.25
Lot Features: On Trail, Sidewalks
Utilities
Utility Information
Utility Prim Sewage Disp: Municipal Sewer Connected
Water Source: Municipal/City
Utilities: Cable Connected, Gas Nearby
Solid Waste Information: No
Location
HOA Information
Has HOA
Association Fee: $550
Association Fee Frequency: Semi-Annually
Association Fee Includes: Association Home Owners, Clubhouse, Exercise Room, Insurance, Nature Area, ParkPlayground
School Information
High School District: Hamilton Southeastern Schools
Location Information
Directions: North on SR 37, East on SR 32, SE on SR 38 to community on right. Enter on Long Creek, left on Babbling Brook to home. Just a few minutes from Geist!
Tax Legal Description: HIGHLANDS AT STONY CREEK
Public facts
Beds: 4
Baths: 3.5
Sq. Ft.: 5,763
Stories: 2.0
Lot Size: 0.25 acres
Style: Single Family Residential
Year Built: 2003
Year Renovated: 2003
County: Hamilton County
APN: 291103001018000022
Home facts updated by county records on Sep 16, 2026