1 of 19

Want to see this home?

174 Yellow Snapdragon Drive

DAVENPORT, FL 33837

6 beds
5 baths
3,427 sqft
10,650 sqft lot
$183 per sqft
2012 build
– on site

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.

Listing courtesy of STELLAR_MLS / ORLANDO 4 VILLAS REALTY LLC

Last checked: Checking… • Last updated Apr 1, 2025 •

MLS# O6286680 —

The Building

Year Built:

2012
New Construction:

false
Construction Materials:

Block
Levels:

Two
Stories Total:

2
Roof:

Shingle
Foundation Details:

Slab
Patio And Porch Features:

Deck
Building Area Total:

4208
Building Area Units:

Square Feet
Building Area Source:

Public Records

Interior

Interior Features:

Ceiling Fan(s)
Furnished:

Turnkey
Flooring:

Carpet
Fireplace:

false

Room Dimensions

Living Area:

3427
Living Area Units:

Square Feet
Living Area Source:

Public Records

Location

Directions:

GPS
Latitude:

28.212228
Longitude:

-81.560799
Coordinates:

-81.560799, 28.212228

The Property

Parcel Number:

272624706191001380
Property Type:

Residential
Property Subtype:

Single Family Residence
Lot Features:

Sidewalk
Lot Size Acres:

0.24
Lot Size Area:

10650
Lot Size SqFt:

10650
Lot Size Units:

Square Feet
Total Acres:

0 to less than 1/4
Direction Faces:

Southwest
View:

Trees/Woods
View:

true
Exterior Features:

Sidewalk
Water Source:

Public
Road Surface Type:

Paved
Road Frontage Type:

Street Paved
Flood Zone Code:

x
Additional Parcels:

false
Homestead:

false
Land Lease:

false

Listing Agent

Contact info:

Taxes

Tax Year:

2024
Tax Lot:

138
Tax Legal Description:

WATERSONG PHASE ONE PB 135 PGS 45-52 LOT 138
Tax Book Number:

135-45-52
Tax Annual Amount:

6398.1

Beds

Bedrooms Total:

6

Baths

Total Baths:

5
Total Baths:

5
Full Baths:

5

The Listing

Virtual Tour URL Unbranded:

https://www.propertypanorama.com/instaview/stellar/O6286680
Special Listing Conditions:

None

Heating & Cooling

Heating:

Central
Heating:

true
Cooling:

Central Air
Cooling:

true

Utilities

Utilities:

BB/HS Internet Available
Sewer:

Public Sewer

Appliances

Appliances:

Dishwasher
Laundry Features:

Inside

Schools

Elementary School:

Loughman Oaks Elem
Middle Or Junior School:

Boone Middle
High School:

Davenport High School

The Community

Subdivision Name:

WATERSONG PH 1
Senior Community:

false
Community Features:

Fitness Center
Waterview:

false
Water Access:

false
Waterfront:

false
Spa:

true
Spa Features:

In Ground
Pool Private:

true
Pool Features:

Deck
Pets Allowed:

Yes
Pet Restrictions:

Ask the HOA for Pet Restrictions
Association:

true
Association Fee:

1566
Association Fee Frequency:

Quarterly
Association Fee Includes:

24-Hour Guard
Association Fee Requirement:

Required
Monthly HOA Amount:

522
Ownership:

Fee Simple

Parking

Garage:

true
Attached Garage:

true
Garage Spaces:

2
Carport:

false
Covered Spaces:

2
Open Parking:

true
Parking Features:

Driveway

Monthly cost estimate

Asking price

$629,000

Expense	Monthly cost
Mortgage	$3,368
Taxes	$533
Insurance	$172
HOA fees	$522
Utilities	$213 See report
Total	$4,808/mo.^*
	^*This is an estimate

Explore the Area

My Commute

From

Walk Score®

Provided by WalkScore® Inc.

Bike Score®

Provided by WalkScore® Inc.

Air Pollution Index

Provided by ClearlyEnergy

Sale history

Date	Event	Source	Price	% Change
3/6/25 Mar 6, 2025	Listed / Active	STELLAR_MLS	$629,000
9/14/23 Sep 14, 2023	Listed / Active	STELLAR_MLS

Want a closer look?

Go see 174 Yellow Snapdragon Drive

Or Call Toll Free 1-800-241-3327

We guarantee that we’ll never spam you.

* indicates a required field

More homes

Newest listings in 33837

Similar sold homes

This house located in Watersong, FL 33837 is currently for sale for $629,000. 174 Yellow Snapdragon Drive is a 3,427 square foot house with 6 beds and 5 baths that has been on Estately for 29 days. 174 Yellow Snapdragon Drive is in the Watersong neighborhood of DAVENPORT. This house is in the attendance area of Dundee Ridge Middle Academy, Bethune Academy, Davenport High School, Shelley S. Boone Middle School, Davenport School Of The Arts, Loughman Oaks Elementary School, Dundee Elementary Academy, and Daniel Jenkins Academy Of Technology Middle School.

Listing Courtesy of: STELLAR_MLS and ORLANDO 4 VILLAS REALTY LLC.

Based on information from the My Florida Regional MLS DBA Stellar MLS 2025.

All information provided is deemed reliable but is not guaranteed and should be independently verified. Stellar MLS, Estately and their affiliates provide the MLS and all content therein “AS IS” and without any warranty, express or implied. The information included in this listing is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information on each listing is furnished by the owner and deemed reliable to the best of his/her knowledge, but should be verified by the purchaser. Stellar MLS and Estately assume no responsibility for typographical errors, misprints or misinformation. This property is offered without respect to any protected classes in accordance with the law. For any questions please call (407) 499-8911.