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

125 Chestnut Hill Road
Flora, MS 39071
Terri Morgan with BHHS Gateway Real Estate, original listing - (601) 853-0414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,275,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 5569 Square Feet
Agency: BHHS Gateway Real Estate
Agency Phone: (601) 853-0414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Nestled amidst the majestic old mossy oaks and other mature hardwoods, this exquisite property offers a serene retreat that feels like miles away from the everyday. Chestnut Hill is right off Mannsdale Rd (Hwy 463), a true gated community that encapsulates some of the most beautiful land in Madison County. This well appointed home exudes character and charm with classic architecture elements and is situated high on 5 1/2 acres in the tree line and the views are breathtaking! Upon entering this special home, your eyes are immediately drawn to the large floor to ceiling picture windows that provide a wide unobstructed view of the natural surroundings. These windows were designed to maximize natural light and create a strong visual connection between the interior space and the outdoor environment. Plus extra large transom windows in the cathedral foyer and great room. You can see the moss blowing high in the oaks from almost every room in the house. Great open plan perfect for entertaining, including a large Chef's kitchen with high-end stainless appliances and an oversize unique rounded granite island, all opening up to the great room. Beautiful floor to ceiling brick fireplace with built-ins on both sides. The primary suite is on one end of the house lending lots of privacy and also has a nice size separate space that is used as an office, but could be another sitting area or a nursery for a newborn. There is a secondary bedroom and bath on the main level as well. But one of the best features of this home is a ''State of the Art'' Media Room, second to none! It's on the main level that has a wet bar and close to the awesome outdoor space. A full bathroom is located in this area for guests and close proximity to outdoor space. Be sure to read the write-up on the media package. There is a staircase in this area that leads to a large bonus office. Very private if you work remote. Also this could be a 6th bedroom. Upstairs there is a catwalk which opens everything up, with three bedrooms, 2 baths and another area with built-ins that is used as an exercise room. There is a screened in porch on the second level balcony. The outdoor living area is very spacious including a covered area, grill station and gorgeous fireplace. Nice flat backyard that is beautifully landscaped and large enough to add a big pool. That space is shared with the amazing wildlife and there are sitings regularly!There is a workshop that is large enough to be used to store equipment, a car, gardening tools, etc. Also, a Steel 6X6 Built-in Storm/Safe Room. There are two separate driveways into the property, a formal entrance that winds around to the 4 car garage, as well as a long gravel road. This gorgeous property gives you a sense of escape and tranquility, and is located in award winning Madison School District. Mannsdale Elementary is just minutes away!! We have access to a 44 acre fishing lake with boat ramp and pier. You can drive your golf cart to the charming Town of Livingston to enjoy multiple dining experiences, a mercantile store, offices, retail and much more! Just minutes to I-55, shopping and healthcare. Contact your favorite realtor to see this special property!
MlsNumber: --
ListingId: 4098046


Listing Provided By: BHHS Gateway Real Estate, original listing
Phone: (601) 853-0414
Office Phone: (601) 853-0414
Agent Name: Terri Morgan
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 = 1449 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;
Real Estate Expert Photo for Joyce Dee
Joyce Dee
ASCIIGarland Group Epique Realty
Call Today!: (601) 507-4966

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App