meta_query='key:subdist__c;value:Financial District - Barbary Coast|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319294' posts_per_page=4 post_type=property
int(1)
string(0) ""
ffd_listing_title, 333 Bush Street #3804, San Francisco, CA, 94104
ffd_mls_id, 422705074
ffd_salesforce_id, a0E8W00000ZM58aUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 45
address2__c, 333 Bush Street #3804, San Francisco, CA, 94104
pba__address_pb__c, 333 Bush Street #3804, San Francisco, CA, 94104
agent_only_remarks__c, easy to show
appliances__c, Dishwasher;Microwave;Hood Over Range;Built-In Electric Range;Built-In Electric Oven
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1987
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Joseph C Silva Gonsalves
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2022-10-27T18:46:34.000+0000
days_on_market__c, 147
dom__c, 146
ffd_description_pb, Light and bright with panoramic views from the 38th floor. An updated two bedroom and two bath condo located in a boutique Financial District Class A building. This small community of only 45 homes offers 24 hour doorman services with private residential entry. The architectural garden and lobby designed by Orlando Diaz-Azcuy provide a grand entrance for residents. Living room views of MOMA in this southwest exposure and offers additional views of Bay and San Francisco landmark buildings. Valet/ Self Parking, 24-Hour Concierge, Walk Score: 99 | Transit Score: 100.
Light and bright with panoramic views from the 38th floor. An updated two bedroom and two bath condo located in a boutique Financial District Class A building. This small community of only 45 homes offers 24 hour doorman services with private residential entry. The architectural garden and lobby designed by Orlando Diaz-Azcuy provide a grand entrance for residents. Living room views of MOMA in this southwest exposure and offers additional views of Bay and San Francisco landmark buildings. Valet/ Self Parking, 24-Hour Concierge, Walk Score: 99 | Transit Score: 100.
