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
496 days
|
5,645
|
272
|
Zillow last checked:
Listing updated:
Listed by:
RE/MAX Elite718-500-3077,
Naruetai Tongsomboon718-500-3077
Source: OneKey® MLS as distributed by MLS GRID,MLS#: 838575
Facts & features
Interior
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 1
Full bathrooms: 1
Other
Description: Main deck -Kitchen & Living room, Full bath, Entertainment area
Property subtype: Single Family Residence, Residential
Materials
Other
Foundation: Other
Condition
Year built: 1980
Utilities & green energy
Sewer: Other
Water: Public
Utilities for property: Trash Collection Public
Community & HOA
HOA
Has HOA: No
Location
Region: Arverne
Financial & listing details
Price per square foot: $134/sqft
Date on market: 3/21/2025
Cumulative days on market: 433 days
Listing agreement: Exclusive Right To Sell
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
3/26/2026
Price change
$215,000-4.4%$134/sqft
Source: OneKey® MLS as distributed by MLS GRID #838575Report a problem
9/8/2025
Price change
$225,000-25%$141/sqft
Source: OneKey® MLS as distributed by MLS GRID #838575Report a problem
6/5/2025
Price change
$300,000-6.3%$188/sqft
Source: OneKey® MLS as distributed by MLS GRID #838575Report a problem
4/17/2025
Price change
$320,000+6.7%$200/sqft
Source: OneKey® MLS as distributed by MLS GRID #838575Report a problem
3/22/2025
Listed for sale
$300,000$188/sqft
Source: OneKey® MLS as distributed by MLS GRID #838575Report a problem
Public tax history
Tax history is unavailable.
Monthly payment
Estimated monthly payment$1,822
Principal & interest
$1,547
Mortgage insurance
$0
Property taxes
$170
Home insurance
$105
HOA fees
$0
Utilities
Not included
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: OneKey® MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.