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 #7656699
MLS #992689
Listing photo

SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey

166-35 9th Ave 6A, Beechhurst, NY 11357
$469,888
2Beds
1Baths
1,144Sqft
--Acres

About this property

SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey and beautifully renovated throughout, this 2-bedroom, 1-bath home offers effortless move-in living plus a private, due-west terrace-perfect for sunsets, morning coffee, or dining al fresco. Inside, the layout opens to an expansive living and dining area with wide-plank style flooring, recessed lighting, and oversized windows that bring in terrific natural light. The brand-new, modern kitchen is finished with custom shaker cabinetry, quartz countertops, and stainless steel appliances, including a built-in microwave and dishwasher-clean lines, smart storage, and a polished, designer look. The spa-like bathroom features a contemporary double vanity and striking wall tile for a crisp, high-end finish. Both bedrooms are well-proportioned, and the home is vacant and waiting for your personal touches. Conveniently, there is a washer/dryer on every floor. Enjoy the exceptional lifestyle at Le Havre, featuring 2 outdoor pools, 3 tennis courts, a fitness center, clubhouse/restaurant, playgrounds, and a park-like setting that makes everyday feel like a retreat.

Property Features

2 Beds
1 Baths
1,144 Sqft
Built in 1953
0.000 Acres
1 Story
On Beachfront
Off Street, Assigned, On Street, Parking Lot
Oil, Radiant
Queens County
Le Havre On The Water Community

Additional Photos

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

Contact Information

Robert J. Gellert SRES

Shares of New York Marketing LLC

914-215-4307

Location

Map
Listing Agent: Robert J. Gellert SRES 914-215-4307
Broker: Shares of New York Marketing LLC 914-721-3355 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

SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 1
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 2
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 3
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 4
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 5
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 6
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 7
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 8
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 9
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 10
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 11
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 12
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 13
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 14
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 15
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 16
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 17
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 18
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 19
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 20
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 21
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 22
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 23
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 24
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 25
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 26
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 27
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 28

$469,888

2
Beds
1
Baths
1,144
Sqft

166-35 9th Ave 6A, Beechhurst, NY 11357

By contacting this agent you agree to these Terms and Conditions.
Home New York Beechhurst
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 1
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 2
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 3
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 4
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey - photo 5
MLS# 992689
Home Sale Pending

SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey

$469,888

166-35 9th Ave 6A, Beechhurst, NY 11357

2
Beds
1
Baths
1,144
Sqft
--
Acres
$469,888
166-35 9th Ave 6A, Beechhurst, NY 11357
2 Beds
1 Baths
1,144 Sqft
-- Acres
SPONSOR APARTMENT - NO BOARD APPROVAL. Just completed, turnkey and beautifully renovated throughout, this 2-bedroom, 1-bath home offers effortless move-in living plus a private, due-west terrace-perfect for sunsets, morning coffee, or dining al fresco. Inside, the layout opens to an expansive living and dining area with wide-plank style flooring, recessed lighting, and oversized windows that bring in terrific natural light. The brand-new, modern kitchen is finished with custom shaker cabinetry, quartz countertops, and stainless steel appliances, including a built-in microwave and dishwasher-clean lines, smart storage, and a polished, designer look. The spa-like bathroom features a contemporary double vanity and striking wall tile for a crisp, high-end finish. Both bedrooms are well-proportioned, and the home is vacant and waiting for your personal touches. Conveniently, there is a washer/dryer on every floor. Enjoy the exceptional lifestyle at Le Havre, featuring 2 outdoor pools, 3 tennis courts, a fitness center, clubhouse/restaurant, playgrounds, and a park-like setting that makes everyday feel like a retreat.
102 days
on BeachHouse.com
0
view
0
saves

Property Details

HOME DETAILS

2 Beds
1 Baths
1,144 Sqft
Built in 1953
0.000 Acres
1 Story

BEACH & VIEW

