No results found.
Try adjusting or resetting your filters.
{{ agent?.kind }}
{{ agent?.firstname }} {{ agent?.lastname }}
{{ agent?.type }}
{{ agent?.office?.officename }}
{{ agent?.office?.officeaddress }}
Office {{ formatPhoneString(agent?.office?.phone) }}
Cell. {{ formatPhoneString(agent?.cellphone) }}
Languages: {{ agent?.languagesNames }}
{{ agent?.text }}
{{ agent?.biography }}
{{agent?.rating}}
{{agent?.reviews?.length ?? 0}} Reviews
{{ review.created_at }}
{{ review.name }}
{{ agent?.firstname }} {{ agent?.lastname }} currently has no active listings.
Flushing
199-06 47th Ave, Flushing, NY 11358
This impressive three-story mixed-use building in Flushing presents a remarkable investment opportunity. Featuring two spacious family apartments, each equipped with three sizable bedrooms and two full bathrooms, the property ensures comfortable living arrangements. The street-level office space is ideally suited for medical or treatment purposes, making it perfect for professionals such as dentists or acupuncturists. Constructed in 2007, the building boasts a full finished basement, providing additional utility and potential for various uses. Furthermore, the property accommodates up to four vehicles with parking available at both the front and rear. Strategically located on the border of Flushing and Bayside, residents enjoy convenient access to multiple bus lines, a vibrant array of shopping options, diverse restaurants, community centers, and more. This versatile building is a prime example of modern urban living combined with professional space.
Total Units: 1
For Sale: 0
For Rent: 0
Building type: Attached
Commercial Features Interior:
  • Lobby
  • Other
Parking Attributes:
  • 4 Spaces
{{ property.neighbourhood?.name }}
{{ property.borough?.name }}
{{ property.projectname }}
{{ property.address }}
MLS #{{ property.mlsnumber }}
OPEN HOUSE: {{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}

{{ property.listprice | toCurrency }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}
Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}
Days on Market: {{ property.dom }}
Expiration Date: {{ property.expireddate }}
Listed Price: {{ property.listprice | toCurrency }}
Sold Price: {{ property.closeprice | toCurrency }}
Days on Market: {{ property.dom }}
Close Date: {{ property.closedate }}
Listed Price: {{ property.listprice | toCurrency }}
Closed Price: {{ property.closeprice | toCurrency }}
Days on Market: {{ property.dom }}
Close Date: {{ property.closedate }}
Under Contract: {{ property.lastchangedate }}

{{ property.publicremarks }}

{{ property.propertyType }}
Floor: {{ property.floornumber }}
Year built: {{ property.yearbuilt }}
Period built: {{ property.periodbuilt }}
Building type: {{ property.buildingtype }}
Pets Allowed: {{ property.petsallowed }}
Style: {{ property.style }}
Assessment included
Board approval included
Building amenities:
  • {{ amenity }}
Residential Features:
  • {{ feature }}
Commercial Features Interior:
  • {{ feature }}
Utilities:
  • {{ utility }}
Parking Attributes:
  • {{ parkingattribute }}
Parking Features:
  • {{ property.parkingfeaturesingle }}
  • {{ parkingfeature }}
Basement amenities:
  • {{ basementamenity }}
Exterior:
  • {{ exteriorItem }}
All listings are subject to errors, omissions, price change, withdrawal and sale without notice.
Data source copyright: © 2026 BROOKLYNMLS USA. All rights reserved.
{{ property.propertysubtype }}
Bedrooms: {{ property.bedstotal }}
Baths Full: {{ property.bathsfull }}
Baths Half: {{ property.bathshalf }}
Rooms: {{ property.roomcount }}
Stories: {{ property.stories }}
Building Size: {{ property.buildingwidth }}' x {{ property.buildinglength }}'
Lot: {{ property.lotsizewidth }}' x {{ property.lotsizelength }}'
Finished Sq. Ft.: {{ property.sqfttotal | toLocaleFormat }}
CC/Maintenance: {{ property.maintenancecommonfee | toCurrency }}
RE Tax: {{ property.taxamount | toCurrency }}
Families #: {{ property.numberoffamilies }}
Contacts
{{ agent?.kind }}
{{ agent?.firstname }} {{ agent?.lastname }}
{{ agent?.type }}
{{ agent?.officename }}
{{ agent?.officeaddress }}
Office {{ formatPhoneString(agent?.officephone) }}
Cell. {{ formatPhoneString(agent?.cellphone) }}
Languages: {{ agent?.languages }}
{{ agent?.text }}
Mortgage Calculator

{{ calc.monthly }}

{{ property.matrix_unique_id }}