meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='331799' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15734
[post_author] => 4
[post_date] => 2018-11-02 19:54:59
[post_date_gmt] => 2018-11-02 19:54:59
[post_content] => Jimi Hendrix, Janis Joplin, The Grateful Dead. 1968. Victorians, Edwardians, street punks, and skater kids. Everyone has an idea of what the Haight should be. Come discover what it actually is for yourself.
[post_title] => Haight Ashbury
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => haight-ashbury
[to_ping] =>
[pinged] =>
[post_modified] => 2018-11-02 19:54:59
[post_modified_gmt] => 2018-11-02 19:54:59
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15734
[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, 626 Clayton Street #C, San Francisco, CA, 94117
ffd_mls_id, 423728514
ffd_salesforce_id, a0E8W00000baamnUAA
num_of_fireplaces__c, 2
num_of_rooms__c, 6
of_units__c, 4
address2__c, 626 Clayton Street #C, San Francisco, CA, 94117
pba__address_pb__c, 626 Clayton Street #C, San Francisco, CA, 94117
agent_only_remarks__c, Disclosure Link https://app.disclosures.io/link/626-Clayton-Street-polexjkg This lovely TIC is staged as a two bedroom but tax records show a 1 bedroom & was marketed to sellers as two bed in 2019. The building was Ellis Acted in 2016 so there are rental restrictions, buyer to investigate to their satisfaction. Square footage was quoted as approximately 900-950 sf in 2019 but neither agent or seller has verified square footage, buyer to investigate. Association managed by Homworks Property Services. Unit is vacant but sellers want to give neighbors 24 hrs for showings,if possible. Sellers can accept or reject any/all offers. https://www.cbhometour.com/626-Clayton-Street-Apt-C-San-Francisco-CA-94117/mlsindex.html
appliances__c, Dishwasher;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Marble;Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1905
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-04-19
cooling__c, None
ffd_createddate, 2023-04-03T10:48:18.000+0000
days_on_market__c, 46
dom__c, 32
ffd_description_pb, Perfectly placed between Haight Ashbury & Cole Valley is this charming and bright top floor Edwardian flat bursting with period charm including soaring coved ceilings, pocket doors, crown moldings, Anaglypta wallpaper , 2 decorative fireplaces, lovely built-in cabinetry and an original stained glass hallway window. A thoughtfully updated kitchen with stainless appliances, an in-unit laundry porch, a lovely shared garden and a windowed bonus room or home office at garden level. Out the door it's a short walk to local favorites including Golden Gate Park, Gus's Community Market , Whole Foods, Amoeba Records, Robert's Hardware, The Mellow, Magnolia Brewing and all this vibrant neighborhood offers you to discover. Multiple daycares, nurseries and schools close by for young families. Here's your opportunity to own a piece of the lyrical and musically significant enclave that is Haight Ashbury.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__floortype_pb__c, Tile;Vinyl;Wood
hoa_fee_includes__c, Insurance on Structure,Management,Sewer,Trash,Water
pba__hoafees__c, 325
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 626 Clayton HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-05-18T10:49:12.000+0000
pba__latitude_pb__c, 37.7694211
pba__latitude_property__c, 37.7694211
laundry_features__c, Inside Room;Inside Area;Washer Included;Dryer Included
listed_date__c, 2023-03-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Elizabeth
pba__listing_agent_lastname__c, Kraus
listing_agent_mls_id__c, 810548
ffd_listingagentname, Liz A Kraus
listing_agent_number__c, 1046867
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 840000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=KxB3kXvPgpF&brand=0
pba__longitude_pb__c, -122.448263
lower_level__c, Retreat,Street Entrance
mls_id__c, 423728514
main_level__c, Bedroom(s);Kitchen;Family Room
master_bathroom_features__c, Tub w/Shower Over;Marble;Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-04-02
original_price__c, 840000
overall_days_on_market__c, -81540
pba__pendingdate__c, 2023-05-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000baamnUAA
roof__c, Bitumen;Composition
room_type__c, Bonus Room;Laundry;Family Room
sale_date__c, 2023-05-12
sale_price__c, 840000
security_features__c, Security Gate
selling_agent_mls_id__c, EB26493
selling_agent_number__c, 981073154
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Clayton
subdist__c, Haight Ashbury
ffd_name, 626 Clayton Street #C, San Francisco, CA, 94117
view__c, City;Garden/Greenbelt
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530598452-1.jpg
