meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='213209' 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, 143 Buchanan Street, San Francisco, CA, 94102
ffd_mls_id, 501008
ffd_salesforce_id, a0E1I00000SxxYXUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 3
address2__c, 143 Buchanan Street, San Francisco, CA, 94102
pba__address_pb__c, 143 Buchanan Street, San Francisco, CA, 94102
agent_only_remarks__c, Covid compliant showings available by appointment with signed PEAD forms once virtual tours have been viewed. https://calendly.com/erinthompson/143-buchanan. Buyer to investigate square footage prior to offer. Assessors office says 1480 (see disclosures), MLS tax record says less. Leased parking (a great spot) is secured less than one block away at 34 Buchanan for $250/mo. All offers to be submitted on SFAR PA with proof of funds or pre approval letter.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-07-10T10:48:07.000+0000
days_on_market__c, 1104
dom__c, 9
ffd_description_pb, Exquisitely renovated Hayes Valley 3BD/2BA condo combines old and new with original millwork, high ceilings, hardwood floors, modern lighting and countless contemporary updates. The formal living/dining room welcomes you with a sunny bay window and original stone fireplace. The renovated chef's kitchen boasts custom cabinetry, stone counters, SS appliances, pantry. Enjoy a cozy family room with built-in shelves in the center of the home. Iconic Sutro Tower views greet you in the owner's suite featuring two closets and an en suite bath. A secondary bedroom has a bay window, stone fireplace and large closet. The third bedroom can also be used as an office, nursery. Landscaped shared yard and large front deck provide wonderful outdoor options. Located on a quiet tree-lined street just blocks to great parks and amazing dining and nightlife in Hayes Valley and Lower Haight. Nearby buses, MUNI and BART trains make this a commuter's paradise. Leased parking secured less than one block away.
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
hoa_dues__c, 350
pba__hoafees__c, 350
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
ffd_lastmodifieddate, 2022-01-25T15:27:19.000+0000
pba__latitude_pb__c, 37.771191
pba__latitude_property__c, 37.771191
listed_date__c, 2020-06-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Erin
pba__listing_agent_lastname__c, Thompson
listing_agent_mls_id__c, 806326
ffd_listingagentname, Erin Thompson
listing_agent_number__c, 166016753
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1549000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.143Buchanan.com
pba__longitude_pb__c, -122.427214
pba__lotsize_pb__c, 0
mls_id__c, 501008
master_property__c, a0O1I000001ViDaUAK
monthly_parking_fees__c, 250
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-07-10
original_price__c, 1549000
overall_days_on_market__c, 143
parking_access__c, Independent
parking_features__c, Garage
parking_type__c, Lease Avail Off Site
pba__pendingdate__c, 2020-07-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1040.54
pba__propertytype__c, Condominium
id, a0E1I00000SxxYXUAZ
sale_date__c, 2020-08-18
sale_price__c, 1540000
selling_agent_mls_id__c, 808971
selling_agent_name__c, Michael L. Bellings
selling_agent_number__c, 1038794
selling_co_agent_mls_id__c, 808937
selling_co_agent_name__c, Aaron M Bellings
selling_co_agent_number__c, 1038623
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1480
size__c, 1480
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Buchanan
subdist__c, Hayes Valley
ffd_name, 143 Buchanan Street, San Francisco, CA, 94102
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/365907-1.jpg
ListingId, a0E1I00000SxxYXUAZ