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;

1129 Livingston Vernon Road
Flora, MS 39071
Shane Saxton with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,187,500
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2978 Square Feet
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 28 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Welcome home to this stunning 4 bed/3.5 bath home that sits nestled on approximately 28 acres+/-. Enjoy the peace and privacy of country life while living only minutes from Livingston, Madison and Flora. The property boasts of wildlife where you can enjoy hunting and nature from the convenience of your home. The home has a front porch where you can relax in a rocking chair or porch swing while enjoying the tranquility. The home is equipped with many windows where you can enjoy the beautiful views of your property from most of the rooms in the house. The spacious living room features a beautifully bricked fireplace with built-in shelving and cabinets on either side. The living room is open to the kitchen which is convenient for entertaining. The kitchen features a large island with plenty of space for seating as well as additional space for a kitchen table. It has many cabinets for storage as well as a large walk-in pantry with built-in shelving. The primary bedroom provides plenty of space along with a large window where you can enjoy views of your property from the comfort of your own bed. The primary bathroom features double vanities, a soaking tub, shower as well as a large walk-in closet. The primary bedroom along with two other bedrooms are located on the main floor with a bedroom/bonus and full bathroom located upstairs. There is also a room on the primary floor with a built-in desk and shelving that can be used for an office, playroom or study. The laundry room offers plenty of space along with a sink as well as cabinet space & shelving for storage. There is also a built-in coat rack with storage conveniently located in the back hallway near the laundry room. The home has a back-up generator in place as well. Step right outside the back door onto your back patio where you can enjoy sitting by the bricked fire pit while watching wildlife and enjoying the stunning scenery. No need for a deer camp when you can hunt right off your back porch. There is a 30x40 heated and cooled shop/guesthouse with 14 foot over hang that runs the full 40 ft length on each side. The shop is open and spacious inside giving you plenty of storage space. It is equipped with living quarters and a full bath with a large storage closet also. It is also equipped with a utility room with a washer and dryer hook up. The owners have enjoyed deer right from their back porch literally almost feeding the deer right from their own hands. The owners have also harvested trophy deer right from the back porch. There are multiple food plots and stands already in place on the property as well as established road systems throughout the property. If you enjoy quiet country life while being only minutes from restaurants and shopping, then don't wait to make this house your new home! Call today.
MlsNumber: --
ListingId: 4089945


Listing Provided By: Hopper Properties, original listing
Phone: (601) 540-5040
Office Phone: (601) 724-1435
Agent Name: Shane Saxton
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 Camryn Greer
Camryn Greer
ASCIIMcCool Thorpe Real Estate
Call Today!: (662) 739-7661

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App