Title Page Background
DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => agent ) BEFORE: Site: 3343 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => lender ) BEFORE: Site: 3343 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3343 [1] => [2] => [3] => other ) BEFORE: Site: 3343 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3343 Igate: njhud LocID: 3343 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

5602 Limelight Drive
Apollo Beach, FL 33572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $665,900
Beds: 4
Baths: 3
Status: Active
SqFt: 2617
Agency: Align Right Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: NEW PRICE IMPROVEMENT!!! BRING ALL OFFERS! Seller is MOTIVATED!! SELLER WILL CONTRIBUTE $5,000 IN BUYER'S CONCESSIONS! Welcome HOME! This Waterset home is the ONE! This Serafina Model by David Weekley Homes was built in 2021 and still looks like a model home. The style and décor are impeccable. With 4 sizable bedrooms, 3 full baths, a Media Room, a huge Kitchen, Great Room, Dining Room, Sunroom, an over-sized screened-in Lanai with a brand-new Outdoor Kitchen, as well as an additional open Lanai with firepit, and a 3-car garage, this home has everything you need to make it your own tropical oasis. The home is located on a beautiful corner lot with a fenced-in yard. As you enter the home, there are two of the four bedrooms off the beautiful, welcoming foyer, with a bathroom between the two bedrooms. Then you enter the grand living area with the Kitchen, Great Room and dining area. Soaring ceilings, lots of windows, and sliding doors overlooking the amazing backyard give you a wide-open and airy feeling. The chef's Kitchen features quartz countertops, 42" upper cabinets with crown molding, an extended island bar with additional seating, and upgraded Whirlpool gourmet appliances including a built-in oven and microwave, an industrial stainless steel exhaust hood, a gas cooktop, dishwasher, and a Samsung refrigerator. The Dining Room and Sunroom are spacious and allow plenty of room for entertaining guests. The Great Room is open and spacious enough for a sectional sofa, or large sofas, and a big screen TV. Off the hallway, behind the Great Room, is the Media Room and a third bedroom. The 3rd Bedroom is spacious and has plenty of closet space. The Media Room is set up specifically for the whole family to enjoy your favorite movies! Both the Great Room and the Media Room are pre-wired for AV/ Sound systems. There is a convenient bathroom located just off the Media Room as well. The Master Suite is located at the rear of the house, giving the owner plenty of privacy. The room features a beautiful tray ceiling, windows across the back of the room to allow plenty of daylight, and an ensuite bathroom with a spectacular tiled walk-in shower with two showerheads, dual vanities with a seating area in-between, and two walk-in closets. The home also features an Outdoor Kitchen with Blaze appliances, including a grill, sink, beverage distribution system, refrigerator, granite countertops, and plenty of seating. There’s also an open Lanai area with a built-in firepit and seating. The 3-car garage includes an epoxy-coated floor and 2 storage racks installed overhead for storage. There’s a whole-home water softening system and gutters installed on the home as well. What else could you possibly need? Easy access to I-75, US 41, and 301 makes for an EASY COMMUTE anywhere in Tampa Bay!!! Nestled in the AMAZING COMMUNITY OF WATERSET with tons of AMENITIES!!! With almost 14 miles of walking trails, 4 swimming pools, fitness centers, tennis courts, basketball courts, pickleball courts, sand volleyball, playgrounds, parks, and even a doggy park!!! THIS IS THE PLACE TO BE!!! HURRY!!!
MlsNumber: T3503880


Listing Provided By: Align Right Realty, original listing
Name: Align Right Realty
Phone: (813) 743-4663
Office Name: ALIGN RIGHT REALTY SOUTH SHORE
Office Phone: (813) 645-4663
Agent Name: Kimberly Booth
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => hillsborough-southeast [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: hillsborough-southeast State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: hillsborough-southeast State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('flhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Doug and Jenna Degroot
Doug and Jenna Degroot
ASCIIeXp Realty LLC
Doug: (813) 767-6386
Jenna: (813) 598-6363

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App