
Property Attributes
- MLS#1763636
- TypeSingle Family
- CountyCLERMONT
- CityGoshen Twp
- AreaClermont
- NeighborhoodGoshen Township
- Zip45140
- StyleTransitional
- Price$ 3,260,501
- Bedrooms4
- Full Bathrooms3
- Half Bathrooms1
Data Source:
MLS of Greater Cincinnati (CABR)
Property Description
Sprawling single level living at its finest, with exquisite finishes throughout. Build your forever home with Hueber Homes nestled on 14+ acres in The Estates at Stone Pillars Farm! Just outside of Loveland, this peaceful equestrian community offers vast open acreage for pastures & gardens, or options to build nestled in wooded alcoves. The community not only offers training & boarding opportunities, but eventing courses on over 3 miles of trails across the terrain, accessible by hoof or foot.
High School |
---|
Goshen Local High School |
Price History | |
---|---|
3/22/2023 | Listed $3,260,501 |
General Features
Appliances | Oven, Dryer, Washer, Microwave, Dishwasher, Double Oven, Wine Cooler, Refrigerator, Electric Water Heater |
---|---|
Architectural Style | Transitional |
Assoc Fee Paid Per | Monthly |
Assoc Fees | 0.0 |
Association Name | TBD |
Association Y/N | Yes |
Builder Name | Hueber Homes |
City | Goshen Twp |
Construction Materials | Brick, Stone |
Cooling | Central Air |
County | Clermont |
Days on Market | 91 |
Directions | From Downtown Loveland, S on SR 48, R on Smith, Property on L (Gated. Agent must be present). |
Exterior Features | Lighting, Outdoor Kitchen |
Garage Spaces | 3.0 |
Heating | Geothermal |
High School District | Goshen Local SD |
Lease Considered Y/N | No |
Levels | Two |
Lot Size Square Feet | 0.0 |
Patio/Porch Features | Deck, Patio, Porch, Covered |
Percent Ownership | Consumer |
Possession | Close Of Escrow |
Property Condition | Planned Construction |
Property SubType | Single Family Residence |
Property Type | Residential |
Roof | Shingle |
Security Features | Security System |
Sewer | Septic Tank |
Standard Status | Active |
Street Name | Smith |
Structure Type | Detached Home |
Tax Annual Amount | 0.0 |
Topography | Rolled |
Total Rooms | 12.0 |
Unit Number | 112 |
View | Trees/Woods |
Zoning | Residential |
Interior Features
Basement | Full, Finished, Sump Pump |
---|---|
Entry Level | 1 |
Fireplace Features | Living Room, Wood Burning |
Flooring | Wood |
Full Baths | 3 |
Half Baths | 1 |
Street Suffix | Rd |
Total Bedrooms | 4 |
Total Fireplaces | 2 |
Window Features | Insulated Windows |
Exterior Features
Door Features | French Doors, Sliding Doors |
---|---|
Foundation Details | Poured |
Lot Dimensions | Irregular |
Lot Features | Rolling Slope |
Lot Size Acres | 0.0 |
Lot Size Area | 0.0 |
Lot Size Units | Square Feet |
Parking Features | Attached, Driveway, Oversized, Garage Faces Side |
Road Frontage Type | County Road |
Vegetation | Partially Wooded |
Room Details
Room | Dimensions | Level | Flooring | Details |
---|---|---|---|---|
Bathroom2 | Second | |||
Bathroom3 | Second | |||
Bathroom4 | First | |||
Bedroom2 | 15 x 12 | Second | ||
Bedroom3 | 15 x 12 | Second | ||
Bedroom4 | 15 x 12 | Second | ||
BreakfastRoom | 16 x 8 | First | ||
DiningRoom | 16 x 13 | First | ||
Entry | 14 x 9 | First | ||
GreatRoom | 20 x 18 | |||
Kitchen | 16 x 14 | First | ||
LaundryRoom | 11 x 8 | First | ||
LivingRoom | First | |||
Office | 18 x 12 | First | ||
PrimaryBathroom | First | Full | ||
PrimaryBedroom | 18 x 14 | First |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool