meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='341455' 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
(
)
)
_yoast_indexnow_last_ping, 1699531781
ffd_listing_title, 900 Bush Street #521, San Francisco, CA, 94109
ffd_mls_id, 423900474
ffd_salesforce_id, a0E8W00000dTw6wUAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 187
address2__c, 900 Bush Street #521, San Francisco, CA, 94109
pba__address_pb__c, 900 Bush Street #521, San Francisco, CA, 94109
agent_only_remarks__c, Offers on SFAR Purchase Agreement + include Contingency Removal Form. Text Tabre Hess at 415-805-2360 for questions and to arrange private showings. https://www.900bush521.com/ | For lending information contact Colette Evans or Cross Country Mortgage - (415)322-3174 or (617)981-0993 / [email protected]. Pre-escrow opened with Steve Salviejo with WFG National Title Company. Sellers prefer to leave here.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1982
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-29T10:47:40.000+0000
days_on_market__c, 41
dom__c, 31
ffd_description_pb, Welcome to the 5th floor's remodeled corner condo in the full-service building known as, La Galleria. Enjoy a morning cup of coffee and an evening glass of wine on different balconies - #521 has two detached balconies w/ unique view corridors. This 2BR/2BA w/ Parking provides both Southern and Eastern exposures rich with natural light and city views. La Galleria offers ample amenities including a spacious, fully equipped, fitness center, EV charging, and, a swimming pool in a landscaped courtyard. Additionally, the HOA dues provide a plethora of conveniences. Internet, Cable, Heat, Water, Garbage, Parking, a Concierge, Professional Management, Building Maintenance, Insurance, and, a 24-hour Doorman who welcomes guests and collects packages, are all-inclusive. Storage spaces are available in the complex on a leased basis. Finally, location - this neighborhood is a walker's paradise being only a few blocks distance from all there is to do around Union Square (French Club), Huntington Park (Grace Cathedral), and the boutique shops, cafes, restaurants, gyms and nightlife located on, and before, Polk St.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
hoa_fee_includes__c, Cable TV,Door Person,Elevator,Heat,Insurance on Structure,Internet,Maintenance Exterior,Management,Pool,Recreation Facility,Security,Sewer,Trash,Water,See Remarks
pba__hoafees__c, 1310
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-11-09T11:47:45.000+0000
pba__latitude_pb__c, 37.789953
pba__latitude_property__c, 37.789953
listed_date__c, 2023-08-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tabre
pba__listing_agent_lastname__c, Hess
listing_agent_mls_id__c, 811731
ffd_listingagentname, Tabre Hess
listing_agent_number__c, 1053350
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 698000
pba__listingtype__c, Sale
pba__listing_website__c, http://900bush521.com/mls
pba__longitude_pb__c, -122.412745
mls_id__c, 423900474
master_property__c, a0O1I000001VhzaUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-09-29
original_price__c, 898000
overall_days_on_market__c, -81720
parking_access__c, Side by Side
parking_features__c, Attached
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-11-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-08T16:47:57.000+0000
price_per_square_foot__c, 618.15
pba__propertytype__c, Condominium
ListingId, a0E8W00000dTw6wUAC
sale_date__c, 2023-11-08
sale_price__c, 620000
selling_agent_mls_id__c, MLSL5090041
selling_agent_number__c, 981375658
selling_co_agent_mls_id__c, EB126680
selling_co_agent_number__c, 981306941
selling_co_office_mls_id__c, 22313
selling_co_office_name__c, Compass
selling_co_office_number__c, 981070629
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 1003
size__c, 1003
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 900 Bush Street #521, San Francisco, CA, 94109
view__c, City;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/530662354-1.jpg