Welcome to this impressive mixed-use building located in the vibrant neighborhood of Homecrest, Brooklyn

Total: {{ totalFound }}

Selected: {{ Object.values(filter.idsInSelected).filter(Boolean).length }}

No results found.
Try adjusting or resetting your filters.

Featured OPEN HOUSE:
{{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}
For sale For rent {{ property.price | toCurrency }} NEW RENTED UNDER CONTRACT Expired SOLD

{{ property?.neighbourhood?.name }}

{{ property?.borough?.name }}

{{ property.address }}

{{ property.propertysubtype }}

Building {{ property.buildingwidth }} Ft x {{ property.buildinglength }} Ft

Lot {{ property.lotsizewidth }} Ft x {{ property.lotsizelength }} Ft

{{ property.bedstotal }} Beds | {{ property.bathstotal }} Baths

Sq. Ft {{ property.sqfttotal.toLocaleString() }}

CC/Maint.{{ property.maintenancecommonfee | toCurrency }}

RE Tax {{ property.taxamount | toCurrency }}

Featured OPEN HOUSE:
{{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}
For sale For rent {{ property.price | toCurrency }} NEW RENTED UNDER CONTRACT Expired SOLD

{{ property?.neighbourhood?.name }}

{{ property?.borough?.name }}

{{ property.address }}

{{ property.propertysubtype }}

Building {{ property.buildingwidth }} Ft x {{ property.buildinglength }} Ft

Lot {{ property.lotsizewidth }} Ft x {{ property.lotsizelength }} Ft

{{ property.bedstotal }} Beds | {{ property.bathstotal }} Baths

Sq. Ft {{ property.sqfttotal.toLocaleString() }}

CC/Maint.{{ property.maintenancecommonfee | toCurrency }}

RE Tax {{ property.taxamount | toCurrency }}

Unit History Building History Save Search Map ViewDetailed View

{{ agent?.office?.officeaddress }}

Office {{ formatPhoneString(agent?.office?.phone) }}

Cell. {{ formatPhoneString(agent?.cellphone) }}

Contact

Languages: {{ agent?.languagesNames }}

View my other listings

{{agent?.reviews?.length ?? 0}} Reviews

{{ agent?.firstname }} {{ agent?.lastname }} currently has no active listings.

Homecrest

1247 Avenue U, Brooklyn, NY 11229

Welcome to this impressive mixed-use building located in the vibrant neighborhood of Homecrest, Brooklyn. This three-story structure features a generous retail space on the ground floor, complemented by two well-appointed residential units above. With a total area of approximately 3,800 square feet, the building provides ample room for both commercial and residential activities. The retail store is designed for optimal functionality, equipped with organized shelving and refrigeration units, making it ideal for a variety of business ventures. The property has undergone recent renovations, ensuring modern amenities and a fresh aesthetic throughout. Additionally, its strategic location on Avenue U places it in a high-traffic commercial zone, enhancing visibility and accessibility for potential customers. The proximity to public transportation adds to the convenience, making this an attractive opportunity for businesses looking to thrive in a bustling community.

Total Units: 2

For Sale: 1

For Rent: 0

Building type: Attached

Commercial Features Interior:

Restrooms - Staff
Other

◀

►

MLS #{{ property.mlsnumber }}

OPEN HOUSE: {{ property.openhouse[0].openhousedate }}, {{ property.openhouse[0].starttime }} - {{ property.openhouse[0].endtime }}

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 }}

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 }}

Virtual Tour

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?.officeaddress }}

Office {{ formatPhoneString(agent?.officephone) }}

Cell. {{ formatPhoneString(agent?.cellphone) }}

Languages: {{ agent?.languages }}

View my other listings

Contact

Mortgage Calculator

Number of Years:

Interest Rate:

Amount of loan after down payment:

Monthly Payment:

Homecrest

1247 Avenue U, Brooklyn, NY 11229

Commercial Features Interior:

{{ property.neighbourhood?.name }}

{{ property.borough?.name }}

{{ property.projectname }}

{{ property.address }}

{{ property.listprice | toCurrency }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}

Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}

Sold Price: {{ property.closeprice | toCurrency }}

Closed Price: {{ property.closeprice | toCurrency }}

Building amenities:

Residential Features:

Commercial Features Interior:

Utilities:

Parking Attributes:

Parking Features:

Basement amenities:

Exterior:

Virtual Tour

{{ property.propertysubtype }}

Contacts

Mortgage Calculator

{{ calc.monthly }}

2 listings at 1247 Avenue U, Brooklyn, NY 11229

Homecrest

1247 Avenue U, Brooklyn, NY 11229

Commercial Features Interior:

{{ property.neighbourhood?.name }}

{{ property.borough?.name }}

{{ property.projectname }}

{{ property.address }}

{{ property.listprice | toCurrency }}

Selling agent commission: {{ property.co_broke_commission| toCurrency }}

Selling agent commission: {{ property.co_broke_commission }}{{ property.co_broke_commission_type }}

Sold Price: {{ property.closeprice | toCurrency }}

Closed Price: {{ property.closeprice | toCurrency }}

Building amenities:

Residential Features:

Commercial Features Interior:

Utilities:

Parking Attributes:

Parking Features:

Basement amenities:

Exterior:

Virtual Tour

{{ property.propertysubtype }}

Contacts

Mortgage Calculator

{{ calc.monthly }}