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

530 Glendale Drive
Metairie, LA 70001
Brittany Picolo-Ramos with Godwyn Realty, ERA Powered, original listing - (504) 826-8426

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,399,000
Beds: 5
Baths: Full: 4, ½: 2
Status: Active
SqFt: 5044 Square Feet
Agency: Godwyn Realty, ERA Powered
Agency Phone: (504) 826-8426

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Introducing a masterpiece of luxury living in the heart of Old Metairie. Crafted by RMC Construction, this breathtaking custom-built home embodies the epitome of sophistication and meticulous attention to detail. Every aspect of this residence has been thoughtfully curated offering an unparalleled level of comfort and elegance. Upon entering the grand foyer adorned with exquisite marble flooring, the residence unveils its true beauty. Boasting 11ft and 14ft ceilings, this home provides an airy and spacious atmosphere with European White Oak engineered floors & custom one-of-a-kind light fixtures. The living room features a custom-made stucco fireplace and open concept living. The gourmet kitchen is a chef's dream, equipped with top-of-the-line Thermador appliances, including a range with 6 burners, griddle, double oven, fridge, freezer, dishwasher, convenient pot filler and built-in coffee maker system. The custom bar area includes a wine cooler and ice maker for entertaining. The first floor offers a junior primary suite with an ADA shower, a walk-in closet with laundry hookups and elevator for easy convenience. A custom marble waterfall edge countertop in the downstairs half bathroom adds a touch of contemporary elegance. The whole house speaker system ensures a seamless audio experience throughout. Upstairs, discover an additional morning kitchen, a media room with built-in speakers, and a built-in water filtration station for added convenience. The primary suite is a sanctuary of relaxation, featuring a custom-designed closet, a luxurious soaking tub paired with a spacious walk-in shower. The thoughtful design extends to the outdoors, where a fully landscaped yards surrounds an outdoor kitchen equipped with a BBQ pit, ice maker, fridge, and sink. This home is a testament to timeless elegance, seamlessly blending classic and contemporary design elements. Don't miss this opportunity to own a residence that transcends luxury.
MlsNumber: --
ListingId: 2437371


Listing Provided By: Godwyn Realty, ERA Powered, original listing
Phone: (504) 300-5179
Office Phone: (504) 826-8426
Agent Name: Brittany Picolo-Ramos
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.


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 = 1143 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;
Real Estate Expert Photo for Kasi Champagne
Kasi Champagne
ASCIIeXp Realty
Call Today!: (504) 715-0115

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App