DAVENPORT, FL 33837 174 YELLOW SNAPDRAGON DRIVE

174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 1174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 2174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 3
14 more
174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 4174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 5174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 6174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 7174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 8174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 9174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 10174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 11174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 12174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 13174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 14174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 15174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 16174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 17174 YELLOW SNAPDRAGON DRIVE DAVENPORT, FL - Image 18
Presented By: ORLANDO 4 VILLAS REALTY LLC with 321-251-6759. - 321-251-6759
  • MLS# O6286680
  • 06/03/2025
  • Request Tour
  • Request Info
  • Beds • 6
  • Baths • 5
  • SQFT • 3,427
  • Garage • 2

Home Details

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.
Presented By: ORLANDO 4 VILLAS REALTY LLC with 321-251-6759. - 321-251-6759

Interior Features for 174 YELLOW SNAPDRAGON DRIVE

Bedrooms

Total Bedrooms6

Bathrooms

Half Baths0
Total Baths5

Other Interior Features

LivingAreaSourcepublic records
Air Conditioning Y/NYes
Fireplace Y/NNo
Flooringcarpet, tile
Furnished Y/Nturnkey
Heating Y/NYes
Interior Amenitiesceiling fan(s), eating space in kitchen, kitchen/family room combo, open floorplan, walk-in closet(s)
Laundry Featuresinside, laundry room
Total Stories2

General for 174 YELLOW SNAPDRAGON DRIVE

Additional Parcels Y/NNo
Appliancesdishwasher, dryer, microwave, range, refrigerator, washer
Assoc Fee Paid Perquarterly
Association Fee Includes24-hour guard, community pool, internet, maintenance grounds
Association Nameassn/manager name: colleen, access management
Attached Garage Yes
Building Area Unitssquare feet
Carport Y/NNo
Citydavenport
Community Featuresfitness center, gated community - guard, park, playground, pool, sidewalks
Construction Materialsblock, stucco, wood frame
Coolingcentral air
Countypolk
Directionsgps
Elementary Schoolloughman oaks elem
Facing Directionsouthwest
Flood Zone Codex
Flood Zone Code XY
Full Baths5
Garage Spaces2
Garage Y/NYes
HOAYes
HOA Fee$1566
Heatingcentral, electric
High Schooldavenport high school
Land Lease Y/NNo
Lease Considered Y/NNo
Legal Descriptionwatersong phase one pb 135 pgs 45-52 lot 138
Levelstwo
Listing Termscash, conventional
Living Area Unitssquare feet
Lot Size Square Feet10650
Lot Size Unitssquare feet
MLS Area33837 - davenport
Middle/Junior High Schoolboone middle
ModificationTimestamp2025-06-05t19:03:17.973z
Monthly HOA Amount522
New ConstructionNo
Occupancy Typevacant
Ownershipfee simple
Patio/Porch Featuresdeck, enclosed, screened
Pets Allowedyes
Pool Featuresdeck, screen enclosure
Property Subtypesingle family residence
Property Typeresidential
Roofshingle
STELLAR_InLawSuiteYNNo
Senior Community Y/NNo
Sewerpublic sewer
Spa Featuresin ground
Standard Statusactive
Statusactive
Subdivision Namewatersong ph 1
Tax Annual Amount6398.1
Tax Lot138
Tax Year2024
Total Rooms8
Utilitiesbb/hs internet available, cable available
Viewtrees/woods
Virtual TourClick here
Water Access Y/NNo
Water View Y/NNo
Year Built2012

Exterior for 174 YELLOW SNAPDRAGON DRIVE

Building Area Total4208
Covered Spaces2
Exterior Amenitiessidewalk, sliding doors
Foundation Detailsslab
Lot Featuressidewalk
Lot Size Acres0.24
Lot Size Area10650
Open Parking Y/NYes
Parking Featuresdriveway
Private PoolYes
Road Frontage Typestreet paved
Road Surface Typepaved, asphalt
SpaYes
Water Sourcepublic
WaterfrontY/NNo

Additional Details

Price History

Schools

High School Davenport High School
Elementary School Loughman Oaks Elem
Middle School Boone Middle

Andre LaFountain

Realtor / Coach
Price $629,000
MLS#O6286680
List Date 06/03/2025
Property Type Single Family
Phone 518.569.7173
Request Tour
Request Info
Visit My Website

Similar Properties to 174 YELLOW SNAPDRAGON DRIVE

Got questions? We’re just an email away – feel free to reach out!

MLS® Disclaimer

MLS Logo Copyright © MFRMLS.com All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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. Information on this site was last updated Last updated on April 28, 2025 8:46 AM UTC The listing information on this page last changed on Last updated on April 28, 2025 8:46 AM UTCd. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of MFR MLS. All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided 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. Updated on April 28, 2025 8:46 AM UTC

33. Required DMCA Notice

DMCA Disclaimer

The Digital Millennium Copyright Act of 1998, 17 U.S.C. §512, the DMCA, provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com. The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owners behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

Location
  • Babcock Ranch