meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326806' 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-11-25 11:19:58
[post_modified_gmt] => 2024-11-25 19:19:58
[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, 117 Buchanan 119 Street, San Francisco, CA, 94102
ffd_mls_id, 423716048
ffd_salesforce_id, a0E8W00000a7NzPUAU
num_of_rooms__c, 10
of_units__c, 2
address2__c, 117 Buchanan 119 Street, San Francisco, CA, 94102
pba__address_pb__c, 117 Buchanan 119 Street, San Francisco, CA, 94102
agent_only_remarks__c, We are not using Showing Time to set appointments. Any offers are welcome by 12pm on Wednesday, February 1st. Only showing the tenant occupied unit on Saturday (1/28) 2:00 to 3:00 PM and Tuesday (1/31) from 11:30 AM to 12:30 PM. Upper unit is vacant. Downstairs unit is tenant occupied. Tenant has claimed protected rights based on longevity of occupancy (he has lived there since 1999 & is 65 years old). In addition, tenant lease allows for 1 to 2 car parking in the garage. The washer and dryer in the garage is exclusive to #117 (tenant unit). One of the sellers may want to do a 1031 exchange at no cost to the buyer.
appliances__c, Free Standing Gas Range
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Carren S Shagley
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-19T18:47:12.000+0000
days_on_market__c, 712
dom__c, 14
ffd_description_pb, A wonderful 2-story 1922 Edwardian with a 2 car garage below. It is situated in one of the most desirable areas in SF. The duplex has been in the same family for approximately 60 years. Opportunity knocks with 2,940 sq. ft of living space. Two spacious flats with wonderful details: a picture-tiled fireplace, built-in bookcases, baseboards, ceiling trim, and newly refinished hardwood floors in the vacant upper unit. The lower unit is rented. The building has updated plumbing, a newer roof, and a garage with two-car tandem parking, lots of storage, and a charming landscaped backyard complete with a succulent garden. Mint Hill is a competitive rental market. Coveted for good weather, great restaurants and easy access to downtown; the Castro, Duboce Park, Hayes Valley, and Market Street. It is close to public transportation, parks, shops, restaurants, and more.
district__c, SF District 6
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-03-01T03:49:44.000+0000
pba__latitude_pb__c, 37.770929
pba__latitude_property__c, 37.770929
laundry_features__c, Washer/Dryer Hookups;Varies by Unit
listed_date__c, 2022-11-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jennifer
pba__listing_agent_lastname__c, Burden
listing_agent_mls_id__c, 804035
ffd_listingagentname, Jennifer C Burden
listing_agent_number__c, 166013451
listing_co_agent_mls_id__c, 113506
listing_co_agent_number__c, 113506
listing_co_office_mls_id__c, LEGACY
listing_co_office_name__c, Legacy Real Estate
listing_co_office_number__c, 27760
listing_office_mls_id__c, LEGACY
listing_office_name__c, Legacy Real Estate
listing_office_number__c, 27760
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/790347461/3b1053fc02
pba__longitude_pb__c, -122.427114
mls_id__c, 423716048
parkingspaces__c, 2
on_market_date__c, 2023-01-19
original_price__c, 1495000
overall_days_on_market__c, -81467
parking_features__c, Attached,Garage,Garage Door Opener,Tandem Garage
pba__pendingdate__c, 2023-02-02
price_per_square_foot__c, 561.22
pba__propertytype__c, Duplex
ListingId, a0E8W00000a7NzPUAU
roof__c, Bitumen
sale_date__c, 2023-02-28
sale_price__c, 1650000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 803966
selling_agent_number__c, 166013345
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Inspiration Real Estate, Inc.
pba__status__c, Closed
pba__totalarea_pb__c, 2940
size__c, 2940
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Buchanan
subdist__c, Hayes Valley
ffd_name, 117 Buchanan 119 Street, San Francisco, CA, 94102
view__c, Garden/Greenbelt
website_property_type__c, Duplex
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530570257-1.jpg
_yoast_indexnow_last_ping, 1735678918