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

600 N Overton Street
Dequincy, LA 70633
JOSH FOSTER with Exit Realty Southern, original listing - (337) 287-9500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $485,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3450 Square Feet
Agency: Exit Realty Southern
Agency Phone: (337) 287-9500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Welcome to your dream home in the heart of DeQuincy! Nestled on a generous 2-acre parcel, this meticulously crafted Acadian-style brick home is a true masterpiece. Boasting 3 bedrooms, 3.5 bathrooms, and a plethora of amenities, this property offers a lifestyle of comfort, luxury, and convenience. This exquisite Acadian-style home combines traditional charm with modern amenities, creating a warm and inviting atmosphere that you'll be proud to call home. With its spacious layout, ample storage, and incredible workshop, this property is an ideal choice for those seeking a blend of comfort and functionality. <br /> Property Highlights:<br /> <br /> Open Floor Plan: As you step inside, you'll be greeted by an inviting and spacious open floor plan. The living area seamlessly flows into the kitchen and dining area, creating the perfect space for entertaining family and friends.<br /> <br /> Upstairs Game Room and Office: Need extra space for work or play? This home features a large upstairs game room and a dedicated office area. Whether you're into gaming, working from home, or simply need a versatile space, you'll find it here.<br /> <br /> Impressive Workshop: Car enthusiasts and hobbyists, take note! The property includes a substantial 30x40 brick siding workshop with 2 bays and a convenient half bath. The 16-foot overhangs provide ample space for RV parking, making it the perfect spot to work on projects or store your vehicles and equipment. (Please note: Seller reserves the car lift in the workshop.)<br /> <br /> Concrete Drive: The concrete driveway adds to the property's curb appeal while providing a smooth and durable surface for parking and maneuvering vehicles.<br /> <br /> Beautiful Landscaping: Surrounding the home is a lush and beautifully landscaped yard, enhancing the overall aesthetics of the property and providing a serene backdrop for outdoor activities.<br /> <br /> Central HVAC Replaced in 2021: Enjoy peace of mind with the recently replaced central HVAC system, ensuring year-round comfort and energy efficiency.
MlsNumber: --
ListingId: SWL23005921


Listing Provided By: Exit Realty Southern, original listing
Phone: (337) 287-9500
Office Phone: (337) 287-9500
Agent Name: JOSH FOSTER
Disclaimer: Copyright © 2024 Greater Southern MLS. 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 = 1127 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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;
Scott Moffett
ASCIILATTER & BLUM, INC
Call Today!: (337) 540-3498

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App