10475 Harrison Road, Warren, OH 45140

Warren
Local realty services provided by:ERA Real Solutions Realty
10475 Harrison Road,Hamilton Twp, OH 45140
$2,600,000
Virtual Tour
  • 4 Beds
  • 5 Baths
  • 5,091 sq. ft.
  • Single family
  • Active
Listed by: adam schupp, mark schupp
Office: sibcy cline, inc.513-385-0900
MLS#:1894058
Source:OH_CINCY

Price summary

  • Price:$2,600,000
  • Price per sq. ft.:$510.71

About this home

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.

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2026
  • Listing ID #:1894058
  • Added:7 day(s) ago
  • Updated:September 26, 2026 at 02:22 PM

Rooms and interior

  • Bedrooms:4
  • Total bathrooms:5
  • Full bathrooms:4
  • Half bathrooms:1
  • Rooms Total:15
  • Dining Description:Chandelier, Walkout, Wood Floor
  • Kitchen Description:Butler's Pantry, Counter Bar, Dishwasher, Eat-In, Gourmet, Island, Microwave, Oven/Range, Refrigerator, Wine Cooler, Wood Cabinets, Wood Floor
  • Bedroom Description:Bath Adjoins, Vaulted Ceiling, Walk-in Closet, Wood Floor
  • Basement Description:Full, Part Finished
  • Living area:5,091 sq. ft.

Heating and cooling

  • Cooling:Central Air, ENERGY STAR, SEER Rated 13-15
  • Heating:Forced Air, Gas Furn EF Rtd 95%+, Zoned

Structure and exterior

  • Roof:Shingle
  • Year built:2026
  • Building area:5,091 sq. ft.
  • Lot area:4.01 Acres
  • Architectural Style:Transitional
  • Construction Materials:Fiber Cement, Stone
  • Exterior Features:Covered Deck/Patio, Fireplace, Patio, Porch
  • Foundation Description:Poured
  • Levels:2 Story

Utilities

  • Water:Public
  • Sewer:Septic Tank

Finances and disclosures

  • Price:$2,600,000
  • Price per sq. ft.:$510.71

Features and amenities

  • Appliances:Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler
  • Laundry features:Dryer, Washer
  • Amenities:9Ft + Ceiling, Beam Ceiling, Crown Molding, Natural Woodwork, Vaulted Ceiling

Parking

  • Parking description:Driveway, Off Street
  • Garage:Yes
  • Garage spaces:4
MLS LogoInformation deemed reliable but not guaranteed. The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than ERA Real Solutions Realty are marked with the Broker Reciprocity&#8482 logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. 2026, MLS of Greater Cincinnati, Inc. All rights reserved. OH_CINCY Member Broker: Jeremy Raby

New listings near 10475 Harrison Road