Buy
  • Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (747)
    Mexico Listings (332)
    Central America Listings (625)
    Caribbean Islands Listings (45)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7692724
MLS #1017811
Listing photo

Bright and spacious Colonial, impeccably maintained and

42 North Rd, Great Neck, New York, 11024
$2,560,000
4Beds
3Baths
2,558Sqft
0.140Acres

About this property

Bright and spacious Colonial, impeccably maintained and thoughtfully designed for comfortable living and entertaining. The main level features an elegant formal living room and dining room, complemented by a welcoming family room with vaulted ceilings, skylights, and a cozy fireplace that fills the space with natural light and warmth. The beautifully appointed eat-in kitchen is equipped with top-of-the-line appliances and offers both functionality and style. The home features 4 generously sized bedrooms and 2.5 bathrooms. The full finished basement provides exceptional additional living space, including 2 bedrooms, full bathroom, abundant storage, and endless possibilities for recreation, guests, or a home office. Set on a beautifully flat 6,200-square-foot property, this home enjoys a prime location in the heart of Great Neck, just moments from shopping, dining, houses of worship, and the LIRR, offering both convenience and an exceptional lifestyle.

Property Features

4 Beds
3 Baths
2,558 Sqft
Built in 1986
0.140 Acres
Siding: Frame
Has Fireplace
Natural Gas
$20,067 / yr property tax
Nassau County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Kathleen Yekotiel

S Sharf Realty, Inc.

516-640-1017

Location

Map
Listing Agent: Kathleen Yekotiel 516-640-1017
Broker: S Sharf Realty, Inc. 516-773-6677 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Jul 16, 2026

Photo Gallery

Bright and spacious Colonial, impeccably maintained and - photo 1
Bright and spacious Colonial, impeccably maintained and - photo 2
Bright and spacious Colonial, impeccably maintained and - photo 3
Bright and spacious Colonial, impeccably maintained and - photo 4
Bright and spacious Colonial, impeccably maintained and - photo 5
Bright and spacious Colonial, impeccably maintained and - photo 6
Bright and spacious Colonial, impeccably maintained and - photo 7
Bright and spacious Colonial, impeccably maintained and - photo 8
Bright and spacious Colonial, impeccably maintained and - photo 9
Bright and spacious Colonial, impeccably maintained and - photo 10
Bright and spacious Colonial, impeccably maintained and - photo 11
Bright and spacious Colonial, impeccably maintained and - photo 12
Bright and spacious Colonial, impeccably maintained and - photo 13
Bright and spacious Colonial, impeccably maintained and - photo 14
Bright and spacious Colonial, impeccably maintained and - photo 15
Bright and spacious Colonial, impeccably maintained and - photo 16
Bright and spacious Colonial, impeccably maintained and - photo 17
Bright and spacious Colonial, impeccably maintained and - photo 18
Bright and spacious Colonial, impeccably maintained and - photo 19
Bright and spacious Colonial, impeccably maintained and - photo 20
Bright and spacious Colonial, impeccably maintained and - photo 21
Bright and spacious Colonial, impeccably maintained and - photo 22
Bright and spacious Colonial, impeccably maintained and - photo 23
Bright and spacious Colonial, impeccably maintained and - photo 24
Bright and spacious Colonial, impeccably maintained and - photo 25
Bright and spacious Colonial, impeccably maintained and - photo 26
Bright and spacious Colonial, impeccably maintained and - photo 27
Bright and spacious Colonial, impeccably maintained and - photo 28
Bright and spacious Colonial, impeccably maintained and - photo 29
Bright and spacious Colonial, impeccably maintained and - photo 30
Bright and spacious Colonial, impeccably maintained and - photo 31
Bright and spacious Colonial, impeccably maintained and - photo 32
Bright and spacious Colonial, impeccably maintained and - photo 33
Bright and spacious Colonial, impeccably maintained and - photo 34
Bright and spacious Colonial, impeccably maintained and - photo 35
Bright and spacious Colonial, impeccably maintained and - photo 36
Bright and spacious Colonial, impeccably maintained and - photo 37
Bright and spacious Colonial, impeccably maintained and - photo 38
Bright and spacious Colonial, impeccably maintained and - photo 39
Bright and spacious Colonial, impeccably maintained and - photo 40
Bright and spacious Colonial, impeccably maintained and - photo 41
Bright and spacious Colonial, impeccably maintained and - photo 42

