meta_query='key:subdist__c;value:Yerba Buena|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338368' 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] => 2024-04-17 08:01:07
[post_modified_gmt] => 2024-04-17 15:01:07
[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, 766 Harrison Street #706, San Francisco, CA, 94107
ffd_mls_id, 423723003
ffd_salesforce_id, a0E8W00000bFYv8UAG
num_of_fireplaces__c, 0
num_of_rooms__c, 2
of_units__c, 103
address2__c, 766 Harrison Street #706, San Francisco, CA, 94107
pba__address_pb__c, 766 Harrison Street #706, San Francisco, CA, 94107
agent_only_remarks__c, No lockbox, call or text David at 415 828-3615 for an appointment. Disclosure link: https://app.disclosures.io/link/766-Harrison-Street-706-40l8dy2q Rentals allowed - 30 day minimum. Pets ok (breed and number restrictions). Deeded storage locker S-10 included. The building is FHA and VA approved. Pre-escrow with Katarina Rosignuolo at DOMA. Offers on SF Purchase Agreement please.
appliances__c, Dishwasher;Microwave;Electric Cook Top;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 2008
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-07-19
ffd_createddate, 2023-03-10T17:49:08.000+0000
days_on_market__c, 200
dom__c, 165
ffd_description_pb, Welcome to the SF Cubix! A modern SOMA building with stylish features like polished concrete floors with radiant heat, stainless steel appliances, exposed concrete walls and frosted glass doors. Unit #706 has an efficient kitchen that includes a dishwasher, convection microwave oven, cooktop, and mini fridge. This unit has its own private balcony plus a deeded storage room in the basement for additional storage! Bring your nightcap outside and enjoy the downtown views and evening Salesforce Tower lightshow from your balcony! Building amenities include bike parking and a spacious roof deck with three covered cabanas and two BBQ grills. The roof deck has 360 degree views of the city and is a great space for entertaining and relaxing. Excellent location for commuters - walk to CalTrain and BART and easy freeway access. Whole Foods is next door and you're four blocks to Union Square. Walk Score 97. Transit Score 100. Bike Score 86. Low HOA dues!
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Concrete
hoa_fee_includes__c, Common Areas,Elevator,Heat,Insurance on Structure,Maintenance Exterior,Management,Sewer,Trash,Water
pba__hoafees__c, 283
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 766 Harrison Street Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor
ffd_lastmodifieddate, 2023-09-27T01:48:35.000+0000
pba__latitude_pb__c, 37.781671
pba__latitude_property__c, 37.781671
listed_date__c, 2023-03-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Fusco
listing_agent_mls_id__c, 809651
ffd_listingagentname, David Fusco
listing_agent_number__c, 1042415
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, GROB
listing_office_name__c, Grobecker Holland International Inc.
listing_office_number__c, 24034
pba__listingprice_pb__c, 369000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.399166
mls_id__c, 423723003
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Low-Flow Shower(s);Radiant Heat
master_property__c, a0O1I000001VhkYUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-03-10
original_price__c, 375000
overall_days_on_market__c, -81517
pba__pendingdate__c, 2023-09-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000bFYv8UAG
sale_date__c, 2023-09-12
sale_price__c, 358000
security_features__c, Secured Access
selling_agent_mls_id__c, 818536
selling_agent_number__c, 1077270
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Dotown, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Harrison
subdist__c, Yerba Buena
ffd_name, 766 Harrison Street #706, San Francisco, CA, 94107
view__c, City Lights
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2008
pba__postalcode_pb__c, 94107
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530589227-1.jpg
_edit_lock, 1711735706:1564
_edit_last, 1564
_yoast_indexnow_last_ping, 1711735840
_price_reduced__c, field_61ce1b15d3a3f
_has_3d_tour__c, field_61ce1b4cd3a40
_ListingId, field_62bf231ba1405
_pba__latitude_pb__c, field_62c436cc3ee02
_pba__longitude_pb__c, field_62c436f43ee03
_yoast_wpseo_content_score, 90
_yoast_wpseo_focuskeywords, []
_yoast_wpseo_keywordsynonyms, [""]
_yoast_wpseo_estimated-reading-time-minutes, 1
_yoast_wpseo_canonical, https://jacksonfuller.com/property/766-harrison-street-706-san-francisco-ca-94107-2/