Current Listings ActiveActiveFor Sale For Lease For Sale & Lease Pending Active Under Contract ClosedSold Leased Off Market Expired Canceled — Any Beds 1+ Beds 2+ Beds 3+ Beds 4+ Beds 5+ Beds Any Baths 1+ Baths 2+ Baths 3+ Baths 4+ Baths Any Area Pacific Heights | Presidio Heights | Cow Hollow Marina Russian Hill | Telegraph Hill | North Beach | Financial District | Nob Hill Sea Cliff Noe Valley | Twin Peaks | Dolores Heights Sausalito Tiburon | Belvedere Mill Valley Larkspur Greenbrae Kentfield Ross Stinson Beach | Bolinas You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (CASE WHEN listings.listing_status = 1 THEN list_price WHEN listings.list' at line 13