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

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

Single Family, 244-19 Grand Central Parkway #, Douglas Manor-Douglaston-Little Neck - Real Estate Brooklyn :: Brick&Mortar LLC

‹ Back to Listings

Status: Active

244-19 Grand Central Parkway, #

Douglas Manor-Douglaston-Little Neck

$1,600,000
 |  5 Beds  |  4 Baths  |  2,100SF

Description

Welcome to this beautiful Hi-Ranch in Douglaston!! Features include: a heated inground swimming pool with heated spa, with additional heating. An outdoor complete kitchen that has a BBQ grill, stove top, refrigerator, and extra storage including pergola. In the back of the house there is a glass sun room. A resort styled setup with bamboo walls. A cabin room that has tiles and marble wall. The front has silver and gold designed fence. There are 9 rooms including a sunroom. Sun room has a lot of storage underneath. Total 4 full baths. The main bath has a Jaccuzzi, standing shower, and bidet toilet system with remote. Total five bedrooms. Master bedroom has an attached bathroom. The house has golden molding and golden decorations in the living room, and has nice a large hand de wall fountain. Close to ground transportation, major highways, easy shopping and excellent restaurants. In School District #26

Property Details

  • Single Family

Amenities

  • Building Garden
  • Cooling: Central Air
  • Pets: Building Yes, Yes

The Neighborhood

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

Douglas Manor-Douglaston-Little Neck Guide ›
All Neighborhoods ›

For information on 244-19 Grand Central Parkway, # contact:

realtor top real estate agent

Martin Olsen

Licensed RE Salesperson

(718) 809-1099

Licensed RE Salesperson
martin@brickandmortar.com
(718) 809-1099

Listing courtesy of Laffey Real Estate NYC 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.