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

1322 Spencer Trail Sw
Bogue Chitto, MS 39629

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $319,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1823 Square Feet
Agency: Doug Rushing Realty
Agency Phone: (601) 876-3409

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Located within the landscapes of Arlington in Lincoln County, MS, lies a new construction home of unparalleled elegance and charm. Situated on a sprawling 2-acre lot in a highly sought-after area, this residence embodies the epitome of refined living in a peaceful setting. Welcome to this exquisite 2670 square foot abode, where every detail has been thoughtfully considered to create a harmonious blend of comfort and sophistication. Boasting 1823 square feet of meticulously crafted heated and cooled living space, this home offers a sanctuary for a new family starting their journey or a retired couple seeking the perfect haven. Step inside to discover a luminous interior adorned in a beautiful white palette. With 4 bedrooms and 2 bathrooms, this home provides ample space for both relaxation and entertainment, ensuring that every moment spent here is filled with joy and contentment. Outside, the property unfolds onto 2 acres of lush greenery, offering a private retreat where one can bask in the beauty of nature and savor the tranquility of the surroundings. Located in a new subdivision with a cul-de-sac, the setting is perfect for those craving a slower pace of life and a strong sense of community. Conveniently positioned just a short drive off the interstate, this lovely abode effortlessly combines convenience with luxury, inviting you to embrace a lifestyle of serenity and sophistication. Asking $319,500.
MlsNumber: --
ListingId: 142838


Listing Provided By: Doug Rushing Realty, original listing
Phone: (601) 876-7984
Office Phone: (601) 876-3409
Agent Name: Jacob Cantrell
Disclaimer: Copyright © 2024 Southwest Mississippi Board of Realtors. 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