A PHP Error was encountered

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_dev\application\controllers\Listing.php
Line: 140
Function: trim

File: C:\www_resoft\bam\site_dev\application\controllers\Listing.php
Line: 21
Function: getListingData

File: C:\www_resoft\bam\site_dev\index.php
Line: 315
Function: require_once

A PHP Error was encountered

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_dev\application\controllers\Listing.php
Line: 140
Function: trim

File: C:\www_resoft\bam\site_dev\application\controllers\Listing.php
Line: 21
Function: getListingData

File: C:\www_resoft\bam\site_dev\index.php
Line: 315
Function: require_once

Single Family, 240-17 67th Avenue #, Douglas Manor-Douglaston-Little Neck - Real Estate Brooklyn :: Brick&Mortar LLC

Status: Active

240-17 67th Avenue, #

Douglas Manor-Douglaston-Little Neck

$1,193,000
 |  3 Beds  |  2.5 Baths  |  1,368SF

Description

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 >

Property Details

  • Single Family

Amenities

  • Building Garden, Garden, Private Outdoor Space Over60 Sqft
  • View: City
  • Dryer, Dishwasher, Washer
  • Pets: Building Yes, Yes

The Neighborhood

Douglas
Manor-Douglaston-Little
Douglas Manor-Douglaston-Little Neck

For information on 240-17 67th Avenue, # contact:

realtor top real estate agent

Agent fields

Licensed RE Salesperson

Licensed RE Salesperson
bbagamerii@resoftsyys.com

Listing courtesy of Hauseit LLC
The First Name field is required.
The Last Name field is required.
The Email field is required.
The Mobile Number field is required.. Please enter a valid phone number.
All information is intended only for the visitor’s personal, noncommercial use. This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2026. The Real Estate Board of New York, Inc., All rights reserved. The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. RLS Data display by Brick & Mortar.