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;

3521 Corinne Avenue
Chalmette, LA 70043
TIFFANI L BERNHEISEL with KELLER WILLIAMS REALTY PROFESSIONALS, original listing - (985) 649-6333

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $465,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 2746 Square Feet
Agency: KELLER WILLIAMS REALTY PROFESSIONALS
Agency Phone: (985) 649-6333

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: Live your dream life in this stunning 2-story popular Corinne Estates home! Not only does this beautifully maintained & loved 4bd/4.5bth have over 2746 sq ft of living space, but it offers wood flooring throughout main living area & office; kitchen with beautiful granite counters, convenient island/breakfast bar, New stainless steel Jen-Air Built in Wall Oven, Convection Oven/Microwave, Warming Drawer, Jen-Air 5 burner gas cooktops & tons of cabinetry; formal dining rm; custom wood plantation shutters throughout home and custom aluminum hurricane shutters on exterior. ALL bedrooms upstairs w/master bedroom ensuite w/walk-in closet, dual vanities, garden tub & walk-in shower; tile flooring in wet areas, vast, private backyard w/covered brick patio, rear yard access, custom electronic iron fencing to access side drive & rear detached garage! 2 High efficient HVAC system (with 1 less than a year old) keeps the electricity bill at an average of $100 a month. Other features include gas front lanterns, 2 tankless hot water heaters, new garage door opener with light, sprinkle irrigation system with sub-surface drainage, transferable window warranty, and LED garden and fence lighting. Gas or wood burning fireplace in living room keeps the home cozy in the winter time. This home's location is nestled in a family-friendly neighborhood just minutes from shopping/restaurants/amenities. Don't pass up this wonderful opportunity--come see this gem today!
MlsNumber: --
ListingId: 2430747


Listing Provided By: KELLER WILLIAMS REALTY PROFESSIONALS, original listing
Phone: (504) 339-6999
Office Phone: (985) 649-6333
Agent Name: TIFFANI L BERNHEISEL
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