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;

2509 Pelitere Drive
Chalmette, LA 70043

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $219,999
Beds: 4
Baths: 3
Status: Active
SqFt: 2568
Agency: Crescent City Living LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: You're going to be hard-pressed to find another property like this in St. Bernard Parish! 2509 Pelitere is zoned C-1 Neighborhood commercial, which offers lots of possibilities, from living on site and making the former beauty salon into an STR (help pay the mortgage!) to using it for another business! There is a dedicated driveway for this additional unit/space. Lack of imagination is the only thing that would hold you back! <br /> <br /> <br /> <br /> <br /> As you enter the home, you will be struck by the huge living space, complete with a wood fireplace and wet bar. The kitchen is spacious and offers tons of cabinet space. The built-in oven is original and still functioning, but the newer gas range/oven is also available. Throw in the breakfast space to complete the package. It even has a pantry! <br /> <br /> <br /> <br /> <br /> Downstairs offers the primary suite (with its own half bath) and another bedroom. Both are well-sized and have two closets. Storage is not an issue at this home! <br /> <br /> <br /> <br /> <br /> Head upstairs and check out the massive landing, which could be a playroom, office, gym, or whatever your heart desires! The bedrooms are large and have even more closet space! There are THREE attics—two of them are walk-ins! You really can have it all! <br /> <br /> <br /> <br /> <br /> Lagniappe: seamless gutters, X flood zone with flood policy, termite contract, and a covered patio! The yard space is manageable and even includes two big fig trees. <br /> <br /> <br /> <br /> <br /> This property is a once-in-a-lifetime opportunity!
MlsNumber: 2448491


Listing Provided By: Crescent City Living LLC, original listing
Name: Crescent City Living LLC
Phone: (504) 327-5303
Office Name: Crescent City Living, LLC
Office Phone: (504) 327-5303
Agent Name: Leslie Heindel
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