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;

135 Neighbor Lane
Dequincy, LA 70633

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $490,000
Beds: 5
Baths: 3
Status: Active
SqFt: 3006
Agency: RE/MAX ONE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2011
Notes: ***HEAD’S UP <br /> PEEPS! With <br /> good, <br /> acceptable <br /> offer, <br /> sellers will <br /> pay up to <br /> $10,000 of <br /> purchasers <br /> closing <br /> costs! Welcome to this incredible property with an abundance of features and amenities! <br /> <br /> This property was built in 2011 and boasts several modern features, including double ovens for the cooking enthusiasts and handicap-accessible showers in both the master and second bathroom. The master suite opens up to a serene gazebo oasis, offering a private sanctuary for relaxation. This listing sits on 7 acres and offers a picturesque 1.5 acre pond stocked with white perch and catfish. It also features a charming bridge, perfect for peaceful strolls or fishing. As a bonus, there is a fully stocked screened-in outdoor kitchen, complete with a convenient fish cleaning station. Whether you're hosting a summer barbecue or simply enjoying a quiet evening meal, this outdoor kitchen is ready for all your culinary adventures. This property is also equipped with a camper hookup. Additionally, there are second electric, water, and septic hookups available, ensuring flexibility and convenience for visitors or additional dwellings. Need extra space for projects or storage? Look no further than the 40x40 shop, featuring a 20x20 area and two 20x40 lean-tos. This versatile space is perfect for a workshop, storing equipment, or pursuing your hobbies. On hot summer days, cool off in the 24x48 above ground chlorine pool, creating the ideal setting for relaxation and fun in the sun. The fully fenced property offers privacy and safety, making it perfect for families or those seeking a tranquil retreat.<br /> <br /> The roof was replaced after Hurricane Laura, and the outside A/C unit has been recently replaced, providing peace of mind and comfort year-round. With a 24x38 carport and an attached 8x24 storage area, you'll have ample space for vehicles, equipment, and additional storage.<br /> <br /> Additional highlights of this property include a convenient pot filler, a walk-in pantry for storing all your culinary essentials, and a spacious master closet measuring an impressive 10x10.<br /> <br /> Don't miss out on the opportunity to own this extraordinary property with a stocked pond, outdoor kitchen, camper hookup, ample storage space, pool, and much more. Schedule a showing today and experience the endless possibilities this property has to offer!
MlsNumber: SWL23003653


Listing Provided By: RE/MAX ONE, original listing
Name: RE/MAX ONE
Phone: (337) 794-7848
Office Name: RE/MAX ONE
Office Phone: (337) 725-4663
Agent Name: McCall Nixon
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