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 = 1465 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 = 1465 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 = 1465 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;

719 Leesburg Road
Pelahatchie, MS 39145

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $859,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4085 Square Feet
Agency: Tom Smith Land & Homes
Agency Phone: (601) 898-2772

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Stunning Horse Property with Modern Comforts on 13 Acres in Rankin County!Discover the charm and luxury of this exceptional 13-acre horse property nestled in the heart of Rankin County. This expansive property offers a five-bedroom, four-bathroom home with 4,000 square feet of living space that seamlessly blends rustic elegance with modern amenities.Upon entering the home, you are greeted by an open floor plan adorned with rustic yet contemporary decor and custom crown molding. The large family room features a built-in TV and a cozy brick fireplace, creating a warm and inviting space. This room flows effortlessly into the gourmet kitchen, where long granite countertops and a spacious center island provide both beauty and functionality. The kitchen is equipped with double ovens, a commercial-grade cooktop, a built-in microwave, abundant storage options, and a convenient pantry located near the spacious laundry room and a 1/2 bath is conveniently located for guests and family members off the kitchen.The grand master suite is a sanctuary of luxury and comfort. Large windows allow natural light to fill the room, highlighting the elegant design of the master bath, which includes an extra-large shower, a separate tub, his-and-her vanities, and an expansive master closet complete with its own washer and dryer hookup.On the opposite side of the home, you will find three additional bedrooms and 2 bathrooms and a versatile office space, all featuring stylish concrete floors that add to the home's modern charm. And above the three-car garage, there is bonus room or another bedroom with its own full bathroom, offering privacy and convenience. This home has everything you will need. The home features tall ceilings throughout, a palette of neutral colors, gorgeous concrete floors, and a second eating area off the kitchen that is ideal for casual dining.Stepping outside, you are greeted by a sprawling covered outdoor kitchen that includes a stunning custom brick fireplace and a liner pool, perfect for both entertaining and enjoying peaceful evenings under the stars. Adjacent to the main residence, the property includes a fantastic barn that features a 12 x 40 unfinished apartment or storage area but plumbed for a bathroom providing flexible space for various needs. The barn also boasts four 12 x 12 stalls with a removable-track system, mats, and drains, along with a 12 x 16 tack room with concrete floors. A lean-to on each side of the barn offers additional shelter for exterior equipment or a trailer.This property presents a rare opportunity to embrace country living at its finest. With ample space for equestrian pursuits or outdoor activities, and all the modern comforts and conveniences you could desire, this expansive property is perfect for those seeking a private sanctuary or a place to entertain guests. Schedule your appointment today and imagine the possibilities of making this extraordinary property your own.
MlsNumber: --
ListingId: 4085513


Listing Provided By: Tom Smith Land & Homes, original listing
Phone: (601) 954-9395
Office Phone: (601) 898-2772
Agent Name: Ellen Smith
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.


Local Real Estate Expert

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 = 1465 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;
Cindy Robertson
ASCIIMaselle & Associates
Call Today!: (601) 331-5599

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App