meta_query='key:subdist__c;value:Downtown|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214358' 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 #705, San Francisco, CA, 94109
ffd_mls_id, 504722
ffd_salesforce_id, a0E1I00000TG54IUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 194
address2__c, 900 Bush Street #705, San Francisco, CA, 94109
pba__address_pb__c, 900 Bush Street #705, San Francisco, CA, 94109
agent_only_remarks__c, Request a covid-compliant showing with Stu at https://calendly.com/steven-gerry/900-bush-street705?month=2020-09. Please review all photos and virtual info at 900Bush-705.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.Offers anytime.
appliances__c, Dishwasher;Electric Range;Microwave;Refrigerator
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Remodeled
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, Steven C Gerry
pba__contingentdate__c, 2020-09-30
ffd_createddate, 2020-08-27T21:46:56.000+0000
days_on_market__c, 1056
dom__c, 47
ffd_description_pb, Elegant light filled VIEW condo features picture windows framing San Francisco's stunning skyline. Completely renovated in 2017 the large, open floor plan offers wide plank flooring, energy efficient LED light fixtures, Shade Store window shades & more! The kitchen highlights incl. new appliances, custom cabinets, Grohe fixtures, imported designer tile, organic quartz countertops, backsplash & bar. Step into the spa like bathroom with walk-in shower, Duravit vanity, Grohe fixtures, marble niche, & Porcelanosa tile. Bedroom upgrades incl. French doors, plus a customized walk-through closet with designer hooks & brushed stainless steel hardware. 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 $994/mo incl. everything except electric. The neighborhood enjoys world class dining, galleries, theaters. This condo has it ALL!
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Tile;Simulated Wood
hoa_dues__c, 944.03
hoa_fee_includes__c, Management,Cable TV,Door Person,Maintenance Exterior,Trash,Maintenance Grounds,Homeowners Insurance,Security,Water
pba__hoafees__c, 944
hoa_name__c, La Galleria Condominium Owners Assn.
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:32:28.000+0000
pba__latitude_pb__c, 37.789893
pba__latitude_property__c, 37.789893
listed_date__c, 2020-08-26
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, 725000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.412311
pba__lotsize_pb__c, 0
mls_id__c, 504722
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O8W00000Dagu7UAB
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-08-27
original_price__c, 725000
overall_days_on_market__c, 184
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-10-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1055.72
pba__propertytype__c, Condominium
id, a0E1I00000TG54IUAT
sale_date__c, 2020-10-29
sale_price__c, 720000
selling_agent_mls_id__c, 814558
selling_agent_name__c, Cindy Manning
selling_agent_number__c, 1067132
selling_co_agent_mls_id__c, 807278
selling_co_agent_name__c, Joshua A. Lawrence
selling_co_agent_number__c, 1013874
selling_co_office_mls_id__c, COMP4
selling_co_office_name__c, Compass
selling_co_office_number__c, 27592
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 682
size__c, 682
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bush
subdist__c, Downtown
ffd_name, 900 Bush Street #705, San Francisco, CA, 94109
transportation__c, 1 Block
unit_number__c, 705
view__c, Panoramic;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/369140-1.jpg
ListingId, a0E1I00000TG54IUAT