87-17 254th Street

Bellerose Manor

$798,888
Price
3
Beds
1
Bath
1
1/2 Bath
1,422 Sq. Ft.
$562 / Sq. Ft.
1,422
Sq. Ft.
$562
per Sq. Ft.

Description

Welcome home to this detached legal 2-family (currently used as a 1-family) with curb appeal galore! First floor features hardwood oak floors and high-hat lighting throughout, a living room with French doors to formal dining room, large eat in kitchen with stainless steel appliances and a large, picturesque window letting in exceptional amounts of natural light, and a rare half bathroom. Second floor features three bedrooms and a large full bathroom, as well as plenty of closet space, plus access...Welcome home to this detached legal 2-family (currently used as a 1-family) with curb appeal galore! First floor features hardwood oak floors and high-hat lighting throughout, a living room with French doors to formal dining room, large eat in kitchen with stainless steel appliances and a large, picturesque window letting in exceptional amounts of natural light, and a rare half bathroom. Second floor features three bedrooms and a large full bathroom, as well as plenty of closet space, plus access to the attic with tremendous storage. The full finished basement features baseboard heating, a separate thermostat, as well as a separate entrance, and is roughed out for a full bathroom. Access your own private yard through the kitchen. This expansive yard, perfect for outdoor entertaining and relaxation, features outlets, a shed, a Trex deck, and your own fig tree. This home is conveniently located near shopping and restaurants on Jericho Turnpike and Hillside Avenue, as well as the local Q36 bus line and the LIRR station.
  1. Listed by David J Pastorini • Coldwell Banker Phillips
    P: 718-326-3900 C: 718-757-5881 davepastorini@gmail.com

Property Details for 87-17 254th Street

Township
Hempstead
Architectural Style
Colonial
Community Features
Park,Near Public Transportation
Garage Spaces
.00
Section Area
87 Avenue
Offer Presentation
Cannot be Present

Location

Listing Courtesy of Coldwell Banker Phillips
Add your commute
LISTING UPDATED: 04/16/2024 09:29 PM

Property Details for 87-17 254th Street

StatusActive
MLS ID3542958
Days on Market18
Taxes$6,598 / year
Maintenance-
Min. Down Pymt-
Total Rooms10.0
Compass TypeSingle Family
MLS TypeSingle Family
Year Built1925
Lot Size2,717 SF / 27' x 100'
CountyQueens County

Building

87-17 254th St

2 Units2 StoriesBuilt in 1925

Location

Listing Courtesy of Coldwell Banker Phillips
Add your commute

Building Information for 87-17 254th Street

Stories2Year Built1925Building Size18' x 36'Building Sq. Ft1,296 SFLot Size2,717 SF / 27' x 100'Building Age-Building Type-

Payment Calculator

$4,910 per month

30 year fixed, 7.25% Interest

Principal and Interest

$4,360

Property Taxes

$550

Maintenance/Common Charges

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 87-17 254th Street

Summary
Location and General Information
  • Senior Community YN: No
  • MLS Area Minor: 12
  • Directions: Waze/Google Maps
  • Tax Block: 8647
  • Tax Lot: 18
  • Property Attached: No
  • Structure Type: false
  • Levels: Two
  • Property Condition: Excellent
  • New Construction YN: No
  • Flood Zone Report: 0
  • Lot Size Source: Other
  • Country: US
  • State Or Province: NY
School Information
  • School District: Queens 26
  • Elementary School District: Queens 26
  • Elementary School: Ps 133
  • Middle Or Junior School District: Queens 26
  • Middle Or Junior School: Irwin Altman Middle School 172
  • High School District: Queens 26
  • High School: Martin Van Buren High School
Rental
Rental
  • Lease Considered: No
Unit Information
Unit Information
  • Building Units Total: 1
Room Information
Room 1 Information
  • Room Level: First
  • Room Type: Additional
  • RoomDescription 1: Foyer, living room, formal dining room, half bath, eat in kitchen with access to private yard
Room 2 Information
  • Room Level: Second
  • Room Type: Additional
  • Room Description: 3 bedrooms, full bathroom
Room 3 Information
  • Room Level: Basement
  • Room Type: Additional
  • Room Description: Full finished, separate entrance
Taxes and HOA Information
Taxes and HOA Information
  • Parcel Number: 08647-0018
  • Tax Map Number: 08647-0018
