$3,300,000
210-23-25 Jamaica Avenue
Queens Village, NY 11428
Listed with NYCRB Corp
$4,280,000
Est. $23,304/moLittle Neck, NY 11362 · Queens
Know your budget before you tour. Get pre-qualified
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.
As reported by the listing office; verify enrollment with the district.
Listed with RE/MAX 1st Choice · Po Wei Tair · Source: OneKey MLS
Information provided by One Key MLS, and is deemed reliable but not guaranteed accurate. Data last updated: Sep 18, 2026, 11:08 AM ET. ©2026 One Key MLS.
Estimate your mortgage payment, including the principal and interest, taxes, insurance, HOA, and Private Mortgage Insurance.
Estimated Monthly Payment
Representative rates
Representative rates only, indicative for comparison. Edit the interest rate for your own quote; your lender’s numbers vary with credit, points, and insurance.
Be the first to know when a Queens home hits the market.
Market Insights
Current Listings
New in the last 30 days
19
Sep 2026
Average Price
Active listings
$927,345
Sep 2026
Average Days on Market
Active listings
108 days
Sep 2026
Computed from 118 active OneKey MLS listings in Little Neck, NY.
$3,300,000
210-23-25 Jamaica Avenue
Queens Village, NY 11428
Listed with NYCRB Corp
$3,300,000
0.1 Acres
2145 23rd Street
Astoria, NY 11105
Listed with Modern Spaces Love Your Place
$2,999,999
6 Bed • 4 Bath
21432 40th Avenue
Bayside, NY 11361
Listed with Continental Real Estate Group