Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2344 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2344 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2344 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

900 Fairview Farms Road
Campobello, SC 29332
Betina Conway with Blackstream International RE, original listing - (864) 920-0303

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $11,000,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: --
Agency: Blackstream International RE
Agency Phone: (864) 920-0303

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 94 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to Meadow Brook, where luxury and equestrian excellence meet in perfect harmony. Nestled on almost 100 acres of picturesque land, this state-of-the-art horse farm offers an unparalleled experience for both horse enthusiasts and those seeking a tranquil retreat. As you enter the property, you'll be captivated by the exceptional mountain views that surround you. Immerse yourself in nature as you explore the horse trails that wind through the property, providing endless opportunities for adventure and exploration. The centerpiece of this magnificent estate is the 10,688 sqft main home, spanning three levels and boasting luxurious amenities at every turn. Step inside and be greeted by a grand foyer, leading you to a world of opulence. The main level features a gourmet kitchen with top-of-the-line appliances, a walk-in pantry, and a stunning living room with vaulted ceilings, exposed beams, and floor-to-ceiling windows that showcase the breathtaking views. Indulge in relaxation in the owner suite, complete with spacious his and hers closets, laundry and the most beautiful bathroom. A beautiful sitting room with direct access to the screened-in porch, and waterfall pool. The main home also offers a large bar, game room, massage suite with a steam shower, and a gym, ensuring that every desire is catered to. For your guests, a 4,400 sqft guest house awaits, providing the perfect blend of comfort and privacy. Connected to the equestrian dream barn, this guest house offers direct access to the heart of the equestrian facilities. Speaking of the equestrian facilities, the barn is a true masterpiece. With 7 stalls equipped with automatic waterers, separate fans and lights for each stall, and fully matted floors, your horses will be treated like royalty. The barn aisle is lined with rubber pavers, ensuring secure footing for the horses. Inside, you'll find a spacious riders lounge/tack room with a kitchenette, full bathroom, and built-in blanket drawers. A wash rack with hot/cold water and warming lamps adds to the convenience, while a large workshop and beautiful courtyard complete the picture. As you explore the property, you'll discover lush pastures, a soothing waterfall, and apark-like setting that will take your breath away. Cross the beautiful bridge and immerse yourself in the serenity of this truly incredible estate. Meadow Brook is more than just a horse farm; it's a lifestyle. Whether you're a seasoned equestrian or simply seeking a luxurious retreat, this architectural gem offers the perfect blend of elegance, functionality, and natural beauty. Come experience the magic of Meadow Brook and make your equestrian dreams a reality.
MlsNumber: --
ListingId: 1537389


Listing Provided By: Blackstream International RE, original listing
Phone: (864) 516-7466
Office Phone: (864) 920-0303
Agent Name: Betina Conway
Disclaimer: Copyright © 2024 Greater Greenville Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App