Southwest Ohio MLS Listings | Gwen Nalls, J.D.

Properties

MLS Search · Showcase IDX

Property Search

Browse every available listing across Southwest Ohio — Springboro, Dayton, Beavercreek, Centerville, Mason and beyond. Updated daily from the MLS.

Save
Ask
Tour
Hide
Share
$2,600,000
2 Days On Site

10475 Harrison Road
Hamilton Twp, OH 45140

For Sale|Single Family Residence|Active
4
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
5,091
SqFt
$511
/SqFt
2026
Built
County:
Warren
Listing courtesy of Adam Schupp of Sibcy Cline, Inc.
Call Now: 937-974-1510
Is this the listing for you? We can help make it yours.
937-974-1510
10475 Harrison Road10475 Harrison Road10475 Harrison Road10475 Harrison Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

Enter an interest rate to see your estimated monthly payment.
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Set on 4 private acres just minutes from downtown Loveland, this exceptional Stonehaven Modern Manor by Old World Custom Homes presents a rare opportunity to own a completed, move in ready custom home with immediate availability. Blending timeless architecture with luxury craftsmanship, the home offers over 5,000 finished square feet highlighted by a breathtaking vaulted kitchen featuring exposed timber trusses, custom Amish built cabinetry, oversized quartzite islands, adjoining scullery, and dramatic arched stone window wall. The open design flows seamlessly into the Great Room and covered outdoor living area with a see through fireplace. Additional highlights include a luxurious First floor Primary Suite, Private Study, dedicated lounge, finished lower level with bar and fitness space, and a 4 car garage. A truly rare opportunity to enjoy the craftsmanship of Old World Custom Homes on a scale and setting seldom available.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,600,000
Days On Site 
2 Days
Bedrooms 
4
Inside Area (SqFt) 
5,091 sqft
Total Baths 
5
Full Baths 
4
Partial Baths 
1
Lot Size 
4.008 Acres
Year Built 
2026
MLS® Number 
1894058
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
9 hours agoListing updated with changes from the MLS®
2 days agoListing first seen on site
General Features
Acres 
4.008
Attached Garage 
Yes
Garage 
Yes
Garage Spaces 
4
Levels 
Two
Parking 
Garage Door OpenerOff StreetDrivewayAttached
Property Condition 
New Construction
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
Style 
Transitional
Utilities 
Propane
Water Source 
Public
Zoning 
Residential
Interior Features
Appliances 
RangeOvenHumidifierDishwasherDryerMicrowaveRefrigeratorWasherWine Cooler
Basement 
Partially FinishedSump PumpFull
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
Wood BurningGreat RoomGas
Fireplaces 
2
Heating 
Forced AirZoned
Interior 
Vaulted Ceiling(s)Eat-in KitchenKitchen IslandPantryWalk-In Closet(s)Crown MoldingNatural WoodworkBookcases
Bathroom 1 
Level – First
Bathroom 2 
Level – Second
Bathroom 3 
Level – Second
Bathroom 4 
Level – Lower
Bedroom 2 
Dimensions – 16 x 12Level – SecondArea – 192
Bedroom 3 
Dimensions – 16 x 12Level – SecondArea – 192
Bedroom 4 
Dimensions – 13 x 13Level – SecondArea – 169
Dining Room 
Dimensions – 17 x 14Level – FirstArea – 238
Entry Room 
Level – FirstArea – 84
Family Room 
Dimensions – 21 x 17Level – LowerArea – 357
Great Room 
Level – First
Kitchen 
Dimensions – 20 x 17Area – 340
LaundryRoom 
Dimensions – 10 x 9Level – FirstArea – 90
Living Room 
Dimensions – 13 x 12Area – 156
Master Bedroom 
Dimensions – 23 x 16Level – FirstArea – 368
RecreationRoom 
Dimensions – 16 x 9Level – SecondArea – 144
StudyLibDen 
Dimensions – 15 x 12Level – FirstArea – 180
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneFiber Cement
Lot Features 
ClearedLevel
Patio And Porch 
PatioPorch
Roof 
Shingle
Community Features
MLS Area 
Warren-E09
School District 
Little Miami Local S
Township 
Hamilton Twp
Schools
School District
Little Miami Local S
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Adam Schupp of Sibcy Cline, Inc.



Listing information is provided by Participants of the Cincy MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, Cincy MLS.
Last checked: 2026-09-21 11:00 PM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

The data does not represent listings of any one agent or broker, but of the broader real estate community.