meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213084' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70672
[post_author] => 4
[post_date] => 2018-11-30 20:30:47
[post_date_gmt] => 2018-11-30 20:30:47
[post_content] => Not quite as glamorous as the Financial District, not quite as tough as the Tenderloin. Midrise mixed-use buildings dominate in the district that includes tourist-heavy destinations and world-class shopping district Union Square.
[post_title] => Downtown
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => downtown
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:10:22
[post_modified_gmt] => 2024-04-09 18:10:22
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70672
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 900 Bush Street #820, San Francisco, CA, 94109
ffd_mls_id, 500830
ffd_salesforce_id, a0E1I00000SxtepUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 194
address2__c, 900 Bush Street #820, San Francisco, CA, 94109
pba__address_pb__c, 900 Bush Street #820, San Francisco, CA, 94109
agent_only_remarks__c, Vacant, staged and ready to show. Showing instructions: PRIOR to requesting a showing, please review disclosures https://app.disclosures.io/link/900-Bush-Street-820-i9rsvswt, online photos and 3D video tour 900bushst.com. Send the signed Disclosure Packet Cover Sheet, PEAD-V, BPPP (Best Practices Guidelines and Prevention Plan), and buyer's pre-approval letter or proof of funds. All COVID documents and detailed showing instructions are available in the disclosure packet. Please email the required showing forms to [email protected] and request the showing time. Escrow is opened with Gerrie Brindley at Chicago Title, [email protected]. Offers will be submitted on most current 7-page SFAR contract. If needed, a blank SFAR contract is included in the disclosures. Prospective purchasers are advised to independently verify accuracy of square footage and to review any disclosure information before submitting offers.
appliances__c, Dishwasher;Electric Range;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1982
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-07-05
ffd_createddate, 2020-07-02T01:45:52.000+0000
days_on_market__c, 1113
dom__c, 12
ffd_description_pb, Elegant top floor corner condo with huge picture windows framing views of the Downtown skyline, flooded with natural light. Downtown views are also seen from the kitchen window, which features stainless appliances, granite counters and an adjoining walk-in pantry. The main bedroom enjoys a huge closet and an en suite bathroom. The small second bedroom/office is across from the guest bathroom and features a desk alcove. The well-designed residence enjoys polished hardwood floors and 2 balconies. There is assigned parking for one car in a secure garage. Additional parking and storage are available for lease. La Galleria is a full service building with a 24x7 lobby attendant and 24x7 security attendant, elevators, shared laundry, fitness center and swimming pool. HOA dues of $1,042.90/mo include cable, internet and everything except electricity. The neighborhood enjoys world class dining, a Walkscore of 99 and the ultimate city experience in shopping and entertainment.
district__c, SF District 8
entry_level__c, 8
external_listing__c, 1
pba__floor__c, 8
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 1042.9
hoa_fee_includes__c, Management,Cable TV,Door Person,Maintenance Exterior,Trash,Maintenance Grounds,Heat,Homeowners Insurance,Security,Water
pba__hoafees__c, 1042
pba__hoafrequency_pb__c, Monthly
hoa_name__c, La Galleria Condominiu Owners Assn.
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard
ffd_lastmodifieddate, 2022-01-25T15:26:46.000+0000
pba__latitude_pb__c, 37.78988
pba__latitude_property__c, 37.78988
listed_date__c, 2020-05-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Solaegui
listing_agent_mls_id__c, 803722
ffd_listingagentname, John R Solaegui
listing_agent_number__c, 803722
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 839000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.900bushst.com
pba__longitude_pb__c, -122.412327
pba__lotsize_pb__c, 0
mls_id__c, 500830
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room
master_property__c, a0O8W00000Dagu7UAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-07-01
original_price__c, 839000
overall_days_on_market__c, 91
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-07-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 968.82
pba__propertytype__c, Condominium
id, a0E1I00000SxtepUAB
sale_date__c, 2020-07-15
sale_price__c, 839000
selling_agent_mls_id__c, 808606
selling_agent_name__c, Christian Buckley
selling_agent_number__c, 1037210
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 866
size__c, 866
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 900 Bush Street #820, San Francisco, CA, 94109
transportation__c, 1 Block
unit_number__c, 820
view__c, City Lights;Downtown;San Francisco
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1982
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/365672-1.jpg
ListingId, a0E1I00000SxtepUAB