Breathtaking Home! Over 5000 sf 5 bed 4 full bath on .43 acre corner lot in Lochaven! Soaring two level Great Room w/fireplace & main level guest suite w/ full bath! Gourmet kitchen w/granite, SS appls, gas cooktop, backsplash, two large walk-in pantries, staggered cabs, & massive 6'x10' center island! Engineered hardwood floors, two custom mud benches & upgraded lighting fixtures throughout! Gorgeous master suite w/huge connecting bath including tiled spa shower w/duel heads & bench. Marble topped duel raised vanities & spacious his/her walk-in closets. Laundry w/cabs located upstairs. Large finished 9ft ceiling bsmt w/ AMAZING custom Theater Room, full bath and spacious open Rec room! Built only 1 year ago, owners relocating.
*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
4
Baths
4.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.43 Acres
Year renovated
2017
Sq. Ft.
4,916
Year built
2017
Style
Single Family Residential
County
Hamilton County
APN
291015023039000013
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
Property details
Parking
Parking Information
Garage Parking Other: Finished Garage
Parking Features: Attached, Concrete, Garage Door Opener, Side Load Garage
Garage Spaces: 3
Has Garage
Interior
Interior Sq. Ft. Information
Building Area Total: 5048
Living Area: 3401
Main Level Sq. Ft.: 1776
Upper Level Sq. Ft.: 1625
Lower/Basement Level Sq. Ft (Finished): 1482
Bedroom Information
Primary Bedroom Description: Closet Walk in,Shower Stall Full,Sinks Double,Suite