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"
}
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
See your best matches daily!