Wonderful home on premium lot w/ beautiful views. Open floor plan w/ 9ft clngs, hardwood floors and double staircase. Large gourmet kitchen w/ granite, 42-inch cabinets, double ovens and gas cooktop. Family room features fireplace, built-in speakers and lots of windows overlooking huge lot & common area. 4 large bedrooms & 3 full baths w/tons of closet space. Huge fenced-in lot, large deck w/ built-in seating, irrigation system, 3 car garage, beautiful landscaping. Home is move-in ready!
*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
Beds
3
Baths
4.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.34 Acres
Year renovated
2007
Sq. Ft.
3,770
Year built
2007
Style
Single Family Residential
County
Hamilton County
APN
290919001060000018
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
S-1
Residence District
The purpose of the S1 District is to provide for the development of innovative residential environments in keeping with the rural character of this district, by providing for a development process that allows a high degree of flexibility in the design of single-family subdivisions. Further, it is the purpose of this district to provide for a development process that allows for more efficient use of the land through the introduction of open space and conservation lands within subdivisions. It is the intention of this district to protect remaining significant natural features within this district by placing an emphasis on less intensive urban land uses.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Infrastructure
Park & open space
Property details
Parking
Parking Information
Parking Features: Attached
Garage Spaces: 3
Has Garage
Interior
Interior Sq. Ft. Information
Building Area Total: 5030
Living Area: 3324
Main Level Sq. Ft.: 1706
Upper Level Sq. Ft.: 1618
Lower/Basement Level Sq. Ft (Finished): 0
Bedroom Information
Primary Bedroom Description: Sinks Double,Tub Full with Separate Shower,Sitting Room,Closet Walk in,Tub Whirlpool
# of Upper Bedrooms: 4
Beds MU: 4
Bedrooms MU: 4
Bathroom Information
# of Full Baths (Total): 3
# of Half Baths (Total): 2
# of Full Baths (Upper): 3
# of Half Baths (Main): 2
Half Baths MU: 2
Half Bathrooms MU: 2
Full Baths MU: 4
Full Bathrooms MU: 3
Room 1 Information
Room Type: Library
Room Features: Hardwood
Room Dimensions: 13x13
Room Level: Main
Room 2 Information
Room Type: Bedroom 2
Room Features: Carpet
Room Dimensions: 12x12
Room Level: Upper
Room 3 Information
Room Type: Bedroom 3
Room Features: Carpet
Room Dimensions: 13x11
Room Level: Upper
Room 4 Information
Room Type: Bedroom 4
Room Features: Carpet
Room Dimensions: 11x11
Room Level: Upper
Room 5 Information
Room Type: Breakfast Room
Room Features: Hardwood
Room Dimensions: 13x09
Room Level: Main
Room 6 Information
Room Type: Dining Room
Room Features: Hardwood
Room Dimensions: 13x11
Room Level: Main
Room 7 Information
Room Type: Family Room
Room Features: Hardwood
Room Dimensions: 20x17
Room Level: Main
Room 8 Information
Room Type: Kitchen
Room Features: Hardwood
Room Dimensions: 13x10
Room Level: Main
Room 9 Information
Room Type: Living Room
Room Features: Hardwood
Room Dimensions: 13x11
Room Level: Main
Room 10 Information
Room Features: Carpet
Room Dimensions: 23x16
Room Level: Upper
Room 11 Information
Room Dimensions: 10x08
Room Level: Upper
Other Rooms Information
# of Rooms: 15
Laundry Room Information
Laundry Features: Upper Level
Basement Information
Has Basement
Basement Features: Ceiling - 9+ feet, Roughed In, Sump Pump
Fireplace Information
# of Fireplaces: 1
Fireplace Features: Family Room, Gas Starter, Woodburning Fireplce
Heating & Cooling
Heating Information: Forced Air, Gas
Cooling Information: Central Electric
Interior Features
Interior Features: Attic Access, Built In Book Shelves, Walk-in Closet(s), Hardwood Floors, Screens Complete, Windows Vinyl, Pantry
Appliances: Gas Cooktop, Dishwasher, Disposal, MicroHood, Double Oven, Gas Water Heater
Areas Interior: Living Room Formal
Exterior
Building Information
Percent Optional Level Finished: 0-25%
Exterior Features
Patio And Porch Features: Deck Main Level, Wrap Around
Utility Prim Sewage Disp: Municipal Sewer Connected
Water Source: Municipal/City
Utilities: Cable Available, Cable Connected, Gas
Solid Waste Information: Yes
Location
HOA Information
Has HOA
Association Fee: $790
Association Fee Frequency: Annually
Association Fee Includes: Association Home Owners, Insurance, Maintenance, ParkPlayground, Snow Removal, Tennis Court(s)
School Information
High School District: Carmel Clay Schools
Location Information
Directions: Located just north of 131st Street off Shelborne Road. Left (west) into Long Ridge Estates onto Long Ridge Blvd. to house ahead on left (south) side of road.
Tax Legal Description: Longridge Estates
Public facts
Beds: 3
Baths: 4.5
Sq. Ft.: 3,770
Stories: 2.0
Lot Size: 0.34 acres
Style: Single Family Residential
Year Built: 2007
Year Renovated: 2007
County: Hamilton County
APN: 290919001060000018
Home facts updated by county records on Sep 16, 2026