$230,000
1 Bed • 1 Bath • 610 Sq. Ft.
199-39 19th Avenue #2143
Whitestone, NY 11357
Listed with Americana Realty Group LLC
$215,000
Est. $1,259/moArverne, NY 11692 · Queens
Know your budget before you tour. Get pre-qualified
Step aboard "Ziggy Stardust," a beautifully crafted and truly unique houseboat that blends artistry, comfort, and breathtaking views. Thoughtfully designed with love and creativity, this one-of-a-kind masterpiece offers panoramic vistas of Marina 59 in Rockaway Beach, making it the perfect retreat for surfers, fishing enthusiasts, and sunset lovers. With four spacious bedrooms, a full bath, and a fully equipped kitchen, this home provides modern comforts, including a bathroom, an outdoor shower for rinsing off after a day by the water, and an expansive upper deck, the perfect spot to enjoy unbeatable bay views and stunning sunsets. Thoughtfully designed with ample storage and an updated heating and cooling system with split units, this houseboat is as functional as it is charming. Located at Marina 59, you'll have easy access to public transportation, the beach, and the iconic Rockaway Boardwalk. For approximately $2,100 per month, the slip fee includes water, internet, electricity, free gated parking, and full access to the marina's year-round facilities. While direct water access to the boat is turned off from mid-December to April 1st, the boat is equipped with a water tank, allowing you to have running water throughout the winter. Whether you're seeking an artistic retreat, a peaceful getaway, or a unique waterfront lifestyle, "Ziggy Stardust" is a true labor of love. The boat can also be moved back into the water. Cash-only transaction
As reported by the listing office; verify enrollment with the district.
Listed with RE/MAX Elite · Naruetai Tongsomboon · Source: OneKey MLS
Information provided by One Key MLS, and is deemed reliable but not guaranteed accurate. Data last updated: Sep 17, 2026, 5:09 PM ET. ©2026 One Key MLS.
Estimate your mortgage payment, including the principal and interest, taxes, insurance, HOA, and Private Mortgage Insurance.
Estimated Monthly Payment
Representative rates
Representative rates only, indicative for comparison. Edit the interest rate for your own quote; your lender’s numbers vary with credit, points, and insurance.
Taxes are estimated; the listing office didn't report an annual tax figure.
Be the first to know when a Queens home hits the market.
Market Insights
Current Listings
New in the last 30 days
4
Sep 2026
Average Price
Active listings
$843,776
Sep 2026
Average Days on Market
Active listings
179 days
Sep 2026
Computed from 47 active OneKey MLS listings in Arverne, NY.
$230,000
1 Bed • 1 Bath • 610 Sq. Ft.
199-39 19th Avenue #2143
Whitestone, NY 11357
Listed with Americana Realty Group LLC
$249,000
1 Bath • 162,750 Sq. Ft.
4601 39th Avenue #311
Sunnyside, NY 11104
Listed with Charles Rutenberg Realty Inc
$225,000
1 Bed • 1 Bath • 850 Sq. Ft.
99-10 60th Avenue #5-F
Corona, NY 11368
Listed with Strictly Realty