What is 154 Sterling Rd?

154 Sterling Rd is a 1,142 square foot house on a 5,000 square foot lot with 4 bedrooms and 3 bathrooms. 154 Sterling Rd is a house currently priced at $699,999.

How many photos are available for this home?

DistressedRealEstate.net has 26 photos of 154 Sterling Rd.

How much is this home worth?

Based on DistressedRealEstate.net's Elmont, NY data, we estimate the home's value is $735,200.

How long has this home been listed on DistressedRealEstate.net?

154 Sterling Rd has been listed on DistressedRealEstate.net since July 30, 2023.

When was this home built?

154 Sterling Rd was built in 1949.

When was this home last sold?

154 Sterling Rd was last sold in June 22, 2006.

How competitive is the market for this home?

Based on DistressedRealEstate.net's market data, we calculate that market competition in 11003, this home's neighborhood, is somewhat competitive. This home sell's for about 5% below listed price.

What’s the full address of this home?

The full address for this home is 154 Sterling Rd, Elmont, NY 11003.

154 Sterling Rd, Elmont, NY 11003

Property details for 154 Sterling Rd

Estimated Reasonable Offer

$580,800

Status

For Sale

Pending

Yes

Foreclosure

Yes

Days on market

278 days

Type

Single Family Home

Town House

Year Built

1949

Stories

3

Garage

Yes

Flood Factor

1 / 10

Last Sold

$340K in 2006

The description and property data below may have been provided by a third party, the homeowner or public records.

Welcome To Your Dream Home In The Heart Of Elmont. This Beautifully Renovated Cape Offers 4 Bedrooms, 3 Brand New Baths, Meticulously Redesigned Kitchen Boasting Granite CounterTops And Stainless Steel Appliances, Gas Cooking And Heating, Separate Zones, Gleaming Hardwood Floors, LED Hi-Hats Throughout, Full Finished Basement With Bonus Rooms And Outside Entrance, Tons Of Storage, Nice Size Concrete Patio For Bbq Nights, New Vinyl Siding And Gutters, 1 Car Det Garage, Spacious Backyard. Enjoy The Convenience Of The Prime Location......Rare Opportunity Won't Last!

Property facts

Property features

Amenities and Community Features

Community Features:
Community Features:
Park
Park

Bedrooms

Bedrooms:
Bedrooms:
4
4

Exterior and Lot Features

Patio And Porch Features:
Patio And Porch Features:
Patio, Porch
Patio, Porch

Heating and Cooling

Heating Features:
Heating Features:
Natural Gas, ENERGY STAR Qualified Equipment, Hot Water
Natural Gas, ENERGY STAR Qualified Equipment, Hot Water

Bathrooms

Full Bathrooms:
Full Bathrooms:
3
3
Total Bathrooms:
Total Bathrooms:
3
3

Garage and Parking

Garage Spaces:
Garage Spaces:
1
1
Parking Features:
Parking Features:
Private, Detached, 1 Car Detached, Driveway
Private, Detached, 1 Car Detached, Driveway

Homeowners Association

Association:
Association:
No
No
Calculated Total Monthly Association Fees:
Calculated Total Monthly Association Fees:
0
0

Utilities

Sewer:
Sewer:
Sewer
Sewer
Water Source:
Water Source:
Public
Public

Appliances

Dishwasher
ENERGY STAR Qualified Dishwasher
ENERGY STAR Qualified Stove
Refrigerator

Land Info

Lot Description:
Lot Description:
Level, Near Public Transit
Level, Near Public Transit
Lot Size Acres:
Lot Size Acres:
0.1147842
0.1147842
Lot Size Dimensions:
Lot Size Dimensions:
50x100
50x100
Lot Size Square Feet:
Lot Size Square Feet:
5000
5000

Other Rooms

Basement Description:
Basement Description:
Finished, Full, Walk-Out Access
Finished, Full, Walk-Out Access
Basement Features:
Basement Features:
Finished, Full, Walk-Out Access
Finished, Full, Walk-Out Access
Living Room Level:
Living Room Level:
First
First
Total Rooms:
Total Rooms:
7
7

School Information

Elementary School District:
Elementary School District:
Elmont
Elmont
High School District:
High School District:
Elmont
Elmont
High School:
High School:
Elmont Memorial High School
Elmont Memorial High School
Middle School:
Middle School:
Elmont Memorial High School
Elmont Memorial High School
Middle or Junior School District:
Middle or Junior School District:
Elmont
Elmont

Interior Features

Door Features:
Door Features:
ENERGY STAR Qualified Doors
ENERGY STAR Qualified Doors
Eat-in Kitchen
Flooring:
Flooring:
Hardwood
Hardwood
Granite Counters
Living Room/Dining Room Combo
Master Downstairs
Window Features:
Window Features:
Double Pane Windows, ENERGY STAR Qualified Windows
Double Pane Windows, ENERGY STAR Qualified Windows

Building and Construction

