array(57) {
["_yoast_indexnow_last_ping"]=>
string(10) "1744848446"
["streetname"]=>
string(8) "Woodside"
["_streetname"]=>
string(19) "field_6675aa8b47c8f"
["neighborhood"]=>
string(4) "7760"
["_neighborhood"]=>
string(19) "field_665dee7122fa3"
["bedrooms"]=>
string(1) "6"
["_bedrooms"]=>
string(19) "field_665deeaa47d7d"
["basement"]=>
string(5) "Other"
["_basement"]=>
string(19) "field_665e0d2e90019"
["patioandporchfeatures"]=>
string(4) "None"
["_patioandporchfeatures"]=>
string(19) "field_665e0e9790021"
["coolingyn"]=>
string(1) "1"
["_coolingyn"]=>
string(19) "field_665e0d1090016"
["listprice"]=>
string(7) "1750000"
["_listprice"]=>
string(19) "field_665dee2822fa2"
["streetsuffix"]=>
string(6) "Avenue"
["_streetsuffix"]=>
string(19) "field_6675aabf47c93"
["laundryfeatures"]=>
string(6) "InUnit"
["_laundryfeatures"]=>
string(19) "field_665e095bbfa67"
["streetnumber"]=>
string(5) "77-16"
["_streetnumber"]=>
string(19) "field_6675aa9b47c90"
["mlsid"]=>
string(11) "RLS20016876"
["_mlsid"]=>
string(19) "field_666771355b150"
["modified"]=>
string(29) "2025-04-16T18:33:28.357-00:00"
["_modified"]=>
string(19) "field_667359b200d6b"
["bathrooms"]=>
string(1) "4"
["_bathrooms"]=>
string(19) "field_665deeb447d7e"
["listing_key"]=>
string(10) "1111815235"
["_listing_key"]=>
string(19) "field_65d642d31b95f"
["cooling"]=>
string(5) "Other"
["_cooling"]=>
string(19) "field_665e0975bfa69"
["state"]=>
string(2) "NY"
["_state"]=>
string(19) "field_6656331ef053c"
["petsallowed"]=>
string(0) ""
["_petsallowed"]=>
string(19) "field_665e0b4390010"
["publicremarks"]=>
string(1517) "
Turnkey Trophy Asset 7.5 Cap Fully Occupied Mixed-Use Gem
Introducing a rare opportunity to own a sleek 2-unit mixed-use condominium in a vibrant, high-density corridor that practically prints cash. Built just 11 years ago, this modern new construction property is as sharp as it is solid - offering investors a fully leased, income-generating machine with zero headaches and serious upside.
NOI 136,150 7.5 Cap Rate
1 Commercial Condo featuring 2 dynamic retail storefronts
1 Residential Condo comprised of 4 fully occupied rental apartments
Strong occupant mix with consistent cash flow and proven performance
Located in a high-traffic, transit-rich neighborhood - excellent for both residential living and commercial exposure
Surrounded by shopping, dining, and major transportation hubs, making it a resident and commuter favorite
This is the kind of turnkey investment that savvy buyers dream of - low maintenance, fully stabilized, and delivering immediate returns. Whether you're expanding your portfolio or entering the mixed-use space with confidence, this property checks every box.
Solid construction. Prime location. Sexy numbers.
Let's talk.
"
["_publicremarks"]=>
string(19) "field_665dee9522fa4"
["city"]=>
string(6) "Queens"
["_city"]=>
string(19) "field_66563315f053b"
["floor"]=>
string(1) "1"
["_floor"]=>
string(19) "field_665def17897b5"
["zipcode"]=>
string(5) "11373"
["_zipcode"]=>
string(19) "field_66563322f053d"
["view"]=>
string(5) "Other"
["_view"]=>
string(19) "field_665e0e6d9001d"
["propertysubtype"]=>
string(8) "MixedUse"
["_propertysubtype"]=>
string(19) "field_665e168921ace"
["structuretype"]=>
string(8) "MixedUse"
["_structuretype"]=>
string(19) "field_665e0ce590014"
["taxannualamount"]=>
string(5) "24360"
["_taxannualamount"]=>
string(19) "field_665e164421acc"
["media"]=>
string(0) ""
["_media"]=>
string(19) "field_665dfc55bfa65"
["latitude"]=>
string(11) "40.74342665"
["_latitude"]=>
string(19) "field_65cfb7b05bfc2"
["longitude"]=>
string(14) "-73.8873230971"
["_longitude"]=>
string(19) "field_65d3a87704862"
}
$1,750,000/mo Corona-Elmhurst | 6 beds | 4 baths | Floor 1
Description
Turnkey Trophy Asset 7.5 Cap Fully Occupied Mixed-Use Gem
Introducing a rare opportunity to own a sleek 2-unit mixed-use condominium in a vibrant, high-density corridor that practically prints cash. Built just 11 years ago, this modern new construction property is as sharp as it is solid – offering investors a fully leased, income-generating machine with zero headaches and serious upside.
NOI 136,150 7.5 Cap Rate
1 Commercial Condo featuring 2 dynamic retail storefronts
1 Residential Condo comprised of 4 fully occupied rental apartments
Strong occupant mix with consistent cash flow and proven performance
Located in a high-traffic, transit-rich neighborhood – excellent for both residential living and commercial exposure
Surrounded by shopping, dining, and major transportation hubs, making it a resident and commuter favorite
This is the kind of turnkey investment that savvy buyers dream of – low maintenance, fully stabilized, and delivering immediate returns. Whether you’re expanding your portfolio or entering the mixed-use space with confidence, this property checks every box.
Solid construction. Prime location. Sexy numbers.
Let’s talk.
Read More
Apartment Features
- Cooling - Other
- Laundry - In Unit
See your best matches daily!