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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

632 Sheringham Court
Ridgeland, MS 39157

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $419,900
Beds: 4
Baths: 3
Status: Active
SqFt: 3393
Agency: Ward Enterprises Inc dba RE/MAX Connection

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1998
Notes: Welcome to this well maintained home nestled in the Wendover subdivision of Ridgeland. Situated on a small cul-de-sac, this home offers an exclusive blend of privacy and convenience.Entering the home, you're greeted by a formal entryway that opens to the formal dining room and family room. The foyer and entryway boast low maintenance scored concrete floors. The family room, accentuated by a cozy corner fireplace, offers serene views of the private backyard adorned with numerous trees, providing an ideal place for relaxation or entertaining.The home features a primary suite and an additional bedroom, both equipped with private baths on the main floor. The gourmet kitchen is a chef's dream, outfitted with granite countertops, a granite island, as well as stainless steel appliances, including a gas cooktop and double ovens, microwave, and dishwasher.Upstairs, you'll find two more bedrooms, a shared hall bath, and a bonus room that can serve as a home office, gym, home theater, or playroom.The expansive backyard hosts 2 covered porches, a pergola, and a storage shed that both remain with the property. This outdoor space is perfect for hosting summer barbecues or simply savoring a quiet evening under the stars.The Wendover community offers numerous amenities including sidewalks, access to area walking and biking trails, a private playground, clubhouse, and pool. Its convenient location in Ridgeland provides easy access to restaurants, shopping, interstate access, and the Ross Barnett Reservoir. More than a home, this home is a lifestyle. Come and experience it for yourself.
MlsNumber: 4069039


Listing Provided By: Ward Enterprises Inc dba RE/MAX Connection, original listing
Name: Ward Enterprises Inc dba RE/MAX Connection
Phone: (601) 326-3670
Office Name: RE/MAX Connection
Office Phone: (601) 326-3670
Agent Name: Stephanie P Nix
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