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 = 3343 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 = 3343 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 = 3343 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;

13227 Fawn Lily Drive
Riverview, FL 33579

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $769,999
Beds: 4
Baths: 3
Status: Pending
SqFt: 3110
Agency: Dalton Wade, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2016
Notes: Introducing the impressive Key Largo floor plan meticulously designed by WestBay Homes! Nestled within the highly sought-after Waterleaf community, this expansive residence boasts 4 Bedrooms, 3 full bathrooms, a Bonus room, and a 3-car garage, spanning 3,160 square feet of luxurious living space. Upon arrival, you'll be greeted by a brick-paved driveway leading to the spacious 3-car garage.<br /> <br /> Stepping inside, you'll be greeted by soaring 12-foot ceilings and arched openings that allow natural light to illuminate the interior. To your left, French glass doors lead to a versatile den/study or office space, while to your right, the formal dining room awaits for memorable holiday meals or family gatherings.<br /> <br /> Continuing onward, you'll discover the heart of the home featuring a combined grand room/living room, an exquisite kitchen, and a casual dining area. The gourmet kitchen is equipped with 42-inch cabinets, a tiled backsplash, stainless steel appliances, a 36-inch glass top stove, a convenient pot filler, and an oversized island, perfect for entertaining. The casual dining area features a built-in dry bar, while the grand room/living room offers stunning water views, accessible from the lanai with its private pool, framed by 15 feet of glass sliding doors.<br /> <br /> Exploring further, you'll find the luxurious Owner's Suite, boasting ample space for a king-size bed, a sitting area, tray ceilings, and more. The suite includes dual spacious walk-in closets, an en-suite bathroom with granite countertops, dual sinks, illuminated mirrors, a separate soaking tub, and a walk-in rain shower with 4 body jets. This home features a split plan with 3 additional bedrooms on the opposite side, two of which feature walk-in closets and share a bathroom with dual sinks and a shower/tub.<br /> <br /> The 18x15 bonus room offers versatility as a theater, play area/game room, or in-law suite, with French doors leading to the lanai and a custom pool. The pool and spa are solar and gas heated, perfect for enjoying beautiful sunsets over the water. This home is loaded with upgrades, including prewired surround sound in the living room, bonus room, and lanai, tray ceilings in the formal dining room and Owner's Suite, a 250-gallon propane tank, exterior LED lighting, Pentair pool equipment with Wi-Fi, in-floor electrical outlets, electric blinds on glass sliding doors, prewiring for an electric vehicle, pre-plumbing for an outdoor kitchen, a water softener, UV sterilizing light for the A/C, pre-plumbing for a laundry tub, and many more.<br /> <br /> Enjoy fantastic resort-like amenities including a clubhouse, pool, playground, basketball court, dog park, fitness stations, and trails in this UltraFi Wifi gated community. Don't miss the opportunity to tour this exquisite home - call today to schedule your appointment!
MlsNumber: T3505497


Listing Provided By: Dalton Wade, Inc., original listing
Name: Dalton Wade, Inc.
Phone: (727) 888-4175
Office Name: DALTON WADE INC
Office Phone: (888) 668-8283
Agent Name: Donnell Carter
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 = 3343 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 Anne Nymark
Anne Nymark
ASCIISignature Realty Associates
Call Today!: (813) 293-9236

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App