142-28 254th Street, Rosedale, NY 11422 - Photo 1

1/1

$995,000 Just Listed

For Sale
Active
Multi-Family
4 Total Beds
2 Car Garage
Updated 19 hours ago

1/1

Property Description

Legal 2 family Colonial house in Rosedale. Excellent Location, Close To Everything. 5 New A/Cs saves on utilities. Roof 4 years old, new gutters. Finished basement with separate outside entrance from the backyard. Big lot size. Can accommodate 5-6 cars.

Full Property Details

Full Property Details for 142-28 254th St

General

Price: $995,000
Taxes: $5,953
Status: Active
Type: Multi-Family
Source: Long_Island
MLS ID: 1062969
Updated: 10/15/2026
Added to Site: 2 day(s) ago

Interior

Interior Features: First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Formal Dining, Kitchen Island

Rooms

Bathrooms

Total Bathrooms: 2
Full Bathrooms: 2

Bedrooms

Total Bedrooms: 4

Parking

Garage: Yes
Garage Spaces: 2
Total Spaces: 4
Parking Features: Detached, Private

Location

County: Queens
Cross Streets: Memphis Avenue

School Information

High School District: Queens 29
Elementary School: Ps 131 Abigail Adams
Middle School: Cambria Heights Academy
High School: HEALTH ARTS ROBOTICS AND TECHNOLOGY HIGH SCHOOL

Heating & Cooling

Cooling Type: Wall/Window Unit(s)
Heating Type: Natural Gas, Steam

Utilities

Sewer: Public Sewer
Water: Public
Utility Description: Electricity Available, Electricity Connected, Natural Gas Available, Natural Gas Connected

Structural Information

Architectural Style: Colonial
Detached/Attached: Detached
Construction: Frame
Basement: Yes
Basement Desc.: Finished, Full Basement, Walk-Out Access
Year Built: 1970

Lot Features

Lot Size (Sq. Ft.): 5,000
Lot Dimensions: 50 x 100

Financial Considerations

Tax Amount: $5,953

Disclosures and Reports

Special Conditions: None
Property ID: 13585-0080

Listed by Cross Island Realty One Inc

Quickly Find Out More

* Indicates a required field

Comment optional

Full Name *

Email Address *

Mobile Phone Number *

See this property in person

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 142-28 254th St —

Cross Island Realty One Inc

718-831-0100

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 142-28 254th St

School District:New York City Geographic School District 29

Name	Grades	Distance
P.S. / M.S. 138 Sunrise 251-11 Weller Ave, Queens, NY 11422	K-8	0.1 mi
Community Voices Middle School 145-00 Springfield Blvd, Queens, NY 11413	6-8	1.4 mi
Collaborative Arts Middle School 145-00 Springfield Blvd, Queens, NY 11413	6-8	1.4 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 142-28 254th St Get Price Alerts and Save Property

Date

Details

Price

Change

Source

10/15/2026

Listed

$995,000

93.2%

MLS

7/25/2005

Sold

$515,000

—

Public Record

Get Price Alerts and Save Property

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History

Tax History for 142-28 254th St

Year

Property Taxes

Change

Tax Assessment

Change

2025

$7,838

—

$40,003

3%

2025

$7,838

6%

$39,025

-2%

2024

$7,394

6%

$40,020

15%

2023

$6,976

3%

$34,733

-12%

2022

$6,770

-4%

$39,480

16%

2021

$7,016

2%

$34,140

1%

2020

$6,884

6%

$33,660

3%

2019

$6,494

15%

$32,700

13%

2017

$5,663

—

$28,944

4%

2017

$5,663

—

$27,780

-2%

2016

$5,685

7%

$28,440

5%

2015

$5,299

8%

$27,101

6%

2015

$4,898

9%

$25,567

6%

2013

$4,511

—

$24,120

—

View All

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 142-28 254th St

145-105 178th Pl, Springfield Gardens, NY 11434 - Photo 1

Just Listed

$899,000

145-105 178th Pl Springfield Gardens, NY 11434

Multi-Family
Active
Updated 3 days ago

Listed by Charles Rutenberg Realty Inc

122-19 Lucas St, Springfield Gardens, NY 11413 - Photo 1

Just Listed

$929,000

Open House

122-19 Lucas St Springfield Gardens, NY 11413

Single Family
Active
Updated 6 hours ago

5
Beds
4
Total Baths
1,980
Sq. Ft.

Listed by Exclusive Homes Group Inc

179-12 145th Rd, Springfield Gardens, NY 11434 - Photo 1

Just Listed

$629,000

Open House

179-12 145th Rd Springfield Gardens, NY 11434

Single Family
Active
Updated 4 days ago

3
Beds
2
Total Baths

Listed by FIRST FLAG Realty Inc

153-16 132nd Ave, Springfield Gardens, NY 11434 - Photo 1

Just Listed

$779,000

Open House

153-16 132nd Ave Springfield Gardens, NY 11434

Single Family
Active
Updated 3 days ago

3
Beds
1
Total Bath
1,275
Sq. Ft.

Listed by Massada Realty Inc

142-28 254th Street, Rosedale, NY 11422 (MLS# 1062969) is a Multi-Family property with 2 units containing 4 bedrooms and 2 full bathrooms. 142-28 254th Street is currently listed for $995,000 and was received on October 15, 2026. Want to learn more about 142-28 254th Street? Do you have questions about finding other Multi-Family real estate for sale in Rosedale? You can browse all Rosedale real estate or contact a Coldwell Banker agent to request more information.

142-28 254th St Rosedale, NY 11422