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;

421 Islebay Drive
Apollo Beach, FL 33572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,100,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3341
Agency: Keller Williams Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2004
Notes: Under contract-accepting backup offers. Welcome to Resort Style Living! Located in the premier waterfront community of Mirabay in the SouthShore area of Tampa Bay. This spectacular Manatee floor plan by David Weekley Homes (one of the most desired floorplans in Mirabay) is the ideal home for living the Florida life! This two-story home sits on a waterfront lot with a private dock and lush tropical landscaping. Exterior features include brick paver driveway, walkway, front porch and rear lanai. Inside the home has been remodeled with luxury vinyl flooring throughout (no carpet) and features a large kitchen with a 42" cabinets w/crown molding, glass backsplash, stone countertops, closet pantry, gas cooktop, breakfast nook, center island & extensive counter space overlooking the great room. The master suite is located on the first floor & features a large bathroom with dual split sinks, a jetted whirlpool tub & a standalone shower. A huge, walk-in closet provides lots of storage. Other interior features include a den/office & separate dining room, recessed lighting, cathedral ceilings, lots of storage, plantation shutters, gas appliances, and 2 HVAC units for efficient temp control of living spaces. The 2nd floor has 3 bedrooms and a loft overlooking the great room and with fantastic views on the salt water canal. Two of the three bedrooms feature a connecting bathroom. The 4th bedroom offers flexibility as a guest suite, with an attached bathroom, or a media room. Enjoy the Florida lifestyle from the covered patio overlooking the fenced yard and dock w/lift and canal with direct access to Tampa Bay. Need a boat to make your waterfront dream complete? The boat on site can be included for a total purchase price of $1,200,000. Ask us for a link with more info about the vessel. Mirabay is loaded with amenities, including a Clubhouse with an activities director, café, outdoor heated pools with 110' waterslide, tennis, basketball & pickleball courts, water sports including sunfish sailboats, kayaks, paddleboards, fishing, fitness center, parks & playgrounds. Located halfway between Tampa & Sarasota, it is convenient to beautiful sandy beaches, airports, hospitals, shopping.
MlsNumber: T3504593


Listing Provided By: Keller Williams Realty, original listing
Name: Keller Williams Realty
Phone: (813) 641-8300
Office Name: KELLER WILLIAMS SOUTH SHORE
Office Phone: (813) 641-8300
Agent Name: Gene Batronie
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