#866828, Listing office: LAFFEY REAL ESTATE
$6,200,000 List price
9 Stream Ct Great Neck, NY 11024
6 beds
5 full, 1 partial
5,500 sqft
$1,127 / sqft
House
Property details
About 9 Stream Ct
Welcome to this one-of-a-kind Kings Point Center Hall Colonial, fully renovated and set on 1.4 acres of beautifully manicured property in the prestigious Great Neck School District. This expansive home features 6 bedrooms and 6 full bathrooms, blending classic design with modern luxury. Enjoy a spacious, gourmet eat-in kitchen, elegant living and dining areas, and a fully finished basement offering versatile space for entertainment, a gym, or guest quarters. Every room showcases high-end finishes and impeccable craftsmanship. Step outside to your private oasis—featuring a heated in-ground pool, expansive deck, charming gazebo, and a serene private fish pond. Perfect for entertaining or peaceful outdoor living. This rare gem combines space, sophistication, and an unbeatable location—don’t miss it!
Highlights
Home typeSingle Family Residence
HeatingHot Water, Natural Gas
StatusActive
CoolingCentral Air
Size5,500 sqft
BasementYes
Year built2000
ParkingAttached, Driveway, Private
MLS #872727
Garage2 spaces
WaterfrontPond
Private poolYes
Virtual tour
Summary
- Partial Bathrooms: 1
- Full Bathrooms: 5
- Appliances: Dishwasher, Dryer, Refrigerator, Washer, Gas Water Heater
- Basement: Yes
- Flooring Type: Hardwood
- Interior: First Floor Bedroom, First Floor Full Bath, Cathedral Ceiling(s), Eat-in Kitchen, Entrance Foyer, Formal Dining, Granite Counters, High Ceilings, Marble Counters, Open Kitchen, Pantry
- Total Bedroom Count: 6
- Garage Space: 2 spaces
- Private Pool: Yes
- Parking: Attached, Driveway, Private
- Waterfront: Pond
- Exterior: Basketball Court, Garden, Gas Grill, Patio
- Architectural Style: Colonial
- Heating: Hot Water, Natural Gas
- Cooling: Central Air
- List Price: $6,200,000
- Price/SqFt: $1,127
- Annual Tax Amount: $8,808
- Tax Year: 2024
- Lot: Sprinklers In Front, Sprinklers In Rear
- Directions: Long Island Expressway 33N Right On Lakeville Road, N On Middle Neck Road, Left On Great Neck Rd, Right On Bayview Right On Beach Ln, Left On Stream Court.
- Year Built: 2000
- Living Area: 5,500 SqFt
- MLS Number: 872727
- MLS Name: ONEKEY2
- Office Name: LAFFEY REAL ESTATE
- Office Phone: (516) 482-1111
Listings courtesy of OneKey MLS as distributed by MLS GRID.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
DMCA Notice
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
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.
Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 7/30/2025, 7:41:28 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
| Date | Event | Price |
|---|---|---|
| Dec 01, 2015 | Home Sold | $5,200,000 |
| Jun 06, 2008 | Home Sold | $3,275,000 |
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2024 | $3,327 | $8,808 |
| 2023 | $3,327 | $48,026 |
| 2022 | $3,327 | $47,770 |
| 2021 | $3,505 | $52,064 |
| 2020 | $3,505 | $47,940 |
| 2019 | $4,989 | $44,918 |
| 2018 | $4,989 | $43,000 |
| 2017 | $4,989 | $40,884 |
History based on county public records data.
Nearby schools
8
Saddle Rock Elementary School
Public District KG-5
0.6 mi
•10 Hawthorne Ln
8
John F. Kennedy Elementary School
Public District PK-5
1.1 mi
•1A Grassfield Rd
8
Elizabeth M. Baker Elementary School
Public District KG-5
1.1 mi
•69 Baker Hill Rd
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $176,351. Residents of Great Neck, NY typically earn $200k+ each year. The most common type of family is married, no kids. The majority of residents in this area have post secondary degree education.
How much money do the neighbors make?
7%
<35k
18%
35k-100k
35%
100k-200k
40%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
What types of families live nearby?
16%
Single, No Kids
2%
Single, with Kids
46%
Married, No Kids
36%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
9%
<11 yrs old
8%
12-17 yrs old
45%
18-34 yrs old
25%
35-64 yrs old
13%
65+ yrs old
What do the neighbors do for fun?
PGA/LPGA
Skiing/snowboarding
Men's Tennis
Where do the neighbors shop?
Chico's
Nordstrom
Bloomingdales
Where do the neighbors go to eat?
Bonefish Grill
California Pizza Kitchen
Qdoba
What do the neighbors drive?
Cadillac
BMW
Lexus
What do the neighbors listen to?
Classical
Talk/Personality
News
All data provided by Home Junction and Claritas
Similar homes for sale
#830368, Listing office: Edna Mashaal Realty LLC
#890672, Listing office: S Sharf Realty Inc
#875373, Listing office: S Sharf Realty Inc
#837729, Listing office: S Sharf Realty Inc
#829103, Listing office: Daniel Gale Sothebys Intl Rlty
#886140, Listing office: LAFFEY REAL ESTATE
#885456, Listing office: Edna Mashaal Realty LLC
#810932, Listing office: Lin Pan Realty Group LLC
#865708, Listing office: S Sharf Realty Inc
Frequently asked questions
About 9 Stream Ct
The listing price of 9 Stream Ct property is $6,200,000.
The property 9 Stream Ct is a house located in Great Neck, New York, 11024.
Active Listing: 9 Stream Ct is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 9 Stream Ct are: Saddle Rock Elementary School (GreatSchools Rating 8/10), John F. Kennedy Elementary School (GreatSchools Rating 8/10), Elizabeth M. Baker Elementary School (GreatSchools Rating 8/10), Richard S. Sherman Great Neck North Middle School (GreatSchools Rating 7/10), Bell Academy (GreatSchools Rating 8/10), Manhasset Middle School (GreatSchools Rating 8/10), John L. Miller Great Neck North High School (GreatSchools Rating 9/10), Manhasset Secondary School (GreatSchools Rating 10/10), Bayside High School (GreatSchools Rating 8/10).
According to the records, the last property tax for 2024 is $8,808 (source: MLS/based on county public records data).
The last sale was on December 1, 2015 for $5,200,000 (source: MLS/tax record).
The property at 9 Stream Ct has 6 bedrooms and 5 full and 1 half bathrooms.
The property 9 Stream Ct is 5,500 SqFt (source: MLS/tax record).
The year of construction for 9 Stream Ct is 2000.
This home is located at 9 Stream Ct in Great Neck, NY and zip code 11023 in the Town of North Hempstead neighborhood. This 5,500 square foot home was built in 2000. Features: 6 bedrooms, 6 bathrooms. It has been listed on Rocket Homes since June 4, 2025 and is currently priced at $6,200,000.
While more than 6 listings in Great Neck, NY in June 2025 were sold above asking price, there were more than 2 listings sold at asking price, and more than 12 were sold below. The number of homes for sale in Great Neck, NY increased by 1.9% between May and June 2025. The median list price of listings available in June 2025 was $1,118,000, while the average time on the real estate market was 47 days.
From Rocket Homes Real Estate and based on county public records data.