Private 5-acre estate with resort-style amenities! Tucked more than 100 yards off the road, this custom Hueber Homes brick-and-stone ranch offers over 4,000 SF, 5 bedrooms, 4 baths, and exceptional indoor-outdoor living. Enjoy a dark-bottom gunite pool with infinity-edge waterfall, expansive deck, covered outdoor entertaining space, theater-ready bonus room, and upscale finishes throughout. The detached 1,000 SF carriage house, complete with a bathroom and plumbed for a future kitchen, offers incredible flexibility for guests, a home office, hobbies, or multigenerational living. Orchard trees, berry beds, a chicken coop, and fenced free-range area provide a unique opportunity to embrace a more intentional lifestyle without sacrificing luxury. Recent updates include a newer roof, updated water heater, and expanded deck. A truly rare offering where privacy, elegance, and everyday enjoyment come together. Schedule your private tour today.
For sale
$1,495,000
10313 Harrison Rd, Loveland, OH 45140
5beds
5,120sqft
Single Family Residence
Built in 2003
5 Acres Lot
$-- Zestimate®
$292/sqft
$-- HOA
What's special
Chicken coopTheater-ready bonus roomExpansive deckUpscale finishes throughoutExpanded deckOrchard treesFenced free-range area
- 1 day |
- 667 |
- 51 |
Zillow last checked:
Listing updated:
Listed by:
Scott J Wert 513-344-2080,
Comey & Shepherd 513-489-2100
Source: Cincy MLS,MLS#: 1882784
Originating MLS: Cincinnati Area Multiple Listing Service

Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), Walkout
- Level: First
- Area: 176
- Dimensions: 16 x 11
Bedroom 2
- Level: First
- Area: 168
- Dimensions: 14 x 12
Bedroom 3
- Level: First
- Area: 156
- Dimensions: 13 x 12
Bedroom 4
- Level: Lower
- Area: 182
- Dimensions: 14 x 13
Bedroom 5
- Level: Lower
- Area: 176
- Dimensions: 16 x 11
Primary bathroom
- Features: Built-In Shower Seat, Shower, Double Shower, Tile Floor, Double Vanity, Tub, Jetted Tub, Window Treatment
Bathroom 1
- Features: Full
- Level: First
Bathroom 2
- Features: Full
- Level: First
Bathroom 3
- Features: Full
- Level: Lower
Bathroom 4
- Features: Partial
- Level: First
Dining room
- Features: French Doors, Chandelier, Open, Walkout
- Level: First
- Area: 182
- Dimensions: 14 x 13
Family room
- Features: Laminate Floor
- Area: 126
- Dimensions: 21 x 6
Kitchen
- Features: Solid Surface Ctr, Tile Floor, Kitchen Island, Wood Cabinets, Marble/Granite/Slate
- Area: 260
- Dimensions: 20 x 13
Living room
- Features: Wall-to-Wall Carpet, Fireplace
- Area: 860
- Dimensions: 43 x 20
Office
- Area: 0
- Dimensions: 0 x 0
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, Double Oven, Dryer, Disposal, Gas Cooktop, Microwave, Refrigerator, Washer, Water Softener, Propane Water Heater
Features
- High Ceilings, Cathedral Ceiling(s), Crown Molding, Vaulted Ceiling(s), Ceiling Fan(s)
- Doors: French Doors, Multi Panel Doors
- Windows: Double Hung, Wood Frames
- Basement: Full,Finished,Walk-Out Access
- Attic: Storage
- Number of fireplaces: 1
- Fireplace features: Gas, Outside, Living Room
Interior area
- Total structure area: 5,120
- Total interior livable area: 5,120 sqft
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Asphalt, Driveway, Garage Door Opener
- Attached garage spaces: 4
- Has uncovered spaces: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered Deck/Patio, Deck, Porch
- Exterior features: Fire Pit, Fireplace, Yard Lights
- Has private pool: Yes
- Pool features: Gunite, In Ground, Salt Water, Tile
- Fencing: Wire,Wood
- Has view: Yes
- View description: Trees/Woods, Other
Lot
- Size: 5 Acres
- Features: Flag Lot, 5 to 9.9 Acres
- Topography: Level
Details
- Additional structures: Shed(s)
- Parcel number: 1601276010
- Zoning description: Residential
- Other equipment: Sump Pump
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick, Stone
- Foundation: Concrete Perimeter
- Roof: Shingle
Condition
- New construction: No
- Year built: 2003
Utilities & green energy
- Electric: 220 Volts
- Gas: Propane
- Sewer: Septic Tank
- Water: Public
Community & HOA
Community
- Security: Security System
HOA
- Has HOA: No
Location
- Region: Loveland
Financial & listing details
- Price per square foot: $292/sqft
- Tax assessed value: $878,390
- Annual tax amount: $13,640
- Date on market: 6/19/2026
- Listing terms: No Special Financing,Cash
- Road surface type: Paved
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/19/2026 | Listed for sale | $1,495,000+1.4%$292/sqft |
Source: | ||
| 10/24/2025 | Sold | $1,475,000+9.3%$288/sqft |
Source: | ||
| 10/6/2025 | Pending sale | $1,350,000$264/sqft |
Source: | ||
| 10/3/2025 | Listed for sale | $1,350,000+125%$264/sqft |
Source: | ||
| 9/26/2014 | Sold | $600,000-10.3%$117/sqft |
Source: Public Record Report a problem | ||
| 7/27/2014 | Pending sale | $669,000$131/sqft |
Source: WIR LLC dba Keller Williams Realty Associate Partners #1412375 Report a problem | ||
| 7/18/2014 | Listed for sale | $669,000+13%$131/sqft |
Source: WIR LLC dba Keller Williams Realty Associate Partners #1412375 Report a problem | ||
| 12/17/2003 | Sold | $591,933+654.1%$116/sqft |
Source: Public Record Report a problem | ||
| 10/22/2002 | Sold | $78,500$15/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $13,641 +14.8% | $307,440 +28.5% |
| 2023 | $11,886 +5.8% | $239,280 +4.6% |
| 2022 | $11,236 +4.9% | $228,861 |
| 2021 | $10,708 -5.2% | $228,861 +11% |
| 2020 | $11,298 -1.7% | $206,181 |
| 2019 | $11,488 +1.9% | $206,181 0% |
| 2018 | $11,272 +12.1% | $206,182 +11.5% |
| 2017 | $10,052 -2.1% | $184,839 |
| 2016 | $10,269 -0.2% | $184,839 |
| 2015 | $10,290 -9.3% | $184,839 +2.7% |
| 2014 | $11,350 +1.8% | $180,060 -11.3% |
| 2013 | $11,154 +0.1% | $203,000 |
| 2012 | $11,143 -0.6% | $203,000 -1.2% |
| 2011 | $11,206 +30.7% | $205,450 |
| 2010 | $8,575 +2.9% | $205,450 |
| 2009 | $8,334 -2.3% | $205,450 |
| 2008 | $8,533 | $205,450 -6.6% |
| 2007 | -- | $220,050 +6.5% |
| 2006 | -- | $206,640 +11.7% |
| 2005 | -- | $185,000 |
| 2004 | -- | $185,000 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 45140
Nearby schools
GreatSchools rating
- 7/10Little Miami Primary SchoolGrades: 2-3Distance: 3.9 mi
- 8/10Little Miami Junior High SchoolGrades: 6-8Distance: 6.2 mi
- 7/10Little Miami High SchoolGrades: 9-12Distance: 6.4 mi
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Ohio
- Warren County
- Loveland
- 45140
- 10313 Harrison Rd







