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;

5413 Wishing Arch Drive
Apollo Beach, FL 33572

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1966
Agency: Align Right Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: ****** MOTIVATED SELLER offering buyers agent bonus for an agreed upon contract by May 31st<br /> You have got to see this waterfront fully dockable 2 year old Home in Mirabay. Featuring 3 bed 2 bath plus den. Minutes from your backyard to waterfront dining, dolphins, manatees and world famous fishing! <br /> <br /> Welcome to 5413 Wishing Arch Dr, a stunning waterfront gem. This 2021-built home is a perfect blend of luxury and comfort, offering an exceptional living experience.<br /> <br /> Key Features: 3 Bedrooms Plus Office/Den: Each room is designed with comfort and style in mind, providing ample space for relaxation and work. Situated on a prime waterfront lot, this home offers breathtaking views.<br /> <br /> Dockable with Easement: Already equipped with a dock easement, it's ready for you to add your dock and enjoy direct access to Tampa Bay. The Owner has worked with a local dock company and has dock plans drawn up for you.<br /> <br /> High-End Upgrades: From upgraded tilework to crown molding, every detail in this home speaks of quality and elegance.<br /> <br /> Custom Built Bar: Perfect for entertaining, the centrally located custom bar adds a touch of sophistication and fun to your gatherings.<br /> <br /> Office with Upgraded Glass Doors: The office space, enhanced with beautiful glass doors, provides a tranquil environment for productivity.<br /> <br /> Expansive Lagoon View: Enjoy the tranquil views of the expansive waterview of the Mirabay Lagoon, adding a sense of peace and tranquility to your daily living.<br /> <br /> Privacy Guaranteed: With no front or rear neighbors, this home offers an exclusive and private living experience.<br /> <br /> Community and Lifestyle: Located close to the award-winning Mirabay clubhouse, engage in community activities and enjoy the convenience of nearby amenities.<br /> <br /> Ready for Pool Installation: The large lot provides more than enough room for a large pool, with sample pool plans available in the MLS attachments.<br /> <br /> Dock Plans Available: Detailed dock plans are also included, making it easy to start your waterfront lifestyle.<br /> <br /> This property is more than just a home; it's a lifestyle choice for those seeking luxury, comfort, and a connection with nature. Don't miss the opportunity to own this piece of paradise in Apollo Beach.
MlsNumber: T3496819


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: Shawna Calvert
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