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

506 Quentin Road Se
Mccall Creek, MS 39647
Robin D. McDaniel with United Country - McDaniel Gray, original listing - (601) 835-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 3721 Square Feet
Agency: United Country - McDaniel Gray
Agency Phone: (601) 835-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 43 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: Welcome to your dream estate, a stunning 43.38-acre paradise overlooking the serene McCall Creek and adjoining the beautiful Homochitto National Forest. This newly constructed property features a magnificent 3,721 square foot barndominium that perfectly combines rustic charm with modern comfort. With six spacious bedrooms and four luxurious bathrooms, there's ample space for family, friends, and guests. The barndominium includes a convenient garage and a charming front porch, perfect for relaxing and enjoying the breathtaking views of the surrounding landscape. Inside, the open floor plan seamlessly connects the living, dining, and kitchen areas, creating a warm and inviting atmosphere. For those looking to expand or customize, the property offers an additional house pad complete with well, septic, and power. This ready-to-build site provides endless possibilities for a guest house, rental property, or personal retreat. There is also an equipment shed for your tractor, trailers and ATVS The estate is a haven for outdoor enthusiasts and gardeners alike. A large garden spot awaits your green thumb, while numerous fruit trees promise a bountiful harvest. The property also includes hay ground and a thriving pine plantation, offering both beauty and potential income. This exceptional property truly has it all—new construction, breathtaking views, ample living space, and numerous opportunities for both relaxation and productivity. Plus, with direct access to the Homochitto National Forest, you'll have endless opportunities for outdoor adventures right at your doorstep. Don't miss your chance to own this unique and versatile estate overlooking McCall Creek.
MlsNumber: --
ListingId: 141727


Listing Provided By: United Country - McDaniel Gray, original listing
Phone: (601) 757-2700
Office Phone: (601) 835-2000
Agent Name: Robin D. McDaniel
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