Sign In

Close

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

Courtesy of: Bhupinder Singh Devgun, Cross Island Realty One Inc, realelite.67@gmail.com

142-28 254th Street
Rosedale NY 11422 US

Save
1 /

Courtesy of: Bhupinder Singh Devgun, Cross Island Realty One Inc, realelite.67@gmail.com

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

Get more info about this property

142-28 254th Street
Rosedale NY 11422 US

$995,000

Active Listing ID 1062969
bed icon
4 bed
bath icon
2.00 Bath (2 Full)
lot icon
Lot: 0.11 Acres
home icon
Duplex

$995,000

Active Listing ID 1062969
Save
3d icon
Maps

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

Collapse all

Property Features

  • Facts
  • Lot Size: 0.11 Acres
  • Property Type: Residential Multi Family
  • Property Sub-type: Duplex
  • Features
  • Full Bathrooms: 2
  • Cooling System: Window Unit(s), Wall/Window Unit(s)
  • Heating Fuels: Steam, Natural Gas
  • Additional Features
  • Basement

School Information

  • School
  • Ps 131 Abigail Adams(Elementary)
  • Cambria Heights Academy(MiddleSchool)
  • HEALTH ARTS ROBOTICS AND TECHNOLOGY HIGH SCHOOL(HighSchool)

Property

  • propertytype: Residential Multi Family
  • propertysubtype: Duplex
  • listprice: 995000
  • unparsedaddress: 142-28 254th Street
  • postalcity: Rosedale
  • stateorprovince: NY
  • country: US
  • postalcode: 11422
  • bathroomsfull: 2
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.1148
  • lotsizeunits: Acres
  • lotsizearea: 0.1148
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 40.659234
  • longitude: -73.733667
  • listagentfullname: Bhupinder Singh Devgun
  • listagentemail: realelite.67@gmail.com
  • listagentkey: 3yd-MLSLINY-206788
  • listagentmlsid: 206788
  • listagentpreferredphone: 3476598130
  • listagentofficephone: 3476598130
  • listofficekey: 3yd-MLSLINY-SUMA01
  • listofficemlsid: SUMA01
  • 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: 1970
  • listingcontractdate: 2026-10-15
  • listagentfax: 7188310170
  • listagenturl: http://www.crossislandrealtyone.net
  • countyorparish: Queens
  • parcelnumber: 13585-0080
  • elementaryschool: Ps 131 Abigail Adams
  • highschool: HEALTH ARTS ROBOTICS AND TECHNOLOGY HIGH SCHOOL
  • elementaryschooldistrict: Queens 29
  • middleorjuniorschooldistrict: Queens 29
  • highschooldistrict: Queens 29
  • cooling: Window Unit(s), Wall/Window Unit(s)
  • constructionmaterials: Frame
  • heating: Natural Gas, Steam
  • numberofunitstotal: 2
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 4
  • waterfrontyn: False
  • franchiseaffiliation: Independent
  • interiorfeatures: First Floor Bedroom, First Floor Full Bath, Eat-in Kitchen, Formal Dining, Kitchen Island
  • architecturalstyle: Colonial
  • rooms: Bathroom 1, Bedroom 4, Bedroom 3, Bathroom 2, Basement, Bedroom 1, Bedroom 2, Dining Room
  • utilities: Natural Gas Available
  • basement: Full, Walk-Out Access, Finished
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: False
  • internetconsumercommentyn: False
  • location: -73.733665, 40.659233
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Cross Island Realty One, Inc", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"realelite.67@gmail.com", "ListBrokerageCity":"Bellerose", "ListBrokerageCountry":"US", "ListBrokerageEmail":"palbabu@aol.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Cross Island Realty One, Inc", "ListBrokeragePhone":"(718) 831-0100", "ListBrokeragePostalCode":"11426", "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"250-14A Hilllside Ave", "ListBrokerageWebsiteUrl":"http://www.crossislandrealtyone.net", "ListOfficeAddress1":"25014 Hillside Ave Ste A ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"SUMA01", "ListOfficeCity":"Bellerose", "ListOfficeCountry":"US", "ListOfficeEmail":"cirealty5@gmail.com", "ListOfficePostalCode":"11426", "ListOfficeStateOrProvince":"NY", "ListPriceCurrencyType":"USD", "ListingTitle":"Residential Income, Rosedale, NY", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/14228-254th-St_Rosedale_NY_11422_M48986-44717?f=listhub&s=MLSLINY&m=1062969&c=rexren", "MLSModificationTimestamp":"2026-10-16 09:01:40", "Neighborhoods":[], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":5953, "TaxDescription":null, "TaxYear":"2026"}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 10/24/2026 9:34:35 AM GMT
Source Updated Date: 11/5/2026 12:48:11 PM GMT

Courtesy of: Bhupinder Singh Devgun, Cross Island Realty One Inc, realelite.67@gmail.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