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

SELECT * FROM wp_res WHERE idx_mls_status != 'DeListed' AND (sale_or_rent = 'For Sale Only' OR sale_or_rent = 'For Sale' OR ( current_price > '25000' AND sale_or_rent = 'For Sale or Rent' )) AND island = 'New Providence/Paradise Island' AND area = 'Lyford Cay' AND `property_type` = 'Single Family Home' AND current_price >= 0 AND current_price <= (SELECT MAX(current_price) FROM wp_res WHERE idx_mls_status != 'DeListed' AND (sale_or_rent = 'For Sale Only' OR sale_or_rent = 'For Sale or Rent' OR sale_or_rent = 'For Sale') ) GROUP BY mls_number ORDER BY current_price DESC LIMIT 30 OFFSET 0
  • VILLA BELVEDERE

    Lyford Cay

    $10,950,000

    VIEW DETAILS
  • HIBISCUS DRIVE, LYFORD

    Lyford Cay

    $6,500,000

    VIEW DETAILS
  • COLUMBIA ROAD

    Lyford Cay

    $6,400,000

    VIEW DETAILS
  • EDGEWATER, LYFORD CAY DR

    Lyford Cay

    $5,900,000

    VIEW DETAILS
  • RAINBOW RD, LYFORD CAY

    Lyford Cay

    $4,995,000

    VIEW DETAILS
  • GARDEN GROVE

    Lyford Cay

    $4,200,000

    VIEW DETAILS
  • CHRISTIE TERRACE HOME

    Lyford Cay

    $3,000,000

    VIEW DETAILS
  • LYFORD CAY

    Lyford Cay

    $1,400,000

    VIEW DETAILS