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' )) GROUP BY mls_number ORDER BY current_price DESC LIMIT 30 OFFSET 0
  • 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
  • RAINBOW ROAD

    Lyford Cay

    $45,000 /Month

    VIEW DETAILS
  • OCEAN CLUB ESTATES

    Paradise Island

    $25,000 /Month

    VIEW DETAILS
  • WEST BAY STREET

    Old Fort Bay

    $25,000 /Month

    VIEW DETAILS
  • 14 CANAL BEACH

    Old Fort Bay

    $15,000 /Month

    VIEW DETAILS
  • WEST BAY STREET

    Old Fort Bay

    $14,500 /Month

    VIEW DETAILS
  • PALM BREEZE DRIVE LOT S

    Carmichael Road

    $8,500 /Month

    VIEW DETAILS
  • 2 CORAL BEACH, SANDYPORT

    Cable Beach

    $7,800 /Month

    VIEW DETAILS
  • GRAPLING CLOSE

    Fortune Bay

    $7,500 /Month

    VIEW DETAILS
  • WEST BAY STREET

    Cable Beach

    $7,000 /Month

    VIEW DETAILS
  • EAST BAY STREET

    Eastern Road

    $10,000 /Month

    VIEW DETAILS
  • EMMA CLOSE

    Westridge

    $7,000 /Month

    VIEW DETAILS
  • WHISPERING WINDS

    West Bay Street

    $6,500 /Month

    VIEW DETAILS
  • WESTRIDGE

    Westridge

    $6,500 /Month

    VIEW DETAILS
  • SANDYPORT

    Cable Beach

    $6,500 /Month

    VIEW DETAILS
  • CAVES HEIGHTS

    West Bay Street

    $6,100 /Month

    VIEW DETAILS
  • BAYROC

    Cable Beach

    $6,000 /Month

    VIEW DETAILS
  • CLOISTER DRIVE WEST

    Paradise Island

    $6,000 /Month

    VIEW DETAILS
  • CLOISTER DRIVE

    Paradise Island

    $6,000 /Month

    VIEW DETAILS
  • DEVELOPMENT

    Fortune Beach

    $5,500 /Month

    VIEW DETAILS
  • COLUMBUS COVE

    Love Beach

    $5,750 /Month

    VIEW DETAILS
  • FOXHILL CREEK, EASTERN RO

    Eastern Road

    $5,500 /Month

    VIEW DETAILS
  • 5D - CAVES HEIGHTS

    West Bay Street

    $5,500 /Month

    VIEW DETAILS
  • WEST BAY ST

    West Bay Street

    $5,400 /Month

    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $5,200 /Month

    VIEW DETAILS
  • WEST BAY STREET

    West Bay Street

    $5,000 /Month

    VIEW DETAILS