Picture your dream home on this premier lot at Stone Pillars Farm! Hueber Homes has crafted this beautiful ranch with over 4,000 sq. ft. of living space. Top of the line finishes throughout. 3 car garage. Build this plan or work with our architects to design your perfect home. This community will also feature a stable for boarding horses, and an equestrian center. A beautiful 1.25 acres surrounded by trees, walking trails & bridle trails, you will be 3 mins from I-275, Downtown Loveland.
SE on Oakland Rd./St. Rt. 48. Entrance is on the right, past 6791 Oakland Rd. The Reserves section is adjacent to the Estate of Stone Pillars Farm.
Property Type | Residential |
---|---|
Style | Single Family |
Suburb | Goshen Twp |
Zip Code | 45140 |
School District | Goshen Local SD - Clermont County |
MLS# | 1765176 |
Levels | 1 Story |
---|---|
Construction | Stone, Fiber Cement |
Architecture | Ranch |
Lot Dimensions | 150 x 360 |
Total Acres | 1.252 |
Gas | Natural |
Water | Public |
Sewer | Public |
Foundation | Poured |
Occupancy | At Closing |
Semi-Annual Taxes | Of Record |
Basement | Full |
---|---|
Garage | Attached, Front, Oversized |
Cars | 3 |
Parking | Driveway |
Windows | Insulated, Casement |
Heating | Gas Furn EF Rtd 95%+, Variable Speed HVAC |
Cooling | Central Air, SEER Rated 16+ |
Fireplace | Gas |
Master Bedroom Info | Wall-to-Wall Carpet, Bath Adjoins |
---|---|
Master Bath Info | Whirlpool, Marb/Gran/Slat, Double Vanity, Ceramic Tile, Built-In Shower Seat |
Basement Details | Finished, Laminate Floor |
Entry Features | Double Doors, Wood Floors |
Dining Room Features | Wood Floors, Walkout, Formal |
Kitchen Features | Pantry, Walkout, Wood Floor, Eat-In, Island, Counter Bar, Quartz Counters |
Great Room Features | Fireplace, Wood Floor, Bookcases |
Appliances | Microwave, Garbage Disposal, Gas Cooktop, Double Oven |
Other Features | Ceiling Fan, High Tech Wiring, Smoke Alarm, Recess Lights |
HOA Fee - Annual |
Dimensions | Level | |
---|---|---|
Entry | 11 x 9 | 1 |
Dining | 22 x 16 | 1 |
Kitchen | 20 x 18 | 1 |
Great Room | 22 x 19 | 1 |
Recreation Room | 22 x 21 | Lower |
Study | 8 x 8 | 1 |
Laundry | 11 x 9 | 1 |
Dimensions | Level | |
---|---|---|
Master Bedroom | 17 x 16 | 1 |
Bedroom 2 | 12 x 12 | 1 |
Bedroom 3 | 14 x 13 | Lower |
Bedroom 4 | 14 x 12 | Lower |
Bedroom 5 | 12 x 12 | Lower |
Type | Level | |
---|---|---|
Bath 1 | Full | 1 |
Bath 2 | Full | 1 |
Bath 3 | Full | Lower |
Bath 4 | Full | Lower |
To receive more information about this property, please fill out the form below.
To determine affordability and approximate loan payments, use the button below to reveal the mortage calculator. Please note that when using the form one of either the 'Down Payment Pct' or 'Amount of Loan' fields, but not both, must be set to zero to complete the calculation.
Residential: Single Family
Listing # 1765176
Picture your dream home on this premier lot at Stone Pillars Farm! Hueber Homes has crafted this beautiful ranch with over 4,000 sq. ft. of living space. Top of the line finishes throughout. 3 car garage. Build this plan or work with our architects to design your perfect home. This community will also feature a stable for boarding horses, and an equestrian center. A beautiful 1.25 acres surrounded by trees, walking trails & bridle trails, you will be 3 mins from I-275, Downtown Loveland.
SE on Oakland Rd./St. Rt. 48. Entrance is on the right, past 6791 Oakland Rd. The Reserves section is adjacent to the Estate of Stone Pillars Farm.
This listing courtesy of Jeri O'Brien-Lofgren (513-266-8568), Sibcy Cline, Inc. (513-793-2700). All Information is believed accurate, but is NOT guaranteed.
Price | $1,650,000 |
---|---|
Rooms | 0 |
Bedrooms | 5 |
Bathrooms | 4 - 0 |
Levels | 1 Story |
Basement | Full |
Garage | Attached, Front, Oversized |
Cars | 3 |
Construction | Stone, Fiber Cement |
Architecture | Ranch |
Lot Dimensions | 150 x 360 |
Total Acres | 1.252 |
Parking | Driveway |
Suburb | Goshen Twp |
School District | Goshen Local SD - Clermont County |
Windows | Insulated, Casement |
Heating | Gas Furn EF Rtd 95%+, Variable Speed HVAC |
Cooling | Central Air, SEER Rated 16+ |
Fireplace | Gas |
Gas | Natural |
Water | Public |
Sewer | Public |
Foundation | Poured |
Occupancy | At Closing |
HOA Fee - Annual | |
Semi-Annual Taxes | Of Record |
Master Bedroom Info | Wall-to-Wall Carpet, Bath Adjoins |
Master Bath Info | Whirlpool, Marb/Gran/Slat, Double Vanity, Ceramic Tile, Built-In Shower Seat |
Basement Details | Finished, Laminate Floor |
Entry Features | Double Doors, Wood Floors |
Dining Room Features | Wood Floors, Walkout, Formal |
Kitchen Features | Pantry, Walkout, Wood Floor, Eat-In, Island, Counter Bar, Quartz Counters |
Great Room Features | Fireplace, Wood Floor, Bookcases |
Appliances | Microwave, Garbage Disposal, Gas Cooktop, Double Oven |
Other Features | Ceiling Fan, High Tech Wiring, Smoke Alarm, Recess Lights |
All information is believed accurate, but NOT guaranteed.
Copyright © 2025 Comey & Shepherd Realtors®. All Rights Reserved.