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;

978 Signet Drive
Apollo Beach, FL 33572
Dondra Jacobs Shultz with KELLER WILLIAMS TAMPA PROP., original listing - (813) 264-7754

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,820,000
Beds: 6
Baths: Full: 5, ½: 2
Status: Active
SqFt: 5284 Square Feet
Agency: KELLER WILLIAMS TAMPA PROP.
Agency Phone: (813) 264-7754

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Exquisite home available to the buyer who appreciates the finest upgrades and move-in ready furnishings. Step into this unparalleled blend of luxury and waterfront living in the prestigious Mirabay neighborhood. Meticulously crafted and curated, this newly constructed 2-story home boasts 6 bedrooms, 5 full baths, 2 half baths and features a host of upgrades. This is the only Cararra model with this distinctive elevation in Mirabay. Your journey begins the moment you enter the dramatic 25-foot foyer and take in the stunning architectural details and thoughtful design choices that reflect the seller's passion for interior aesthetics. Upgraded engineered hardwood flooring adds warmth and elegance flowing throughout this open floorplan, complimented by 13-foot ceilings. Forge powerful connections in your bespoke whiskey lounge with a striking 3-tiered tray ceiling, black accent wall, beautiful contemporary art and fixtures, and a stainless steel wine refrigerator. Located across the entryway, is a spacious home office, perfect for the CEO mindset. Find your zen in the inspired master suite, featuring tray ceilings, recessed lighting, custom ceiling fan, palatial windows, upgraded California closet with his-and-hers walk-in dressing rooms, custom mirrors, quartz surfaces, and a vast spa-like master bath including a luxurious shower with a rain showerhead and a 66" freestanding tub. An additional downstairs guest enclave features an en-suite bath with a glass-enclosed shower stall and French door leading out to the lanai. Custom plantation shutters throughout add a touch of sophistication. At the heart of this idyllic property lies the designer kitchen, complete with an expansive Quartz island and countertops, custom lighting, high-end stainless steel appliances, 5-burner gas range and hood, double ovens, ceramic tile backsplash, spacious walk-in pantry, a butler's pantry expansion provides temperature-controlled wine storage. Entertain in the elegant dining area and living space with custom LED light fixtures and floor-to-ceiling windows. Venture to your private waterfront oasis with a 2-story cage protecting the shimmering 36' x 26' pebble-tech pool with a cooling shell-stone deck, 2 sun shelves, 4 bubblers - 2 with LED lighting, and built-in hot tub. Brand new boat dock and slip will accommodate a vessel up to 45', equipped with a 20,000-lb boat lift, so you can hit the water and explore the many hidden treasures including islands, white sand beaches, and waterfront restaurants. An elegant hardwood and iron staircase leads to the expansive second floor with a bonus loft and upgraded kitchenette with wet bar, and a tech-enabled theater/media room. The second-floor balcony overlooks the serene surroundings. Four more bedrooms provide 5-star accommodations, offering en suite or Jack and Jill bathroom, including a custom-crafted Princess bedroom with a play area or sitting room and a private bath. The property includes a security system, water softener, and is poised to become part of a gated community in the near future. The custom decor, fixtures and furnishings are negotiable with the sales price. The Mirabay waterfront community boasts a resort-style pool with a waterslide and lap lanes, lush landscaping, spa services, restaurant and bar, tennis, pickleball and cabanas. The fitness center is equipped with state-of-the-art facilities. At its heart is the 135-acre lagoon, perfect for boating, kayaking, and paddleboarding.
MlsNumber: --
ListingId: TB8353344


Listing Provided By: KELLER WILLIAMS TAMPA PROP., original listing
Phone: (727) 433-1239
Office Phone: (813) 264-7754
Agent Name: Dondra Jacobs Shultz
Disclaimer: Copyright © 2025 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 Dani Hosey Weng
Dani Hosey Weng
ASCIICharles Rutenberg Realty
Call Today!: (703) 862-4306

Local Mortgage Pro

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;
Real Estate Expert Photo for Joe Spellman NMLS# 2142845
Joe Spellman NMLS# 2142845
ASCIIFamily First Mortgage USA empowered by NEXA
Call Today!: (863) 559-8288

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App