meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234504' 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-04-09 11:28:05
[post_modified_gmt] => 2024-04-09 18:28:05
[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, 540 Ashbury Street, San Francisco, CA, 94117
ffd_mls_id, 422625963
ffd_salesforce_id, a0E8W00000V3epNUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 540 Ashbury Street, San Francisco, CA, 94117
pba__address_pb__c, 540 Ashbury Street, San Francisco, CA, 94117
agent_only_remarks__c, Vacant & easy to show. Buyers to verify all information provided to satisfaction. Schedule a private showing via Showingtime (see Button top right). Disclosures available via disclosures.io, send email to listing agent. Escrow opened with Heather Schiffer at First American Title. Offers reviewed as they come.
appliances__c, Dishwasher;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances;Free Standing Electric Range
architectural_style__c, Edwardian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Quartz;Closet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-02-13
ffd_createddate, 2022-02-02T21:47:27.000+0000
days_on_market__c, 532
dom__c, 15
ffd_description_pb, Located on THE iconic Haight Ashbury block, this full-flat condo is your chance to own a quintessential part of San Francisco history. Let's just say that if these walls could talk, this building would have stories to tell! This classic Edwardian light-filled, tall-ceilings condominium consist of 3 beds, 2 updated baths, updated kitchen with stainless steel appliances & quartz countertops, washer & dryer in the unit, refurbished wood floors throughout, a peaceful dining room overlooking the lush backyard & an ample living room in the front. Large storage area in the basement Surrounded to the South by the vibrant shops & restaurants on the Haight corridor, to the North by the Golden Gate Park Panhandle, & to the West by the Golden Gate Park itself, this is a walker/biker paradise! It is centrally located in the heart of the City, making it convenient to commute to the 4 corners of San Francisco, or the entire Bay Area with easy access to 101, the Bay Bridge and 280.
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fencing__c, Back Yard;Wood
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 400
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-03-08T19:22:00.000+0000
pba__latitude_pb__c, 37.770448
pba__latitude_property__c, 37.770448
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2022-01-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Harold
pba__listing_agent_lastname__c, Deblander
listing_agent_mls_id__c, 809042
ffd_listingagentname, Harold Deblander
listing_agent_number__c, 1039971
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=fZTNSP2uH4s&mls=1
pba__longitude_pb__c, -122.446684
mls_id__c, 422625963
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_property__c, a0O1I00000DFdEuUAL
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2022-02-02
original_price__c, 1395000
overall_days_on_market__c, 148
pba__pendingdate__c, 2022-02-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-03-04T15:30:08.000+0000
price_per_square_foot__c, 890.63
pba__propertytype__c, Condominium
id, a0E8W00000V3epNUAR
room_type__c, Storage;Office;Kitchen;Living Room;Family Room
sale_date__c, 2022-03-03
sale_price__c, 1425000
selling_agent_mls_id__c, 810328
selling_agent_number__c, 1045692
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, BarbCo
pba__status__c, Closed
pba__totalarea_pb__c, 1600
size__c, 1600
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Ashbury
subdist__c, Haight Ashbury
ffd_name, 540 Ashbury Street, San Francisco, CA, 94117
view__c, Garden/Greenbelt
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530395158-1.jpg
ListingId, a0E8W00000V3epNUAR