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

158 Laundre Road
Coldwater, MS 38618
Leigh Graves with Crye-leike Hernando, original listing - (662) 429-2442

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $497,500
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3106 Square Feet
Agency: Crye-leike Hernando
Agency Phone: (662) 429-2442

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1970
Notes: Exciting news alert! We just listed a stunning home on 7.5 acres in Tate County that has been completely renovated from top to bottom. This property is an absolute gem and has everything you could ever want in a dream home. Step inside to find all new kitchen cabinets and stainless steel appliances, complete with quartz countertops that will make preparing meals a breeze. The large laundry room with a half bath adds convenience to your daily routine. With 2 bedrooms and 2.5 baths downstairs and 2 bedrooms and 1 bath upstairs, there is plenty of space for you and your family to spread out and relax. The large dining room with vaulted ceilings is perfect for entertaining guests, while the new flooring throughout adds a touch of luxury. The bathrooms have been fully renovated, and all new plumbing and electrical ensure that this home is move-in ready. The property also features a brand new water well and a large back porch and patio that overlook the beautiful natural hardwoods. Imagine sipping your morning coffee here as you take in the peaceful surroundings. But wait, there's more! This listing also includes a 30'x 60' shop with large roll-up doors and electricity, perfect for storing all of your outdoor equipment and toys. This is truly a one-of-a-kind property that you won't want to miss out on. Contact us today to schedule a showing and make this gorgeous home yours. The inspiration behind the renovation of this home on 7.5 acres in Tate County was to create a modern and stylish living space that seamlessly blends with the surrounding natural landscape. The homeowners wanted to preserve the charm and character of the original structure while updating it with contemporary features and amenities. Additionally, they were drawn to the idea of transforming the property into a peaceful retreat where they could enjoy the beauty of nature and escape from the hustle and bustle of city life. Overall, the goal of the renovation was to enhance the property's inherent beauty and create a tranquil and welcoming environment for the future homeowners and their guests.
MlsNumber: --
ListingId: 4083852


Listing Provided By: Crye-leike Hernando, original listing
Phone: (901) 371-7460
Office Phone: (662) 429-2442
Agent Name: Leigh Graves
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 = 1473 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;
Hollye Granier
ASCIITurn Key Realty Group
Call Today!: (901) 870-4020

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App