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 ( rental_amount < '50000' AND sale_or_rent = 'For Sale or Rent' )) AND (`property_type` = 'Condo') GROUP BY mls_number ORDER BY current_price DESC
  • OCEAN CLUB 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
  • SEASCAPE @ WHISPERING WIN

    West Bay Street

    $7,500 /Month

    VIEW DETAILS
  • WEST BAY STREET

    Cable Beach

    $7,000 /Month

    VIEW DETAILS
  • CAVES HEIGHTS

    West Bay Street

    $6,100 /Month

    VIEW DETAILS
  • CLOISTER DRIVE WEST

    Paradise Island

    $6,000 /Month

    VIEW DETAILS
  • CLOISTER DRIVE

    Paradise Island

    $6,000 /Month

    VIEW DETAILS
  • ONE OCEAN

    Paradise Island

    $5,900 /Month

    VIEW DETAILS
  • ROYALL BEACH ESTATES

    South Ocean

    $5,500 /Month

    VIEW DETAILS
  • COLUMBUS COVE

    Love Beach

    $5,200 /Month

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $5,200 /Month

    VIEW DETAILS
  • Love Beach

    $5,200

    VIEW DETAILS
  • VISTA BELLA CABLE BEACH

    Cable Beach

    $5,000 /Month

    VIEW DETAILS
  • DELAPORTE POINT

    Cable Beach

    $4,750 /Month

    VIEW DETAILS
  • EASTWIND

    Paradise Island

    $4,500 /Month

    VIEW DETAILS
  • CAVES HEIGHTS

    West Bay Street

    $4,500 /Month

    VIEW DETAILS
  • TURNBERRY CHARLOTTEVILLE

    Charlotteville

    $4,500 /Month

    VIEW DETAILS
  • OCEANVIEW

    Lucaya

    $4,500 /Month

    VIEW DETAILS
  • NIVEN HEIGHTS

    John F. Kennedy Drive

    $4,500 /Month

    VIEW DETAILS
  • DELAPORTE

    Cable Beach

    $4,500

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $4,300 /Month

    VIEW DETAILS
  • MIRAMAR WEST, LOVE BEACH

    West Bay Street

    $4,200 /Month

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $4,200 /Month

    VIEW DETAILS
  • 64 NAUTICA

    West Bay Street

    $4,000 /Month

    VIEW DETAILS
  • BAYVIEW LANE, PARADISE IS

    Paradise Island

    $4,000 /Month

    VIEW DETAILS
  • WEST BAY STREET

    West Bay Street

    $4,000 /Month

    VIEW DETAILS
  • BALMORAL DEVELOPMENTS

    Cable Beach

    $4,000 /Month

    VIEW DETAILS