meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216577' 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 #214, San Francisco, CA, 94109
ffd_mls_id, 510160
ffd_salesforce_id, a0E1I00000TvYCyUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 194
address2__c, 900 Bush Street #214, San Francisco, CA, 94109
pba__address_pb__c, 900 Bush Street #214, San Francisco, CA, 94109
agent_only_remarks__c, Property is vacant, staged and easy to show. Covid compliant showings by appt with signed PEAD: text Robert at (415) 425-8304 or email [email protected]. Please use SFAR PA Disclosures available at Disclosures.i.o
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Ice Maker
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Tile;Granite
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1982
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Robert Merryman
pba__contingentdate__c, 2021-02-14
ffd_createddate, 2021-01-15T20:46:13.000+0000
days_on_market__c, 915
dom__c, 42
ffd_description_pb, Not your everyday downtown condo! Stylish and serene with a rare spacious private patio and peaceful urban vibe! This one is in the BACK of the building, NOT on Bush. Freshly painted with newly refinished hardwood floors. Clean lines showcase the open floor plan. The efficient kitchen with new appliances has counter height seating and is open to the living/dining area. Direct access to a generous private patio. The restful bedroom has outlooks to the patio and courtyard. The high-touch high-service La Galleria HOA amenities include 24/7 lobby attendants/security, professionally landscaped courtyard perfect for socially distant outdoor gatherings or work from home outside. One-car garage parking. On-site laundry (credit card-enabled). Storage space available for rent. Convenience is key and rated with 99 Walkscore'. Easy access to Union Square and the Financial District.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 990
hoa_fee_includes__c, Cable TV,Door Person,Heat,Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c, 1088
pba__hoafrequency_pb__c, Monthly
hoa_name__c, La Gallaria Condo Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard
ffd_lastmodifieddate, 2022-01-25T15:42:32.000+0000
pba__latitude_pb__c, 37.789893
pba__latitude_property__c, 37.789893
listed_date__c, 2021-01-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Melodie
pba__listing_agent_lastname__c, Duke
listing_agent_mls_id__c, 244901
ffd_listingagentname, Melodie Duke
listing_agent_number__c, 244901
listing_co_agent_mls_id__c, 804452
listing_co_agent_number__c, 166014009
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 575000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.412311
pba__lotsize_pb__c, 0
mls_id__c, 510160
main_level__c, Full Bath(s);Bedroom(s);Kitchen
master_property__c, a0O1I000001VhzaUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-01-15
original_price__c, 575000
overall_days_on_market__c, 90
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-02-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 903.43
pba__propertytype__c, Condominium
id, a0E1I00000TvYCyUAN
sale_date__c, 2021-03-04
sale_price__c, 580000
selling_agent_mls_id__c, 244901
selling_agent_number__c, 244901
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 642
size__c, 642
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 900 Bush Street #214, San Francisco, CA, 94109
transportation__c, 3 Blocks
unit_number__c, 214
view__c, Garden/Greenbelt
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/375715-1.jpg
ListingId, a0E1I00000TvYCyUAN