Architectural Style:
Architectural Style:
Cape Cod
Cape Cod
Attic:
Attic:
Scuttle
Scuttle
Common Walls:
Common Walls:
No Common Walls
No Common Walls
Construction Materials:
Construction Materials:
Brick, Frame, Vinyl Siding
Brick, Frame, Vinyl Siding
Levels:
Levels:
Three Or More
Three Or More
Property Age:
Property Age:
75
75
Property Condition:
Property Condition:
Mint++
Mint++
Year Built Effective:
Year Built Effective:
2024
2024
Year Built:
Year Built:
1949
1949

Other Property Info

Annual Tax Amount:
Annual Tax Amount:
10690.00
10690.00
County:
County:
Nassau
Nassau
Cross Street:
Cross Street:
Hempstead Tpke
Hempstead Tpke
Directions:
Directions:
Hempstead Tpke To Sterling Rd.
Hempstead Tpke To Sterling Rd.
List Price Low:
List Price Low:
699999
699999
Parcel Number:
Parcel Number:
2089-32-402-00-0109-0
2089-32-402-00-0109-0
Property Subtype:
Property Subtype:
Single Family Residence
Single Family Residence
Source Listing Status:
Source Listing Status:
Pending
Pending
Source Property Type:
Source Property Type:
Residential
Residential
Source System Name:
Source System Name:
C2C
C2C
Tax Block:
Tax Block:
402
402
Township:
Township:
Hempstead
Hempstead

Property Price History

for 154 Sterling Rd

Date	Event	Price	Price/Sqft	Source
Apr 6, 2024	Relisted	$699,999	—	OneKeyMLS
Apr 4, 2024	Listing removed	$699,999	—	OneKeyMLS
Mar 20, 2024	Listed	$699,999	—	OneKeyMLS
Jun 7, 2022	Listing removed	$415,000	—	OneKeyMLS
Jan 25, 2019	Price Changed	$429,000	—	OneKeyMLS
Nov 22, 2018	Price Changed	$449,000	—	OneKeyMLS
Nov 13, 2018	Price Changed	$475,000	—	OneKeyMLS
Oct 26, 2018	Price Changed	$499,000	—	OneKeyMLS
Sep 20, 2018	Listed	$599,000	—	OneKeyMLS
Jun 22, 2006	Sold	$340,000	$298	Public Record

Show more Hide

Property Tax History

for 154 Sterling Rd

Year	Taxes	Land	Additions	Total Assessment
2022	$9,494	$229	$187	$416
2021	$13,002	$229	$187	$416
2020	$10,260	$219	$179	$398
2019	$10,601	$550	$159	$709
2018	$10,000	$550	$159	$709
2016	$8,642	$550	$159	$709
2016	$9,079	$550	$159	$709
2016	$9,079	$550	$159	$709
2015	$8,421	$550	$159	$709
2014	$8,062	$550	$159	$709
2013	$7,586	$550	$168	$718
2011	$6,995	$550	$168	$718
2010	$6,828	$550	$411	$961
2010	$6,828	$550	$271	$821
2009	$7,614	$525	$435	$960
2007	$11,271	$525	$381	$906

Show more Hide

Sold Homes

near 154 Sterling Rd

Address	Price	Built	Beds	Baths	Sqft	Lot Size	Distance
228-09 114th Ter Cambria Heights, NY 11411SF	$685,000 01/18/2024	1945	3	2	1,218 +76difference	3,946	0.51 mi
1945 Built 1,218 +76 Sqft 3,946 Lot Size 0.51 mi Distance
221-28 103 Ave Queens Village, NY 11429SF	$680,000 04/01/2024	1925	2	2	1,232 +90	2,600	0.77 mi
1925 Built 1,232 +90 Sqft 2,600 Lot Size 0.77 mi Distance
115-07 226th St Cambria Heights, NY 11411SF	$790,000 03/05/2024	1945	4	2	1,290 +148	4,000	0.68 mi
1945 Built 1,290 +148 Sqft 4,000 Lot Size 0.68 mi Distance
91 Rockmart Ave Elmont, NY 11003SF	$700,000 11/30/2023	1925	3	3	1,290 +148	6,000	0.80 mi
1925 Built 1,290 +148 Sqft 6,000 Lot Size 0.80 mi Distance
223-02 113th Dr Queens Village, NY 11429SF	$640,000 12/29/2023	1940	3	3	1,320 +178	3,300	0.67 mi
1940 Built 1,320 +178 Sqft 3,300 Lot Size 0.67 mi Distance
142 Wellington Rd Elmont, NY 11003SF	$790,000 12/29/2023	1951	3	3	2,600 +1,458	6,000	0.23 mi
1951 Built 2,600 +1,458 Sqft 6,000 Lot Size 0.23 mi Distance
123 Waldorf Ave Elmont, NY 11003SF	$1,100,000 04/01/2024	1991	6	5	2,500 +1,358	7,280	0.23 mi
1991 Built 2,500 +1,358 Sqft 7,280 Lot Size 0.23 mi Distance
65 Gotham Ave Elmont, NY 11003SF	$435,000 11/09/2023	1923	2	2	1,547 +405	4,160	0.32 mi
1923 Built 1,547 +405 Sqft 4,160 Lot Size 0.32 mi Distance
104-02 223rd St Queens Village, NY 11429SF	$845,000 04/26/2024	1930	4	3	1,746 +604	3,800	0.73 mi
1930 Built 1,746 +604 Sqft 3,800 Lot Size 0.73 mi Distance
11 Ruby St Elmont, NY 11003SF	$690,000 11/15/2023	1950	4	2	1,336 +194	5,000	0.85 mi
1950 Built 1,336 +194 Sqft 5,000 Lot Size 0.85 mi Distance

