Anissa Yoder
BEDS4
BATHS4 full 1 partial
SQUARE FEET5,091
MLS#1894058
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLLittle Miami S
Property 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. 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.
Property Features
Property Type: Residential - Single Family
Basement: Yes
Basement: Full
Cooling: SEER Rated 13-15,Central Air, ENERGY STAR
Fireplaces: 2
Garage: 4
Heating: Forced Air, Gas Furn EF Rtd 95%+, Zoned
Home Style: Transitional
Lot Size: 4.01 Acres
Roof Type: Shingle
Stories: 2.0
Taxes: $4,044
Year Built: 2026
Amenities
9Ft + Ceiling
Beam Ceiling
Crown Molding
Natural Woodwork
Vaulted Ceiling
Covered Deck/Patio
Fireplace
Patio
Porch
Feature Descriptions
Appliances: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler
Basement Fatures: Part Finished
Days on Site: 9
Exterior: Stone, Fiber Cement
Family Room: Wet Bar, Wood Floor
Fireplace Features: Gas, Wood
Flex Rooms: Loft, Media Room, Exercise Room, Game Room
Foundation: Poured
Garage/Carport: Side, Garage Attached
Gas: Propane
Great Room: Bookcases, Fireplace, Wood Floor
Kitchen: Butlers Pantry, Counter Bar, Eat-In, Gourmet, Island, Wood Cabinets, Wood Floor
Mechanical Systems: Air Cleaner, Garage Door Opener, Humidifier, Sump Pump w/Backup
Miscellaneous: 220 Volt, Recessed Lights
Parcel #: 17-31-151-004
Parking: Off Street, Driveway
Primary Bathroom: Built-In Shower Seat, Double Shower, Tile Floor, Double Vanity, Tub, Marb/Gran/Slate
Primary Bedroom: Bath Adjoins, Vaulted Ceiling, Walk-in Closet, Wood Floor
Rooms Total: 15
Sewer: Septic Tank
SQFT Basement: 821
Study: Bookcases, Wall-to-Wall Carpet
Tax Abatement: No
Topography: Cleared, Level
Water: Public
Water Heater: High Effic Heat Pump, Tankless
Window Features: LowE, Double Hung, Other
Room Sizes
Primary Bedroom: 23 X 16 Level - 1
Bedroom 2: 16 X 12 Level - 2
Bedroom 3: 16 X 12 Level - 2
Bedroom 4: 13 X 13 Level - 2
Dining Room: 17 X 14 Level - 1
Entry: 12 X 7 Level - 1
Family Room: 21 X 17 Level - Lower
Great Room: 23 X 20 Level - 1
Living Room: 13 X 12 Level - 1
Laundry Room: 10 X 9 Level - 1
Recreation Room: 16 X 9 Level - 2
Study/Den: 15 X 12 Level - 1
Local Schools
School District: Little Miami S
Listed By / Shown By
Listed By
Agency Name: Sibcy Cline, Inc.
Agent Name: Adam Schupp
Shown By
Agent Name: Anissa Yoder
Agent Phone: Cell: (419) 466-7373
Agency Title: Key Realty
Estimate Your Payment
Estimated Payment
$ 15,639.00 per month $14,543.66 Principal & Interest $337.00 Property Tax $758.33 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agency License Information: 1-877-539-7589 | Ohio Lic# REC.2010002888 6800 W Central Ave #B, Toledo, OH 43617 | Michigan Lic# 6505366134 8040 Summerfield Rd, Lambertville, MI 48144 | Indiana Lic# RC52400106 3029 W Smith Valley Rd #211, Greenwood, IN 46142 | West Virginia LIC# 010306 Erin Rickman, Broker. 410 Market St #3, Parkersburg, WV, 26101 | Colorado LIC# EC.100108419 603 Rood Ave, Grand Junction, CO 81501 | Nevada LIC# B.0146350.LLC 9190 Double Diamond Pwky, Reno, NV 89521 | Florida LIC# CQ1073507 16638 Mooner Plank Cir, Wimauma, FL 33598 | Illinois LIC# 481014661 640 S Washington St. Suite 212, Naperville, IL 60540
10475 Harrison Road | MLS# 1894058
This single family home located at 10475 Harrison Road, Hamilton Township, OH 45140 is currently listed for sale with an asking price of $2,600,000. This property was built in 2026 and has 4 bedrooms and 4 full and 1 partial baths with 5091 sq. ft. Harrison Road is located within the Little Miami S school district. Search Hamilton Township real estate on anissayoder.ikeyrealty.com today.