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;

4001 Metairie Court
Metairie, LA 70002
Sarah Rieger with Realty One Group Immobilia, original listing - (504) 228-6399

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,269,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3195 Square Feet
Agency: Realty One Group Immobilia
Agency Phone: (504) 228-6399

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Welcome to a masterpiece of luxury living, meticulously crafted by the award-winning builder RMC Construction. This stunning custom home, nestled on the prestigious last block of Metairie Court, redefines elegance and comfort with designer finishes throughout and no expense spared.<br /> Key Features:<br /> Flexible Floorplan: Designed to accommodate a variety of lifestyles, this residence boasts a primary bedroom suite conveniently located on the main floor, ensuring privacy and ease. Upstairs, discover three spacious bedrooms along with a versatile den area, perfect for a home office or playroom, complete with a built-in desk for added functionality.<br /> Gourmet Kitchen: The heart of this home is a chef’s dream kitchen featuring a full suite of Thermador appliances. Experience the convenience of a butler’s pantry, equipped with wine storage, an ice maker, and a built-in coffee maker, making it effortless to entertain guests or enjoy quiet family meals.<br /> Outdoor Entertaining: Step outside to your personal oasis, complete with an outdoor kitchen, perfect for alfresco dining and summer gatherings. This seamless indoor-outdoor living space allows you to bask in the beauty of the surrounding environment.<br /> Unmatched Storage: Every inch of this home has been thoughtfully designed to provide ample storage, ensuring a clutter-free living experience.<br /> Security & Peace of Mind: Enjoy peace of mind with a state-of-the-art security system, providing a safe haven for you and your loved ones.<br /> Prime Location: Enjoy easy access to the levee and Bonnabel boat launch, perfect for outdoor enthusiasts. This prime location offers unparalleled convenience to all the amenities Metairie has to offer, from dining and shopping to parks and recreation.<br /> This extraordinary new construction home is a rare find, combining luxury, functionality, and a prime location in one magnificent package. Don’t miss your chance to own a piece of elegance in Metairie—schedule your private showing today! Flood Zone X.
MlsNumber: --
ListingId: 2470084


Listing Provided By: Realty One Group Immobilia, original listing
Phone: (504) 228-6399
Office Phone: (504) 228-6399
Agent Name: Sarah Rieger
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