Recently Viewed Properties

No photo available

See This Home
Save This Listing
Close

$989,999 Just Listed

  • For Sale
  • Active
  • Multi-Family
  • 5 Total Beds
  • 1 Car Garage
  • Updated 6 days ago

No photo available

New Listing Alert! Property Type: Legal Semi-Attached 2 Family Home Total Bedrooms: 5 Total Baths: 3 Full Baths Basement: Full Finished Year Built: 1985 Lot Size: 30 x 125 This is an excellent opportunity for both investors and end buyers! With spacious layout and a finished basement, this home offers versatility and potential rental income or multigenerational living!

Full Property Details for 142-11 254th St

General

  • Price: $989,999
  • Taxes: $8,057
  • Status: Active
  • Type: Multi-Family
  • Source: Long_Island
  • MLS ID: 1023060
  • Updated: 7/7/2026
  • Added to Site: 6 day(s) ago

Interior

  • Interior Features: First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Granite Counters, High Ceilings, Open Kitchen
  • Flooring: Hardwood

Rooms

Bathrooms

  • Total Bathrooms: 2
  • Full Bathrooms: 2

Bedrooms

  • Total Bedrooms: 5

Parking

  • Garage: Yes
  • Garage Spaces: 1
  • Total Spaces: 4
  • Parking Features: Detached, Driveway, Garage

Location

  • County: Queens
  • Cross Streets: Memphis Ave

School Information

  • High School District: Queens 29
  • Elementary School: Ps/Ms 138 Sunrise
  • Middle School: Benjamin Franklin Hs-Finance-Info
  • High School: Excelsior Prep High School

Heating & Cooling

  • Cooling Type: None
  • Heating Type: Baseboard, Hot Water, Natural Gas
  • Heating Zones: 2

Utilities

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

Structural Information

  • Detached/Attached: Attached
  • Construction: Frame, Vinyl Siding
  • Basement: Yes
  • Basement Desc.: Finished, Full Basement
  • Building Size: 2200
  • Square Feet: 2,200
  • Year Built: 1985

Lot Features

  • Lot Size (Acres): 0.0861
  • Lot Size (Sq. Ft.): 3,750
  • Fence: Yes
  • Fencing (Description): Back Yard, Fenced, Front Yard

Financial Considerations

  • Tax Amount: $8,057

Disclosures and Reports

  • Special Conditions: None
  • Property ID: 13586-0110

Listed by RE/MAX Southshore Realty

Quickly Find Out More

* Indicates a required field

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-11 254th St —

  • RE/MAX Southshore Realty

718-276-4848

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 142-11 254th St

School District:New York City Geographic School District 29
NameGradesDistance
P.S. / M.S. 138 Sunrise
251-11 Weller Ave, Queens, NY 11422
K-80.1 mi
Community Voices Middle School
145-00 Springfield Blvd, Queens, NY 11413
6-81.4 mi
Collaborative Arts Middle School
145-00 Springfield Blvd, Queens, NY 11413
6-81.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-11 254th St Get Price Alerts and Save Property

Date
Details
Price
Change
Source
7/07/2026
Listed
$989,999
104.12%
MLS
8/11/2004
Sold
$485,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 for 142-11 254th St

Year
Property Taxes
Change
Tax Assessment
Change
2025
$8,056
—
$42,518
6%
2025
$8,056
6%
$40,112
-30%
2024
$7,601
—
$57,420
52%
2023
$7,601
—
$37,843
-31%
2022
$7,628
2%
$54,840
17%
2021
$7,457
5%
$46,860
4%
2020
$7,076
6%
$45,240
8%
2019
$6,675
5%
$41,700
32%
2017
$6,380
—
$31,536
1%
2017
$6,380
8%
$31,298
6%
2016
$5,903
8%
$29,527
6%
2015
$5,447
8%
$27,856
6%
2015
$5,034
-7%
$26,280
-10%
2013
$5,419
—
$29,160
—
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 for 142-11 254th St

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Listed by RE/MAX Southshore Realty

Similar Properties near 142-11 254th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

256-12 147th Ave, Rosedale, NY 11422 - Photo 1
$999,000

256-12 147th Ave  Rosedale, NY 11422

  • Multi-Family
  • Active
  • Updated 10 days ago
  • 5
    Total Beds
Listed by Real Broker NY LLC
147-68 259th St, Rosedale, NY 11422 - Photo 1
$963,000

147-68 259th St  Rosedale, NY 11422

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by eXp Realty
219-19 143rd Rd, Springfield Gardens, NY 11413 - Photo 1
$935,000

219-19 143rd Rd  Springfield Gardens, NY 11413

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by VYLLA Home
221-26 134th Rd, Springfield Gardens, NY 11413 - Photo 1
$1,049,000

221-26 134th Rd  Springfield Gardens, NY 11413

  • Multi-Family
  • Active
  • 5
    Total Beds
Listed by Next Level Homes Group Ltd

Just Listed near 142-11 254th St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

86-38 232nd St, Queens Village, NY 11427 - Photo 1 Just Listed
$1,050,000

86-38 232nd St  Queens Village, NY 11427

  • Single Family
  • Active
  • Updated 5 days ago
  • 5
    Beds
  • 3
    Total Baths
  • 1,701
    Sq. Ft.
Listed by Property Professionals Realty
103-15 217th St, Queens Village, NY 11429 - Photo 1 Just Listed
$1,529,000
Open House

103-15 217th St  Queens Village, NY 11429

  • Multi-Family
  • Active
  • Updated 1 hour ago
  • 6
    Total Beds
Listed by Imperial Legacy Real Estate
159 Iris Ave, Floral Park, NY 11001 - Photo 1 Just Listed
$939,000

159 Iris Ave  Floral Park, NY 11001

  • Single Family
  • Active
  • Updated 8 hours ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,536
    Sq. Ft.
Listed by Realty Connect USA L I Inc
84-70 129th St, Kew Gardens, NY 11415 - Photo 1 Just Listed
$349,999

84-70 129th St  #5B  Kew Gardens, NY 11415

  • Co-op
  • Active
  • Updated 14 hours ago
  • 2
    Beds
  • 1
    Total Bath
Listed by Atlantis Realty Group Corp

142-11 254th Street, Rosedale, NY 11422 (MLS# 1023060) is a Multi-Family property with 2 units containing 5 bedrooms and 2 full bathrooms. 142-11 254th Street is currently listed for $989,999 and was received on July 07, 2026. Want to learn more about 142-11 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.

Tour this property