Date
Details
Price
Change
Source
11/02/2025
Listed
$3,250,000
—
MLS
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/48
$3,250,000
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
1/48
Property Description
NOTHING compares to this stately mansion in the Rockwood Park Section of New Howard Beach. Close to major highways, JFK, and commuting to Manhattan, this location is unbeatable. This breathtaking 6 bedroom, 6.5 bath offers the most prestigious option when looking for a sizable estate. The massive iron doors invite you to the grand entrance, double level, with a winding staircase with hand carved wooden and wrought iron railing. To the right, is a ceiling to wall custom built wood library. Over 5000 square ft and situated on a 10,000 sq. ft. lot, this home is unique. Every room in the house has crown molding, custom millwork, coffered ceilings or some premium and extravagent detail. The designer kitchen with radiant heat has a tremendous center island to entertain your guests. These solid wood custom made cabinetry offers a timeless expression of elegance and class. Equipped with 2 sub-zero refrigerators plus pull out refrigerator drawer, 2 Bosch dishwashers, Viking Stove with grill and custom hood. Formal living with fireplace, leads into the formal living room and bar. Every room is enhanced by intricate crown molding and classic white trim. Recessed lighting throughout with beautiful chandeliers. The refined elegance of the backyard could host the most distinguished events and family gatherings. Mature trees and plantings grace the backyard, with a waterfall and pond, surrounding the heated free form swimming pool. The second level has a separate landing for seating, and has 6 bedrooms all en-suite. With walk out access from the lower level/basement and 9 foot ceilings, this level with make guests want to stay the weekend! Don't worry about the wash with 2 washers and 2 dryers. This home is for a buyer with discerning taste and doesn't disappoint.
Full Property Details
Full Property Details for 87-07 158th Ave
General
- Price: $3,250,000
- Taxes: $10,500
- Status: Active
- Type: Single Family
- Source: Long_Island
- MLS ID: 916039
- Updated: 11/2/2025
- Added to Site: 75 day(s) ago
Interior
- Number of Rooms: 12
- Interior Features: Beamed Ceilings, Breakfast Bar, Built-in Features, Cathedral Ceiling(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Molding, Double Vanity, Dry Bar, Eat-in Kitchen, ENERGY STAR Qualified Door(s), Entertainment Cabinets, Entrance Foyer, Formal Dining, Granite Counters, High Ceilings, High Speed Internet, His and Hers Closets, In-Law Floorplan, Kitchen Island, Low Flow Plumbing Fixtures, Natural Woodwork, Open Floorplan, Open Kitchen, Pantry, Primary Bathroom, Recessed Lighting, Sound System, Speakers, Storage, Tray Ceiling(s), Walk-In Closet(s), Washer/Dryer Hookup, Wet Bar, Whole House Entertainment System, Wired for Sound
- Number of Fireplaces: 2
- Fireplace(s): Wood Burning Stove
- Appliances: Convection Oven, Cooktop, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Exhaust Fan, Freezer, Gas Oven, Gas Range, Microwave, Oven, Range, Refrigerator, Stainless Steel Appliance(s), Washer, Wine Refrigerator
- Laundry Facilities: Yes
- Flooring: Hardwood, Tile
Rooms
Bathrooms
- Total Bathrooms: 7
- Full Bathrooms: 6
- Half Bathrooms: 1
Bedrooms
- Total Bedrooms: 6
Other Rooms
- Laundry: Laundry Room, Other
Additional Information
- Pool: Yes
- Private Pool: Yes
- Pool Description: Vinyl
- Security/Safety: Security System, Smoke Detector(s), Video Cameras
Parking
- Garage: Yes
- Garage Spaces: 8
- Total Spaces: 6
- Parking Features: Driveway, Garage, On Street
Location
- County: Queens
- Cross Streets: 87th Street
- Driving Directions: WAZE
School Information
- High School District: Queens 27
- Elementary School: Ps 207 Rockwood Park
- Middle School: Jhs 202 Robert H Goddard
- High School: John Adams High School
Heating & Cooling
- Central air: Yes
- Cooling Type: Central Air
- Heating Type: Natural Gas, Radiant, Radiant Floor
Utilities
- Sewer: Public Sewer
- Water: Public
- Utility Description: Cable Connected, Electricity Connected, Natural Gas Connected, Phone Connected, Sewer Connected, Trash Collection Public, Water Connected
Structural Information
- Architectural Style: Colonial
- Detached/Attached: Detached
- Construction: Brick, Fiberglass Insulation, Frame
- Basement: Yes
- Basement Desc.: Finished
- Windows: Double Pane Windows
- Building Size: 5232
- Square Feet: 5,232
- Sq. Ft. Source: Plans
- Year Built: 1945
Additional Structures
- Other Structures: Garage(s), Outdoor Kitchen
Lot Features
- Lot Size (Acres): 0.2296
- Lot Size (Sq. Ft.): 10,000
- Lot Dimensions: 100 x 100
- Road Maintenance: Public Maintained Road
- Fence: Yes
- Lot Features: Cleared, Corner Lot, Front Yard, Garden, Landscaped, Level, Near Public Transit, Near School, Near Shops, Sprinklers In Front, Sprinklers In Rear
- Fencing (Description): Back Yard, Brick, Front Yard
Financial Considerations
- Tax Amount: $10,500
Disclosures and Reports
- Special Conditions: None
- Property ID: 13967-0093
Listed by Douglas Elliman Real Estate
We Value Your Privacy
We Value Your Privacy
We Value Your Privacy
Listing agents
— 87-07 158th Ave —
Douglas Elliman Real Estate
Douglas Elliman Real Estate
347-386-6932
NMLS#: 1598647Get Pre-Approved Today
Schools
Schools serving 87-07 158th Ave
School District:New York City Geographic School District 27
| Name | Grades | Distance |
|---|---|---|
Ps 207 Rockwood Park 159-15 88th St, Queens, NY 11414 | PK-8 | 0.2 mi |
Jhs 202 Robert H Goddard 138-30 Lafayette St, Queens, NY 11417 | 6-8 | 0.7 mi |
John Adams High School 101-01 Rockaway Blvd, Queens, NY 11417 | 9-12 | 1.3 mi |
Disclaimer:
School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.
Price & Sales History for 87-07 158th Ave
Tax History
Tax History for 87-07 158th Ave
Year
Property Taxes
Change
Tax Assessment
Change
2025
$18,915
—
$94,176
-3%
2024
$18,915
1%
$96,660
3%
2023
$18,771
5%
$93,456
-12%
2022
$17,908
2%
$105,840
21%
2021
$17,507
5%
$87,720
11%
2020
$16,612
—
$79,260
-9%
2019
$16,612
11%
$87,300
12%
2017
$14,979
—
$77,880
6%
2017
$14,979
8%
$73,483
6%
2016
$13,859
8%
$69,324
6%
2015
$12,788
4%
$65,400
—
2014
$12,252
-7%
$65,400
—
2013
$13,142
—
$65,400
—
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.
Estimate the Cost
Estimate the Cost for 87-07 158th Ave
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Single Family
- Active
- 5Beds
- 7Total Baths
Listed by Douglas Elliman Real Estate
- Single Family
- Active
- 5Beds
- 5Total Baths
Listed by NY Empire Real Estate
- Single Family
- Active
- 5Beds
- 6Total Baths
Listed by Connexion I Rl Est Svcs Inc
This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.
- Multi-Family
- Active
- Updated 27 minutes ago
Listed by Coldwell Banker American Homes
- Multi-Family
- Active
- Updated 4 days ago
- 5Total Beds
Listed by Connie Francisco R E Group
- Single Family
- Active
- Updated 2 days ago
- 3Beds
- 3Total Baths
- 1,032Sq. Ft.
Listed by Keller Williams Realty Greater
- Multi-Family
- Active
- Updated 1 day ago
- 8Total Beds
Listed by Real Estate Classic LLC
87-07 158th Avenue, Howard Beach, NY 11414 (MLS# 916039) is a Single Family property with 6 bedrooms, 6 full bathrooms and 1 partial bathroom. 87-07 158th Avenue is currently listed for $3,250,000 and was received on November 02, 2025. Want to learn more about 87-07 158th Avenue? Do you have questions about finding other Single Family real estate for sale in Howard Beach? You can browse all Howard Beach real estate or contact a Coldwell Banker agent to request more information.