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 = 1474 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1474 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1474 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

25201 Highway 370
Falkner, MS 38629
Jeremy Ryan with Crye-Leike Of TN-Collierville, original listing - (901) 854-5050

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,299,000
Beds: 5
Baths: Full: 6, ½: 1
Status: Active
SqFt: 7200 Square Feet
Agency: Crye-Leike Of TN-Collierville
Agency Phone: (901) 854-5050

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 87 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Welcome to one of the most beautiful southern plantation homes on the hilltop just outside of Falkner, Ms. A Private Ranch Estate on 87.169 acres 1/4 mile off the highway with gently rolling, lush pastureland perfect for the horses. This property is pristine country living and an equestrian riders dream. Located ten minutes from the county seat of Ripley, Ms. you can do your grocery shopping, fine dining at ease again with no hustle & bustle of long lines, waiting and self checkout with the southern charm of the locals. This beauty features over 7100 sq' of custom living area along with a gourmet kitchen with custom cabinets, granite countertops, two ovens, two sinks, built in refrigerator, ice maker, dishwasher, customized throughout. Five Bedrooms each with their own private baths 6 Full and 1 half bath total. 3 fire places, A grand foyer, beautiful oak staircase, crystal chandelier with lots of sunlight that welcomes you into this gorgeous home. Outside you have a beautiful courtyard for entertaining with stunning back yard views of the mature landscape, 3 car garage with complete upstairs, asphalt driveway gently rolling patureland line with vinyl fencing. An indoor arena, outdoor arena, 9 stalls, foaling stalls, sprinkler system, loft, paddock barns, late 1800's remodeled cabin for reading your favorite novel, Whole home generator backup and so much more. Whether you are looking for a private equestrian estate, boarding and training facility, maybe a wedding venue look no further this beauty has it ALL! Call today for your private showing.
MlsNumber: --
ListingId: 4095529


Listing Provided By: Crye-Leike Of TN-Collierville, original listing
Phone: (901) 854-5050
Office Phone: (901) 854-5050
Agent Name: Jeremy Ryan
Disclaimer: Copyright © 2024 MLS United. 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