Buy
  • Alabama Alaska California 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 (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    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 #8021281
MLS #998857
Listing photo

A circular driveway leads to this spectacular fully renovated

5 Twin Ponds St, Great Neck, NY 11024
$5,875,000
7Beds
6Baths
6,213Sqft
1Acres

About this property

A circular driveway leads to this spectacular fully renovated Center Hall Colonial, privately situated on a quiet cul-de-sac in the prestigious Village of Kings Point. Surrounded by lushly landscaped gardens and a stunning in-ground swimming pool, this exceptional residence offers the perfect blend of elegance, luxury, and modern living. A grand entry foyer welcomes you into beautifully designed interiors featuring a formal living room with a dual fireplace, banquet-sized formal dining room, spacious den, and an expansive family room ideal for entertaining. The state-of-the-art eat-in kitchen is thoughtfully designed with premium finishes and top-of-the-line appliances, creating the perfect space for everyday living and hosting. This magnificent home offers 7 generously sized bedrooms and 5.5 beautifully appointed bathrooms. The finished lower level includes a large playroom, private office, and abundant storage space. Additional highlights include a generator, surround sound system and an attached 3-car garage. A rare opportunity to own a move-in ready luxury home in one of Kings Point's most prestigious locations.

Property Features

7 Beds
6 Baths
6,213 Sqft
Built in 1979
1 Acres
Siding: Frame
Has Swimming Pool
Has Fireplace
Radiant, Natural Gas
$43,256 / 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

Carole Hakimi

S Sharf Realty, Inc.

516-967-6666

Location

Map
Listing Agent: Carole Hakimi 516-967-6666
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 Aug 11, 2026

Photo Gallery

A circular driveway leads to this spectacular fully renovated - photo 1
A circular driveway leads to this spectacular fully renovated - photo 2
A circular driveway leads to this spectacular fully renovated - photo 3
A circular driveway leads to this spectacular fully renovated - photo 4
A circular driveway leads to this spectacular fully renovated - photo 5
A circular driveway leads to this spectacular fully renovated - photo 6
A circular driveway leads to this spectacular fully renovated - photo 7
A circular driveway leads to this spectacular fully renovated - photo 8
A circular driveway leads to this spectacular fully renovated - photo 9
A circular driveway leads to this spectacular fully renovated - photo 10
A circular driveway leads to this spectacular fully renovated - photo 11
A circular driveway leads to this spectacular fully renovated - photo 12
A circular driveway leads to this spectacular fully renovated - photo 13
A circular driveway leads to this spectacular fully renovated - photo 14
A circular driveway leads to this spectacular fully renovated - photo 15
A circular driveway leads to this spectacular fully renovated - photo 16
A circular driveway leads to this spectacular fully renovated - photo 17
A circular driveway leads to this spectacular fully renovated - photo 18
A circular driveway leads to this spectacular fully renovated - photo 19
A circular driveway leads to this spectacular fully renovated - photo 20
A circular driveway leads to this spectacular fully renovated - photo 21
A circular driveway leads to this spectacular fully renovated - photo 22
A circular driveway leads to this spectacular fully renovated - photo 23
A circular driveway leads to this spectacular fully renovated - photo 24
A circular driveway leads to this spectacular fully renovated - photo 25
A circular driveway leads to this spectacular fully renovated - photo 26
A circular driveway leads to this spectacular fully renovated - photo 27
A circular driveway leads to this spectacular fully renovated - photo 28
A circular driveway leads to this spectacular fully renovated - photo 29
A circular driveway leads to this spectacular fully renovated - photo 30
A circular driveway leads to this spectacular fully renovated - photo 31
A circular driveway leads to this spectacular fully renovated - photo 32
A circular driveway leads to this spectacular fully renovated - photo 33
A circular driveway leads to this spectacular fully renovated - photo 34
A circular driveway leads to this spectacular fully renovated - photo 35
A circular driveway leads to this spectacular fully renovated - photo 36
A circular driveway leads to this spectacular fully renovated - photo 37
A circular driveway leads to this spectacular fully renovated - photo 38
A circular driveway leads to this spectacular fully renovated - photo 39
A circular driveway leads to this spectacular fully renovated - photo 40
A circular driveway leads to this spectacular fully renovated - photo 41
A circular driveway leads to this spectacular fully renovated - photo 42
A circular driveway leads to this spectacular fully renovated - photo 43
A circular driveway leads to this spectacular fully renovated - photo 44
A circular driveway leads to this spectacular fully renovated - photo 45
A circular driveway leads to this spectacular fully renovated - photo 46
A circular driveway leads to this spectacular fully renovated - photo 47
A circular driveway leads to this spectacular fully renovated - photo 48
A circular driveway leads to this spectacular fully renovated - photo 49
A circular driveway leads to this spectacular fully renovated - photo 50

$5,875,000

7
Beds
6
Baths
6,213
Sqft

5 Twin Ponds St, Great Neck, NY 11024

By contacting this agent you agree to these Terms and Conditions.
Home New York Great Neck
A circular driveway leads to this spectacular fully renovated - photo 1
A circular driveway leads to this spectacular fully renovated - photo 2
A circular driveway leads to this spectacular fully renovated - photo 3
A circular driveway leads to this spectacular fully renovated - photo 4
A circular driveway leads to this spectacular fully renovated - photo 5
MLS# 998857
Home For Sale

A circular driveway leads to this spectacular fully renovated

$5,875,000

5 Twin Ponds St, Great Neck, NY 11024

7
Beds
6
Baths
6,213
Sqft
1
Acres
$5,875,000
5 Twin Ponds St, Great Neck, NY 11024
7 Beds
6 Baths
6,213 Sqft
1 Acres
A circular driveway leads to this spectacular fully renovated Center Hall Colonial, privately situated on a quiet cul-de-sac in the prestigious Village of Kings Point. Surrounded by lushly landscaped gardens and a stunning in-ground swimming pool, this exceptional residence offers the perfect blend of elegance, luxury, and modern living. A grand entry foyer welcomes you into beautifully designed interiors featuring a formal living room with a dual fireplace, banquet-sized formal dining room, spacious den, and an expansive family room ideal for entertaining. The state-of-the-art eat-in kitchen is thoughtfully designed with premium finishes and top-of-the-line appliances, creating the perfect space for everyday living and hosting. This magnificent home offers 7 generously sized bedrooms and 5.5 beautifully appointed bathrooms. The finished lower level includes a large playroom, private office, and abundant storage space. Additional highlights include a generator, surround sound system and an attached 3-car garage. A rare opportunity to own a move-in ready luxury home in one of Kings Point's most prestigious locations.
35 days
on BeachHouse.com
41
views
0
saves

Property Details

HOME DETAILS

7 Beds
6 Baths
6,213 Sqft
Built in 1979
1 Acres

EXTERIOR

Siding: Frame
Has Swimming Pool

INTERIOR

Has Fireplace
Radiant, Natural Gas

FINANCIAL & COMMUNITY

$43,256 / yr property tax
Nassau County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
8021281
Viewed
41 times
Listing Status
Active
Added
Jul 07, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
OneKey MLS
Source Property ID
998857
Listing Agent: Carole Hakimi 516-967-6666
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
Privately set behind a long driveway in the prestigious Village - photo 1
Privately set behind a long driveway in the prestigious Village - photo 2
Privately set behind a long driveway in the prestigious Village - photo 3
Privately set behind a long driveway in the prestigious Village - photo 4
Privately set behind a long driveway in the prestigious Village - photo 5
Privately set behind a long driveway in the prestigious Village - photo 6
Privately set behind a long driveway in the prestigious Village - photo 7
Privately set behind a long driveway in the prestigious Village - photo 8
Privately set behind a long driveway in the prestigious Village - photo 9
Privately set behind a long driveway in the prestigious Village - photo 10
Privately set behind a long driveway in the prestigious Village - photo 11
Privately set behind a long driveway in the prestigious Village - photo 12
Privately set behind a long driveway in the prestigious Village - photo 13
Privately set behind a long driveway in the prestigious Village - photo 14
Privately set behind a long driveway in the prestigious Village - photo 15
Privately set behind a long driveway in the prestigious Village - photo 16
Privately set behind a long driveway in the prestigious Village - photo 17
Privately set behind a long driveway in the prestigious Village - photo 18
Privately set behind a long driveway in the prestigious Village - photo 19
Privately set behind a long driveway in the prestigious Village - photo 20
Privately set behind a long driveway in the prestigious Village - photo 21
Privately set behind a long driveway in the prestigious Village - photo 22
Privately set behind a long driveway in the prestigious Village - photo 23
Privately set behind a long driveway in the prestigious Village - photo 24
Privately set behind a long driveway in the prestigious Village - photo 25
Privately set behind a long driveway in the prestigious Village - photo 26
Privately set behind a long driveway in the prestigious Village - photo 27
Privately set behind a long driveway in the prestigious Village - photo 28
Privately set behind a long driveway in the prestigious Village - photo 29
Privately set behind a long driveway in the prestigious Village - photo 30
Privately set behind a long driveway in the prestigious Village - photo 31
Privately set behind a long driveway in the prestigious Village - photo 32
Privately set behind a long driveway in the prestigious Village - photo 33
Privately set behind a long driveway in the prestigious Village - photo 34
Privately set behind a long driveway in the prestigious Village - photo 35
Privately set behind a long driveway in the prestigious Village - photo 36
Privately set behind a long driveway in the prestigious Village - photo 37
Privately set behind a long driveway in the prestigious Village - photo 38
Privately set behind a long driveway in the prestigious Village - photo 39
Privately set behind a long driveway in the prestigious Village - photo 40
Privately set behind a long driveway in the prestigious Village - photo 41
Privately set behind a long driveway in the prestigious Village - photo 42
Privately set behind a long driveway in the prestigious Village - photo 43

$4,790,000

7 Beds | 7.0 Baths | 6,900 Sqft

369 E Shore Rd, Great Neck, NY 11023

Privately set behind a long driveway in the prestigious Village

Added: 05/20/2026 • Updated: 07/09/2026
Sale Pending
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 1
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 2
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 3
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 4
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 5
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 6
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 7
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 8
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 9
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 10
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 11
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 12
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 13
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 14
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 15
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 16
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 17
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 18
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 19
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 20
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 21
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 22
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 23
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 24
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 25
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 26
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 27
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 28
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 29
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 30
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 31
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 32
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 33
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 34
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 35
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 36
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 37
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 38
Welcome to an exquisite custom-built masterpiece nestled at 48 - photo 39

$4,800,000

6 Beds | 7.0 Baths | 6,938 Sqft

48 Nassau Dr, Great Neck, NY 11021

Welcome to an exquisite custom-built masterpiece nestled at 48

Added: 06/15/2026 • Updated: 07/09/2026
View More in Great Neck View More in Great Neck
SEARCH STATES
Alabama Alaska California 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.08.11
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
  • 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 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.08.11
Terms & Policy