array(151) { ["_yoast_indexnow_last_ping"]=> string(10) "1767272454" ["streetname"]=> string(9) "Clearview" ["_streetname"]=> string(19) "field_6675aa8b47c8f" ["neighborhood"]=> string(4) "7517" ["_neighborhood"]=> string(19) "field_665dee7122fa3" ["bedrooms"]=> string(1) "3" ["_bedrooms"]=> string(19) "field_665deeaa47d7d" ["basement"]=> string(4) "Full" ["_basement"]=> string(19) "field_665e0d2e90019" ["patioandporchfeatures"]=> string(10) "Deck,Patio" ["_patioandporchfeatures"]=> string(19) "field_665e0e9790021" ["coolingyn"]=> string(1) "1" ["_coolingyn"]=> string(19) "field_665e0d1090016" ["listprice"]=> string(7) "1100000" ["_listprice"]=> string(19) "field_665dee2822fa2" ["streetsuffix"]=> string(10) "Expressway" ["_streetsuffix"]=> string(19) "field_6675aabf47c93" ["listagentmlsid"]=> string(5) "87740" ["_listagentmlsid"]=> string(20) "field_665e09aksdf789" ["laundryfeatures"]=> string(22) "LaundryRoom,SeeRemarks" ["_laundryfeatures"]=> string(19) "field_665e095bbfa67" ["flooring"]=> string(32) "Carpet,CeramicTile,Hardwood,Tile" ["_flooring"]=> string(19) "field_665e099abfa6b" ["fireplacefeatures"]=> string(5) "Other" ["_fireplacefeatures"]=> string(19) "field_665e1015ed4eb" ["streetnumber"]=> string(5) "38-22" ["_streetnumber"]=> string(19) "field_6675aa9b47c90" ["mlsid"]=> string(11) "RLS20060373" ["_mlsid"]=> string(19) "field_666771355b150" ["fireplacestotal"]=> string(1) "1" ["_fireplacestotal"]=> string(19) "field_665e097ebfa6a" ["storiestotal"]=> string(1) "3" ["_storiestotal"]=> string(19) "field_665e0b339000e" ["modified"]=> string(29) "2026-04-09T14:34:13.310-00:00" ["_modified"]=> string(19) "field_667359b200d6b" ["bathrooms"]=> string(1) "2" ["_bathrooms"]=> string(19) "field_665deeb447d7e" ["yearbuilt"]=> string(4) "1930" ["_yearbuilt"]=> string(19) "field_665e0b3b9000f" ["listing_key"]=> string(10) "1146519500" ["_listing_key"]=> string(19) "field_65d642d31b95f" ["cooling"]=> string(5) "Other" ["_cooling"]=> string(19) "field_665e0975bfa69" ["garageyn"]=> string(1) "1" ["_garageyn"]=> string(19) "field_665e0d1790017" ["exteriorfeatures"]=> string(41) "PrivateOutdoorSpaceOver60Sqft,PrivateYard" ["_exteriorfeatures"]=> string(19) "field_665e099ebfa6c" ["state"]=> string(2) "NY" ["_state"]=> string(19) "field_6656331ef053c" ["petsallowed"]=> string(0) "" ["_petsallowed"]=> string(19) "field_665e0b4390010" ["basementyn"]=> string(1) "1" ["_basementyn"]=> string(19) "field_665e0e569001a" ["publicremarks"]=> string(1060) "Welcome home to this fully detached one-family in a fabulous Bayside, Queens location. Set on a 40-foot-wide lot just moments from Bell Boulevard and the LIRR, this sun-filled home combines convenience, space, and incredible outdoor living. An extra-wide private driveway provides abundant off-street parking, along with easy street parking and a two-car garage. The private fenced yard with pool creates a true at-home retreat ideal for relaxing or entertaining. This home is fully appointed with a recently gut-renovated kitchen, and freshly updated baths- all meticulously maintained! Inside, you’ll find an open living area and a spacious formal dining room that flows beautifully to the kitchen for gathering and entertaining. The home boasts three stories of living space plus a basement. The large attic with full-height ceilings works perfectly as a home office, playroom, fitness room, or flexible bonus space. In mint, move-in-ready condition and set in one of Bayside’s most sought-after neighborhoods, this property is a standout opportunity." ["_publicremarks"]=> string(19) "field_665dee9522fa4" ["fireplaceyn"]=> string(1) "1" ["_fireplaceyn"]=> string(19) "field_665e0e5c9001b" ["city"]=> string(6) "Queens" ["_city"]=> string(19) "field_66563315f053b" ["floor"]=> string(1) "1" ["_floor"]=> string(19) "field_665def17897b5" ["listagentfullname"]=> string(19) "Bianca A Colasuonno" ["_listagentfullname"]=> string(19) "field_665e09a4bask3" ["zipcode"]=> string(5) "11361" ["_zipcode"]=> string(19) "field_66563322f053d" ["heatingyn"]=> string(1) "1" ["_heatingyn"]=> string(19) "field_665e09a9bfa6e" ["livingarea"]=> string(4) "1701" ["_livingarea"]=> string(19) "field_665deec247d7f" ["parkingfeatures"]=> string(21) "Garage,OnSite,Private" ["_parkingfeatures"]=> string(19) "field_665e0cc990011" ["propertysubtype"]=> string(7) "Triplex" ["_propertysubtype"]=> string(19) "field_665e168921ace" ["poolfeatures"]=> string(11) "AboveGround" ["_poolfeatures"]=> string(19) "field_665e0cd090012" ["appliances"]=> string(85) "Dryer,Dishwasher,Freezer,Microwave,Range,Refrigerator,StainlessSteelAppliances,Washer" ["_appliances"]=> string(19) "field_665e09babfa6f" ["heating"]=> string(10) "NaturalGas" ["_heating"]=> string(19) "field_665e0cde90013" ["structuretype"]=> string(17) "Townhouse,Triplex" ["_structuretype"]=> string(19) "field_665e0ce590014" ["taxannualamount"]=> string(5) "10356" ["_taxannualamount"]=> string(19) "field_665e164421acc" ["listofficename"]=> string(7) "Compass" ["_listofficename"]=> string(18) "field_665e2334f789" ["media_0_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/18/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/NhuLLyR8w5vFB5c2O5IQX2VE4Y9qFUCNoFHPhmO4OfQ" ["_media_0_url"]=> string(19) "field_665e0818bfa66" ["media_1_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/14/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/ogrA7jwtkepkIOkQcPL6pSbHeeKOFIuYLxgE47f11s0" ["_media_1_url"]=> string(19) "field_665e0818bfa66" ["media_2_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/8/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/R7A1gXwvXaCbVy0G-w72xDcW5xBfXE9UF1LCYZqPG1M" ["_media_2_url"]=> string(19) "field_665e0818bfa66" ["media_3_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/20/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/dkxaFE5_kFsKNy0D9N1WcHw5K3bCa7oucHg7tNWEYeQ" ["_media_3_url"]=> string(19) "field_665e0818bfa66" ["media_4_url"]=> string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1146519500/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/zQgJiziT53084N4-GGXQu6W1qLsK2djRYbSS-FWzUso" ["_media_4_url"]=> string(19) "field_665e0818bfa66" ["media_5_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/15/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/aztLI1ilDfCk99vbYMrhNrmHMKKRXvhz8XTzTUqvxIo" ["_media_5_url"]=> string(19) "field_665e0818bfa66" ["media_6_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/23/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/ANGd0DOrJ8ZN5--vF6xb59Sf84RbsXB_KnJfxpSkPAc" ["_media_6_url"]=> string(19) "field_665e0818bfa66" ["media_7_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/22/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/Uby_F2sn3X2DsGrn8OUpoxdzRqa-eA13H35-T5hJqnk" ["_media_7_url"]=> string(19) "field_665e0818bfa66" ["media_8_url"]=> string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1146519500/3/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/VPcU1Qd253_qzRkVW-MD0XMg-Kr2ItPjuk-lIngqjrk" ["_media_8_url"]=> string(19) "field_665e0818bfa66" ["media_9_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/16/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/7H-BU0GdZHdFq7kcTHheN1JjSokO4Al0lhpVNsKeRsc" ["_media_9_url"]=> string(19) "field_665e0818bfa66" ["media_10_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/19/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/mMOE9y-E3wgSTKojOsooNTKagUwGoBq8-b7eZN-XBpc" ["_media_10_url"]=> string(19) "field_665e0818bfa66" ["media_11_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/1/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/NJttTRNvKYDt_7wsHE92G7MKjWT4z9_D6Sd2sP3Po88" ["_media_11_url"]=> string(19) "field_665e0818bfa66" ["media_12_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/3/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/TbTSX8ymGGsJGvWGBs8GWg1NOmDnoNy30B1XkbPgJAg" ["_media_12_url"]=> string(19) "field_665e0818bfa66" ["media_13_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/21/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/uF4iHHMdmdIDfj9S9hOrnB17hl2QCF8qO2FqUjSioBE" ["_media_13_url"]=> string(19) "field_665e0818bfa66" ["media_14_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/2/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/qAan9uRAZqPjqDlkhtUwW6brGJnvAt2wEjoCpHN1oS0" ["_media_14_url"]=> string(19) "field_665e0818bfa66" ["media_15_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/9/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/OgxVS-_hIyWKSK8Q0FPxdTR5PT968jEBMdrWtxKMlrI" ["_media_15_url"]=> string(19) "field_665e0818bfa66" ["media_16_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/17/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/lOBwsNaLtzGrugBBGMuNoc7tMHjDKQ0hPH25i9DRcfM" ["_media_16_url"]=> string(19) "field_665e0818bfa66" ["media_17_url"]=> string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1146519500/5/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/Df-dPm1apv_LNNeycl1DhNBdlQmH6WQmINvNQe19n0k" ["_media_17_url"]=> string(19) "field_665e0818bfa66" ["media_18_url"]=> string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1146519500/2/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/5fgw2hdgmbJxmJXXmWxfYe3ncgdh37xzDP2LLVnQMD8" ["_media_18_url"]=> string(19) "field_665e0818bfa66" ["media_19_url"]=> string(162) "https://api.cotality.com/trestle/Media/Property/DOCUMENT-Jpeg/1146519500/4/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/--Oc7gm15-2oPuYKkEkKVxhbwimbvUh10bDT752tQz8" ["_media_19_url"]=> string(19) "field_665e0818bfa66" ["media_20_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/7/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/7DgxZEk3xbO4BNQA2k7x8yEYpgkEzabaIgmaXPJ3l44" ["_media_20_url"]=> string(19) "field_665e0818bfa66" ["media_21_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/6/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/0o_60vT36EOju0KziQJEYlLz1WueJ_2hmhIRkEkr3GA" ["_media_21_url"]=> string(19) "field_665e0818bfa66" ["media_22_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/11/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/UQbq2cJz0csA5FwtXXMfwMI0WsSXNT3Z8QhymOuGF20" ["_media_22_url"]=> string(19) "field_665e0818bfa66" ["media_23_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/12/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/yxiVxWN3kWy_pXw_zcw_7Jna8B5TzbK_iDzxaGBA4xM" ["_media_23_url"]=> string(19) "field_665e0818bfa66" ["media_24_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/24/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/1Cfeb56WwvAIIGFccmuTh5Bqd5B_AemsraGsLxlcMYI" ["_media_24_url"]=> string(19) "field_665e0818bfa66" ["media_25_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/10/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/jsWiubNXBpbKk_Yc2XISM2QtYtdIjS53Knk48hwOG4A" ["_media_25_url"]=> string(19) "field_665e0818bfa66" ["media_26_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/5/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/1q3KFGWGvO9dFES0ipa7m7K7vx5LGJbT-2fwKYXO9DA" ["_media_26_url"]=> string(19) "field_665e0818bfa66" ["media_27_url"]=> string(159) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/4/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/0Aii5Rq1b-IG5F49uCTQMb3NllnxdJLEKv4MP3b8CpQ" ["_media_27_url"]=> string(19) "field_665e0818bfa66" ["media_28_url"]=> string(160) "https://api.cotality.com/trestle/Media/Property/PHOTO-Jpeg/1146519500/13/ODQ3Mi84MzYzLzIw/MjAvMTY5NjUvMTc3NTc0NjgwMw/UJo9eF5X7PWEmRmBzG5TJaR1GEeCHytXypKziC8nAaM" ["_media_28_url"]=> string(19) "field_665e0818bfa66" ["media"]=> string(2) "29" ["_media"]=> string(19) "field_665dfc55bfa65" ["latitude"]=> string(13) "40.7275793198" ["_latitude"]=> string(19) "field_65cfb7b05bfc2" ["longitude"]=> string(14) "-73.7588900888" ["_longitude"]=> string(19) "field_65d3a87704862" ["address"]=> string(26) "38-22 Clearview Expressway" ["_address"]=> string(19) "field_6656330af053a" }
29 Photos
Save

38-22 Clearview Expressway

$1,100,000/mo Flushing | 3 beds | 2 baths | 1701 sqft | Floor 1

Description

Welcome home to this fully detached one-family in a fabulous Bayside, Queens location. Set on a 40-foot-wide lot just moments from Bell Boulevard and the LIRR, this sun-filled home combines convenience, space, and incredible outdoor living. An extra-wide private driveway provides abundant off-street parking, along with easy street parking and a two-car garage. The private fenced yard with pool creates a true at-home retreat ideal for relaxing or entertaining. This home is fully appointed with a recently gut-renovated kitchen, and freshly updated baths- all meticulously maintained!

Inside, you’ll find an open living area and a spacious formal dining room that flows beautifully to the kitchen for gathering and entertaining. The home boasts three stories of living space plus a basement. The large attic with full-height ceilings works perfectly as a home office, playroom, fitness room, or flexible bonus space. In mint, move-in-ready condition and set in one of Bayside’s most sought-after neighborhoods, this property is a standout opportunity.

Read More

Apartment Features

  • Flooring - carpet,ceramictile,hardwood,tile
  • Garage,OnSite,Private
  • Cooling - Other
  • Heating - NaturalGas
  • Fireplace - other
  • Dryer
  • Dishwasher
  • Freezer
  • Microwave
  • Range
  • Refrigerator
  • Stainless Steel Appliances
  • Washer
  • Laundry - Laundry Room
  • Private Outdoor Space Over60 Sqft
  • Private Yard

Building Features

  • 3 stories
  • Pool

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