Emilia "Mia" Pizzo
BEDS6
BATHS4 full 1 partial
SQUARE FEET8,126
MLS#970809
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLGreat Neck
Property Description
Set on a prime waterfront property in the prestigious Village of Kings Point, this exceptional contemporary residence offers a rare blend of privacy, scale, and breathtaking surroundings. Designed for both grand entertaining and comfortable living, the home features expansive living areas filled with natural light and a gourmet eat-in kitchen tailored for the most discerning chef. With six spacious bedrooms and 4.5 baths, the residence provides ample space for easy living and guests alike. Outdoors, a magnificent flat property unfolds to a serene waterfront backdrop, highlighted by a beautifully designed in-ground swimming pool-creating a resort-like setting perfect for entertaining or simply enjoying tranquil everyday living. A rare opportunity to own a remarkable waterfront estate in one of Kings Point's most coveted locations.
Property Features
Property Type: Residential - Single Family
Basement: Yes
Basement: Full
Cooling: Central Air
Fireplaces: 1
Garage: 3
Heating: Forced Air
Home Style: Contemporary
Lot Size: 1.60 Acres
Taxes: $161,560
Year Built: 1971
Amenities
Eat-in Kitchen
Entrance Foyer
Formal Dining
Pantry
Primary Bathroom
Storage
Feature Descriptions
Appliances: Cooktop, Dishwasher, Dryer, Oven, Range, Refrigerator, Washer
Attic: Partial
Days on Site: 1
Exterior: Frame
Fireplace Y/N: Yes
Formal Dining: Yes
GarageY/N: Yes
Number Of Kitchens: 1
On Market Date: 2026-03-23
Parcel Number: 2217-01-173-00-0013-0
Parking Features: Attached
Pool Features: In Ground
Rental Term: Monthly
Rooms Total: 12
Sewer: Cesspool
Special View Info: Water
Swimming Pool: Yes
Utilities: Electricity Connected, Natural Gas Connected, Water Connected
Water: Public
Waterfront Features: Waterfront
Local Schools
High School: Great Neck North High School
Middle School: Great Neck North Middle School
Elementary School: John F Kennedy School
School District: Great Neck
Listed By / Shown By
Listing By
Agency Name: S Sharf Realty Inc
Agency Contact: 516-773-6677
Shown By
Agent Name: Emilia "Mia" Pizzo
Agent Phone: Cell: (516) 984-3190
Agency Title: Howard Hanna | Coach Realtors
Estimate Your Payment
Estimated Payment
$ 68,498.21 per month $51,534.88 Principal & Interest $13,463.33 Property Tax $3,500.00 Homeowner's InsuranceChange Payment Information
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX 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, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the 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.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agency License Information: https://www.coachrealtors.com New York State Real Estate Broker Principal Office License Number: 10991237973
150 W Shore Road | MLS# 970809
This single family home located at 150 W Shore Road, Great Neck, NY 11024 is currently listed for sale with an asking price of $12,000,000. This property was built in 1971 and has 6 bedrooms and 4 full and 1 partial baths with 8126 sq. ft. W Shore Road is located within the Great Neck school district. Search Great Neck real estate on www.miapizzo.com today.