See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

87-17 157th Avenue, Howard Beach, NY, 11414

5beds
3baths
2,610sqft
$1,488,000
$570price/sqft
$9,361/moest. monthly cost
$374,440/yrincome needed

About This Home

Introducing an extraordinary family estate in the heart of New Howard Beach. Perfectly positioned on a sprawling 6,000 square foot corner property, this exceptional residence offers the space, flexibility, and amenities that today's buyers search years to find. Offering approximately 2,610 square feet above grade, PLUS a beautifully finished basement adding substantial additional square footage, this property is truly designed to evolve with every stage of life. From the moment you arrive, the home's stately presence, double driveways, manicured grounds, wraparound curb appeal, and inviting front porch create an unforgettable first impression. Inside, generously proportioned rooms flow effortlessly from one to the next, offering an ideal balance of elegance and everyday comfort. The main level features a gracious living room with a gas fireplace, formal dining room, spacious family room, hardwood floors, and a beautifully appointed kitchen that truly serves as the heart of the home. This property's most remarkable feature is the incredible versatility. Offering three kitchen areas, three full bathrooms, and the potential for up to seven bedrooms, the flexible layout is perfectly suited for multigenerational living, extended family, private guest quarters, home offices, recreation rooms, or whatever your lifestyle demands. Several rooms are currently enjoyed as family and den spaces, giving the next owner endless possibilities to customize the home. Upstairs, the oversized primary suite showcases soaring vaulted ceilings and abundant natural light, while spacious secondary bedrooms continue the home's theme of comfort, scale, and functionality. On this level you will also find upstairs laundry, an amenity that transforms one of life's daily chores into an easy routine. Designed with comfort and functionality in mind, this home features a three-zone gas heating system, two-zone central air conditioning, and an in-ground sprinkler system for effortless year-round living. The beautifully finished basement dramatically expands the home's living space with an additional kitchen area, full bathroom, expansive recreation room, SECOND laundry area, storage, and exceptional flexibility for entertaining or extended living. Step outside into your own private backyard retreat. Designed for making memories, the resort style grounds feature a sparkling in ground pool, spacious patios, covered lounge area, lush landscaping, and beautifully maintained outdoor living spaces that make entertaining family and friends effortless all season long. Rarely does a property combine this level of size, flexibility, outdoor living, and pride of ownership on such a prominent corner parcel. More than just a house, this is a true New Howard Beach family estate where generations can gather, celebrate, and create memories for years to come.

Getting Around

71
WalkingVery Walkable
0
TransitVery Limited Transit
75
BikeVery Bikeable

Schools

7/10
Ps 207 Rockwood ParkGrades PK-80.3 mi
4/10
John Adams High SchoolGrades 9-121.3 mi
7/10
Jhs 202 Robert H GoddardGrades 6-80.6 mi

Construction

Condition

  • Year built: 1950

Materials

  • Construction materials: Shake Siding

Type & Style

  • Home type: SingleFamily
  • Architectural style: Colonial
  • Property subType: Single Family Residence,Residential

Interior

Appliances

  • Appliances included: Dishwasher,Dryer,Gas Range,Microwave,Refrigerator,Stainless Steel Appliance(s),Washer
  • Laundry features: Multiple Locations

Basement

  • Has basement: Yes
  • Basement: Finished,Full

Bedrooms & Bathrooms

  • Bedrooms: 5
  • Bathrooms: 3
  • Full bathrooms: 3

Features

  • First Floor Bedroom,First Floor Full Bath,Entrance Foyer
  • Attic: Pull Stairs

Heating & Cooling

  • Heating features: Natural Gas
  • Cooling features: Central Air

Interior Area

  • Total structure area: 2,610
  • Total interior livable area: 2,610 sqft

Property

Details

  • Parcel number: 139520033
  • Special condition: None

Features

  • Private pool: Yes
  • Pool features: In Ground

Lot

  • Lot size: 6,000 sqft

Parking

  • Total spaces: 3
  • Parking features: Garage
  • Has garage: Yes
  • Attached garage spaces: 1
  • Covered spaces: 1

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Cold Wave
    Cold WaveRelatively High
  • Heat Wave
    Heat WaveRelatively High
  • Coastal Flooding
    Coastal FloodingModerate
  • Earthquake
    EarthquakeModerate
  • Hurricane
    HurricaneModerate
  • Inland Flooding
    Inland FloodingModerate
  • Strong Wind
    Strong WindModerate
  • Winter Weather
    Winter WeatherModerate
  • Tsunami
    TsunamiInsufficient Data

How This Home’s Risks Compare

Cold Wave
Heat Wave
Coastal Flooding
Earthquake
Hurricane
Inland Flooding
Strong Wind
Winter Weather
Tsunami

FEMA Declared Disasters in Queens County and New York

Flood
Severe Storm
Snowstorm

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $7,524$90,288
Home Insurance *$476$5,712
Property Taxes $930$11,160
Electricity $431$5,175
Total$9,361$112,332
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$320,948/yr
40% on housing$280,830/yr
45% on housing$249,626/yr

New York FAIR Plan Programs

New York Property Insurance Underwriting Association

Covered
WildfireWildfire
HailHail
WindWind
Visit Website →
Current Policies
Residential: 20,669Commercial: 1,556
Total Premiums$32.27M
Total Exposure$7.63B

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 2.5%
2.5%
0%30.0%
Electricity Growth Rate10-year average: 7.1%
7.1%
0%15.0%
Property Taxes Growth Rate2-year average: -0.4%
-0.4%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$570This listing

vs Other Active Listings

Avg $/sqft

ZIP 11414$397
Queens County$533

vs Homes Sold Last Month

Median $/sqft

ZIP 11414$467
Queens County$600

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

Price History

DateEventPrice
2026-08-06Price change$1,349,000
2026-07-22Listed for sale$1,488,000

For Sale by Agent

AgentBrina Ciaramella
BrokerageEsquire Realty Ciaramella & Co

Similar Homes