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;

1888 Springfield Road
Senatobia, MS 38668
Barbara Ferguson with Burch Realty Group Hernando, original listing - (662) 449-1700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $759,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 4056 Square Feet
Agency: Burch Realty Group Hernando
Agency Phone: (662) 449-1700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: IF YOU ARE LOOKING FOR PRIVACY CLOSE TO TOWN (12 MINUTES FROM SENATOBIA I:55) YOU MUST SEE THIS UNIQUE 4056 +- SQ.FT HOME WITH AN ADDITIONAL 1007+- SQ.FT 3-SEASON ROOM WITH 1/2 BATH ON 10.87 ACRES SURROUNDED BY VIEWS OF APPROX. 2200 BEAUTIFUL ACRES OF LAND ENTER THE DOUBLE GATES AND YOU WILL SEE THIS STUNNING HOME SITTING ON TOP OF A HILL WITH A WINDING CONCRETE DRIVE . THE HOME SHOWCASES A LARGE FRONT PORCH WITH A VIEW TO DIE FOR AND AN AMAZING PLACE TO GETAWAY AND ENJOY THE PEACE AND QUIET ! THIS HOME HAS AN ENTRY HALL , A DINING ROOM LARGE ENOUGH FOR THE WHOLE FAMILY , A STUDY WITH A FIREPLACE AND BUILT IN BOOK SHELVES ,A HUGE DEN WITH GAS FIREPLACE OPENS INTO A BEAUTIFUL KITCHEN/BREAKFAST ROOM WITH A 5 SEATER ISLAND WITH A BAR SINK ,DOUBLE OVENS ,(GAS COOKTOP TO BE INSTALLED), STAINLESS APLIANCES AND A WALK IN PANTRY.THE MASTER BEDROOM IS ON THE MAIN FLOOR AND FEATURES A MASTERBATH WITH A CLAW FOOT TUB, ,A LARGE WALK IN SHOWER ,DOUBLE SEPARATED VANITIES AND AN ENORMOUS CUSTOM HIS/HERS CLOSET . THERE IS A GUEST ROOM AND FULL BATH ON THE MAIN FLOOR ,A LARGE LAUNDRY ROOM AND A MUDROOM ,STORAGE ROOM AND HALF BATH . A STAIRCASE OFF OF THE ENTRY HALL LEADS TO THE UPSTAIRS WITH TWO BEDROOMS ,TWO BATHS AND A GREAT ROOM THAT IS LARGE ENOUGH TO HAVE TWO OR THREE BEDS OR A MEDIA/GREATROOM .THERE IS A GIGANTIC FLOORED ATTIC THAT COULD BE FINISHED IF NEEDED AND A BACK STAIRCASE LEADING TO THE HALL OFF OF THE KITCHEN . I SAVED THE BEST TO LAST ,THE AWESOME VAULTED WOODBEAMED THREE SEASON ROOM, 1007 +- SQ.FT. OF ENJOYMENT WITH A WOODBURNING FIREPLACE AND A HUGE BAR ,AN ICEMAKER ,BAR SINK, FRIDGE AND A LARGE DINING AREA TO TOP IT OFF !!!!!THERE IS A HALF BATH WITH A MINI SPLIT THAT ADJOINS THIS ROOM. THE HOME HAS A 3- CAR GARAGE AND A LARGE CONCRETE PARKING AREA . THERE ARE 3 ELECTRIC HEAT/AIR UNITS AND 2 ELECTRIC HOTWATER HEATERS.A ,NEW ROOF AND NEW CARPET UPSTAIRS , THERE ARE TOO MANY AMENITIES TO LIST !YOU JUST HAVE TO COME AND SEE !!!!!!!
MlsNumber: --
ListingId: 4097469


Listing Provided By: Burch Realty Group Hernando, original listing
Phone: (662) 560-7926
Office Phone: (662) 449-1700
Agent Name: Barbara Ferguson
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