Richard Heubish

230 Gristmill Lane , Great Neck, NY 11023

Rented: $25,000
Rented on: Nov 9th, 2026
$ Per Square Foot: $10
Rented: $25,000
Rented on: Nov 9th, 2026
$ Per Square Foot: $10
BEDS4 BATHS4 full 1 partial SQUARE FEET2,483 MLS#1070041
STATUSClosed PROPERTY TYPERental - Single Family SCHOOLGreat Neck


Property Description

Location! Location! Location! Imagine not only being able to wake up to these remarkable views, but to be surrounded by water front views through out the entire house! This beautifully renovated waterfront luxury home features features 4 bedrooms, 4.5 bathrooms, formal living room, dining room, and a oversized eat in kitchen with new stainless steel appliances. The Full finished basement is perfect for entertaining, a home office, toy room, or extra living space. The beautifully landscaped back yard is an excellent extension of the home, with views of the Manhattan bridge this will be the focal point of all of your gatherings and outdoor events. The house is located in the prestigious Village of Saddle Rock which gives you access community Pool, tennis courts, and playground park. Zoned for Saddle Rock Elementary School and North school zone.

Property Features

Basement: Yes
Basement: Full
Cooling: Central Air
Days on Market: 6
Garage: 2
Heating: Forced Air
Year Built: 1955

Amenities

First Floor Bedroom
First Floor Full Bath
Beamed Ceilings
Breakfast Bar
Ceiling Fan(s)
Chefs Kitchen
Double Vanity
Eat-in Kitchen
Entrance Foyer
Formal Dining
Galley Type Kitchen
High Ceilings
Open Kitchen
Primary Bathroom
Quartz/Quartzite Counters
Smart Thermostat
Sound System
Storage
Walk-In Closet(s)
Washer/Dryer Hookup

Feature Descriptions

Appliances: Convection Oven, Cooktop, Dishwasher, Dryer, Electric Cooktop, Electric Oven, Electric Range, Electric Water Heater, Refrigerator, Stainless Steel Appliance(s)
Attic: Crawl
Exterior: Brick
Formal Dining: Yes
GarageY/N: Yes
On Market Date: 2026-11-03
Parking Features: Driveway
Parking Total: 6
Permit Required Y/N: No
Pets Allowed: Cats OK, Dogs OK
Rental Term: Monthly
Rooms Total: 8
Sewer: Public Sewer
Utilities: Electricity Available
Water: Public
Waterfront Features: Ocean Front, Sound, Waterfront

Local Schools

High School: Great Neck North High School
Middle School: Great Neck North Middle School
Elementary School: Saddle Rock School
School District: Great Neck

Listed By / Sold By

Listed By

Agency Name: Pomp Realty Advisors Inc
Agency Phone: 917-727-3037

Shown By

Agent Name: Richard Heubish
Agent Phone: (347) 613-4509
Agency Title: Laffey Real Estate

Sold By

Agency Name: Daniel Gale Sothebys Intl Rlty
Agency Phone: 516-626-7600
Agent Name: Orit Ofir

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 11/11/2026. The listing information on this page last changed on 11/11/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Wed 11/11/2026 12:42:52 AM EST) or OneKey MLS (last updated Wed 11/11/2026 12:35:22 AM EST). Real estate listings held by brokerage firms other than Laffey Real Estate may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

Listing data and photos distributed by MLSGRID
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
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register