array(99) { ["_yoast_indexnow_last_ping"]=> string(10) "1751911598" ["streetname"]=> string(5) "254th" ["_streetname"]=> string(19) "field_6675aa8b47c8f" ["neighborhood"]=> string(4) "7608" ["_neighborhood"]=> string(19) "field_665dee7122fa3" ["bedrooms"]=> string(1) "3" ["_bedrooms"]=> string(19) "field_665deeaa47d7d" ["coolingyn"]=> string(1) "1" ["_coolingyn"]=> string(19) "field_665e0d1090016" ["listprice"]=> string(6) "950000" ["_listprice"]=> string(19) "field_665dee2822fa2" ["streetsuffix"]=> string(6) "Street" ["_streetsuffix"]=> string(19) "field_6675aabf47c93" ["laundryfeatures"]=> string(10) "SeeRemarks" ["_laundryfeatures"]=> string(19) "field_665e095bbfa67" ["streetnumber"]=> string(5) "38-02" ["_streetnumber"]=> string(19) "field_6675aa9b47c90" ["mlsid"]=> string(11) "RLS20011399" ["_mlsid"]=> string(19) "field_666771355b150" ["storiestotal"]=> string(1) "1" ["_storiestotal"]=> string(19) "field_665e0b339000e" ["modified"]=> string(29) "2025-07-07T14:01:25.783-00:00" ["_modified"]=> string(19) "field_667359b200d6b" ["bathrooms"]=> string(1) "1" ["_bathrooms"]=> string(19) "field_665deeb447d7e" ["yearbuilt"]=> string(4) "1955" ["_yearbuilt"]=> string(19) "field_665e0b3b9000f" ["listing_key"]=> string(10) "1109192256" ["_listing_key"]=> string(19) "field_65d642d31b95f" ["cooling"]=> string(10) "CentralAir" ["_cooling"]=> string(19) "field_665e0975bfa69" ["state"]=> string(2) "NY" ["_state"]=> string(19) "field_6656331ef053c" ["petsallowed"]=> string(1) "1" ["_petsallowed"]=> string(19) "field_665e0b4390010" ["publicremarks"]=> string(174) "Original Owner!! RARE OVERSIZED LOT 35 X 142 feet. Built in 1955 , this sale being offered by orginal owners. Many Possibilities!! Must see. Wonโ€™t last . 7,277 sq foot lot" ["_publicremarks"]=> string(19) "field_665dee9522fa4" ["city"]=> string(6) "Queens" ["_city"]=> string(19) "field_66563315f053b" ["zipcode"]=> string(5) "11363" ["_zipcode"]=> string(19) "field_66563322f053d" ["livingarea"]=> string(4) "1250" ["_livingarea"]=> string(19) "field_665deec247d7f" ["propertysubtype"]=> string(21) "SingleFamilyResidence" ["_propertysubtype"]=> string(19) "field_665e168921ace" ["structuretype"]=> string(5) "House" ["_structuretype"]=> string(19) "field_665e0ce590014" ["taxannualamount"]=> string(4) "9552" ["_taxannualamount"]=> string(19) "field_665e164421acc" ["media"]=> string(2) "19" ["_media"]=> string(19) "field_665dfc55bfa65" ["latitude"]=> string(11) "40.77575315" ["_latitude"]=> string(19) "field_65cfb7b05bfc2" ["longitude"]=> string(14) "-73.7421290151" ["_longitude"]=> string(19) "field_65d3a87704862" ["listagentmlsid"]=> string(5) "37264" ["_listagentmlsid"]=> string(20) "field_665e09aksdf789" ["listagentfullname"]=> string(13) "Shari Markoff" ["_listagentfullname"]=> string(19) "field_665e09a4bask3" ["listofficename"]=> string(6) "Avenue" ["_listofficename"]=> string(18) "field_665e2334f789" ["media_0_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/11/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/XdNInHJvdXiV5mOCJU8_CF9IHZOplLm7fedj7dsqJdE" ["_media_0_url"]=> string(19) "field_665e0818bfa66" ["media_1_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/7/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/yGmrzSbKWHEkMtFiwmB2HZofQjUO4bA3Pee8aQX7Y_M" ["_media_1_url"]=> string(19) "field_665e0818bfa66" ["media_2_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/12/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/JludrbD0bYVvBimd07Xp1SXQi33ncv4q0U0ihNJjptY" ["_media_2_url"]=> string(19) "field_665e0818bfa66" ["media_3_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/14/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/sNhVO8lNYwiVpLb5hEhuWjCodWmlGucjRiHjgwWUUWU" ["_media_3_url"]=> string(19) "field_665e0818bfa66" ["media_4_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/13/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/fs0oniG57_xJOpjZyAi-aju6-O2wDzuUXFNrJOqvGnE" ["_media_4_url"]=> string(19) "field_665e0818bfa66" ["media_5_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/10/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/ytHxuRs5jn0MkZFkqVYpR_ZKYetJKHyhIZcqxFel1Is" ["_media_5_url"]=> string(19) "field_665e0818bfa66" ["media_6_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/9/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/8wm1_Gr8BTMf3kUVY7Ums1mTg9Iw_2t9ApomXIKPwUk" ["_media_6_url"]=> string(19) "field_665e0818bfa66" ["media_7_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/8/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/d1yjKJssT6N05UGubIkgbNztowlvFw59RFBSZgmPCl0" ["_media_7_url"]=> string(19) "field_665e0818bfa66" ["media_8_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/18/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/5YMAtPRmsQmsoNWiSt9sXOFLwDnmpXwLV4sPSA45ueA" ["_media_8_url"]=> string(19) "field_665e0818bfa66" ["media_9_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/17/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/pngzW8E8JEi0igpSHbKpRng-M1_x9BP-Xoo3N18gi5g" ["_media_9_url"]=> string(19) "field_665e0818bfa66" ["media_10_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/16/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/K2wvdF-_T6RbC7rRp82KqM2HJUayU3c_w_6Knv87yVw" ["_media_10_url"]=> string(19) "field_665e0818bfa66" ["media_11_url"]=> string(173) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/15/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/C_NHT9kG6bH-Dux9k-Kan2FJrPjxNX-ImfHlBwmjFVE" ["_media_11_url"]=> string(19) "field_665e0818bfa66" ["media_12_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/6/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/o6lLIp1YLyVZ2LzY6U2_tq9_aFUoQdlGaxk0cMLi2IU" ["_media_12_url"]=> string(19) "field_665e0818bfa66" ["media_13_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/5/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/uLCnurzXQgZdb7-L4iJR_vcd-XwKcgVWEOdBgC6rFxM" ["_media_13_url"]=> string(19) "field_665e0818bfa66" ["media_14_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/4/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/jT-ejpVHVCAFFLTev7Do06MI-yBXStqJtaM5XQWhtTk" ["_media_14_url"]=> string(19) "field_665e0818bfa66" ["media_15_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/3/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/ZkdAFCuAm-BTCKNf2RqXldIAajIxysdUq_TvOhTwU-U" ["_media_15_url"]=> string(19) "field_665e0818bfa66" ["media_16_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/U-udK9yi4PKETaRPyZ1DlypOYmXL0zsATRpSw23pSxU" ["_media_16_url"]=> string(19) "field_665e0818bfa66" ["media_17_url"]=> string(175) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/DOCUMENT-Jpeg/1109192256/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/xFHcrx3D08lbxnugIEgQ-uZDa3ueEmScRNZcojvgZWk" ["_media_17_url"]=> string(19) "field_665e0818bfa66" ["media_18_url"]=> string(172) "https://api-trestle.corelogic.com/trestle/Media/RLS/Property/PHOTO-Jpeg/1109192256/2/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc1MTkxMTQ5NQ/4PkGaZTMale0q5Hsp91xdi0inffxJfGDeIfSHlmN1sg" ["_media_18_url"]=> string(19) "field_665e0818bfa66" }
19 Photos
Save

38-02 254th Street

$950,000/mo Little Neck | 3 beds | 1 bath | 1250 sqft

Description

Original Owner!! RARE OVERSIZED LOT 35 X 142 feet. Built in 1955 , this sale being offered by orginal owners. Many Possibilities!! Must see. Wonโ€™t last . 7,277 sq foot lot

Read More

Apartment Features

  • Cooling - CentralAir
  • Laundry - See Remarks
  • Pets - Allowed

Building Features

  • 1 stories

See your best matches daily!

By submitting contact information on this website, you are consenting to receive calls, SMS, and emails from Loftey and its affiliates. You certify that you are the owner of the contact information provided.

Related listings