Property Attributes
- MLS#896180
- TypeSingle Family
- Listing Status Active
- CountyQUEENS
- CityLittle Neck
- Zip11362
- StyleContemporary
- Year Built2016
- Taxes$ 24260
- Price$ 4,280,000
- Bedrooms5
- Full Bathrooms5
- Half Bathrooms1
- Sqr Footage5640
- Lot Size0.2731 Acres
Data Source:
Listings courtesy of OneKey® MLS as distributed by MLS GRID
Property Description
A High-End Custom Resort Style Modern Mansion in Little Neck. Welcome to an extraordinary custom mansion, built in 2016, in the prestigious Little Neck area, where architectural vision meets uncompromising luxury on an expansive 11,520 sq ft lot (60x198). This 5,640 sq ft masterpiece begins with a breathtaking 20-foot grand foyer that sets the tone for unparalleled craftsmanship throughout. The coffered ceiling living room and formal dining room create sophisticated entertaining spaces, with oversized windows flooding each room with natural light. At the heart of this resort-style sanctuary lies your crown jewel—a magnificent 400 sq ft climate-controlled indoor heated pool with humidifier, delivering year-round aquatic luxury. The culinary experience reaches new heights with a custom Cambridge kitchen showcasing premium Wolf and Sub-Zero appliances, complemented by a secondary service kitchen that ensures effortless entertaining for any occasion. Comfort is elevated to an art form through ten-zone radiant floor heating, eight-zone central air, and centralized fresh air circulation with 24-hour filtration throughout every corner of this architectural marvel. Indoor and outdoor living merge seamlessly through a stunning gazebo-style sunroom that opens to your lush backyard oasis, complete with a built-in DSC BBQ set for the ultimate alfresco dining experience. Exceptional craftsmanship reveals itself in every detail—from floor-to-ceiling stonework and rich engineered hardwood to the distinctive Welsh slate roof and elegant copper gutters. Your personal wellness retreat features an authentic Canadian cedar sauna, therapeutic soaking Jacuzzi tub, and a glass-enclosed double shower with commercial-grade Hansgrohe systems, creating a spa-inspired bathroom that rivals the world's finest resorts. Entertainment reaches cinematic heights in your dedicated 7-seat home theater, where leather recliners face a commanding 120-inch screen powered by 1,240 watts of premium audio-visual technology. The formal wine cellar satisfies the most distinguished connoisseur while enhancing daily living with sophisticated storage for your finest vintages. Thoughtful luxury extends throughout with an integrated 12-zone music system, central vacuum convenience, and dual laundry rooms for seamless daily living. The grand, curved staircase, adorned with bespoke iron railings, serves as a stunning architectural focal point, while energy efficiency is maximized through the use of spray foam insulation. Quaker windows and doors frame picturesque views while flooding interiors with natural beauty. The fully finished basement expands your living possibilities with an additional 1,800+ sq ft of entertainment space, while a two-car garage provides practical luxury. This architectural masterpiece transcends ordinary luxury living, creating a private resort where every carefully crafted detail serves both beauty and function—the ultimate expression of modern sophistication and refined comfort.
| Elementary School | Middle School | High School |
|---|---|---|
| Ps 221 North Hills School Elementary School | Jhs 67 Louis Pasteur Middle School | Benjamin N Cardozo High School |
| Price History | |
|---|---|
| 8/5/2025 | Listed $4,280,000 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Natural Gas,Radiant,Radiant Floor |
| Cooling | Air Purification System,Central Air,Zoned |
| Utilities | Cable Available,Electricity Connected,Natural Gas Connected,Phone Available,Sewer Connected,Trash Collection Public,Water Connected |
| Appliances | Dishwasher,Dryer,Refrigerator,Washer |
| Garage Spaces | 2 |
| Patio/Porch Features | Porch |
| Architectural Style | Contemporary |
| Pool Features | Electric Heat,In Ground,Indoor,Pool Cover |
| Construction Materials | Blown-In Insulation,Brick |
| Year Built | 2016 |
| Property Subtype | Single Family Residence |
| Tax Year | 2024 |
| Parcel Number | 08399-0236 |
| County | Queens |
| Property Type | Residential |
| HOA | No |
| Garage Y/N | Yes |
| Other Structures | Outdoor Kitchen |
| Total Rooms | 15 |
| Full Baths | 5 |
| High School | Benjamin N Cardozo High School |
| City | New York |
| Senior Community Y/N | No |
| High School District | Queens 26 |
| Carport Y/N | No |
| Elementary School | Ps 221 North Hills School |
| Property Attached Y/N | No |
| Tax Annual Amount | 24260 |
| Middle/Junior High School | Jhs 67 Louis Pasteur |
| Building Area Units | Square Feet |
| Standard Status | Active |
| Middle/Junior School District | Queens 26 |
| Elementary School District | Queens 26 |
| Tax Lot | 236 |
| PostalCity | Little Neck |
| AttributionContact | 516-888-6000 |
| Listing Appliances | Dishwasher, Dryer, Refrigerator, Washer |
Interior Features
| Interior Amenities | First Floor Full Bath,Breakfast Bar,Central Vacuum,Chandelier,Chefs Kitchen,Crown Molding,Double Vanity,Eat-in Kitchen,Entrance Foyer,Formal Dining,High Ceilings,Kitchen Island,Primary Bathroom,Reces |
|---|---|
| Basement | Finished,Full |
| Flooring | Combination,Hardwood |
| Fireplace Features | Family Room |
| Formal Dining | Yes |
| Basement Features | Finished, Full |
| Basement (Y/N) | Yes |
| Window Features | Oversized Windows |
| Fireplace Y/N | Yes |
| Half Baths | 1 |
| Total Bedrooms | 5 |
| Eat-in Kitchen | Yes |
| Total Baths | 6 |
| General Features | First Floor Full Bath,Breakfast Bar,Central Vacuum,Chandelier,Chefs Kitchen,Crown Molding,Double Vanity,Eat-in Kitchen,Entrance Foyer,Formal Dining,High Ceilings,Kitchen Island,Primary Bathroom |
| Entrance Foyer | Yes |
Exterior Features
| Exterior Amenities | Gas Grill,Rain Gutters |
|---|---|
| Fencing | Back Yard,Fenced,Other |
| Parking Features | Attached,Driveway,Garage,Private |
| Water Source | Public |
| Parking Features | Attached, Driveway, Garage, Private |
| Building Area Total | 5640 |
| Waterfront Y/N | No |
| General Features Ext. | Gas Grill,Rain Gutters |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
OneKey® MLS required Copyright, Source of Data and Disclaimer for IDX display
Information Copyright 2026, OneKey® MLS. All Rights Reserved.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers' personal, non-commercial use.
The data relating to real estate for sale on this website comes in part from the