On Beachfront

EXTERIOR

Off Street, Assigned, On Street, Parking Lot

INTERIOR

Oil, Radiant

FINANCIAL & COMMUNITY

Queens County
Le Havre On The Water Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7656699
Viewed
0 time
Listing Status
Pending
Added
May 01, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
OneKey MLS
Source Property ID
992689
Listing Agent: Robert J. Gellert SRES 914-215-4307
Broker: Shares of New York Marketing LLC 914-721-3355 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
Seller to offer credit at closing for closing costs. Garage - photo 1
Seller to offer credit at closing for closing costs. Garage - photo 2
Seller to offer credit at closing for closing costs. Garage - photo 3
Seller to offer credit at closing for closing costs. Garage - photo 4
Seller to offer credit at closing for closing costs. Garage - photo 5
Seller to offer credit at closing for closing costs. Garage - photo 6
Seller to offer credit at closing for closing costs. Garage - photo 7
Seller to offer credit at closing for closing costs. Garage - photo 8
Seller to offer credit at closing for closing costs. Garage - photo 9
Seller to offer credit at closing for closing costs. Garage - photo 10
Seller to offer credit at closing for closing costs. Garage - photo 11
Seller to offer credit at closing for closing costs. Garage - photo 12
Seller to offer credit at closing for closing costs. Garage - photo 13
Seller to offer credit at closing for closing costs. Garage - photo 14
Seller to offer credit at closing for closing costs. Garage - photo 15
Seller to offer credit at closing for closing costs. Garage - photo 16
Seller to offer credit at closing for closing costs. Garage - photo 17
Seller to offer credit at closing for closing costs. Garage - photo 18
Seller to offer credit at closing for closing costs. Garage - photo 19
Seller to offer credit at closing for closing costs. Garage - photo 20
Seller to offer credit at closing for closing costs. Garage - photo 21
Seller to offer credit at closing for closing costs. Garage - photo 22

$550,000

2 Beds | 2.0 Baths | 1,600 Sqft

166-25 Powells Cove Blvd 18G, Beechhurst, NY 11357

Seller to offer credit at closing for closing costs. Garage

Added: 12/17/2025 • Updated: 07/07/2026
For Sale
Experience unparalleled waterfront living in this stunning - photo 1
Experience unparalleled waterfront living in this stunning - photo 2
Experience unparalleled waterfront living in this stunning - photo 3
Experience unparalleled waterfront living in this stunning - photo 4
Experience unparalleled waterfront living in this stunning - photo 5
Experience unparalleled waterfront living in this stunning - photo 6
Experience unparalleled waterfront living in this stunning - photo 7
Experience unparalleled waterfront living in this stunning - photo 8
Experience unparalleled waterfront living in this stunning - photo 9
Experience unparalleled waterfront living in this stunning - photo 10
Experience unparalleled waterfront living in this stunning - photo 11
Experience unparalleled waterfront living in this stunning - photo 12
Experience unparalleled waterfront living in this stunning - photo 13
Experience unparalleled waterfront living in this stunning - photo 14
Experience unparalleled waterfront living in this stunning - photo 15
Experience unparalleled waterfront living in this stunning - photo 16
Experience unparalleled waterfront living in this stunning - photo 17
Experience unparalleled waterfront living in this stunning - photo 18
Experience unparalleled waterfront living in this stunning - photo 19
Experience unparalleled waterfront living in this stunning - photo 20
Experience unparalleled waterfront living in this stunning - photo 21
Experience unparalleled waterfront living in this stunning - photo 22
Experience unparalleled waterfront living in this stunning - photo 23
Experience unparalleled waterfront living in this stunning - photo 24
Experience unparalleled waterfront living in this stunning - photo 25
Experience unparalleled waterfront living in this stunning - photo 26
Experience unparalleled waterfront living in this stunning - photo 27
Experience unparalleled waterfront living in this stunning - photo 28
Experience unparalleled waterfront living in this stunning - photo 29
Experience unparalleled waterfront living in this stunning - photo 30

