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

1823 Avenue U, Brooklyn, NY 11229

This exceptional mixed-use property is ideally situated in the bustling Avenue U business district of Sheepshead Bay, an area known for its vibrant atmosphere and high foot traffic. The building boasts three retail stores along with two beautifully renovated apartments, ensuring a diverse income stream. With no vacancies currently, this property reflects strong demand within the community. A prominent corner store, measuring approximately 350 square feet, is available for rent, offering excellent visibility at a busy intersection. The space is suited for a variety of retail or service businesses, providing a fantastic opportunity for entrepreneurs looking to establish or expand their footprint in this dynamic neighborhood. While the storefront requires some minor renovations, it presents an excellent canvas for customization to meet specific business needs. Located in one of Brooklyn's most sought-after areas, this property represents a prime investment opportunity in a thriving locale.

Total Units: 1

For Sale: 0

For Rent: 0

Building type: Semi-Detached

Commercial Features Interior:

None

Utilities:

Electric
Gas
Heat
Phone
Sewer
Water

◀

►

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

1823 Avenue U, Brooklyn, NY 11229

Commercial Features Interior:

Utilities:

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