• Sign Up
  • Log In
Susan Camus | Imagine Properties
  • HOME
  • ABOUT
    • Learn More
    • Meet the Team
    • Reviews
  • LIST OF SERVICES
    • Union News
    • Services
  • MORTGAGE
    • Mortgage Calculator
  • COMMUNITIES
    • Areas
    • Community News
    • All Listings
    • Palm Beach County
    • New Jersey
  • IMAGINE HELP
  • BUYERS
    • Buying Tips
    • Featured Listings
    • Search New York Homes
    • Search New Jersey Homes
  • SELLERS
    • Home Valuation
  • INVESTORS
  • RESOURCES
    • Slattery Moving & Storage
    • Short Sale
    • Senior Real Estate
    • Probate
    • Articles
  • MORE
    • Florida
    • School Report
    • Real Estate Tips
    • Sold Properties
  • RITZ-CARLTON RESIDENCES
  • CONTACT

Susan Camus

(845) 398-1717
susan@ImagineProperties1.com
  • Susan Camus(845) 398-1717
    susan@ImagineProperties1.com
    Copy Email
  • 100 Dutch Hill Rd Suite 260
    Orangeburg , NY 10962

Home

  • HOME
  • ABOUT
  • LIST OF SERVICES
  • MORTGAGE
  • COMMUNITIES
  • IMAGINE HELP
  • BUYERS
  • SELLERS
  • INVESTORS
  • RESOURCES
  • MORE
  • RITZ-CARLTON RESIDENCES
  • CONTACT

Account

  • Login
  • Sign Up
Susan Camus | Imagine Properties - Footer Logo
  • Notice of Exclusive Property Listing
  • Notice of Exclusive Property Listing
  • Privacy
  • Terms
  • DMCA
  • Accessibility
  • Fair Housing
© 2025 Imagine Properties. All rights reserved.
Website built by CloseHack.
Northwest Multiple Listing Service

The information contained in this listing has not been verified by Northwest Multiple Listing Service (NWMLS) - WA and should be verified by the buyer.

Based on information submitted to the MLS GRID as of 2025-11-04 02:35:16. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The database information herein is provided from and copyrighted by the Northwest Multiple Listing Service (NWMLS). NWMLS data may not be reproduced or redistributed and is only for people viewing this site. Listings that feature the "three tree" icon are provided courtesy of NWMLS. All information provided is deemed reliable but is not guaranteed and should be independently verified. All properties are subject to prior sale or withdrawal. All rights are reserved by copyright.

Copyright 2024 Northwest Multiple Listing Service. All rights reserved.

New Jersey Multiple Listing Service, Inc.

The data relating to the real estate for sale on this web site comes in part from the Internet Data Exchange Program of the NJMLS. Real estate listings held by brokerage firms other than Susan Camus | Imagine Properties are marked with the Internet Data Exchange logo and information about them includes the name of the listing brokers. Some properties listed with the participating brokers do not appear on this website at the request of the seller. Listings of brokers that do not participate in Internet Data Exchange do not appear on this website. 

All information deemed reliable but not guaranteed. Last date updated: 01/09/2023

2023 New Jersey Multiple Listing Service, Inc. All rights reserved.  

Beaches MLS

© BEACHES MLS. All rights reserved. Information Deemed Reliable, but Not Guaranteed. Listing information is from various brokers who participate in IDX and not all listings may be visible on the site. The property information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

My Florida Regional MLS DBA Stellar MLS

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Some IDX listings have been excluded from this website. Listing Information presented by local MLS brokerage: Susan Camus | Imagine Properties

OneKey MLS

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

$3,250,000
For Sale

87-07 158th Avenue

New York, NY 11414
5232 sqft | 6 beds | 6.5 baths | 0.23 acres | #916039
  • Save
  • Contact
  • Share
  • Price Change Alerts
Browse 48 photos
Type:Purchase
Structure:House
Zone:Residential

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.

  • Interior Details
      • InteriorBeamed Ceilings, Breakfast Bar, Built-in Features, Cathedral Ceiling(s), Central Vacuum, Chandelier, Chefs Kitchen, Crown Moldin
      • Fireplaces2
    • Heating & Cooling
      • HeatingNatural Gas, Radiant, Radiant Floor
      • CoolingCentral Air
    • Beds & Baths
      • Bathrooms6.5
      • Bedrooms6
      • Full Baths6
      • Half Baths1
  • Property Details
      • Lot DescriptionCleared, Corner Lot, Front Yard, Garden, Landscaped, Level, Near Public Transit, Near School, Near Shops, Sprinklers In Front, S
      • Pool FeaturesVinyl
      • Pool1
    • Measurements
      • Acres0.2296
      • Square Feet5232
    • Parking
      • Parking FeaturesDriveway, Garage, On Street
      • Parking TypeDriveway
      • Parking Spaces8
      • Parking Garage1
  • Construction Details
      • Property TypePurchase
      • Basement1
    • Condition
      • Year Built1945
    • Material information
      • FoundationConcrete Perimeter
  • Utilities / Energy Details
      • Utility FeaturesCable Connected, Electricity Connected, Natural Gas Connected, Phone Connected, Sewer Connected, Trash Collection Public, Water
      • AppliancesConvection Oven, Cooktop, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Exhaust Fan, Freezer, Gas Oven, Gas Range, Mic
      • Sewer InformationPublic Sewer
      • Utility SourcePublic
  • Community and Neighborhood Details
      • Middle SchoolJhs 202 Robert H Goddard
      • High SchoolJohn Adams High School
      • Elementary SchoolPs 207 Rockwood Park
      • School DistrictQueens 27
      • CountyQueens
  • Financial Details
      • Original List Price$3,250,000
      • Taxes Annual$10,500
      • Days on Market (Cumulative)2
  • Other
      • MLS #916039

Location

Legal

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Last Updated: Yesterday at 9:36 PM. Source: ONEKEY

Provided By
Listing Agent: Annette Alicanti (#KEY182389)
Listing Office: Douglas Elliman Real Estate (#KEYDERE57)

Susan Camus | Imagine PropertiesReal Estate Group
Facebook
Google
OR

Interested in Purchasing 87-07 158th Avenue?

Get an estimate on monthly payments on this property.

Note: The results shown are estimates only and do not include all factors. Speak with a licensed agent or loan provider for exact details. This tool is sourced from CloseHack.

Estimated Monthly Payment
$0.00
Loan Amount
$0.00
$
years

Down Payment

$
%
10.0%

Interest Rate

%
6.0%

Tax Rate

%
2.6%
$
$
annually
$
monthly