$475,000

2 Beds | 1.0 Baths | 1,014 Sqft

9-15 166th St 3B, Beechhurst, NY 11357

Experience unparalleled waterfront living in this stunning

Added: 06/18/2026 • Updated: 07/09/2026
For Sale
Feel like you are on vacation every day! Live the resort life at - photo 1
Feel like you are on vacation every day! Live the resort life at - photo 2
Feel like you are on vacation every day! Live the resort life at - photo 3
Feel like you are on vacation every day! Live the resort life at - photo 4
Feel like you are on vacation every day! Live the resort life at - photo 5
Feel like you are on vacation every day! Live the resort life at - photo 6
Feel like you are on vacation every day! Live the resort life at - photo 7
Feel like you are on vacation every day! Live the resort life at - photo 8
Feel like you are on vacation every day! Live the resort life at - photo 9
Feel like you are on vacation every day! Live the resort life at - photo 10
Feel like you are on vacation every day! Live the resort life at - photo 11
Feel like you are on vacation every day! Live the resort life at - photo 12
Feel like you are on vacation every day! Live the resort life at - photo 13
Feel like you are on vacation every day! Live the resort life at - photo 14
Feel like you are on vacation every day! Live the resort life at - photo 15
Feel like you are on vacation every day! Live the resort life at - photo 16
Feel like you are on vacation every day! Live the resort life at - photo 17
Feel like you are on vacation every day! Live the resort life at - photo 18
Feel like you are on vacation every day! Live the resort life at - photo 19
Feel like you are on vacation every day! Live the resort life at - photo 20
Feel like you are on vacation every day! Live the resort life at - photo 21

$425,000

3 Beds | 1.0 Baths | 1,144 Sqft

10-10 166 St 3A, Beechhurst, NY 11357

Feel like you are on vacation every day! Live the resort life at

Added: 07/09/2026 • Updated: 07/09/2026
For Sale
Welcome to Le Havre On the Water, an elite, highly coveted - photo 1
Welcome to Le Havre On the Water, an elite, highly coveted - photo 2
Welcome to Le Havre On the Water, an elite, highly coveted - photo 3
Welcome to Le Havre On the Water, an elite, highly coveted - photo 4
Welcome to Le Havre On the Water, an elite, highly coveted - photo 5
Welcome to Le Havre On the Water, an elite, highly coveted - photo 6
Welcome to Le Havre On the Water, an elite, highly coveted - photo 7
Welcome to Le Havre On the Water, an elite, highly coveted - photo 8
Welcome to Le Havre On the Water, an elite, highly coveted - photo 9
Welcome to Le Havre On the Water, an elite, highly coveted - photo 10
Welcome to Le Havre On the Water, an elite, highly coveted - photo 11
Welcome to Le Havre On the Water, an elite, highly coveted - photo 12
Welcome to Le Havre On the Water, an elite, highly coveted - photo 13
Welcome to Le Havre On the Water, an elite, highly coveted - photo 14
Welcome to Le Havre On the Water, an elite, highly coveted - photo 15
Welcome to Le Havre On the Water, an elite, highly coveted - photo 16
Welcome to Le Havre On the Water, an elite, highly coveted - photo 17
Welcome to Le Havre On the Water, an elite, highly coveted - photo 18
Welcome to Le Havre On the Water, an elite, highly coveted - photo 19
Welcome to Le Havre On the Water, an elite, highly coveted - photo 20

$419,000

3 Beds | 1.0 Baths | 1,144 Sqft

7-25 166 St 6A, Beechhurst, NY 11357

Welcome to Le Havre On the Water, an elite, highly coveted

Added: 06/05/2026 • Updated: 07/09/2026
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

Beechhurst

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

Beechhurst Real Estate Agent Info

About Beechhurst

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