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

285 Cedar Crest Cove
Byhalia, MS 38611
Nannette Deshazo with Coldwell Banker Collins-Maury Southaven, original listing - (662) 548-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $710,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 3980 Square Feet
Agency: Coldwell Banker Collins-Maury Southaven
Agency Phone: (662) 548-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Indulge yourself in modern luxury and serene living on these 3.29 acres. This pristine home, at just 12 months old, offers unparalleled sophistication with its 5 bedrooms and 4.5 bathrooms and just under 5000 sq ft. The interior boasts spacious living areas with an open-concept design, high ceilings, and large windows. The kitchen features custom cabinetry, high-end stainless steel appliances, a 6 burner gas stove, and a generous island with seating for 5. The primary suite is a luxurious with a sitting room, cozy fireplace, an expansive split walk-in closet, and an incredible luxury primary bathroom. This spa-like retreat includes a deep soaking tub, an oversized glass-enclosed shower with multiple showerheads, dual vanities with designer fixtures. The split floor plan is designed for optimal privacy with the second bedroom down and a private bathroom. Upstairs there are 2 other bedrooms with a shared bath and bedroom 5 with a private bath. Exterior features include a covered patio with a stunning fireplace, perfect for year-round entertaining and relaxation. An attached three-car garage and large parking pad provides additional parking for guests. Upgrades are found throughout this home such as an extended breakfast room, luxury spa bathroom, no carpet, luxury vinyl plank flooring throughout, and built in bookcases in the main room. Call for a private tour.
MlsNumber: --
ListingId: 4081077


Listing Provided By: Coldwell Banker Collins-Maury Southaven, original listing
Phone: (901) 870-3685
Office Phone: (662) 548-2000
Agent Name: Nannette Deshazo
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App