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

11475 David Road
Welsh, LA 70591
NANCY CORMIER with FLAVIN REALTY, original listing - (337) 478-8530

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $450,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2533 Square Feet
Agency: FLAVIN REALTY
Agency Phone: (337) 478-8530

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1970
Notes: Welcome to this completely remodeled home, situated on a 20-acre tract of land in a serene rural setting. This home has undergone an impeccable transformation, offering modern updates throughout. Step inside and you are immediately captivated by the open concept plan. The spacious kitchen features stainless appliances, beautiful granite countertops, stone backsplash and an abundance of custom cabinets to solve all of your storage needs. The layout seamlessly connects to the family room, creating the perfect area for entertaining and spending quality time with loved ones.<br /> The living/dining room boasts a beautiful custom fireplace. This is the perfect spot to cozy up on the cold winter evenings.<br /> You will be amazed at the size of the laundry room! Perfect for that extra refrigerator, freezer or BOTH! This generous space offers cabinets and storage as well, all creating functionality and convenience. As you retreat to the primary bedroom area, you will find a custom tiled walk-in shower waiting. This luxurious addition provides a spa like experience, allowing you to unwind and rejuvenate in style. Two additional bedrooms along with another full bathroom round out the tour. One of your favorite spots will be the back screened porch! This is where you can soak up the picturesque country views, beautiful sunsets, and a glorious sunrise! Don't miss your opportunity to experience the tranquility and privacy of a rural setting while still being conveniently located close to all necessary amenities. (Improvements to the home in 2017 include-complete rewiring; blown in insulation; new sheetrock and paint; new flooring; new cabinets and granite; new dishwasher, stove; replaced walk-in shower; all new doors (interior & exterior); all new windows, light fixtures, ceiling fans. In 2019 New AC/HP; 2020-Water Heater;2021-Replaced septic system;2023-storm doors. Schedule your showing today!
MlsNumber: --
ListingId: SWL24006169


Listing Provided By: FLAVIN REALTY, original listing
Phone: (337) 275-6956
Office Phone: (337) 478-8530
Agent Name: NANCY CORMIER
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App