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 = 1421 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 = 1421 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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 = 1421 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;

5138 St Andrews Cove
Olive Branch, MS 38654
Brian Couch with Burch Realty Group Hernando, original listing - (662) 449-1700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $864,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 4793 Square Feet
Agency: Burch Realty Group Hernando
Agency Phone: (662) 449-1700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Elegant and Spacious home with in-ground pool in Wedgewood Golf Community! Sitting on a 1.68 +/- corner lot, this beauty has it all! The gorgeous, landscaped grounds and the elegant interior and quality construction make this home a real showstopper! The living space offers 6 Bedrooms, 4 Bathrooms, Formal Living and Dining Rooms, an impressive Great Room with a two story ceiling, and a kitchen that is open to a breakfast and hearth area. Highlights include an impressive two-story entry with extensive iron railing that starts at the foyer entry and extends to the upstairs; a Chef's kitchen with a buffet and desk area, large island, upgraded appliances that include double ovens and cooktop, custom painted cabinets with stunning quartz counters, decorative backsplash, under cabinet lighting and a walk-in pantry; a massive Master retreat with a sitting area offering a door to covered back porch and an ensuite bathroom that includes two separate vanities with quartz counters, a Jacuzzi brand air bath, a separate shower with wall and rain head faucets, and 2 walk-in closets. Other extras include a second bedroom down with full bathroom, an upstairs that has four additional bedrooms (all with walk-in closets), a jack-n-jill bath between 2 of the bedrooms and another full bath with private access from the 5th Bedroom. Bedrooms 3 and 4 have a door that leads to the upstairs exterior balcony that overlooks the fabulous sparkling pool and the walk-in attic has more storage space than you would ever need. Additional interior features include nailed down hardwood flooring, gorgeous iron work, plantation shutters on every window, upgraded lighting throughout, upgraded cabinet hardware, two staircases, a laundry room with sink, tons of cabinets and room for an extra fridge and if that isn't enough, the outside gets even better! From the extensive landscaping to the heated in-ground pool to the covered back porch to the upstairs balcony with spiral staircase to the outdoor kitchen area, you will never want to go inside. Other exterior features include a 3-car garage, a friend's entrance on the side, tons of additional parking, and a circle driveway. For the golfers, home is located between the 9th green, 1st tee box and the 18th green. It has been meticulously maintained and is a must see to truly appreciate all it has to offer.
MlsNumber: --
ListingId: 4091048


Listing Provided By: Burch Realty Group Hernando, original listing
Phone: (901) 461-7653
Office Phone: (662) 449-1700
Agent Name: Brian Couch
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 = 1421 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;
Grace Webb
ASCIICentury 21 Home First Realtors
Call Today!: (901) 210-8669

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App