Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 376 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 376 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 376 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3524 Lavender Drive
Davenport, FL 33897

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $879,000
Beds: 10
Baths: 8
Status: Active
SqFt: 4399
Agency: Radius Realty Group, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: **NEW PRICE** STUNNING INVESTMENT HOME IN A PRIME LOCATION OF WINDSOR ISLAND RESORT THAT IS SURE TO IMPRESS! PERFECT LOCATION WITHIN COMMUNITY ON LAVENDER DRIVE, JUST MINUTES FROM DISNEY MAINGATE! FILLED WITH NATURAL LIGHT, THIS FULLY FURNISHED HOME FEATURES 10 BEDROOMS AND 8 BATHS, PROFESSIONALLY DECORATED WITH ALL THE EXTRAS!! REST ASSURED KNOWING YOU ARE PROVIDING YOUR GUESTS EVERYTHING THEY WILL NEED FOR THE PERFECT STAY! HUGE EAT-IN, FULLY FURNISHED KITCHEN IS A GOURMET DREAM WITH A LARGE GRANITE ISLAND, STAINLESS APPLIANCES AND GRAY EXTENDED CABINETRY! DINING AREA BOASTS BANQUET SEATING FOR 20 TO ACCOMMODATE LARGE FAMILY GATHERINGS! FIRST FLOOR MASTER BR AND BATH PLUS ADDITIONAL BR/BA SUITE! FULLY THEMED MEDIA ROOM WITH LOTS OF COMFORTABLE SEATING! COMPLETING THE FIRST FLOOR, OUTSTANDING LAUNDRY ROOM WITH NOT ONE, NOT TWO, BUT THREE FULL SIZE SETS OF WASHERS AND DRYERS!! NO WAITING FOR LAUNDRY!!! HEADING UPSTAIRS, ENJOY THE FINISHED THEMED LOFT WITH POOL TABLE, TV AND PLENTY OF SEATING. 8 MORE BEDROOMS UPSTAIRS WITH 5 THEMED DESIGNS! MICKEY AND MINNIE, PRINCESS, FROZEN, MARIO, MARVEL AND SO MUCH MORE!! OUTSIDE ENJOY ADDITIONAL DINING WITH SEATING FOR 12 PLUS LOUNGING FOR 4 MORE! RELAX IN THE SPACIOUS HEATED POOL AND SPA - ALL SCREENED IN! WINDSOR ISLAND HAS BECOME ONE OF THE VERY BEST RESORTS AVAILABLE AND OFFERS UNBEATABLE AMENITIES INCLUDING: BEACH STYLE HEATED POOL, GIANT WATER SLIDE WITH LAZY RIVER, SPLASH PAD AND POOL CABANAS - ALL IN ADDITION TO AN 8,000+ SQ FT CLUBHOUSE WITH CONCIERGE, LOUNGE, SUNDRY SHOP, ARCADE, FITNESS CENTER BLUE MARLIN BAR AND GRILL, PLAYGROUND, PUTT PUTT AND MUCH, MUCH MORE! FINALLY, AT THE END OF THE DAY, ENJOY VIEWS OF DISNEY FIREWORKS FROM THE RELAXING COMMUNITY FIRE PIT! THIS HOME HAS IT ALL AND WILL BE ANY INVESTOR'S - OR VACATIONER'S - DREAM!!
MlsNumber: O6134321


Listing Provided By: Radius Realty Group, LLC, original listing
Name: Radius Realty Group, LLC
Phone: (407) 470-2055
Office Name: RADIUS REALTY GROUP LLC
Office Phone: (407) 541-0779
Agent Name: Hallie Welch
Disclaimer: Copyright © 2024 Stellar MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 376 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Harper Realty Group
Harper Realty Group
Call Today!: (863) 581-6661

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App