MENU
174 Yellow Snapdragon Drive, DAVENPORT, FL 33837
Request More Information
  • All fields are required.
  • Check this box if you are a real person:
  • MLS#: O6286680 ( Residential )
  • Street Address: 174 Yellow Snapdragon Drive
  • Viewed: 36
  • Price: $629,000
  • Price sqft: $149
  • Waterfront: No
  • Year Built: 2012
  • Bldg sqft: 4208
  • Bedrooms: 6
  • Total Baths: 5
  • Full Baths: 5
  • Garage / Parking Spaces: 2
  • Days On Market: 11
Description
Heres your chance to own one of the three vacation properties featured on HGTVs 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 villas 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.
Description
Heres your chance to own one of the three vacation properties featured on HGTVs 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 villas 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.
Payment Calculator
  •   Principal & Interest -
  •   Property Tax $
  •   Home Insurance $
  •   HOA Fees $
  •   Mortgage Insurance-

  •   Monthly -
For a Fast & FREE Mortgage Pre-ApprovalApply Now
Features
Building and Construction
  • Covered Spaces: 0.00
  • Exterior Features: Sidewalk, Sliding Doors
  • Flooring: Carpet, Tile
  • Living Area: 3427.00
  • Roof: Shingle
Land Information
  • Lot Features: Sidewalk, Paved
School Information
  • High School: Davenport High School
  • Middle School: Boone Middle
  • School Elementary: Loughman Oaks Elem
Garage and Parking
  • Garage Spaces: 2.00
  • Parking Features: Driveway
Eco-Communities
  • Pool Features: Deck, Screen Enclosure
  • Water Source: Public
Utilities
  • Carport Spaces: 0.00
  • Cooling: Central Air
  • Heating: Central, Electric
  • Pets Allowed: Yes
  • Sewer: Public Sewer
  • Utilities: BB/HS Internet Available, Cable Available
Finance and Tax Information
  • Home Owners Association Fee Includes: Guard - 24 Hour, Pool, Internet, Maintenance Grounds
  • Home Owners Association Fee: 1566.00
  • Net Operating Income: 0.00
  • Tax Year: 2024
Other Features
  • Appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer
  • Association Name: Assn/Manager Name: Colleen, Access Management
  • Association Phone: 407-480-4200
  • Country: US
  • Furnished: Turnkey
  • Interior Features: Ceiling Fans(s), Eat-in Kitchen, Kitchen/Family Room Combo, Open Floorplan, Walk-In Closet(s)
  • Legal Description: WATERSONG PHASE ONE PB 135 PGS 45-52 LOT 138
  • Levels: Two
  • Area Major: 33837 - Davenport
  • Occupant Type: Vacant
  • Parcel Number: 27-26-24-706191-001380
  • View: Trees/Woods
  • Views: 36
Similar Properties

Details for 5288 Oakbourne Ave, DAVENPORT, FL 33837
$585,000.00 ($134.73 / sqft )

5288 Oakbourne Ave Reduced More Like This

Gorgeous home and beautifully furnished by professional designers in popular Solterra Resort. It sits on a rare premium lot providing more privacy and enjoyment You will find ample space with 7 bedroo

  1. Bedrooms: 7
  2. Baths: 6
  3. Approx. 4342 sqft
  1. MLSID: O6073595
  2. Provided by COMPASS FLORIDA LLC
  3. Contact Ali Mazahaem Flores
  4. mfrmls
  5. DMCA Notice
Details for 4179 Oaktree Drive, DAVENPORT, FL 33837
$680,000.00 ($82.17 / sqft )

4179 Oaktree Drive Virtual Tour More Like This

Sellers Open To All Offers And / Or Talking About Concessions / Credits Towards Upgrades Or Closing Costs * Must reach out for additional details * Don't miss out on the incredible opportunity to own

  1. Bedrooms: 6
  2. Baths: 7
  3. Approx. 8276 sqft
  1. MLSID: L4950113
  2. Provided by KELLER WILLIAMS REALTY SMART
  3. Contact Daniel Fleischman
  4. mfrmls
  5. DMCA Notice
Details for 5234 Wildwood Way, DAVENPORT, FL 33837
$659,000.00 ($151.77 / sqft )

5234 Wildwood Way Virtual Tour Green Listing More Like This

Your Perfect Aaaahhh Moment Awaits Step into a home that feels like a five star retreat. This pristine 7 bedroom, 5.5 bathroom, turnkey, private pool/spa home has been thoughtfully designed to offe

  1. Bedrooms: 7
  2. Baths: 6
  3. Approx. 4342 sqft
  1. MLSID: O6279176
  2. Provided by COLDWELL BANKER REALTY
  3. Contact Karan Wienker
  4. mfrmls
  5. DMCA Notice
Details for 6049 Broad Oak Drive, DAVENPORT, FL 33837
$649,900.00 ($149.68 / sqft )

6049 Broad Oak Drive Virtual Tour Green Listing More Like This

Beautiful fully furnished turn key luxury home with full 49 roof solar panels fully paid ($45k value) presents in new condition nestled within the gated solterra resort, an easy drive to walt disney

  1. Bedrooms: 7
  2. Baths: 6
  3. Approx. 4342 sqft
  1. MLSID: O6290248
  2. Provided by INTOP REALTY LLC
  3. Contact Yujie Jiang
  4. mfrmls
  5. DMCA Notice

Contact Info

Headshot for Associate Samantha Archer
  1. Samantha Archer, Broker
  2. Tropic Shores Realty
  3. Mobile: 727.534.9276
  4. samanthaarcherbroker@gmail.com