Sign up to get new listings emailed daily! JOIN SIGN IN
(937) 470-0719 Email (937) 470-0719
Ron Russo
REALTOR®
(937) 470-0719
VCard Icon 

10475 Harrison Road
Hamilton Twp, OH 45140

$2,600,000

98 Photos

SCHEDULE A PRIVATE TOUR Street View Call Print Email

Open House

Saturday, September 26th | 12:00 pm - 2:00 pm
Add to Calendar Request a Private Showing

Listing Details

  • $2,600,000
  • MLS# 1894058
  • Type Residential - Single Family
  • Status Active
  • 4
    Bedrooms
  • 4 full 1 partial
    Bathrooms
  • 5,091
    Square Feet
  • 4.008 acres
    Lot Size
  • 2026
    Year Built
  • Little Miami S
    Local Schools
MAP LISTING SHARE

Local Information

Listed By

Agency Name: Sibcy Cline, Inc.
Agent Name: Adam Schupp

agent picture

Shown By

Agent Name: Ron Russo
Agent Phone: (937) 470-0719
Agency Title: Irongate Inc., Realtors

IDX logo

Home Value Estimate

Description

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....read more

Features

  • Dishwasher
  • Dryer
  • Microwave
  • Oven/Range
  • Refrigerator
  • Washer
  • Wine Cooler
  • SEER Rated 13-15,Central Air, ENERGY STAR
  • 2 Fireplaces
  • Forced Air, Gas Furn EF Rtd 95%+, Zoned
  • 2.0 Stories
  • $4,044 Taxes
  • Public
  • Built in 2026

Upcoming Open Houses

Open House Saturday September 26th, 12:00pm - 2:00pm
Print Open House Details
SUBMIT AN OFFERx

Listed By

Agency Name: Sibcy Cline, Inc.
Agent Name: Adam Schupp

agent picture

Shown By

Agent Name: Ron Russo
Agent Phone: (937) 470-0719
Agency Title: Irongate Inc., Realtors

IDX logo

Ron Russo
Ron Russo Cell: (937) 470-0719 Email Me
VCard Icon
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers 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 on this site was last updated 09/25/2026. The listing information on this page last changed on 09/25/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Fri 09/25/2026 7:14:17 AM EST) or Dayton MLS (last updated Thu 09/24/2026 11:47:01 PM EST) or Multiple Listing Service of Greater Cincinnati (last updated Thu 09/24/2026 11:53:43 PM EST) or Wrist MLS (last updated Thu 09/24/2026 11:24:32 PM EST). Real estate listings held by brokerage firms other than Irongate Inc., Realtors may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register