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

3201 Tracy Street
Meraux, LA 70075
Cathy Nunez with 1 Percent Lists Legacy, original listing - (504) 499-0047

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3252 Square Feet
Agency: 1 Percent Lists Legacy
Agency Phone: (504) 499-0047

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Elegant, Exceptional Corner Lot Home in Desirable Neighborhood!<br /> <br /> Welcome to this stunning 4-bedroom, 3.5-bath home offering over 3,250 square feet of spacious living. Situated on a beautiful corner lot in a quiet, sought-after neighborhood, this home is designed for comfort, functionality, and style.<br /> <br /> As you step inside, you’ll be greeted by a generous, open floor plan that flows effortlessly from room to room. The expansive kitchen is the heart of the home, featuring gorgeous granite countertops and a large floor-to-ceiling pantry. This home has plenty of natural light. Fitted with luxury vinyl flooring throughout, adding both durability and elegance to the space.<br /> <br /> The primary bedroom is a true retreat, boasting a dream walk-in closet and a luxurious spa-like bathtub that invites relaxation. Additional highlights include a full-size office/flex space, a workshop, and spray foam insulation in the attic for energy efficiency.<br /> Easy to entertain, with an inviting backyard features a fire pit—made for cookouts, seafood boils, and gatherings with friends and family.<br /> <br /> Located in the high-demand, Blue Ribbon Joe Davies School District, this home offers convenience as well. You can walk to a nearby playground and state-of-the-art library without ever touching the highway. Plus, with low-cost, assumable flood insurance at approximately $900 per year, peace of mind comes easily.<br /> <br /> Don’t miss out on this exceptional home—made for hosting holidays and making lasting memories. There's room for everyone! *See our virtual tour video!<br /> **1 year Home Warranty included with the right offer!
MlsNumber: --
ListingId: 2468934


Listing Provided By: 1 Percent Lists Legacy, original listing
Phone: (504) 258-5410
Office Phone: (504) 499-0047
Agent Name: Cathy Nunez
Disclaimer: Copyright © 2024 Gulf South Real Estate Information Network. 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