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

  • For Sale
  • For Rent
SELECT * FROM wp_res WHERE (sale_or_rent = 'For Rent Only' OR sale_or_rent = 'For Sale or Rent') AND current_price >= 4000 AND ((`property_type` = 'Single Family Home') OR (`property_type` = 'Private Island') OR (`property_type` = 'Lots/Acreage')) GROUP BY mls_number ORDER BY current_price DESC LIMIT 21 OFFSET 0
  • PROSPECT RIDGE ROAD

    Prospect Ridge

    $3,000,000

    • 4Bed
    • 4Bath
    • 8000 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • STARGAZER

    Emerald Bay

    $2,850,000

    • 4Bed
    • 4Bath
    • 3100 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • LAKE CUNNINGHAM

    Lake Cunningham

    $850,000

    • 4Bed
    • 3Bath
    • 4065 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • OCEAN CLUB ESTATES

    Paradise Island

    $65,000 /Month

    • 6Bed
    • 6Bath
    • 8850 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • HARBOURWAY DRIVE

    Paradise Island

    $20,000 /Month

    • 6Bed
    • 6Bath
    • 7521 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • LYFORD CAY

    Lyford Cay

    $15,000 /Month

    • 4Bed
    • 4Bath
    • 3800 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • 24 ISLAND DRIVE

    Yamacraw

    $10,500 /Month

    • 5Bed
    • 4Bath
    • 6918 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • EAST BAY STREET

    East Bay Street

    $10,000 /Month

    • 3Bed
    • 3Bath
    • 2250 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • BRIGHTON PLACE

    Lyford Cay

    $9,000 /Month

    • 3Bed
    • 3Bath
    • 25000 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • STUNNING BEACHFRONT VILLA

    Fortune Cay

    $8,500 /Month

    • 5Bed
    • 7Bath
    • 6000 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • SOUTH OCEAN

    South Ocean

    $7,500 /Month

    • 3Bed
    • 2Bath
    • 7000 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • SOUTH OCEAN

    South Ocean

    $7,500 /Month

    • 3Bed
    • 2Bath
    • 8000 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • WATERCOLOR CAY

    Cable Beach

    $7,200 /Month

    • 3Bed
    • 3Bath
    • 2800 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • CHARLOTTEVILLE

    Charlotteville

    $7,000 /Month

    • 4Bed
    • 3Bath
    • 3500 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • ATLANTIC DRIVE

    West Bay Street

    $7,000 /Month

    • 3Bed
    • 2Bath
    • 3880 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • LAKE CUNNINGHAM

    Lake Cunningham

    $6,500 /Month

    • 5Bed
    • 6Bath
    • 5609 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • PARADISE ISLAND

    Paradise Island

    $6,500 /Month

    • 5Bed
    • 4Bath
    • 8650 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • YAMACRAW HILL ROAD

    Yamacraw

    $6,500 /Month

    • 5Bed
    • 5Bath
    • 4057 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • WEST BAY STREET

    West Bay Street

    $6,250 /Month

    • 3Bed
    • 3Bath
    • 2348 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • EASTERN ROAD

    Eastern Road

    $5,800 /Month

    • 4Bed
    • 4Bath
    • 3000 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS
  • SANDYPORT HOME

    Cable Beach

    $5,500 /Month

    • 4Bed
    • 3Bath
    • 2800 Sq Ft
    • Albany Marina ResidencesBuilding
    VIEW DETAILS