meta_query='key:subdist__c;value:South of Market|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319345' posts_per_page=4 post_type=property
bool(false)
string(0) ""
ffd_listing_title 85 Columbia Square 85A Square, San Francisco, CA, 94103
ffd_mls_id 422708274
ffd_salesforce_id a0E8W00000ZN5oOUAT
num_of_rooms__c 12
of_units__c 2
address2__c 85 Columbia Square 85A Square, San Francisco, CA, 94103
pba__address_pb__c 85 Columbia Square 85A Square, San Francisco, CA, 94103
agent_only_remarks__c Showings by appt. Easy to show. Owners currently using mezzanine office + garage for their business. Will vacate upon COE. (Note: city records say 2 units, but the building actually serves as 3. Two living spaces: Upstairs 4 BR apt -(85 Columbia Sq), Ground floor live/work 2Br apt (85A Columbia Sq), plus the Garage + Office mezzanine which is used separately & with address 171 Harriet St.)
appliances__c Dishwasher;Gas Water Heater;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c Contemporary
pba__fullbathrooms_pb__c 0
pba__bedrooms_pb__c 6
year_build_text__c 1921
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
cooling__c None
ffd_createddate 2022-11-14T18:46:45.000+0000
days_on_market__c 14
dom__c 0
ffd_description_pb A truly unique Live/Work Investment + Flex property. Great for both Owner/User or Investor/Developer. Mixed use residential and commercial building with development potential in the heart of SOMA. 2 floors + huge garage with frontage on both Columbia Square and Harriet Street. Views onto the park from the top floor residential unit features 4 bedrooms, 1 1/2 bath, updated kitchen, tons of natural light, washer/dryer - and opens to a private, sunny roofdeck. The ground floor live/work space features high ceilings, 2 private bedrooms, 1 bathrooms, large kitchen, and skylights - not to mention enough space for a dance studio, offices, light industrial, etc. AND - up to 2 car (or 3 small cars) tandem parking in the large garage + mezzanine office, conference room, kitchenette & full bathroom. Tons of amperage, fully sprinklered, and smart upgrades. Live here yourself, keep as a cash-flow investment property, or take advantage of new high-density zoning opportunities and build up! (Note: City records say 2 units, but this property actually serves as 3 distinct units: Garage + office mezzanine used separately & with different address: 172 Harriet St. Photos shown with staging, now removed.)
district__c SF District 9
external_listing__c 1
pba__floortype_pb__c Concrete;Tile;Wood;Varies by Unit
A truly unique Live/Work Investment + Flex property. Great for both Owner/User or Investor/Developer. Mixed use residential and commercial building with development potential in the heart of SOMA. 2 floors + huge garage with frontage on both Columbia Square and Harriet Street. Views onto the park from the top floor residential unit features 4 bedrooms, 1 1/2 bath, updated kitchen, tons of natural light, washer/dryer - and opens to a private, sunny roofdeck. The ground floor live/work space features high ceilings, 2 private bedrooms, 1 bathrooms, large kitchen, and skylights - not to mention enough space for a dance studio, offices, light industrial, etc. AND - up to 2 car (or 3 small cars) tandem parking in the large garage + mezzanine office, conference room, kitchenette & full bathroom. Tons of amperage, fully sprinklered, and smart upgrades. Live here yourself, keep as a cash-flow investment property, or take advantage of new high-density zoning opportunities and build up! (Note: City records say 2 units, but this property actually serves as 3 distinct units: Garage + office mezzanine used separately & with different address: 172 Harriet St. Photos shown with staging, now removed.)
