

6600 Smith Road
$3,260,501 Active
Overview
- Time on Site:
- 71 days
- Visits:
- 4
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.
Facts & Features
- Type Single Family
- Lot 12.45 Acres
General
Association/HOA
- Association Fee Frequency: Other
- Association Fee Includes: AssociationDues, Other, WalkingTrails
- Association Name: TBD
- Association: Yes
School Information
- High School District: Goshen Local SD
- School Name1: Call SD 513-722-2222
- School Type1: District Phone
Listing Information
- Availability Date: 1800-01-01
- Special Financing: No
Building Information
- Access: County Road
- New Construction: Yes
- Year Built: 0
Location/Region
- County Or Parish: Clermont
- MLS Area Major: Clermont-C02
Rent/Lease Information
- Lease Considered: No
General Information
- Builder: Hueber Homes
- Parcel Number: 11-22-03I-059
- Property Sub Type: Single Family Residence
- Property Type: Residential
Interior
Building Information
- Gas: None
- Levels In Building: 0
- Water Heating: Electric
Parking Information
- Garage Carport: Garage Attached,Oversized,Side
- Garage Spaces: 3.00
Beds/Baths
- Bath Lvl1 Type: Full,Partial
- Bath1: Full
- Bath1 Level: 1
- Bath2: Full
- Bath2 Level: 2
- Bath3: Full
- Bath3 Level: 2
- Bath4: Partial
- Bath4 Level: 1
- Bathroom Level1: Yes
- Bathrooms: 4.00
- Bathrooms Full: 3
- Bathrooms Half: 1
- Bathrooms One Quarter: 0
- Bathrooms Three Quarter: 0
- Bedrooms Total: 4
- Bedroom Level1: Yes
- Bedroom2: 15x12 Level: 2
- Bedroom2 Area: 180
- Bedroom2 Dim: 15 x 12
- Bedroom2 Len: 15
- Bedroom2 Wid: 12
- Bedroom3: 15x12 Level: 2
- Bedroom3 Area: 180
- Bedroom3 Dim: 15 x 12
- Bedroom3 Len: 15
- Bedroom3 Wid: 12
- Bedroom4: 15x12 Level: 2
- Bedroom4 Area: 180
- Bedroom4 Dim: 15 x 12
- Bedroom4 Len: 15
- Bedroom4 Wid: 12
- Bedroom5 Area: 0
- Bedroom5 Dim: 0 x 0
- Bedroom5 Len: 0
- Bedroom5 Wid: 0
- Bedrooms Possible: 0
- Primary Bathroom: Double Vanity,Marb/Gran/Slate,Shower,Other
- Primary Bed Feat: Bath Adjoins,Walk-in Closet,Walkout,Other
- Primary Bedroom: 18x14 Level: 1
- Primary Bedroom Area: 252
- Primary Bedroom Dim: 18 x 14
- Primary Bedroom Len: 18
- Primary Bedroom Wid: 14
Building Interior
- Basement Feat: Finished
- Entry: 14x9 Level: 1
- Entry Area: 126
- Entry Dim: 14 x 9
- Entry Foyer: Closet,Open Foyer,Transom/Sidelit
- Entry Len: 14
- Entry Wid: 9
General Information
- Appliances: Dishwasher,Double Oven,Dryer,Microwave,Oven/Range,Refrigerator,Washer,Wine Cooler
- Basement: Full
- Cooling: Central Air
- Dining Room: 16x13 Level: 1
- Dining Room Area: 208
- Dining Room Dim: 16 x 13
- Dining Room Len: 16
- Dining Room Wid: 13
- Fireplace Features: Wood
- Fireplaces Total: 2
- Foundation Details: Poured
- Heating: Geothermal
- Interior Features: French Doors,Multi Panel Doors
- Levels: Two
- Rooms Total: 12
- Window Features: Insulated
Unit Information
- Unit: 112
Room Information
- Breakfast Room: 16x8 Level: 1
- Breakfast Room Area: 128
- Breakfast Room Dim: 16 x 8
- Breakfast Room Len: 16
- Breakfast Room Wid: 8
- Family Room Area: 0
- Family Room Dim: 0 x 0
- Family Room Len: 0
- Family Room Wid: 0
- Flex Rooms: Media
- Formal Dining Room: Yes
- Kitchen: 16x14 Level: 1
- Kitchen Area: 224
- Kitchen Dim: 16 x 14
- Kitchen Features: Counter Bar,Gourmet,Island,Marble/Granite/Slate,Pantry,Walkout,Wood Cabinets,Wood Floor
- Kitchen Len: 16
- Kitchen Wid: 14
- Laundry Room: 11x8 Level: 1
- Laundry Room Area: 88
- Laundry Room Dim: 11 x 8
- Laundry Room Len: 11
- Laundry Room Wid: 8
- Living Great Rm Area: 360
- Living Great Rm Dim: 20 x 18
- Living Great Rm Len: 20
- Living Great Rm Wid: 18
- Living Room: 20x18 Level: 1
- Living Room Feat: Fireplace
- Recreation Room Area: 0
- Recreation Room Dim: 0 x 0
- Recreation Room Len: 0
- Recreation Room Wid: 0
- Study Lib Den: 18x12 Level: 1
- Study Lib Den Area: 216
- Study Lib Den Dim: 18 x 12
- Study Lib Den Len: 18
- Study Lib Den Wid: 12
Exterior
Parking Information
- Parking Features: Driveway
Lot Information
- Land Description: 10 to 19 Acres
- Lot Size Acres: 12.4530
- Lot Size Dimensions: Irregular
- Lot Size Square Feet: 542453.00
- Lot Size Units: Acres
- Water Source: At Street
Waterfront/View
- View: Woods
Building Exterior/Construction
- Architectural Style: Transitional
- Construction Materials: Brick,Stone
- Roof: Shingle
General Information
- Exterior Features: Covered Deck/Patio,Deck,Kitchen – Outdoor,Patio,Porch,Yard Lights
- Sewer: Septic Tank
Neighborhood
Community
45140 (Goshen Twp) Demographics
Schools
Elementary Schools
- Grades: 3 - 4
- Enrollment: 700
- Grades: KG - 6
- Enrollment: 631
- Grades: KG - 4
- Enrollment: 541
Middle Schools
- Grades: 7 - 8 /
- Enrollment: 739
- Grades: KG - 6 /
- Enrollment: 631
High Schools
- Grades: 9 - 12 /
- Enrollment: 1,414
Monthly Cost
Market Data
Based on the last 30 days in this zip code
History
Date | Value |
---|---|
5/2/2023Source: CincyMLS | May 02, 2023 |
3/22/2023Source: CincyMLS | March 22, 2023 |