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

105 Davis Dr
Thibodaux, LA 70301
Angela Delatte with eXp Realty, LLC, original listing - (337) 526-9330

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $675,000
Beds: 3
Baths: Full: 2, ½: 2
Status: Active
SqFt: 2704 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (337) 526-9330

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: WHAT'S SPECIAL: Beautiful Landscaping, Courtyard, Decorative Concrete, Backyard Hibachi, Custom Copper Fountain, Covered Patio. Welcome Home to your dream oasis! This remarkable find located in this coveted community has been meticulously crafted and maintained. Step into the foyer to be greeted by soaring ceilings. Feel the flood of natural sunlight coming in through the French doors that seamlessly connect the living room and outdoor patio courtyard area. Restore and relax while you listen to the soothing sounds of the custom hammered copper fountain. Enjoy the beautiful view of the lush landscape. Grill and watch the game or your favorite movie on the large flatscreen tv. The kitchen is complete with granite countertops, stainless appliances, centrally located island, raised breakfast bar, and adjacent formal dining area. Imagine the ease of entertaining with space for informal, formal and holiday gatherings. Picture yourself sitting cozily near the fireplace in your peaceful new home which features 3 bedrooms, 2 full and 2 half baths, an office space and study. Practical amenities abound, including a pantry, linen closets, large laundry room, large walk-in closet, spacious garage with custom-built cabinets. The exterior is adorned with landscape lighting, copper lanterns, copper awnings, window box and decorative concrete floors in carport/patio areas and gutters. Generac Whole Home Generator as well as functional hurricane shutters and custom storm panels and screens for specialty windows/doors provide comfort and protection during storm season. Video surveillance and burglar alarm systems. New Storm Master Shake Premium shingle roof. Landscaping and lawn equipped with irrigation systems. Gas quick connect on patio. Large vacant green space for you to add your own outdoor amenities. Located near medical offices, hospital, university, schools, dining options, gyms, and stores. Do not miss this great opportunity to schedule your appointment today!
MlsNumber: --
ListingId: 2024010907


Listing Provided By: eXp Realty, LLC, original listing
Phone: (337) 526-9330
Office Phone: (337) 526-9330
Agent Name: Angela Delatte
Disclaimer: Copyright © 2024 Bayou 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.


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 = 1147 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;
Wendy Benedetto
ASCIILatter & Blum COMPASS
Call Today!: (504) 274-3349

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App