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 150
  • HAMPSHIRE ST CABLE BEACH

    Cable Beach

    $1,400 /Month

    VIEW DETAILS
  • BUTTERFLY COTTAGE RENTAL

    Yamacraw

    $1,400 /Month

    VIEW DETAILS
  • MONTAGU VILLAS

    Village Road

    $1,325 /Month

    VIEW DETAILS
  • HIGH POINT ESTATES RENTAL

    John F. Kennedy Drive

    $1,200 /Month

    VIEW DETAILS
  • HIGH POINT ESTATES RENTAL

    John F. Kennedy Drive

    $1,200 /Month

    VIEW DETAILS
  • JUBILEE GARDENS

    Gladstone Road

    $1,200 /Month

    VIEW DETAILS
  • 8 HILL COURT

    Windsor Park

    $1,000 /Month

    VIEW DETAILS
  • 11A CONFEDERATES WALK

    Bahamia

    $850 /Month

    VIEW DETAILS
  • BUNCA COURT

    East Street

    $800 /Month

    VIEW DETAILS
  • BISHOP'S ROAD

    Greening Glade

    $700 /Month

    VIEW DETAILS
  • SANDYPORT DRIVE

    Cable Beach

    $2,750 /Month

    VIEW DETAILS