Show more Hide

Homes For Sale

near 154 Sterling Rd

Address	Price	Built	Beds	Baths	Sqft	Lot Size	Distance
128-43 226th St Laurelton, NY 11413SF	$475,000 1647 days ago	1945	3	2	1,148 +6difference	10,518	1.70 mi
1945 Built 1,148 +6 Sqft 10,518 Lot Size 1.70 mi Distance
213-14 99th Ave Queens Village, NY 11429SF	$699,000 143 days ago	1930	3	3	1,132 -10	2,500	1.41 mi
1930 Built 1,132 -10 Sqft 2,500 Lot Size 1.41 mi Distance
1033 Stafford Rd Valley Stream, NY 11580SF	$299,000 456 days ago	1950	3	2	1,158 +16	6,900	1.77 mi
1950 Built 1,158 +16 Sqft 6,900 Lot Size 1.77 mi Distance
119-34 234th St Cambria Heights, NY 11411SF	$739,000 10 days ago	1945	4	3	1,125 -17	3,900	1.25 mi
1945 Built 1,125 -17 Sqft 3,900 Lot Size 1.25 mi Distance
119-10 229th St Cambria Heights, NY 11411SF	$699,999 8 days ago	1945	4	2	1,163 +21	4,000	1.23 mi
1945 Built 1,163 +21 Sqft 4,000 Lot Size 1.23 mi Distance
1999 Byron Ave Elmont, NY 11003SF	$759,000 41 days ago	1951	3	2	1,168 +26	7,400	0.89 mi
1951 Built 1,168 +26 Sqft 7,400 Lot Size 0.89 mi Distance
1187 Ormonde Blvd Valley Stream, NY 11580SF	$545,000 55 days ago	1950	4	1	1,109 -33	5,334	1.77 mi
1950 Built 1,109 -33 Sqft 5,334 Lot Size 1.77 mi Distance
11827 219th St Cambria Heights, NY 11411SF	$560,000 156 days ago	1925	3	1	1,184 +42	3,999	1.32 mi
1925 Built 1,184 +42 Sqft 3,999 Lot Size 1.32 mi Distance
118-32 218th St Cambria Heights, NY 11411SF	$610,000 10 days ago	1955	4	3	1,092 -50	5,200	1.37 mi
1955 Built 1,092 -50 Sqft 5,200 Lot Size 1.37 mi Distance
2262 Goodwin Rd Elmont, NY 11003SF	$505,000 196 days ago	1951	3	1	1,194 +52	6,300	0.43 mi
1951 Built 1,194 +52 Sqft 6,300 Lot Size 0.43 mi Distance

Show more Hide

Schools

serving 154 Sterling Rd

School Name	Rating	Grades	Distance
Sacred Heart Catholic School 11550 221ST ST, Queens, NY 11411	—	PK−8	0.91 mi
PK−8 Grades Parent Rating 0.91 mi Distance
Gotham Avenue School 181 Gotham Avenue, Elmont, NY 11003	8 / 10	K−6	0.27 mi
K−6 Grades Parent Rating 0.27 mi Distance
Elmont Memorial High School 555 Ridge Road, Elmont, NY 11003	5 / 10	7−12	0.52 mi
7−12 Grades Parent Rating 0.52 mi Distance
Martin De Porres School 621 Elmont Road, Elmont, NY 11003	—	—	0.66 mi
— Grades Parent Rating 0.66 mi Distance
Bible Baptist Academy 779 Elmont Road, Elmont, NY 11003	—	6−11	0.89 mi
6−11 Grades Parent Rating 0.89 mi Distance
Dutch Broadway School 1880 Dutch Broadway, Elmont, NY 11003	9 / 10	K−6	1.04 mi
K−6 Grades Parent Rating 1.04 mi Distance
Clara H Carlson School 235 Belmont Boulevard, Elmont, NY 11003	7 / 10	K−6	1.04 mi
K−6 Grades Parent Rating 1.04 mi Distance
Floral Park Memorial High School 210 Locust Street, Floral Park, NY 11001	5 / 10	7−12	1.10 mi
7−12 Grades Parent Rating 1.10 mi Distance

Show more Hide

School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

Flood Factor

for 154 Sterling Rd

1 ^|10

Minimal

FEMA Zone (Est.)

X (unshaded)

Flood insurance:

Recommended

Flood risks are increasing as sea levels rise and weather patterns change.

This property has a Minimal Flood Factor .
Although flood risks across the country are changing because of the environment, this property is unlikely to flood over the next 30 years.

Flood Factor data provided by FloodFactor.

154 Sterling Rd, Elmont, NY 11003

Nassau County