meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='333769' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15736
[post_author] => 4
[post_date] => 2018-11-02 20:00:55
[post_date_gmt] => 2018-11-02 20:00:55
[post_content] => Cultural haven. Home to that high-rise. If any SF neighborhood comes remotely close to vaguely feeling like Manhattan, the hustle and bustle of Yerba Buena probably comes closest. Yes, you are south of Market. But this is Yerba Buena.
[post_title] => Yerba Buena
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => yerba-buena
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 10:58:01
[post_modified_gmt] => 2023-06-23 17:58:01
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15736
[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, 870 Harrison Street #301, San Francisco, CA, 94107
ffd_mls_id, 423749785
ffd_salesforce_id, a0E8W00000cJfwgUAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 26
address2__c, 870 Harrison Street #301, San Francisco, CA, 94107
pba__address_pb__c, 870 Harrison Street #301, San Francisco, CA, 94107
agent_only_remarks__c, Easy to show with supra in lobby. Please contact Sabrina Kwok @ 415.217.9621 for entrance code and details. Disclosures : https://app.disclosures.io/link/870-Harrison-Street-301-0fjdehaj
appliances__c, Dishwasher;Disposal;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Bidet;Jack & Jill
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2015
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-08-30
ffd_createddate, 2023-06-21T10:48:44.000+0000
days_on_market__c, 77
dom__c, 61
ffd_description_pb, This 1 bed, 1 bath unit w/parking offers a perfect blend of sophistication, style, and convenience. Situated in a location with easy access to major highways, public transportations, and an array of amenities, this residence is the epitome of urban living. Upon entering, you'll be greeted by an open layout design that maximizes space and creates a seamless flow. The floor-to-ceiling windows allow natural sunlight to flood the interior, creating a warm and inviting ambiance. The captivating city views can be admired from the comfort of your own home, as well as from the rooftop deck, where you can relax and entertain guests while enjoying a BBQ. The kitchen is a chef's delight, featuring stainless steel appliances, plentiful cabinets, and gleaming countertops. Multiple closets provide ample storage space and a home office niche offers a dedicated area for work or study. Luxuries such as the radiant floor heating throughout and in-unit washer and dryer ensures your comfort all year round. Parking will never be a hassle, as this condo comes with an assigned spot in the gated garage, while bike storage offers a convenient solution for active residents. Additionally, the HOA covers essential services such as water, garbage, gas, and even WiFi internet, ensuring a hassle-free lifestyle
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet
hoa_fee_includes__c, Common Areas,Gas,Internet,Trash,Water
pba__hoafees__c, 713
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Radiant Floor
ffd_lastmodifieddate, 2023-09-07T00:46:24.000+0000
pba__latitude_pb__c, 37.779765
pba__latitude_property__c, 37.779765
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-06-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sabrina
pba__listing_agent_lastname__c, Kwok
listing_agent_mls_id__c, 808630
ffd_listingagentname, Sabrina Kwok
listing_agent_number__c, 1037368
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SQRE
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28627
pba__listingprice_pb__c, 599000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.401387
mls_id__c, 423749785
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_property__c, a0O1I000001Vi7fUAC
monthly_parking_fees__c, 44
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-21
original_price__c, 649000
overall_days_on_market__c, -81620
parking_access__c, Independent
parking_features__c, Assigned,Attached,Enclosed,Garage Door Opener,Private,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 953.82
pba__propertytype__c, Condominium
ListingId, a0E8W00000cJfwgUAC
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 628
size__c, 628
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Harrison
subdist__c, Yerba Buena
ffd_name, 870 Harrison Street #301, San Francisco, CA, 94107
view__c, City
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2015
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530634704-1.jpg