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

126 Coffee Street
Mandeville, LA 70448
SHERRIE S YBARZABAL with KELLER WILLIAMS REALTY SERVICES, original listing - (985) 727-7000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,565,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 3675 Square Feet
Agency: KELLER WILLIAMS REALTY SERVICES
Agency Phone: (985) 727-7000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Lakefront living at it’s finest! Don’t be fooled by the Coffee street address, this home faces and is nestled 186 feet from Lakeshore Drive with gorgeous views and the most romantic sunsets of Lake Pontchartrain. Enjoy by watching each evening from your wrap around porch. You'll even have your own private Ravine Aux Coquilles in the rear, peacefully surrounded by green-space. This Ravine connects directly to the Lake, easily kayak or take a small boat anytime you'd like. You’ll find this property will do it all. Enjoy privacy all while being steps away from the Lakefront and all it has to offer. Golf cart ride to all the local restaurants, bars and shops Old Mandeville has to offer. This meticulously maintained home sits on over 1/2 an acre of beautifully manicured gardens with in-ground irrigation, large open green-space areas, being anchored by a sprawling 100+ year old Oak tree. Enjoy the views anywhere from inside with walls of windows in every room, especially the Chef’s kitchen, every entertainer’s dream - Calcutta Marble counters & backsplash, high end Thermador appliances with wine column & ice maker, one of a kind wet-bar and handcrafted Alder wood cabinets. Multiple French doors open to the 10 foot, covered wrapped porch area with electric lift. A few additional highlights include a FULL home generator, multiple walk-in attic spaces, 12 Bevolo gas lanterns, surround sound/lighting & an electric private gate entry with so much more, please see the attached amenities list included and video tour. Not included in the square footage is 4000 sqft of under home space including covered parking for multiple cars, a closed-in storage shed with cabinets/shelving/peg board with dual entry access AND the “Cook’s House”, a charming Historic detached private dwelling, (full bath, bedroom/loft area-300 sqft) - perfect for guests and/or rentable space. Schedule to view this one-of-a-kind, Old Mandeville estate today, it won't last long! **check out the virtual tour link** https://vimeo.com/837024403?share=copy
MlsNumber: --
ListingId: 2453816


Listing Provided By: KELLER WILLIAMS REALTY SERVICES, original listing
Phone: (985) 727-7000
Office Phone: (985) 727-7000
Agent Name: SHERRIE S YBARZABAL
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 = 1169 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 Fiorella Avenue Realty
Fiorella Avenue Realty
ASCIIFiorella Avenue Realty
Call Today!: (985) 788-7110

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App