meta_query='key:subdist__c;value:Financial District - Barbary Coast|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319110' posts_per_page=4 post_type=property
int(1)
string(0) ""
ffd_listing_title, 333 Bush Street #4002, San Francisco, CA, 94104
ffd_mls_id, 422690659
ffd_salesforce_id, a0E8W00000YYv2QUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 45
address2__c, 333 Bush Street #4002, San Francisco, CA, 94104
pba__address_pb__c, 333 Bush Street #4002, San Francisco, CA, 94104
agent_only_remarks__c, I have a fantastic contractor who has worked in 333 Bush for many years. He knows how to get the job done and is very reliable and trustworthy.
appliances__c, Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Contemporary
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, 2022-10-14
ffd_createddate, 2022-08-29T13:46:34.000+0000
days_on_market__c, 324
dom__c, 58
ffd_description_pb, Great opportunity (remodel needed) to own in Manhattan-like boutique Financial District condo mixed-use building. Two terraces with great views. One terrace on living space/ guest bedroom. Other terrace on primary bedroom. Only 45 condos from floor 37 to 42 in this spectacular building. Location Location Location HOA Dues include: Direct TV includes premium movie panels (HBO & Showtime). Webpass high speed wired internet. Gym membership at the 333 Fit Gym. 24/7 doorman services.
333 Bush Street #4002, San Francisco, CA, 94104 - Property Description
Great opportunity (remodel needed) to own in Manhattan-like boutique Financial District condo mixed-use building. Two terraces with great views. One terrace on living space/ guest bedroom. Other terrace on primary bedroom. Only 45 condos from floor 37 to 42 in this spectacular building. Location Location Location HOA Dues include: Direct TV includes premium movie panels (HBO & Showtime). Webpass high speed wired internet. Gym membership at the 333 Fit Gym. 24/7 doorman services.
