$249,000
About this home
The Clearwater vacational rental income condo is waiting for a new owner. It's an end unit overlooking Mandalay Avenue. Walk directly across the street to the baech and famouse beachfront restaurants: The Palm Pavilion, Frenchy Rockaway Grill and many more. Royal Camelot is located on Mandalay Avenue which is the main street of Clerwater Beach. The studio offers a queen size bed and a folding sofa where total of four guests can sleep. You and your guests will love the sugar soft sandy beach of the Gulf of Mexico and beautiful sunsets. Royal Camelot allows short retlals and this unit has a great rental history. This is a studio with low HOA fee of 551 dollas a month. There is a on-site office to handle your booking and making sure your guests are comfortable. Make an appointmment today to see your income producing beach home!
Property details
- MLS #
- MFRTB8461480
- Property type
- Condo - Hotel
- Subdivision
- ROYAL CAMELOT RESORT CONDO
- Status
- Active
- Days on market
- 139
- On market date
- January 6, 2026
- Stories
- N/A
- Total bathrooms
- 1
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- 0.2 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card (e.g. NC Dept. of Public Instruction, SC Report Card).
- Enrollment
- 324
- Student:teacher ratio
- 10.5:1
- District
- PINELLAS
- Enrollment
- 1,022
- Student:teacher ratio
- 19.7:1
- District
- PINELLAS
- Enrollment
- 1,196
- Student:teacher ratio
- 20.3:1
- District
- PINELLAS
Walkability
Blended score for CLEARWATER's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in CLEARWATER, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Stellar MLS (mfrmls) via Trestle/CoreLogic. Last updated May 25, 2026.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.