Welcome home! Don’t miss the rare opportunity to own this exceptional custom luxury residence, meticulously rebuilt in 2007 by its owner for his own family, with no expense spared and only the finest materials, superior craftsmanship, and thoughtful design incorporated throughout.
This timeless, impeccably maintained brick Colonial offers the perfect blend of elegance, comfort, and functionality, providing the convenience and peace of mind today’s discerning homeowners seek. Ideally situated within a highly sought-after school district, the location offers the best of suburban living with easy access to New York City, major highways, hospitals, shopping, dining, and everyday conveniences.
Upon entering, you’re welcomed by a breathtaking chandelier and a dramatic sweeping staircase that set the stage for the home’s grand yet inviting interior. Designed for both everyday living and effortless entertaining, the home features expansive living spaces, a warm family room with a wood-burning fireplace, rich oak trim and custom moldings throughout, Pella windows, French doors, and a gourmet eat-in kitchen appointed with a Wolf range and Thermador refrigerator and freezer.
The luxurious primary suite serves as a private retreat, complete with soaring cathedral ceilings, skylights, floor-to-ceiling windows, a cozy gas fireplace, a spa-inspired en-suite bathroom, a private balcony, and a spacious walk-in closet.
Exceptional amenities continue throughout the home, including six-zone radiant heat, central air conditioning, a whole-house water filtration system, central sound system, central vacuum hookup, pre-wiring for outdoor security cameras, in-ground sprinklers, and a beautifully finished basement with a private entrance, offering endless possibilities for extended or multigenerational living, a guest suite, or recreational space.
Step outside to enjoy the private backyard oasis featuring a maintenance-free Trex deck, ideal for outdoor dining, entertaining, or simply relaxing.
Lovingly maintained by its original owner, this extraordinary home is a rare offering—an exceptional residence built with uncompromising quality and designed to provide generations of lasting comfort, elegance, and cherished memories.
Pending
$1,850,000
24236 51st Avenue, Little Neck, NY 11362
4beds
2,460sqft
Single Family Residence, Residential
Built in 1930
6,000 Square Feet Lot
$-- Zestimate®
$752/sqft
$-- HOA
What's special
Floor-to-ceiling windowsCozy gas fireplacePrivate backyard oasisCentral air conditioningCentral vacuum hookupSpa-inspired en-suite bathroomWhole-house water filtration system
- 95 days
- 82
- 1
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Cosmo Group Realty 516-246-9022,
Karen J. Millan 718-730-2937
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 1018922
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Description: Primary Bedroom with En-Suite Bathroom and Walk-in Closet, Bedroom #2 with Walk-in Closet, Bedroom #3, Bedroom #4, Full Bathroom, Laundry
- Level: Second
Basement
- Description: Full finished basement with additional living space and private entrance.
- Level: Basement
Kitchen
- Description: Foyer, Dining Room, Breakfast Nook, Kitchen, Family Room, Half-Bathroom, Living Room,
- Level: First
Heating
- Radiant, Radiant Floor
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, Exhaust Fan, Freezer, Microwave, Oven, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Gas Water Heater
Features
- Ceiling Fan(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Molding, Entrance Foyer, Kitchen Island, Marble Counters, Natural Woodwork, Open Floorplan, Open Kitchen, Primary Bathroom, Recessed Lighting, Soaking Tub, Speakers, Stone Counters, Storage, Walk-In Closet(s), Wired for Sound
- Flooring: Hardwood
- Doors: ENERGY STAR Qualified Doors
- Windows: Bay Window(s), Casement, ENERGY STAR Qualified Windows, Skylight(s), Wood Frames
- Basement: Finished,Full,Storage Space,Walk-Out Access
- Attic: Partially Finished,Pull Stairs
- Number of fireplaces: 2
- Fireplace features: Bedroom, Family Room, Gas, Masonry, Wood Burning
Interior area
- Total structure area: 3,426
- Total interior livable area: 2,460 sqft
Property
Parking
- Parking features: Driveway
- Has uncovered spaces: Yes
Features
- Levels: Two
Lot
- Size: 6,000 Square Feet
Details
- Parcel number: 081880087
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence, Residential
Materials
- Brick
Condition
- Year built: 1930
- Major remodel year: 2007
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Natural Gas Connected, Sewer Connected, Water Connected
Community & HOA
Community
- Security: Video Cameras
HOA
- Has HOA: No
Location
- Region: Flushing
Financial & listing details
- Price per square foot: $752/sqft
- Tax assessed value: $71,228
- Annual tax amount: $14,133
- Date on market: 7/16/2026
- Cumulative days on market: 93 days
- Listing agreement: Exclusive Right To Sell
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 8/16/2026 | Pending sale | $1,850,000$752/sqft |
Source: | ||
| 7/16/2026 | Listed for sale | $1,850,000-36.2%$752/sqft |
Source: | ||
| 2/14/2024 | Listing removed | -- |
Source: | ||
| 8/31/2023 | Listed for sale | $2,900,000+264.8%$1,179/sqft |
Source: | ||
| 12/13/2006 | Sold | $795,000+48.6%$323/sqft |
Source: Public Record Report a problem | ||
| 10/1/1998 | Sold | $535,000$217/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $88,920 +11.1% |
| 2024 | -- | $80,040 +1.8% |
| 2023 | -- | $78,660 +10.9% |
| 2022 | -- | $70,920 -1.4% |
| 2021 | -- | $71,940 -9% |
| 2020 | $12,469 +6% | $79,080 +7.1% |
| 2019 | $11,764 +7.3% | $73,860 +40.9% |
| 2018 | $10,968 +8.8% | $52,431 +6% |
| 2017 | $10,083 +4.3% | $49,464 |
| 2016 | $9,672 | $49,464 +0.8% |
| 2015 | $9,672 +71.9% | $49,092 +6% |
| 2014 | $5,628 | $46,314 +6% |
| 2013 | -- | $43,693 +6% |
| 2012 | -- | $41,220 -6.2% |
| 2011 | -- | $43,947 |
| 2010 | -- | $43,947 +3.2% |
| 2009 | -- | $42,565 +32.1% |
| 2008 | -- | $32,228 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: Douglaston
Nearby schools
Schools provided by the listing agent
- Elementary: Ps 98 Douglaston School
- Middle: Jhs 67 Louis Pasteur
- High: Benjamin N Cardozo High School
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.




