meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336289' 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] => 2023-06-23 08:24:10
[post_modified_gmt] => 2023-06-23 15:24:10
[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 #604, San Francisco, CA, 94109
ffd_mls_id, 423757504
ffd_salesforce_id, a0E8W00000cocMEUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 187
address2__c, 900 Bush Street #604, San Francisco, CA, 94109
pba__address_pb__c, 900 Bush Street #604, San Francisco, CA, 94109
agent_only_remarks__c, Please call Bob Walker 415-819-1291 to show. Escrow is open with Michael Gaffney (415-345-5012) at Fidelity National Title (escrow # FSFM 0062300619). Disclosure file link -https://app.disclosures.io/link/900-Bush-Street-604-77s1lvch
appliances__c, Dishwasher;Microwave;Disposal;Built-In Refrigerator;Free Standing Electric Range
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Tile;Quartz
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, George M Green
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-04T10:49:00.000+0000
days_on_market__c, 41
dom__c, 25
ffd_description_pb, Beautifully remodeled 2 bedroom / 2 bath condominium in the elegant La Galleria building. Close to both Union Square and the financial district. Home features sleek kitchen cabinets, quartz counters, and stainless steel appliances. Both bathrooms also have matching vanities with quartz tops and lighted mirrors. The wood plank laminate flooring extends throughout the residence providing a modern cohesive feel. The primary bedroom has a large walk in closet and private bath with walk in shower. One car assigned parking in a secure garage is also included. La Galleria is a full service elevator building with 24 hour doorman, fitness center, landscaped terrance with swimming pool, common laundry and professional management. HOA fee includes, heat plus cable and internet. One household pet up to 20 lbs.is permitted. Property is vacant and virtually staged.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Simulated Wood
hoa_fee_includes__c, Cable TV,Common Areas,Door Person,Elevator,Insurance,Internet,Maintenance Exterior,Management,Pool,Security,Sewer,Trash,Water
pba__hoafees__c, 1295
pba__hoafrequency_pb__c, Monthly
hoa_name__c, La Galleria Condominium Owners Assc.
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard
ffd_lastmodifieddate, 2023-09-14T10:46:30.000+0000
pba__latitude_pb__c, 37.78984
pba__latitude_property__c, 37.78984
listed_date__c, 2023-07-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bob
pba__listing_agent_lastname__c, Walker
listing_agent_mls_id__c, 805915
ffd_listingagentname, Bob Walker
listing_agent_number__c, 181518448
listing_co_agent_mls_id__c, 038605
listing_co_agent_number__c, 38605
listing_co_office_mls_id__c, GMGA
listing_co_office_name__c, GM Green Real Estate, Inc.
listing_co_office_number__c, 1151
listing_office_mls_id__c, GMGA
listing_office_name__c, GM Green Real Estate, Inc.
listing_office_number__c, 1151
pba__listingprice_pb__c, 795000
pba__listingtype__c, Sale
pba__listing_website__c, https://900bush604.com/mls
pba__longitude_pb__c, -122.412578
mls_id__c, 423757504
master_bathroom_features__c, Shower Stall(s);Quartz;Walk-In Closet
master_property__c, a0O1I000001VhzaUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-08-04
open_house_end__c, 2023-09-17T16:00:00.000+0000
open_house_start__c, 2023-09-17T14:00:00.000+0000
original_price__c, 795000
overall_days_on_market__c, -81664
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Covered Deck
pba__pendingdate__c, 1800-01-01
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 901.36
pba__propertytype__c, Condominium
ListingId, a0E8W00000cocMEUAY
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Secured Access
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 882
size__c, 882
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 900 Bush Street #604, San Francisco, CA, 94109
view__c, City Lights
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530651803-1.jpg