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 = 3377 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 3377 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 3377 AND i.igate IN ('usahud','nyhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

32 Boulevard
Malba, NY 11357

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,900,000
Beds: 6
Baths: 6
Status: Active
SqFt: 7218
Agency: Douglas Elliman Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2009
Notes: All Buyers MUST Register in Advance. Seller Requires Buyer ID & Pre-Approval Supporting List Price to enter. Elegance & Luxury is Truly Redefined on 32 Boulevard. A Custom-Built 4-Level Expansive Waterfront Mansion in the Private Enclave of Malba. "Palazzo di Acqua" has a Feng Shui Inspired Architectural Design providing Elements of Metal, Water, Wood, Fire & Earth. Premium 7,200 SF on .25 Acre. Ultra Luxurious & Upscale Living Awaits you in the heart of the Elite NYC Suburbs. Young & Completed in 2009 w/ Unparalleled Architectural Details & Meticulous Craftsmanship. Designed for Quintessential Indoor-Outdoor Living. Each Level connects to Lush Outdoor Actual Usable Living Space. Experiencing Unobstructed Waterviews & Complete Serenity daily from Each Room. Magnificent Open Waterviews combined with the NYC Skyline, Stunning Sunsets, the Sound of Water & Birds will leave you Daydreaming. An Silent Elevator stops on all 4 levels of this modern Masterpiece (excellent to transport heavier items) or if you don't feel like take the Stairs. With every detail considered from Quality, High-End Materials, to Modern Classic Style to Practically & Comfort, this home Optimizes Luxury in Every Way. Your choice of 3 Fireplaces. 2 Wet Bars. Chefs Eat-in Kitchen or Outdoor Kitchen. 3 Ensuite Bedrooms. 2 Jack & Jill w/ Marble Bath. Layout features 4 Bedrooms on 2nd Floor w/ large Loft overlooking 1st Floor, Private Primary Bedroom w/ Separate Seating, Office or Nursery Room and 4 Custom Walk in Closets on 3rd Floor & 6th Bedroom on Lower Level. Lower Level is Half in Ground & Half Above w/ large Ingress-Egress Windows, 3 Entry points and 10 ft Ceilings, truly making this additional Grand Living Space. Ground Floor Entry from 3 Car Garage or Door (no stairs) or Private Rear Separate Entry Door w/ Exterior Walk Up. Volume Coffered & High Ceilings throughout. HUGE Cigar Lounge w/ Commercial Exhaust & Wet Bar. Movie Theatre w/Lux Cinema Seating & Lighting. Gym w/ Marble Full Bath & Steam Shower. Central Vacuum. Saltwater IG Pool w/Seating & Hot Tub. Lower Level Can be Private In-law Suite or Guest/Nanny Quarters. Large Laundry Room w/dual W/D. 3 Car Att Garage & Huge Driveway to accommodate multiple Cars. Entertainers Dream. Love to have Parties or Entertain? Plenty of Parking for Guests & Flow through Space, Exquisitely Designed for Entertaining! Home offers a Beautiful Landscaped Catwalk w/ Stone Walkway, allowing guests to come directly to yard w/out entering Home. Separate Private Waterfront Veranda on other Side of Home off Banquet Size Dining Room as outdoor lounge. Every Detail Meticulously Captured! 40 Ft Deeded Boat Dock in Private Malba Marina. All of this is included with Palazzo di Acqua! 25 Min to Manhattan. 5 Star Resort-Style Living Right in NYC! Moments to ALL. Home can come furnished or vacant. Be Prepared to be Impressed! Seller Would Hold Financing at a Low Interest Rate for Right Buyer! Welcome Home to your DREAM HOME, you will NEVER want to leave! The Next Move is Yours!
MlsNumber: 3538774


Listing Provided By: Douglas Elliman Real Estate, original listing
Name: Douglas Elliman Real Estate
Office Name: Douglas Elliman Real Estate
Office Phone: (516) 681-2600
Agent Name: Maria Kafetzis
Disclaimer: Copyright © 2024 OneKey MLS. 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