$2,560,000

4
Beds
3
Baths
2,558
Sqft

42 North Rd, Great Neck, New York, 11024

By contacting this agent you agree to these Terms and Conditions.
Home New York Great Neck
Bright and spacious Colonial, impeccably maintained and - photo 1
Bright and spacious Colonial, impeccably maintained and - photo 2
Bright and spacious Colonial, impeccably maintained and - photo 3
Bright and spacious Colonial, impeccably maintained and - photo 4
Bright and spacious Colonial, impeccably maintained and - photo 5
MLS# 1017811
Home For Sale

Bright and spacious Colonial, impeccably maintained and

$2,560,000

42 North Rd, Great Neck, New York, 11024

4
Beds
3
Baths
2,558
Sqft
0.140
Acres
$2,560,000
42 North Rd, Great Neck, New York, 11024
4 Beds
3 Baths
2,558 Sqft
0.140 Acres
Bright and spacious Colonial, impeccably maintained and thoughtfully designed for comfortable living and entertaining. The main level features an elegant formal living room and dining room, complemented by a welcoming family room with vaulted ceilings, skylights, and a cozy fireplace that fills the space with natural light and warmth. The beautifully appointed eat-in kitchen is equipped with top-of-the-line appliances and offers both functionality and style. The home features 4 generously sized bedrooms and 2.5 bathrooms. The full finished basement provides exceptional additional living space, including 2 bedrooms, full bathroom, abundant storage, and endless possibilities for recreation, guests, or a home office. Set on a beautifully flat 6,200-square-foot property, this home enjoys a prime location in the heart of Great Neck, just moments from shopping, dining, houses of worship, and the LIRR, offering both convenience and an exceptional lifestyle.
5 days
on BeachHouse.com
14
views
0
saves

Property Details

HOME DETAILS

4 Beds
3 Baths
2,558 Sqft
Built in 1986
0.140 Acres

EXTERIOR

Siding: Frame

INTERIOR

Has Fireplace
Natural Gas

FINANCIAL & COMMUNITY

$20,067 / yr property tax
Nassau County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7692724
Viewed
14 times
Listing Status
Active
Added
Jul 10, 2026
Last Refresh
Jul 16, 2026 08:47:24 AM

Listing Information

Data Source
OneKey MLS
Source Property ID
1017811
Listing Agent: Kathleen Yekotiel 516-640-1017
Broker: S Sharf Realty, Inc. 516-773-6677 Listing Site
Copyright © 2026 OneKey MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Prime Development Opportunity! Opportunity to renovate or build - photo 1
Prime Development Opportunity! Opportunity to renovate or build - photo 2
Prime Development Opportunity! Opportunity to renovate or build - photo 3
Prime Development Opportunity! Opportunity to renovate or build - photo 4
Prime Development Opportunity! Opportunity to renovate or build - photo 5
Prime Development Opportunity! Opportunity to renovate or build - photo 6
Prime Development Opportunity! Opportunity to renovate or build - photo 7
Prime Development Opportunity! Opportunity to renovate or build - photo 8
Prime Development Opportunity! Opportunity to renovate or build - photo 9
Prime Development Opportunity! Opportunity to renovate or build - photo 10
Prime Development Opportunity! Opportunity to renovate or build - photo 11
Prime Development Opportunity! Opportunity to renovate or build - photo 12
Prime Development Opportunity! Opportunity to renovate or build - photo 13
Prime Development Opportunity! Opportunity to renovate or build - photo 14
Prime Development Opportunity! Opportunity to renovate or build - photo 15
Prime Development Opportunity! Opportunity to renovate or build - photo 16
Prime Development Opportunity! Opportunity to renovate or build - photo 17

