Title Page Background
DEBUG FN args: Array ( [0] => 1465 [1] => [2] => [3] => agent ) BEFORE: Site: 1465 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1465 Igate: njhud LocID: 1465 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1465 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1465 [1] => [2] => [3] => lender ) BEFORE: Site: 1465 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1465 Igate: njhud LocID: 1465 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1465 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1465 [1] => [2] => [3] => other ) BEFORE: Site: 1465 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1465 Igate: njhud LocID: 1465 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1465 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
<< Go Back | All Foreclosures | | | All Cities

148 Stanton Hall Drive
Florence, MS 39073
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $479,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2800 Square Feet
Agency: McGee Realty Services
Agency Phone: (601) 845-8139

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: &#127969; Welcome to your own private oasis at 148 Stanton Hall Dr., Florence, MS! Nestled on a sprawling 10.6-acre wooded property with Steens Creek running through, this home offers the perfect blend of tranquility and convenience, along with exceptional hunting opportunities.&#127795; Embrace nature's beauty on this expansive estate, complete with a stocked pond and approximately 10 acres of prime wooded land, making it a hunter's paradise. Wildlife enthusiasts will appreciate the abundance of deer and turkey roaming the property, providing ample hunting opportunities right in your backyard.&#128293; Step inside this charming home featuring hardy plank exterior siding and be captivated by the character-filled interior. The focal point is a stunning real brick fireplace with a mantle crafted from a foundation beam of an antebellum home, adding a touch of history and warmth to the space. Between the kitchen and living room, a huge beam, handcrafted and distressed to add a rustic appeal, serves as a unique architectural feature.&#127860; The heart of the home is the well-appointed kitchen boasting stainless steel appliances, concrete countertops, and a spacious bar/table at its center, perfect for meal prep and entertaining. Beaded wood ceilings throughout the living and kitchen areas add a touch of rustic charm and character to the space.&#128663; Outside, you'll find an oversized carport that extends into a spacious porch area, providing ample room for outdoor entertaining and relaxation. This versatile space is perfect for hosting gatherings or simply enjoying the peaceful surroundings after a day of hunting.&#128716; Retreat to the primary suite offering a tranquil escape with an ensuite bath, while two additional bedrooms and a playroom upstairs provide ample space for family and guests. Expand your living space by utilizing the attic space, offering endless possibilities for customization.&#129420; Outdoor enthusiasts will delight in the recreational opportunities this property provides, from hunting in the wooded acres to fishing in the stocked pond. Listen to the soothing sounds of Steens Creek meandering through the grounds, enhancing the serene ambiance of this idyllic retreat.&#127775; Don't miss the chance to own this exceptional property that seamlessly blends natural beauty with comfortable living and unparalleled hunting opportunities. Schedule your showing today and experience the magic of 148 Stanton Hall Dr!
MlsNumber: --
ListingId: 4079421


Listing Provided By: McGee Realty Services, original listing
Phone: (601) 832-4715
Office Phone: (601) 845-8139
Agent Name: Chuck L McGee
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => rankin [3] => MS [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: rankin State: MS Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: rankin State: MS Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1465 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Cindy Robertson
ASCIIMaselle & Associates
Call Today!: (601) 331-5599

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App