Add "CT Compare" Widget via Appearance > Widgets > Compare.

SELECT * FROM wp_res WHERE (sale_or_rent = 'For Rent Only' OR sale_or_rent = 'For Sale or Rent') AND current_price >= 4000 AND ((`property_type` = 'Single Family Home') OR (`property_type` = 'Private Island') OR (`property_type` = 'Lots/Acreage')) GROUP BY mls_number ORDER BY current_price DESC LIMIT 21 OFFSET 0
  • PROSPECT RIDGE ROAD

    Prospect Ridge

    $3,000,000

    VIEW DETAILS
  • STARGAZER

    Emerald Bay

    $2,850,000

    VIEW DETAILS
  • LAKE CUNNINGHAM

    Lake Cunningham

    $850,000

    VIEW DETAILS
  • OCEAN CLUB ESTATES

    Paradise Island

    $65,000 /Month

    VIEW DETAILS
  • HARBOURWAY DRIVE

    Paradise Island

    $20,000 /Month

    VIEW DETAILS
  • LYFORD CAY

    Lyford Cay

    $15,000 /Month

    VIEW DETAILS
  • 24 ISLAND DRIVE

    Yamacraw

    $10,500 /Month

    VIEW DETAILS
  • EAST BAY STREET

    East Bay Street

    $10,000 /Month

    VIEW DETAILS
  • BRIGHTON PLACE

    Lyford Cay

    $9,000 /Month

    VIEW DETAILS
  • STUNNING BEACHFRONT VILLA

    Fortune Cay

    $8,500 /Month

    VIEW DETAILS
  • SOUTH OCEAN

    South Ocean

    $7,500 /Month

    VIEW DETAILS
  • SOUTH OCEAN

    South Ocean

    $7,500 /Month

    VIEW DETAILS
  • WATERCOLOR CAY

    Cable Beach

    $7,200 /Month

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $7,000 /Month

    VIEW DETAILS
  • ATLANTIC DRIVE

    West Bay Street

    $7,000 /Month

    VIEW DETAILS
  • LAKE CUNNINGHAM

    Lake Cunningham

    $6,500 /Month

    VIEW DETAILS
  • PARADISE ISLAND

    Paradise Island

    $6,500 /Month

    VIEW DETAILS
  • YAMACRAW HILL ROAD

    Yamacraw

    $6,500 /Month

    VIEW DETAILS
  • WEST BAY STREET

    West Bay Street

    $6,250 /Month

    VIEW DETAILS
  • EASTERN ROAD

    Eastern Road

    $5,800 /Month

    VIEW DETAILS
  • SANDYPORT HOME

    Cable Beach

    $5,500 /Month

    VIEW DETAILS