$2,980,000

5 Beds | 4.0 Baths | 4,346 Sqft

355 E Shore Rd, Great Neck, NY, 11023

Prime Development Opportunity! Opportunity to renovate or build

Added: 06/28/2026 • Updated: 06/28/2026
For Sale
Opportunity to build new construction on a 57,750 sq ft (1 - photo 1
Opportunity to build new construction on a 57,750 sq ft (1 - photo 2
Opportunity to build new construction on a 57,750 sq ft (1 - photo 3
Opportunity to build new construction on a 57,750 sq ft (1 - photo 4
Opportunity to build new construction on a 57,750 sq ft (1 - photo 5
Opportunity to build new construction on a 57,750 sq ft (1 - photo 6
Opportunity to build new construction on a 57,750 sq ft (1 - photo 7
Opportunity to build new construction on a 57,750 sq ft (1 - photo 8
Opportunity to build new construction on a 57,750 sq ft (1 - photo 9
Opportunity to build new construction on a 57,750 sq ft (1 - photo 10
Opportunity to build new construction on a 57,750 sq ft (1 - photo 11
Opportunity to build new construction on a 57,750 sq ft (1 - photo 12
Opportunity to build new construction on a 57,750 sq ft (1 - photo 13
Opportunity to build new construction on a 57,750 sq ft (1 - photo 14

$2,970,000

4 Beds | 2.0 Baths | 2,080 Sqft

107 Wildwood Rd, Great Neck, NY, 11024

Opportunity to build new construction on a 57,750 sq ft (1

Added: 06/24/2026 • Updated: 06/24/2026
For Sale
Welcome to this Harbor Hills gem - a beautifully renovated - photo 1
Welcome to this Harbor Hills gem - a beautifully renovated - photo 2
Welcome to this Harbor Hills gem - a beautifully renovated - photo 3
Welcome to this Harbor Hills gem - a beautifully renovated - photo 4
Welcome to this Harbor Hills gem - a beautifully renovated - photo 5
Welcome to this Harbor Hills gem - a beautifully renovated - photo 6
Welcome to this Harbor Hills gem - a beautifully renovated - photo 7
Welcome to this Harbor Hills gem - a beautifully renovated - photo 8
Welcome to this Harbor Hills gem - a beautifully renovated - photo 9
Welcome to this Harbor Hills gem - a beautifully renovated - photo 10
Welcome to this Harbor Hills gem - a beautifully renovated - photo 11
Welcome to this Harbor Hills gem - a beautifully renovated - photo 12
Welcome to this Harbor Hills gem - a beautifully renovated - photo 13
Welcome to this Harbor Hills gem - a beautifully renovated - photo 14
Welcome to this Harbor Hills gem - a beautifully renovated - photo 15
Welcome to this Harbor Hills gem - a beautifully renovated - photo 16
Welcome to this Harbor Hills gem - a beautifully renovated - photo 17
Welcome to this Harbor Hills gem - a beautifully renovated - photo 18
Welcome to this Harbor Hills gem - a beautifully renovated - photo 19
Welcome to this Harbor Hills gem - a beautifully renovated - photo 20
Welcome to this Harbor Hills gem - a beautifully renovated - photo 21
Welcome to this Harbor Hills gem - a beautifully renovated - photo 22
Welcome to this Harbor Hills gem - a beautifully renovated - photo 23
Welcome to this Harbor Hills gem - a beautifully renovated - photo 24
Welcome to this Harbor Hills gem - a beautifully renovated - photo 25
Welcome to this Harbor Hills gem - a beautifully renovated - photo 26
Welcome to this Harbor Hills gem - a beautifully renovated - photo 27
Welcome to this Harbor Hills gem - a beautifully renovated - photo 28
Welcome to this Harbor Hills gem - a beautifully renovated - photo 29
Welcome to this Harbor Hills gem - a beautifully renovated - photo 30
Welcome to this Harbor Hills gem - a beautifully renovated - photo 31
Welcome to this Harbor Hills gem - a beautifully renovated - photo 32
Welcome to this Harbor Hills gem - a beautifully renovated - photo 33
Welcome to this Harbor Hills gem - a beautifully renovated - photo 34
Welcome to this Harbor Hills gem - a beautifully renovated - photo 35
Welcome to this Harbor Hills gem - a beautifully renovated - photo 36

$2,895,000

4 Beds | 5.0 Baths | 2,894 Sqft

18 Pond Park Rd, Great Neck, NY, 11023

Welcome to this Harbor Hills gem - a beautifully renovated

Added: 06/27/2026 • Updated: 06/27/2026
For Sale
Welcome to this stately and timeless brick Center Hall Colonial - photo 1
Welcome to this stately and timeless brick Center Hall Colonial - photo 2
Welcome to this stately and timeless brick Center Hall Colonial - photo 3
Welcome to this stately and timeless brick Center Hall Colonial - photo 4
Welcome to this stately and timeless brick Center Hall Colonial - photo 5
Welcome to this stately and timeless brick Center Hall Colonial - photo 6
Welcome to this stately and timeless brick Center Hall Colonial - photo 7
Welcome to this stately and timeless brick Center Hall Colonial - photo 8
Welcome to this stately and timeless brick Center Hall Colonial - photo 9
Welcome to this stately and timeless brick Center Hall Colonial - photo 10
Welcome to this stately and timeless brick Center Hall Colonial - photo 11
Welcome to this stately and timeless brick Center Hall Colonial - photo 12
Welcome to this stately and timeless brick Center Hall Colonial - photo 13
Welcome to this stately and timeless brick Center Hall Colonial - photo 14
Welcome to this stately and timeless brick Center Hall Colonial - photo 15
Welcome to this stately and timeless brick Center Hall Colonial - photo 16
Welcome to this stately and timeless brick Center Hall Colonial - photo 17
Welcome to this stately and timeless brick Center Hall Colonial - photo 18
Welcome to this stately and timeless brick Center Hall Colonial - photo 19
Welcome to this stately and timeless brick Center Hall Colonial - photo 20
Welcome to this stately and timeless brick Center Hall Colonial - photo 21
Welcome to this stately and timeless brick Center Hall Colonial - photo 22
Welcome to this stately and timeless brick Center Hall Colonial - photo 23
Welcome to this stately and timeless brick Center Hall Colonial - photo 24
Welcome to this stately and timeless brick Center Hall Colonial - photo 25
Welcome to this stately and timeless brick Center Hall Colonial - photo 26
Welcome to this stately and timeless brick Center Hall Colonial - photo 27
Welcome to this stately and timeless brick Center Hall Colonial - photo 28
Welcome to this stately and timeless brick Center Hall Colonial - photo 29
Welcome to this stately and timeless brick Center Hall Colonial - photo 30
Welcome to this stately and timeless brick Center Hall Colonial - photo 31
Welcome to this stately and timeless brick Center Hall Colonial - photo 32
Welcome to this stately and timeless brick Center Hall Colonial - photo 33
Welcome to this stately and timeless brick Center Hall Colonial - photo 34
Welcome to this stately and timeless brick Center Hall Colonial - photo 35
Welcome to this stately and timeless brick Center Hall Colonial - photo 36
Welcome to this stately and timeless brick Center Hall Colonial - photo 37
Welcome to this stately and timeless brick Center Hall Colonial - photo 38
Welcome to this stately and timeless brick Center Hall Colonial - photo 39
Welcome to this stately and timeless brick Center Hall Colonial - photo 40
Welcome to this stately and timeless brick Center Hall Colonial - photo 41

$2,758,000

5 Beds | 6.0 Baths | 6,200 Sqft

111 Clent Rd, Great Neck, NY, 11021

Welcome to this stately and timeless brick Center Hall Colonial

Added: 05/12/2026 • Updated: 06/17/2026
View more View More
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.16
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

Great Neck

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

Great Neck Real Estate Agent Info

About Great Neck

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska California Colorado Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.16
Terms & Policy