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

SELECT * FROM wp_res WHERE idx_mls_status != 'DeListed' AND (sale_or_rent = 'For Rent Only' OR sale_or_rent = 'For Rent' OR ( current_price < '50000' AND sale_or_rent = 'For Sale or Rent' )) AND (`property_type` = 'Condo') GROUP BY mls_number ORDER BY current_price DESC LIMIT 30 OFFSET 0
  • OCEAN CLUB ESTATES RENTAL

    Paradise Island

    $390,000 /Month

    VIEW DETAILS
  • OCEAN CLUB DRIVE RENTAL

    Paradise Island

    $345,000 /Month

    VIEW DETAILS
  • OCEAN CLUB DRIVE RENTAL

    Paradise Island

    $135,000 /Month

    VIEW DETAILS
  • THE OCEAN CLUB RENTAL

    Paradise Island

    $72,000 /Month

    VIEW DETAILS
  • ONE OCEAN DIVE RENTAL

    Paradise Island

    $46,500 /Month

    VIEW DETAILS
  • OCEAN CLUB RESIDENCES

    Paradise Island

    $14,500 /Month

    VIEW DETAILS
  • OCEAN CLUB DRIVE

    Paradise Island

    $14,000 /Month

    VIEW DETAILS
  • ONE OCEAN

    Paradise Island

    $7,500 /Month

    VIEW DETAILS
  • CAVES POINT

    Cable Beach

    $7,000 /Month

    VIEW DETAILS
  • CAVES HEIGHTS

    West Bay Street

    $6,100 /Month

    VIEW DETAILS
  • BAYROC

    Cable Beach

    $6,000 /Month

    VIEW DETAILS
  • BAYROC

    Cable Beach

    $6,000 /Month

    VIEW DETAILS
  • SANDYPORT DRIVE

    Cable Beach

    $6,000 /Month

    VIEW DETAILS
  • ONE OCEAN

    Paradise Island

    $5,900 /Month

    VIEW DETAILS
  • COLUMBUS COVE

    Love Beach

    $5,750 /Month

    VIEW DETAILS
  • 35 TURNBERRY TOWNHOME

    Charlotteville

    $5,500 /Month

    VIEW DETAILS
  • COLUMBUS COVE

    Love Beach

    $5,500 /Month

    VIEW DETAILS
  • WEST BAY ST

    West Bay Street

    $5,400 /Month

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $5,200 /Month

    VIEW DETAILS
  • COLUMBUS COVE

    Love Beach

    $5,200 /Month

    VIEW DETAILS
  • SANDYPORT

    Cable Beach

    $4,800 /Month

    VIEW DETAILS
  • DELAPORTE POINT

    Cable Beach

    $4,800 /Month

    VIEW DETAILS
  • BAYVIEW DRIVE

    Paradise Island

    $4,500 /Month

    VIEW DETAILS
  • NIVEN HEIGHTS

    John F. Kennedy Drive

    $4,500 /Month

    VIEW DETAILS
  • OCEANVIEW

    Lucaya

    $4,500 /Month

    VIEW DETAILS
  • EASTWIND

    Paradise Island

    $4,500 /Month

    VIEW DETAILS
  • TURNBERRY CHARLOTTEVILLE

    Charlotteville

    $4,500 /Month

    VIEW DETAILS
  • VENETIAN WEST

    637

    $4,300 /Month

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $4,300 /Month

    VIEW DETAILS
  • LOVE BEACH WALK PENTHOUSE

    Love Beach

    $5,000 /Month

    VIEW DETAILS