D
Seller's Agent in 2025
Drew Frahm
VISTA CAY REALTY COMPANY
(407) 996-4818
55 in this area
58 Total Sales
5024 Shoreway Loop Unit 10106 Orlando, FL 32819
Universal Neighborhood
2
Beds
2
Baths
1,823
Sq Ft
$622/mo
HOA Fee
Highlights
- Water Views
- Heated In Ground Pool
- Open Floorplan
- Fitness Center
- Gated Community
- Community Lake
About This Home
As of August 2025TURNKEY AIRBNB INVESTMENT - CONDO ACROSS FROM EPIC UNIVERSAL and next to the Convention Center!
Fully furnished, move-in ready, and short-term rental approved — this spacious resort condo offers an incredible opportunity for Airbnb, VRBO, or long-term rental income! Situated directly across from Universal's highly anticipated EPIC UNIVERSE theme park, this property is located in one of Orlando’s fastest-growing and most desirable short-term rental zones, with no rental restrictions.
Unbeatable Location for Guests:
Second building next to clubhouse and pool.
Across from Universal’s EPIC UNIVERSE.
2 miles from the Orange County Convention Center (undergoing a $560M expansion).
Minutes to International Drive, Dr. Phillips, SeaWorld (10 min), Orlando International Airport (15 min), and Disney Parks (20 min).
Future SunRail station planned nearby to boost accessibility.
Easy highway access for both tourists and business travelers.
Spacious & Fully Equipped for Guests:
This ground-floor unit offers 1823 sq ft with 2 oversized bedrooms, one additional flex room and 2 full bathrooms. The open-concept living area features a fully equipped kitchen with granite countertops, stainless steel appliances, and durable LVT flooring throughout — ideal for frequent guest turnover. The large layout offers plenty of space for families or groups, a key selling point for short-term renters. The condo features a brand new AC system installed in May 2025, along with LVT flooring and fresh interior painting completed in 2023.
Resort-Style Amenities Guests Love:
3 resort-style pools, 2 bars, game room & private movie theater, state-of-the-art fitness center., full basketball court, playground, BBQ grills & picnic areas.
Scenic 2-mile walking trail around the lake
Gated community with 24-hour security
Investor-Friendly Expenses:
The HOA covers internet, cable, water, and trash — leaving only electric, insurance, property taxes, and HOA dues to handle — making your operating costs predictable and your margins stronger.
Perfect for Airbnb Investors Seeking:
Turnkey, fully furnished rental property.
Resort-style amenities that drive bookings & repeat guests.
High occupancy potential year-round.
Situated just 10 minutes from premier shopping, dining, and entertainment, this fully equipped, income-producing resort property offers an outstanding opportunity for Airbnb, VRBO, or long-term rental investors looking to secure high-demand real estate in one of Orlando’s fastest-growing short-term rental markets—contact us today to schedule your private showing.
Last Agent to Sell the Property
VISTA CAY REALTY COMPANY Brokerage Phone: 407-996-4656 License #3110588 Listed on: 06/12/2025
Property Details
Home Type
- Condominium
Est. Annual Taxes
- $5,730
Year Built
- Built in 2007
HOA Fees
Home Design
- Entry on the 1st floor
- Slab Foundation
- Frame Construction
- Tile Roof
- Block Exterior
Interior Spaces
- 1,823 Sq Ft Home
- 4-Story Property
- Open Floorplan
- Furnished
- Great Room
- Family Room Off Kitchen
- Combination Dining and Living Room
- Water Views
Kitchen
- Walk-In Pantry
- Range
- Microwave
- Dishwasher
- Stone Countertops
- Disposal
Flooring
- Ceramic Tile
- Vinyl
Bedrooms and Bathrooms
- 2 Bedrooms
- Primary Bedroom on Main
- 2 Full Bathrooms
- Bathtub With Separate Shower Stall
Laundry
- Laundry Room
- Dryer
- Washer
Home Security
Parking
- Electric Vehicle Home Charger
- Guest Parking
- Open Parking
- Off-Street Parking
Pool
- Heated In Ground Pool
- Heated Spa
- In Ground Spa
Outdoor Features
- Balcony
- Patio
Schools
- Tangelo Park Elementary School
- Westridge Middle School
- Lake Buena Vista High School
Utilities
- Central Heating and Cooling System
- Underground Utilities
- Electric Water Heater
- Cable TV Available
Additional Features
- Reclaimed Water Irrigation System
- North Facing Home
Listing and Financial Details
- Visit Down Payment Resource Website
- Legal Lot and Block 106 / 10
- Assessor Parcel Number 06-24-29-8887-10-106
Community Details
Overview
- Association fees include cable TV, pool, internet, maintenance structure, ground maintenance, recreational facilities, security, sewer, trash, water
- Andrea Rivera Association, Phone Number (407) 313-4460
- Vista Cay Resort Condos
- Vista Cay/Harbor Square Ph 06 Subdivision
- Community Lake
Amenities
- Clubhouse
- Elevator
Recreation
- Community Basketball Court
- Community Playground
- Fitness Center
- Community Pool
Pet Policy
- Pets up to 25 lbs
- Pet Size Limit
- 2 Pets Allowed
- Breed Restrictions
Security
- Security Service
- Card or Code Access
- Gated Community
- Fire Sprinkler System
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jun 12, 2025
Closed on
Aug 20, 2025
Sold by
Cerqueti Antonio and Cerqueti Laurie Lynne
Bought by
Curtis Michael and Curtis Debra
Seller's Agent
Drew Frahm
VISTA CAY REALTY COMPANY
Buyer's Agent
Pippa Murray
SIGNATURE COLLECTION REALTY IN
List Price
$589,000
Sold Price
$550,000
Premium/Discount to List
-$39,000
-6.62%
Views
25
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
61.66%
Purchase Details
Closed on
Sep 10, 2013
Sold by
Duran Joel Reche
Bought by
J Duran Investments Llc
Purchase Details
Closed on
Sep 14, 2011
Sold by
Bdm Investments Llc
Bought by
Duran Joel Reche
Purchase Details
Closed on
Dec 15, 2010
Sold by
Hallock J C and Hallock Theresa
Bought by
Cerqueti Antonio and Cerqueti Laurie
Purchase Details
Closed on
Feb 8, 2007
Sold by
Pulte Home Corp
Bought by
Hallock J C and Hallock Theresa
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$306,808
Interest Rate
8.62%
Mortgage Type
Negative Amortization
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $550,000 | Express Title & Closing | |
| Quit Claim Deed | -- | None Available | |
| Warranty Deed | $240,000 | Title Warehouses America Inc | |
| Warranty Deed | $122,000 | Attorney | |
| Special Warranty Deed | $383,600 | Landamerica Gulfatlantic Tit |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $306,808 | Negative Amortization |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 08/20/2025 08/20/25 | Sold | $550,000 | -4.3% | $302 / Sq Ft |
| 08/05/2025 08/05/25 | Pending | -- | -- | -- |
| 06/26/2025 06/26/25 | Price Changed | $575,000 | -2.4% | $315 / Sq Ft |
| 06/12/2025 06/12/25 | For Sale | $589,000 | -- | $323 / Sq Ft |
Source: Stellar MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $5,730 | $362,951 | -- | -- |
| 2024 | $4,774 | $362,951 | -- | -- |
| 2023 | $4,774 | $319,000 | $63,800 | $255,200 |
| 2022 | $4,304 | $282,600 | $56,520 | $226,080 |
| 2021 | $3,930 | $247,900 | $49,580 | $198,320 |
| 2020 | $3,618 | $247,900 | $49,580 | $198,320 |
| 2019 | $3,645 | $247,900 | $49,580 | $198,320 |
| 2018 | $3,471 | $240,600 | $48,120 | $192,480 |
| 2017 | $3,168 | $215,100 | $43,020 | $172,080 |
| 2016 | $3,228 | $231,100 | $46,220 | $184,880 |
| 2015 | $3,095 | $218,800 | $43,760 | $175,040 |
| 2014 | $2,840 | $195,600 | $39,120 | $156,480 |
Source: Public Records
Agents Affiliated with this Home
-
Drew Frahm
-
Gabriela Buche
Seller Co-Listing Agent in 2025
Gabriela Buche
VISTA CAY REALTY COMPANY
(815) 790-6419
51 in this area
61 Total Sales
-
Pippa Murray
P
Buyer's Agent in 2025
Pippa Murray
SIGNATURE COLLECTION REALTY IN
(407) 729-1900
2 in this area
57 Total Sales
Map
Source: Stellar MLS
MLS Number: O6316854
APN: 06-2429-8887-10-106
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Listing Information presented by local MLS brokerage: Ten-X - (888)-952-6393
Nearby Homes
- 5012 Shoreway Loop Unit 10107
- 5012 Shoreway Loop Unit 10207
- 5000 Cayview Ave Unit 30408
- 5000 Cayview Ave Unit 30908
- 5000 Cayview Ave Unit 10108
- 5025 Shoreway Loop Unit 20503
- 5036 Shoreway Loop Unit 30505
- 4862 Cayview Ave Unit 10709
- 4862 Cayview Ave Unit 410
- 4862 Cayview Ave Unit 40409
- 4862 Cayview Ave Unit 407
- 8001 Cool Breeze Dr Unit 121
- 4816 Cayview Ave Unit 20111
- 5026 Tideview Cir Unit 17
- 5076 Tideview Cir Unit 90
- 4814 Cayview Ave Unit 10713
- 4814 Cayview Ave Unit 40613
- 4814 Cayview Ave Unit 21013
- 4804 Cayview Ave Unit 20512
- 4802 Cayview Ave Unit 102