meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235445' 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] => 2024-11-09 19:25:51
[post_modified_gmt] => 2024-11-10 03:25:51
[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, 235 Divisadero Street, San Francisco, CA, 94117
ffd_mls_id, 422633600
ffd_salesforce_id, a0E8W00000Vw2IuUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 235 Divisadero Street, San Francisco, CA, 94117
pba__address_pb__c, 235 Divisadero Street, San Francisco, CA, 94117
agent_only_remarks__c, Offers Friday 4/6 at 9am. Instructions in dp. Video etc here: https://www.buenavistavictorian.com/ Do not use showing time to schedule appointments. Email [email protected]. Try to attend pre scheduled open houses please!
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-04-08
ffd_createddate, 2022-04-01T00:48:01.000+0000
days_on_market__c, 475
dom__c, 11
ffd_description_pb, Beautiful, one of a kind 2 lvl Italianate Buena Vista Victorian w exquisite period details, 4BDRS/2.5BAs, 98 WalkScore, 2 car grg, lush garden, renovated kit/ba the whole package! 12 ft soaring ceilings. 4 Valor fireplaces. Expansive living and dining spaces w huge windows, 2 frplcs, wet bar, wood floors perfect for entertaining! Redesigned KIT w SubZero, BlueStar, Dacor, Miele, Caesarstone, and Fireclay, opens to a cozy family rm and to the breathtaking backyard. Sleek powder rm. Up the gorgeous staircase, a coveted floorplan: 4BDRS/2BAs. Spacious, elegant primary BDR w WIC and en suite BA. Spa like 2nd BA w Waterworks marble tile, soaking tub, heated floors. Laundry closet. Lovingly maintained by 25 yr owners. Newer electrical, plumbing, furnace, and roof. Nest thermostat. A walker's paradise, at the cusp of NOPA, Upper/Lower Haight, Duboce Triangle - walk to world class restaurants and cafes, tech shuttles, farmers market, and iconic parks. A home like this rarely comes to market!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-04-22T22:47:52.000+0000
pba__latitude_pb__c, 37.770801
pba__latitude_property__c, 37.770801
listed_date__c, 2022-01-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jessica
pba__listing_agent_lastname__c, Branson
listing_agent_mls_id__c, 805610
ffd_listingagentname, Jessica Branson
listing_agent_number__c, 166015601
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 3095000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=12iLDRCRUUA&mls=1
pba__longitude_pb__c, -122.43731
mls_id__c, 422633600
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-03-31
original_price__c, 3095000
overall_days_on_market__c, -81173
parking_access__c, Independent
parking_features__c, Other
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-04-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-22T09:31:40.000+0000
price_per_square_foot__c, 1460.53
pba__propertytype__c, Single Family Residence
id, a0E8W00000Vw2IuUAJ
sale_date__c, 2022-04-22
sale_price__c, 3885000
selling_agent_mls_id__c, 807921
selling_agent_number__c, 1028628
selling_co_agent_mls_id__c, 803037
selling_co_agent_number__c, 803037
selling_co_office_mls_id__c, VANG02
selling_co_office_name__c, Vanguard Properties
selling_co_office_number__c, 166013449
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 2660
size__c, 2660
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Divisadero
subdist__c, Haight Ashbury
ffd_name, 235 Divisadero Street, San Francisco, CA, 94117
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530427935-1.jpg
ListingId, a0E8W00000Vw2IuUAJ