For Sale
SELECT * FROM `attributeoptions` WHERE `attribute_id` = '33' Search using MAP (Recommended)
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '264'
Downtown Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '254' -- All Downtown Condos (View All)
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '337' -- Bayfront Tower Condos
-- 475 Condos
-- Madison Condos
-- Whitney Plaza Condos
-- The Orion Condos
-- Historic Snell Arcade Condos
-- TownView Condos
-- Detroit Condos
-- W Flats Condos
-- The Sage Condos
-- McNulty Lofts Condos
-- The Signature Condos
-- The Florencia Condos
-- Ovation Condos
-- The Cloisters Condos
-- ParkShore Condos
-- 400 Beach Drive Condos
Gulfport (View All)
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '257'
Clearwater Beach Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '267' -- Clearwater Beach Causeway Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '372'
-- Clearwater Beach Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '373'
-- Clearwater Beach Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '374'
Allendale Homes (View All)
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '226'
St. Pete Beach Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '227' -- St. Pete Beach Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '304'
-- Pass a Grill Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '297'
-- Pass a Grill Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '305'
-- St. Pete Beach Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '300'
Treasure Island Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '228' -- Sunset Beach Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '307'
-- Paradise Island Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '335'
-- Paradise Island Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '316'
-- Yacht Club Estates Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '323'
-- Causeway Isles Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '325'
-- Sunset Beach Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '334'
Park Street Area Homes
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '229'
Pasadena Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '231' -- South Pasadena Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '362'
-- South Pasadena Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '315'
-- Pasadena Yacht and Country Club Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '319'
-- Pasadena Yacht and Country Club Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '350'
Pinellas Point Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '232' -- Pinellas Poin Area Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '320'
-- Pinellas Point Homes (View All)
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '289' -- Bahama Shores Homes
-- Pink Streets
The Jungle Terrace
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '243' -- The Jungle Terrace Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '324'
Snell Isle Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '236' -- Snell Isle Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '299'
-- Snell Isle Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '312'
Shore Acres Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '237' -- Shore Acres Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '351'
-- Shore Acres Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '313'
Old South East Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '238' -- Old South East Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '262'
-- Roser Park
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '263'
-- Driftwood
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '264'
-- Tropical Shores Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '327'
Caya Costa Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '239' -- Caya Costa Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '370'
-- Caya Costa Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '314'
Kenwood Area (View All)
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '244'
Bayway & Tierre Verde Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '224' -- Bayway Isles Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '347'
-- Tierre Verde Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '247'
-- Tierre Verde Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '306'
-- Isla Del Sol Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '302'
-- Dolphin Cay Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '348'
-- Dolphin Cay Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '310'
-- Bacopa Bay Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '303'
-- Point Brittany Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '301'
-- Marina Bay Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '369'
-- Marina Bay Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '368'
Old North East & Surrounding Areas
SELECT * FROM `sub_attributeoptions` WHERE `parent_optid` = '235' -- Cresent Lake
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '259'
-- Old NorthEast and Surrounding Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '311'
-- Old North East Homes
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '330'
-- Euclid St. Paul
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '258'
For Rent
Search using MAP-click RENTAL on left (Recommended)
-- Clearwater Beach Condos
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '371'
St. Pete Beach Areas
-- Pass a Grill
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '357'
-- St. Pete Beach (main area)
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '358'
-- Sunset Beach
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '361'
-- Treasure Island
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '360'
Downtown Areas (View All)
Bayway & Tierra Verde Areas
-- Tierra Verde
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '356'
-- Dolphin Cay,Bayway Isles,Marina Bay, Bacopa Bay
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '353'
-- Isla Del Sol Communities
SELECT * FROM `supersub_attributeoptions` WHERE `parent_suboptid` = '354'
