Sign In

Close

x
Showing 1 of 0
X
Save
142-11 254th Street Rosedale NY 11422US5 Bed, 2.00 Bath (2 Full Bath), 1023060
142-11 254th Street RosedaleNY11422
989999.0000 1/1/1900 12:00:00 AM
Realty Executives Power House
244-06 Jericho TurnpikeFloral ParkNY11001
516-437-8080
1 /

Courtesy of: Andre Horn, RE/MAX Southshore Realty, andre_m_horn@yahoo.com

142-11 254th Street
Rosedale NY 11422 US

Save
1 /

Courtesy of: Andre Horn, RE/MAX Southshore Realty, andre_m_horn@yahoo.com

Realty Executives Power House
244-06 Jericho Turnpike
Floral Park, NY, US 11001
516-437-8080

Get more info about this property

142-11 254th Street
Rosedale NY 11422 US

$989,999

Active Listing ID 1023060
bed icon
5 bed
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 0.09 Acres
home icon
Other

$989,999

Active Listing ID 1023060
Save
3d icon
Maps

142-11 254th Street 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!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.09 Acres
  • Property Type: Residential Multi Family
  • Property Sub-type: Other
  • Features
  • Full Bathrooms: 2
  • Floor Covering: Hardwood
  • Heating Fuels: Natural Gas, Baseboard, Hot Water(Heating)
  • Additional Features
  • Basement

School Information

  • School
  • Ps/Ms 138 Sunrise(Elementary)
  • Benjamin Franklin Hs-Finance-Info(MiddleSchool)
  • Excelsior Prep High School(HighSchool)

Property

  • propertytype: Residential Multi Family
  • propertysubtype: Other
  • listprice: 989999
  • unparsedaddress: 142-11 254th Street
  • postalcity: Rosedale
  • stateorprovince: NY
  • country: US
  • postalcode: 11422
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.0861
  • lotsizeunits: Acres
  • lotsizearea: 0.0861
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 40.659138
  • longitude: -73.73288
  • listagentfullname: Andre Horn
  • listagentemail: andre_m_horn@yahoo.com
  • listagentkey: 3yd-MLSLINY-26677
  • listagentmlsid: 26677
  • listagentpreferredphone: (718) 276-4848
  • listagentofficephone: 9178541177
  • listofficekey: 3yd-MLSLINY-SSRE01
  • listofficemlsid: SSRE01
  • disclaimer: Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MLSLINY
  • yearbuilt: 1985
  • listingcontractdate: 2026-07-07
  • listagentfax: 7182764945
  • listagenturl: http://REMAXSS.NET
  • countyorparish: Queens
  • parcelnumber: 13586-0110
  • elementaryschool: Ps/Ms 138 Sunrise
  • highschool: Excelsior Prep High School
  • elementaryschooldistrict: Queens 29
  • middleorjuniorschooldistrict: Queens 29
  • highschooldistrict: Queens 29
  • constructionmaterials: Frame, Vinyl Siding
  • flooring: Hardwood
  • heating: Natural Gas, Baseboard, Hot Water(Heating)
  • numberofunitstotal: 2
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 4
  • parkingfeatures: Driveway, Garage
  • waterfrontyn: False
  • franchiseaffiliation: RE/MAX International
  • interiorfeatures: First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Granite Counters, High Ceilings, Open Kitchen
  • rooms: Bedroom 4, Bathroom 1, Bedroom 1, Bedroom 3, Basement, Bedroom 5, Bedroom 2, Bathroom 2
  • utilities: Natural Gas Available
  • basement: Full, Finished
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -73.73288, 40.659138
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"RE/MAX SOUTHSHOREREALTY", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"andre_m_horn@yahoo.com", "ListBrokerageCity":"rosedale", "ListBrokerageCountry":"US", "ListBrokerageEmail":"kennysattaur@hotmail.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MLSLINY/d3720d01b8d711de9a6500065bf395fa/20091015141429450.pjpeg", "ListBrokerageName":"RE/MAX SOUTHSHOREREALTY", "ListBrokeragePhone":"(718) 276-4848", "ListBrokeragePostalCode":"11422", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":"140th ave", "ListBrokerageUnparsedAddress":"241-30", "ListBrokerageWebsiteUrl":"http://REMAXSS.NET", "ListOfficeAddress1":"24130 140th Ave ", "ListOfficeAddress2":"140th ave", "ListOfficeBrokerMlsId":"SSRE01", "ListOfficeCity":"Rosedale", "ListOfficeCountry":"US", "ListOfficeEmail":"remaxss@gmail.com", "ListOfficePostalCode":"11422", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"MULTI_FAMILY - Rosedale, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/14211-254th-St_Rosedale_NY_11422_M48251-19013?f=listhub&s=MLSLINY&m=1023060&c=rexren", "MLSModificationTimestamp":"2026-07-08 09:04:45", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":8057, "TaxDescription":null, "TaxYear":"2025"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/9/2026 12:32:35 AM GMT
Source Updated Date: 7/16/2026 12:44:24 PM GMT

Courtesy of: Andre Horn, RE/MAX Southshore Realty, andre_m_horn@yahoo.com

Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact