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 = 375 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 = 375 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 = 375 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;

288 Mobbly Bay Drive
Oldsmar, FL 34677
Jac Smith with KELLER WILLIAMS ST PETE REALTY, original listing - (727) 894-1600

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 5260 Square Feet
Agency: KELLER WILLIAMS ST PETE REALTY
Agency Phone: (727) 894-1600

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: Luxury living with privacy, amazing views, an open floor plan, and ample closet space are just a start. This cul-de-sac custom-built home of unparalleled elegance within a gated enclave features breathtaking water views and abundant natural light without compromising privacy. Spanning 5,260 square feet, this 2 story meticulously designed residence features 4 bedrooms, study, game room, retreat room, 6 bathrooms, elevator and an extended 3-car garage. Step inside to soaring ceilings, coffered detailing, and expansive windows with abundant light as well as privacy. The gourmet kitchen is a chef’s dream, outfitted with a Wolf range, stainless steel appliances, built-in ovens,<br /> microwave, beverage fridge, and generous walk-in pantry with attached second refrigerator. The open-concept kitchen, family room, breakfast nook, and transitional area provide a seamless flow for both everyday living and entertaining with direct access to covered patio. The main level also hosts spacious living room, bedroom with a full bath, and game area. Hardwood stairs, elevator and exterior spiral staircase connect to the second floor. The primary suite is a private sanctuary featuring an opulent ensuite bath, a custom walk-in closet with an organizing<br /> system, and breathtaking, unobstructed bay views with patio access. Large second-floor retreat room offers more opportunities for relaxation and gatherings. Outdoor living is unparalleled with two covered patios and a third-floor crows nest all with panoramic water views of Tampa Bay, and a custom-designed saltwater Pebble-Tec pool & spa to enjoy Florida’s year-round sunshine. The extended garage features larger doors, and built-in closets for maximum storage. Built with both style and security in mind, this home includes hurricane clips, fabric shutters, and remained HIGH AND DRY THROUGH HURRICANE HELENE & MILTON! A brand new high-end aluminum roof (2024) adds lasting durability for years to come. Enjoy your resort-style amenities and a prime central location with less than 30 minutes from St. Pete/Clearwater International Airport, and top-rated private and public schools. Within the hidden treasure of Pinellas County, you are close to great shopping, specialty dining, and Florida's beautiful gulf beaches. Discover the pinnacle of Luxury, privacy, and serenity within this unique home that can be yours today.
MlsNumber: --
ListingId: TB8345779


Listing Provided By: KELLER WILLIAMS ST PETE REALTY, original listing
Phone: (908) 451-5907
Office Phone: (727) 894-1600
Agent Name: Jac Smith
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 = 375 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 Reene Skandaliaris
Reene Skandaliaris
ASCIIDalton Wade Real Estate Group
Call Today!: (727) 877-9367

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App