Here’s your chance to own one of the three vacation properties featured on HGTV’s Theme Queen. This vacation rental property has it all – including a gross rental income of $90.2K in 2022. NEW in February 2025: all carpeted areas have just been replaced with upgraded carpets and underlay; full interior repaint including baseboards, railings, doors and ceilings, (and select exterior spaces as well); new couches; all rugs and mattresses professionally cleaned; and a full-house deep clean has also just been completed. While the Steam Punk room was the star of the TV show, the villa was artfully fabricated by many of the same designers, carpenters and painters who appeared on the TV special. This home features six, highly detailed themed spaces including: (1) an impressive Steam Punk master bedroom with ensuite that was created for a TV shoot; (2) a whimsical “50s Diner” games room with retro pool table and Foose ball table designed for all ages and includes a (combination) Pac-Mac/Ms. Pac-Man/Galaga arcade machine; (3) a jungle room prominently displays floor-to-ceiling 3D animal sculptures and a playful fort-style bunkbed; (4) a circus bedroom boasts an intricate ceiling painted to look like a circus big top tent; and (5) the pool area where Morocco meets Aladdin in this highly detailed outside space where golden lanterns, teak arches, and patterned walls and floors will transport you to Agrabah. The villa’s outdoor area backs onto a nature reserve and is flanked by lush tropical/privacy gardens and features a large pool with variable lighting, oversized lanai, and screened-in area. A BBQ (direct gas line – no tanks required) and an outdoor fridge are built into the outdoor entertaining space. Located just 13 miles from Disney, Watersong is a designated short-term rental community that was developed with the discerning vacationer in mind and offers security with gated entrance. Watersong is adjacent to Providence Golf Club, a 18-hole gift course designed by renowned golf course architect Mike Dasher. And finally, for those looking for beach excursions, Florida's renowned coastal regions are a short 1 hour and 15-minute drive from the vacation villa. Ideally located within central Florida, this home means you are within an easy drive to both the Atlantic and Gulf coasts.
Sold for $600,000
$600,000
174 YELLOW SNAPDRAGON DRIVE, DAVENPORT, FL 33837
6beds
3,427sqft
Single Family Residence
Built in 2012
10,650 Square Feet Lot
$583,900 Zestimate®
$175/sqft
$4,048 Estimated rent
Home value
$583,900
$526,000 - $648,000
$4,048/mo
Zestimate® history
Owner options
List your home for rent
$4,048/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,048/mo
Rent Zestimate®
Refinance and save
$4,508/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,508/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Oversized lanaiOutdoor fridgeFull interior repaintNew couchesUpgraded carpets and underlayFull-house deep clean
Zillow last checked:
Listing updated:
Listed by:
Leah Longhorn 352-255-8202,
ORLANDO 4 VILLAS REALTY LLC 321-251-6759
Bought with:
Philippa Murray, 699511
SIGNATURE COLLECTION REALTY IN
Source: Stellar MLS,MLS#: O6286680
Originating MLS: Orlando Regional
Originating MLS: Orlando Regional
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 5
- Full bathrooms: 5
Primary bedroom
- Features: Built-in Closet
- Level: Second
- Area: 143 Square Feet
- Dimensions: 13x11
Primary bedroom
- Features: Built-in Closet
- Level: Second
- Area: 238 Square Feet
- Dimensions: 14x17
Other
- Features: Built-in Closet
- Level: First
- Area: 143 Square Feet
- Dimensions: 13x11
Bedroom 3
- Features: Built-in Closet
- Level: Second
- Area: 120 Square Feet
- Dimensions: 12x10
Bedroom 4
- Features: Built-in Closet
- Level: Second
- Area: 110 Square Feet
- Dimensions: 11x10
Bedroom 5
- Features: Built-in Closet
- Level: First
- Area: 154 Square Feet
- Dimensions: 11x14
Kitchen
- Features: Built-in Closet
- Level: First
Living room
- Level: First
Heating
- Central, Electric
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer
- Laundry: Inside, Laundry Room
Features
- Ceiling Fan(s), Eating Space In Kitchen, Kitchen/Family Room Combo, Open Floorplan, Walk-In Closet(s)
- Flooring: Carpet, Tile
- Doors: Sliding Doors
- Has fireplace: No
Interior area
- Total structure area: 4,208
- Total interior livable area: 3,427 sqft
Property
Parking
- Total spaces: 2
- Parking features: Driveway
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Enclosed, Screened
- Exterior features: Sidewalk
- Has private pool: Yes
- Pool features: Deck, Screen Enclosure
- Has spa: Yes
- Spa features: In Ground
- Has view: Yes
- View description: Trees/Woods
Lot
- Size: 10,650 Square Feet
- Features: Sidewalk
Details
- Parcel number: 272624706191001380
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Block, Stucco, Wood Frame
- Foundation: Slab
- Roof: Shingle
Condition
- New construction: No
- Year built: 2012
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: BB/HS Internet Available, Cable Available
Community & HOA
Community
- Features: Fitness Center, Gated Community - Guard, Park, Playground, Pool, Sidewalks
- Pet fee: $0 monthly
- Subdivision: WATERSONG PH 1
HOA
- Has HOA: Yes
- Services included: 24-Hour Guard, Community Pool, Internet, Maintenance Grounds
- HOA fee: $522 monthly
- HOA name: Assn/Manager Name: Colleen, Access Management
- HOA phone: 407-480-4200
Location
- Region: Davenport
Financial & listing details
- Price per square foot: $175/sqft
- Tax assessed value: $461,788
- Annual tax amount: $6,398
- Date on market: 3/6/2025
- Cumulative days on market: 28 days
- Listing terms: Cash,Conventional
- Ownership: Fee Simple
- Total actual rent: 0
- Road surface type: Paved, Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 6/24/2025 | Sold | $600,000-4.6%$175/sqft |
Source:  Stellar MLS #O6286680 Report a problem | ||
| 6/9/2025 | Pending sale | $629,000$184/sqft |
Source: Stellar MLS #O6286680 Report a problem | ||
| 6/3/2025 | Listed for sale | $629,000$184/sqft |
Source: Stellar MLS #O6286680 Report a problem | ||
| 4/8/2025 | Listing removed | $629,000$184/sqft |
Source: Stellar MLS #O6286680 Report a problem | ||
| 4/1/2025 | Listed for sale | $629,000$184/sqft |
Source: Stellar MLS #O6286680 Report a problem | ||
| 3/21/2025 | Listing removed | $629,000$184/sqft |
Source: Stellar MLS #O6286680 Report a problem | ||
| 3/6/2025 | Listed for sale | $629,000-3.2%$184/sqft |
Source: Stellar MLS #O6286680 Report a problem | ||
| 7/11/2024 | Listing removed | $650,000$190/sqft |
Source: Stellar MLS #O6140383 Report a problem | ||
| 3/11/2024 | Listing removed | -- |
Source: Stellar MLS #O6140383 Report a problem | ||
| 10/25/2023 | Listed for sale | $650,000$190/sqft |
Source: Stellar MLS #O6140383 Report a problem | ||
| 9/27/2023 | Listing removed | -- |
Source: Stellar MLS #O6140383 Report a problem | ||
| 9/14/2023 | Listed for sale | $650,000+80.7%$190/sqft |
Source: Stellar MLS #O6140383 Report a problem | ||
| 1/15/2013 | Sold | $359,785$105/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,970 +3.5% | $461,788 +7.1% |
| 2024 | $5,771 +3% | $431,005 +10% |
| 2023 | $5,602 +14.4% | $391,823 +10% |
| 2022 | $4,898 +9.2% | $356,203 +10% |
| 2021 | $4,486 +3.7% | $323,821 +4.6% |
| 2020 | $4,325 +2.4% | $309,511 +5.5% |
| 2019 | $4,225 -9.6% | $293,506 -4.7% |
| 2018 | $4,674 -4.1% | $307,838 -0.3% |
| 2017 | $4,874 +7.2% | $308,786 +0.4% |
| 2016 | $4,548 -5.2% | $307,669 +0.3% |
| 2015 | $4,795 +9.6% | $306,680 +10% |
| 2014 | $4,375 -1.4% | $278,800 -2.5% |
| 2013 | $4,439 +1031.4% | $285,844 +1021% |
| 2012 | $392 -40.7% | $25,500 -40% |
| 2011 | $661 -1.9% | $42,500 |
| 2010 | $674 -20.1% | $42,500 -15% |
| 2009 | $843 -10.5% | $50,000 -16.7% |
| 2008 | $942 | $60,000 |
| 2007 | -- | -- |
| 2006 | $264 | -- |
Find assessor info on the county website
Neighborhood: 33837
Nearby homes
- $485,0005 bd5 ba3.4k sqft164 Yellow Snapdragon Dr, Davenport, FL 33837Sold
- $537,9003 bd2 ba2.8k sqft184 Yellow Snapdragon Dr, Davenport, FL 33837Off Market
- $549,9005 bd5 ba3.3k sqft206 Yellow Snapdragon Dr, Davenport, FL 33837Sold
- $535,6005 bd5 ba3.2k sqft155 Yellow Snap Dragon Dr, Davenport, FL 33896Off Market
- $524,8005 bd5 ba3.2k sqft165 Yellow Snapdragon Dr, Davenport, FL 33837Off Market
- $506,0005 bd4 ba2.8k sqft175 Yellow Snapdragon Dr, Davenport, FL 33837Off Market
- $492,2005 bd4 ba2.7k sqft144 Yellow Snapdragon Dr, Davenport, FL 33837Off Market
- $525,0005 bd5 ba3.2k sqft155 Yellow Snapdragon Dr, Davenport, FL 33837Sold
Nearby schools
GreatSchools rating
- 2/10Loughman Oaks Elementary SchoolGrades: PK-5Distance: 0.7 mi
- 3/10Shelley S. Boone Middle SchoolGrades: 6-8Distance: 8.2 mi
- 3/10Davenport High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: Loughman Oaks Elem
- Middle: Boone Middle
- High: Davenport High School
Source: Stellar MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$583,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$583,900
- Florida
- Polk County
- Davenport
- 33837
- 174 YELLOW SNAPDRAGON DRIVE
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Davenport Topics
