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;

5328 Loon Nest Court
Apollo Beach, FL 33572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $949,999
Beds: 4
Baths: 3
Status: Active
SqFt: 2840
Agency: LPT Realty, LLC.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2013
Notes: *****POOL HOME*****<br /> <br /> **THIS HOME COMES WITH A 13 MONTH HOME WARRANTY FREE TO BUYER!<br /> <br /> This Property is UNDER MARKET VALUE. Sellers loss is your GAIN. <br /> <br /> HOME OWNED AND BUILT BY ORIGINAL OWNERS since 2013 featuring a BRAND NEW ROOF in 2023! Welcome to this exquisite 4-bedroom, 3-bathroom, 2840 sq ft WEST BAY - KEY LARGO FLOOR PLAN, WATERFRONT, POOL HOME located on a CANAL with expansive views and direct access to TAMPA BAY, the epitome of luxury living in the heart of the beautiful MIRABAY COMMUNITY in Apollo Beach. OVERSIZED LOT which has an amazing amount of green space as the lot size is 11,720 sq ft with a SALT WATER POOL and 3 CAR GARAGE for storage and ample parking. With an impressive array of amenities and WATERFRONT VIEWS, this 2840 sq ft home is a true paradise. Experience lavish WATERFRONT LIVING at its finest, where elegance meets coastal in this remarkable 2013-built residence. Step into a world of sophistication as you enter the OPEN FLOOR PLAN, HIGH CEILINGS AND CROWN MOLDING, recessed and an abundance of natural light. Enjoy a GOURMET KITCHEN adorned with GRANITE COUNTERTOPS and a large island, perfect for entertaining guests. The seamless flow into the living area, offers a captivating view of the water and easy access to the magnificent outdoor entertaining space. The outdoor oasis beckons with a POOL as you host gatherings outdoors for family events and simply enjoy watching the SUNSET over the water. The MASTER SUITE, a true haven, features awe-inspiring views, a WALK-IN CLOSET, DUAL SINKS, GARDEN TUB and a spa-like en-suite bathroom. The PRIVATE LAUNDRY ROOM with STORAGE, a full sized sink, and granite countertops will make doing laundry a breeze as well as provide a nice space to store additional items. This home features a 3-CAR TANDEM GARAGE providing lots of room for parking and storage! Enjoy all the amenities MiraBay offers, such as a Clubhouse with BEACH-ENTRY POOL, WATERSLIDE, lap lanes, FITNESS CENTER, TENNIS COURTS, BASKETBALL COURTS, Pickle-ball courts, playgrounds, year-round activities, and more. Sign out a kayak/canoe or paddleboard (free for residents) from the clubhouse and take a spin around the LAGOON. Less than 5 miles from I-75, MIRABAY is convenient to Tampa Bay’s best dining, entertainment, beaches, hospitals, and shopping. Located about 25 minutes from downtown Tampa and about 30 minutes from Buccaneers at Raymond James Stadium. Travel about 45 minutes south to Sarasota Beaches, shopping malls, hospitals, and the exclusive resort beach area of Little Harbor is minutes away by boat or car. Request your private showing today…this is a must-see home presenting many options.<br /> <br /> Don't miss the opportunity to call this your home and embrace the ultimate WATERFRONT LIFESTYLE. DON'T BE AFRAID TO MAKE AN OFFER.
MlsNumber: T3480730


Listing Provided By: LPT Realty, LLC., original listing
Name: LPT Realty, LLC.
Phone: (877) 366-2213
Office Name: LPT REALTY
Office Phone: (877) 366-2213
Agent Name: Tony Saccaro
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