meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217537' 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 #717, San Francisco, CA, 94109
ffd_mls_id, 421525302
ffd_salesforce_id, a0E1I00000TwIbeUAF
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 194
address2__c, 900 Bush #717, San Francisco, CA, 94109
pba__address_pb__c, 900 Bush #717, San Francisco, CA, 94109
agent_only_remarks__c, STILL SHOWING! Request a covid-compliant showing with Lauren or Stu using Calendly link: https://calendly.com/steven-gerry/900-bush-717?month=2021-04. Please review all photos and virtual info at 900Bush-717.com before requesting a showing. Showings are available in 25 minute increments to allow time for cleanings in between showings. If you don't see your preferred showing time please contact Stu via text at 415.876.2849. Please note that you are not confirmed until you have filled out and emailed the PEAD-V to book an appointment AND have received a confirmation text/email. HOA does not allow common area tours during COVID. We can coordinate a separate video tour for interested parties. Offers anytime.
architectural_style__c, Contemporary
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, Steven C Gerry
pba__contingentdate__c, 2021-04-26
ffd_createddate, 2021-03-04T23:47:34.000+0000
days_on_market__c, 867
dom__c, 73
ffd_description_pb, New Price! Light filled VIEW condo features picture windows framing San Francisco's stunning skyline. The well maintained condo has an open plan living/dining area, kitchen features a breakfast bar and stainless steel appliances. The large primary en-suite bedroom has abundant closet space; the second bedroom (currently used as a dining room) can be used as a bedroom, home office or guest room, a full hall bath and one car designated on site parking complete the package. La Galleria is a full service building with a 24x7 lobby attendant and security attendant, elevators, shared laundry, fitness center & swimming pool. HOA dues of $1144 per month include everything except electric. The neighborhood enjoys world class dining, galleries, theaters. This condo has it ALL!
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Simulated Wood
hoa_fee_includes__c, Cable TV,Door Person,Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Security,Trash,Water
pba__hoafees__c, 1144
pba__hoafrequency_pb__c, Monthly
hoa_name__c, La Galeria
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:46:24.000+0000
pba__latitude_pb__c, 37.789893
pba__latitude_property__c, 37.789893
listed_date__c, 2021-03-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lauren
pba__listing_agent_lastname__c, O'Brien
listing_agent_mls_id__c, 400152
ffd_listingagentname, Lauren M O'Brien
listing_agent_number__c, 979968042
listing_co_agent_mls_id__c, 808795
listing_co_agent_number__c, 1037611
listing_co_office_mls_id__c, CGL01
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28273
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 765000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.412311
mls_id__c, 421525302
master_property__c, a0O1I000001VhzaUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-03-04
original_price__c, 799000
overall_days_on_market__c, 122
parking_access__c, Independent
parking_features__c, Assigned,Garage Door Opener,Underground Parking
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-05-16
pba__pool_pb__c, 1
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 810.21
pba__propertytype__c, Condominium
id, a0E1I00000TwIbeUAF
sale_date__c, 2021-05-25
sale_price__c, 730000
security_features__c, Secured Access
selling_agent_mls_id__c, 804040
selling_agent_number__c, 166013457
selling_co_agent_mls_id__c, 400242
selling_co_agent_number__c, 1022227
selling_co_office_mls_id__c, STERLING
selling_co_office_name__c, Sterling Homes
selling_co_office_number__c, 27576
selling_office_name__c, Sterling Homes
pba__status__c, Closed
pba__totalarea_pb__c, 901
size__c, 901
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 900 Bush #717, San Francisco, CA, 94109
view__c, City Lights;Downtown;San Francisco
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/530193535-1.jpg
ListingId, a0E1I00000TwIbeUAF