Severity: 8192
Message: trim(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: controllers/Listing.php
Line Number: 140
Backtrace:
File: C:\www_resoft\bam\site_test\application\controllers\Listing.php
Line: 140
Function: trim
File: C:\www_resoft\bam\site_test\application\controllers\Listing.php
Line: 21
Function: getListingData
File: C:\www_resoft\bam\site_test\index.php
Line: 315
Function: require_once
Severity: 8192
Message: trim(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: controllers/Listing.php
Line Number: 140
Backtrace:
File: C:\www_resoft\bam\site_test\application\controllers\Listing.php
Line: 140
Function: trim
File: C:\www_resoft\bam\site_test\application\controllers\Listing.php
Line: 21
Function: getListingData
File: C:\www_resoft\bam\site_test\index.php
Line: 315
Function: require_once
Open House on Sunday 2/1 12-1pm. Showing window is limited due to tenant occupancy. Please make an appointment via email.
Welcome to 164 Underhill Avenue, a remarkable property nestled in the heart of Brooklyn's coveted Prospect Heights neighborhood. This fully renovated five-family residence blends modern luxury with classic charm, making it an outstanding investment opportunity or a spacious home for an owner-occupant.
Spanning 4,441 square feet, the property offers four bedrooms and seven bathrooms, providing both space and privacy. The owner's duplex stands out with two bedrooms, two-and-a-half bathrooms, and a private garden perfect for relaxing or entertaining. The kitchen features stainless steel appliances, two-toned custom cabinetry, and elegant marble countertops, creating a sophisticated yet functional space. Carrara marble bathrooms add a refined touch throughout. Split system heating and cooling provides year round comfort.
The second and third floors include a renovated studio and a one-bedroom apartment, both offering strong rental income and consistent demand. All units are set up separately with mechanicals for heating, cooling and hot water.
Set on a picturesque, tree-lined
...
More >
Prospect Heights is a colorful and diverse neighborhood anchored by multiple cultural institutions: Grand Army Plaza, Brooklyn Botanic Gardens, Barclay’s Center, Prospect Park, the Brooklyn Museum, and the gorgeous central branch of the Brooklyn Library.
Turn down any side street, however, and you’ll find gorgeous old brownstones, stately coops, and new developments on quiet, tree-lined streets. The commercial venues of Vanderbilt and Washington Avenues offer a myriad of restaurants, mom-and-pop shops, craft cocktail bars, cafes, and boutiques with a distinctly “come as you are” Brooklyn attitude. Hot spots include: Faun, Tom’s, White Tiger, Unnameable Books, Chuko, Olmsted, Bearded Lady, and The Islands.
Licensed RE Salesperson
3473594228
Licensed RE Salesperson
yasmeen@brickandmortar.com
3473594228