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;

170 Winchester Drive
Flora, MS 39071

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $570,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2750
Agency: Tom Smith Land and Homes, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2018
Notes: Just a little slice of Heaven! This five-year-old custom-built home located in Heartland Estates on 5.7 +/-beautiful acres. This immaculate 2,750 square foot, 4 bedrooms, 2 1/2 bath home has an open and inviting floor plan with 11-to-10-foot ceilings throughout. The living/kitchen/seated area is spacious with a grand fireplace in the living room complete with built-ins, new luxury wood viny flooring throughout the entire home, and plenty of windows with new custom blinds that provide tons of natural light and gorgeous views. The kitchen has ample counter space, a huge island with bar seating, stainless steel appliances, including gas cooktop, and a huge walk-in pantry!There is also a large laundry room with storage and a large room off the laundry which can be used as the 5th bedroom, nursery or gym! Also, there is a drop zone/storage area and office off the garage entry. The master bedroom is spacious with a stained wood ceiling and custom built-ins. The master bath exudes luxury with soaker tub, separate shower and vanities with tons of storage, granite counter tops, and His and Her closets. There are three additional guest bedrooms and a guest hall bath with double sinks. A complete and fully installed ADT security system with 2 cameras is in place including security for your garages. You only need to connect with ADT to enable the security. You only need to connect with ADT to enable the security system. You will enjoy evenings watching the sunset over the water from your oversized back porch with built-in gas fireplace and Cooley shades to block the sun if needed. This is also a great entertaining space where you can relax and catch the game on your outdoor TV while cooking steaks on the custom outdoor kitchen. The backyard is fully fenced with a4-rail wood fence so that it doesn't take away from the beautiful views of nature and will keep your pets safe and sound! The large pond is stocked for some of the best fishing right out your backdoor. The 3-car garage is loaded with space and deep enough for your large country trucks. If country living in Flora is your thing, you better make a call and come see this amazing home before it's gone!
MlsNumber: 4068600


Listing Provided By: Tom Smith Land and Homes, LLC, original listing
Name: Tom Smith Land and Homes, LLC
Phone: (601) 454-9397
Office Name: Tom Smith Land & Homes
Office Phone: (601) 898-2772
Agent Name: Allyson O Mize
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;
Taylor Lewis
ASCIIHome Again Realty
Call Today!: (601) 750-6788

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App