Stay tuned for more...
USDAProperties.com is recovering from last night...

 

 

 

$2,499,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
1865 St Rt # 247
Concord Township, OH 45133
5 bed 8 bath 10,000 SqFt ($249/SqFt)
23.6 acre lot. Built 2017
Listed 2024-04-25
May be USDA loan restricted due to income limits
near Berrysville

Exquisite rural estate combines beautiful

Private 23.6 acres and a stunning main home w/over 10, 000 square feet of luxury living! A perfect blend of comfort and elegance, the massive stone fireplace in the hearth room is reminiscent of a cozy lodge while the living room evokes sophistication. The two rooms are connected by a cocktail room befitting both areas. Filled with delightful details around every corner such as the well-appointed gourmet kitchen, vast butler's pantry, study, atrium, screened porch, potting room and an oak paneled elevator that goes from basement to 2nd floor.

The property boasts a huge stone entry with imposing gates, circular paver driveway and garage floor. A separate custom barn/home with high end finishes provides opportunity for multi -generation living or rental. The possibilitis are limi ted by your imagination; ideal for development as an equestrian, aviation, wedding venue, classic cars or short term rental property.


Presented by Colleen Hennemann at
Coldwell Banker Realty.
Listing Agent Photo

Property MLS #1803131 from Cincinnati

Bedrooms: 5
Bedroom 2 Dimensions: 16 x 17
Bedroom 3 Dimensions: 14 x 18
Bedroom 4 Dimensions: 44 x 20
Bedroom 2 Sqft: 272
Bedroom 3 Sqft: 252
Bedroom 4 Sqft: 880
Bedroom 2 Description: 17x16 Level: 2
Bedroom 3 Description: 18x14 Level: 2
Bedroom 4 Description: 20x44 Level: 2

Total Rooms: 13
Family Room Dimensions: 39 x 20
Family Room Features: Concrete Floor, Wood Floor
Great Room Features: Fireplace, Walkout, Wood Floor
Living Room Features: Fireplace, Walkout, Wet Bar, Wood Floor
Entry Foyer Description: Closet, Double Doors, Transom/Sidelit, Wood Floor

Total Bathrooms: 8
Full Bathrooms: 6
1/2 Bathrooms: 2
Bathrooms On Level 1: Yes
Bathroom 1 Level: 1
Bathroom 2 Level: 2
Bathroom 3 Level: 2
Bathroom 4 Level: Lower
Bathroom 1 Description: Full
Bathroom 2 Description: Full
Bathroom 3 Description: Full
Bathroom 4 Description: Full

Butler's Pantry
Counter Bar
Gourmet
Island
Quartz Counters
Walkout
Dining Room Description: 18x30 Level: 1
Dining Room Dimensions: 30 x 18
Formal Dining Room Description: Yes

Cooling Features: Central Air
Number of Fireplaces: 3
Water Heaters: Propane

20 to 49 Acres
Lot Size Acres: 23.6
Lot Size Square Feet: 1028016

Garage Spaces: 9

Association: No
Calculated Total Monthly Association Fees: 0

High School District: Bright Local SD

Bright Elementary School is a public elementary school located approximately 3.6 miles away.
directions icon Map directions

Whiteoak Junior High School is a public middle school located approximately 8.6 miles away.
directions icon Map directions

Whiteoak High School is a public high school located approximately 8.6 miles away.
directions icon Map directions

City Region: Concord Twp
Source Listing Status: Active
County: Highland
Cross Street: SR 247/Fair Ridge Rd.
Source Property Type: Residential
Parcel Number: 062500019000
Property Subtype: Single Family Residence
Source System Name: C2C

Listing removed 2024-04-26
$0
Cincinnati
Listed 2024-04-25
$2,499,000
Cincinnati
Listing removed 2024-03-12
$0
Dayton
Price Changed 2023-11-02
$2,699,000
Cincinnati
Price Changed 2023-11-02
$2,699,000
Dayton
Listed 2023-09-12
$2,900,000
Dayton
Listed 2023-09-05
$2,900,000
Cincinnati

Access: Paved Road, State Highway

Total Square Feet Living: 10000
Year Built: 2017
Property Age: 7

Gas: Propane
Click Thumbnail Images To View Full Size
unknownunknownhouse_viewunknownunknown
farm_landunknownunknownhouse_viewgarage
house_viewporchhouse_viewhouse_viewhouse_view
house_viewunknownporchliving_roomliving_room
living_roomunknownliving_roomunknownliving_room
living_roomkitchendining_roomdining_roomliving_room
living_roomkitchenkitchenkitchenkitchen
kitchenunknownbathroombedroombedroom
unknownunknownbathroombathroomkitchen
laundry_roomkitchenunknownliving_roomunknown
kitchenunknownunknownunknownunknown
unknownunknownliving_roomliving_roomliving_room
living_roomliving_roomliving_roombedroombathroom
bedroombedroombathroombathroomunknown
unknownhouse_viewhouse_viewhouse_viewhouse_view
garagebedroomlaundry_roomkitchenbedroom
living_roomdining_roomdining_roomkitchenbathroom
bedroomunknownunknownbathroomunknown
unknownunknownbathroombathroomfarm_land
unknownfloor_planfloor_planfloor_plan

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.