meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222423' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 11:31:42
[post_modified_gmt] => 2024-04-09 18:31:42
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[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, 8 Buchanan Street #401, San Francisco, CA, 94102
ffd_mls_id, 422621359
ffd_salesforce_id, a0E8W00000V32xZUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 115
address2__c, 8 Buchanan Street #401, San Francisco, CA, 94102
pba__address_pb__c, 8 Buchanan Street #401, San Francisco, CA, 94102
agent_only_remarks__c, Pre-sale escrow with Bethe Battalio of Fidelity Tile Co. Disclosure link: https://app.disclosures.io/link/8-Buchanan-Street-401-a83dcs7c. Call Laraine to show (415) 565-1744. Still open 1/22 and 1/23 from 2-4p!
appliances__c, Built-In Refrigerator
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 2014
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Laraine Hsu
pba__contingentdate__c, 2022-01-21
ffd_createddate, 2022-01-17T17:45:57.000+0000
days_on_market__c, 548
dom__c, 30
ffd_description_pb, Modern luxury living at Linea! This light-filled 2 bedrooms and 1 bath home was built in 2014 by noted architect Bernardo Fort-Brescia. This sophisticated building offers an elegant and expansive attended lobby, finished with porcelain tile floors, natural white-oak wood panels and Italian marble highlights. This elevator building features a spectacular roof top deck with panoramic views of the city and multiple outdoor areas to entertain and enjoy the city views. The well-designed condo features floor to ceiling windows and views of Twin Peaks. With a Walk Score of 99 and transit score of 95, this premier location delivers the ultimate urban location centered between Duboce Triangle, Hayes Valley and Castro offering ease of access to multiple restaurants, Whole Foods, Safeway, Muni across the street, BART and nearby tech shuttles.
district__c, SF District 6
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
hoa_fee_includes__c, Common Areas,Door Person,Maintenance Grounds,Management,Trash
pba__hoafees__c, 557
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Linea Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-02-20T11:47:40.000+0000
pba__latitude_pb__c, 37.770074
pba__latitude_property__c, 37.770074
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-01-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robin
pba__listing_agent_lastname__c, Dustan
listing_agent_mls_id__c, 263597
ffd_listingagentname, Robin L Dustan
listing_agent_number__c, 263597
listing_co_agent_mls_id__c, 810237
listing_co_agent_number__c, 1045100
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 848000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.426208
mls_id__c, 422621359
main_level__c, Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I000001VhmeUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-01-17
original_price__c, 848000
overall_days_on_market__c, 88
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 2022-02-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-02-19T15:26:25.000+0000
price_per_square_foot__c, 1102.66
pba__propertytype__c, Condominium
id, a0E8W00000V32xZUAR
room_type__c, Kitchen;Living Room
sale_date__c, 2022-02-18
sale_price__c, 870000
security_features__c, Smoke Detector;Secured Access
selling_agent_mls_id__c, 811632
selling_agent_number__c, 1052818
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 789
size__c, 789
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Buchanan
subdist__c, Hayes Valley
ffd_name, 8 Buchanan Street #401, San Francisco, CA, 94102
view__c, Twin Peaks
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530387376-1.jpg
ListingId, a0E8W00000V32xZUAR