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
Welcome to this beautifully maintained single-family home in the heart of Little Neck, offering approximately 2,400 square feet of comfortable living space and a flexible layout ideal for modern living. This residence features three bedrooms, 2.5 bathrooms, and thoughtfully designed spaces for everyday life and entertaining.
The main level offers a spacious open living and dining area, filled with natural light, along with a well-appointed kitchen that flows seamlessly for daily use. The layout balances openness with privacy, creating a warm and functional living environment.
A major highlight is the fully finished basement, currently used as a media room, which benefits from an enhanced ceiling height, creating a more open and comfortable space for entertainment, recreation, or a home office. The basement also includes a bathroom and direct access to the backyard, providing excellent indooroutdoor flow.
The home features seven high-quality Mitsubishi mini-split heat pump units installed throughout, including one unit serving the garage currently used as a home gym, delivering efficient heating and cooling with individual room-by-room temperature control. The property has benefited from numerous key improvements
...
More >
Licensed RE Salesperson
917-496-5481
Licensed RE Salesperson
sarah@brickandmortar.com
917-496-5481