Interior and Exterior Features
Interior Features
  • Amenities: A/C Units, Back Yard, Colonial, Deck, Dishwasher, Dryer, Eat in Kitchen, Fenced, Formal Dining, Hardwood Floors As Seen, Light Fixtures, Living Room/Dining Room Combo, Near Public Transportation, Park, Partial, Public, Refrigerator, Shed, Storage, Washer
  • Interior Features: Eat-in Kitchen, Formal Dining, Living Room/Dining Room Combo, Storage
  • Appliances: Dishwasher,Dryer,Oven,Refrigerator,Washer
  • Number Of Kitchens: 1.0
  • Total Rooms: 10
  • Living Area Units: Square Feet
  • Basement: Finished, Full, Walk-Out Access
  • Attic Description: See Remarks
  • Fireplaces Total: 0
  • Location Amenities: Walk Out Basement, Near Public Transportation, Fenced, Fenced Yard, Hardwood Floors As Seen, Eat in Kitchen, Formal Dining Room, Living Room / Dining Room, Storage, Deck
  • Common Walls: No Common Walls
  • Flooring: Hardwood
  • Inclusions: A/C Units,Dishwasher,Dryer,Light Fixtures,Refrigerator,Shed,Washer
Exterior Features
  • Exterior Property Features: Deck, Private, Driveway, Back Yard, Fenced, Partial, Park, Near Public Transportation, Near Public Transit
  • Elevation Certificate: No
  • Fencing: Back Yard,Fenced,Partial
  • Patio And Porch Features: Deck
  • Construction Materials: Frame,Aluminum Siding,Vinyl Siding
  • Road Responsibility: Public Maintained Road
Lot Information
  • Lot Features: Near Public Transit
  • Lot Size Dimensions: 27.17x100
  • Site Features: Park, Near Public Transportation, Near Public Transit
  • Building Size: 18x36
  • Building Area Units: Square Feet
Parking
  • Parking Features: Private, Driveway
  • Attached Garage: No
  • Garage: No
Utilities
  • Cooling: Yes
  • Cooling: Wall Unit(s)
  • Heating: Natural Gas, Steam
  • Heat Fuel Type: Natural Gas, Steam
  • Separate Hot water Heater Detail: Y
  • Hot Water: Gas Stand Alone
  • Garbage Removal: Public
  • Sewer: Public Sewer
  • Water Source: Public
Green Features
  • Green Features: Dishwasher, Dryer, Oven, Refrigerator, Washer, Natural Gas, Steam

Property History for 87-17 254th Street

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 87-17 254th Street

Taxable ValueLand$12,720Additions$30,600Total$43,320
Home Facts
Total Finished SqFt1,422 SqFtLot Size2,717 SqFtYear Built1925ZoningR2AAPN4086470018

Schools near 87-17 254th Street

This home is within New York City Geographic District #26.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Public - 9 to 12
Rating
School
Distance
P.S. 133
PublicPK to 5

Irwin Altman Middle School 172
Public6 to 8

Martin Van Buren High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

87-17 254th Street is a single family home for sale in Bellerose Manor. This property was listed for sale on April 14, 2024 by Coldwell Banker Phillips, it's currently listed at $798,888. This listing's school district is New York City Geographic District #26. Nearby schools include P.S. 133, Irwin Altman Middle School 172 and Martin Van Buren High School. 87-17 254th Street is a 3-bed, 1.5-bath, 1,422 sqft single family home built in 1925.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Phillips

This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2024 The Real Estate Board of New York, Inc., All rights reserved. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers’ personal, non-commercial use. The data relating to real estate for sale on this website comes in part from the IDX Program of OneKey® MLS. Information Copyright 2024, OneKey® MLS. All data is deemed reliable but is not guaranteed accurate by Compass. See Terms of Service for additional restrictions. Compass · Tel: 212-913-9058 · New York, NY Listing information for certain New York City properties provided courtesy of the Real Estate Board of New York’s Residential Listing Service (the "RLS"). The information contained in this listing has not been verified by the RLS and should be verified by the consumer. The listing information provided here is for the consumer’s personal, non-commercial use. Retransmission, redistribution or copying of this listing information is strictly prohibited except in connection with a consumer's consideration of the purchase and/or sale of an individual property. This listing information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2024 The Real Estate Board of New York, Inc., all rights reserved. This information is not guaranteed, should be independently verified and may not reflect all real estate activity in the market. Offers of compensation set forth here are for other RLSParticipants only and may not reflect other agreements between a consumer and their broker.©2024 The Real Estate Board of New York, Inc., All rights reserved.