meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209864' 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, 1580 Waller Street, San Francisco, CA, 94117
ffd_mls_id, 493966
ffd_salesforce_id, a0E1I00000QqiHfUAJ
num_of_fireplaces__c, 2
num_of_rooms__c, 5
of_units__c, 3
address2__c, 1580 Waller Street, San Francisco, CA, 94117
pba__address_pb__c, 1580 Waller Street, San Francisco, CA, 94117
agent_only_remarks__c, AS-IS sale. Laundry area/mudroom contains bathroom facilities which are unwarranted. Tax records show 1668 sq ft, floor plan draft shows 1249 sq ft - buyer to verify. Disclosures available via IO link above. Please contact Scott regarding showings and offer date (415) 505-0983. Pre-sale escrow opened with Elisabeth Davis @ Fidelity.
architectural_style__c, Victorian
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-10T11:45:54.000+0000
days_on_market__c, 1255
dom__c, 7
ffd_description_pb, Fantastic opportunity for the savvy buyer! In need of some polish, but beautifully liveable as-is, this full-floor flat retains much of it's rich turn-of-the-century detailing: hardwood floors, tiled fireplaces, built-in shelving, clawfoot tub and box-beam ceilings. Layout is traditional Victorian with double parlor and formal dining room. Recently updated main bath. Easy access to shared backyard, tons of extra basement storage, in-unit laundry and one-car parking top off the list of features. Everything from high culture to dive bars to city parks is an easy walk from the front door. Muni, bike lanes, tech shuttles all nearby. Casually run, yet well-organzied HOA in this fully owner-occupied and pet-friendly building. Opportunity awaits!
district__c, SF District 5
electric__c, 220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floor__c, 0
hoa_dues__c, 375
hoa_fee_includes__c, Maintenance Exterior,Trash,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 375
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1576-80 Waller Street HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas;Stove Heater(s)
ffd_lastmodifieddate, 2022-01-12T15:26:44.000+0000
pba__latitude_pb__c, 37.76888
pba__latitude_property__c, 37.76888
laundry_appliances__c, 220 Volt Wiring,In Laundry Room
laundry_features__c, Inside Room
listed_date__c, 2020-01-10
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Scott
pba__listing_agent_lastname__c, Yarmark
listing_agent_mls_id__c, 808620
ffd_listingagentname, Scott S Yarmark
listing_agent_number__c, 1037311
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, ZEPH
listing_office_name__c, Zephyr Real Estate
listing_office_number__c, 2263
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.45007
pba__lotsize_pb__c, 0
mls_id__c, 493966
master_property__c, a0O1I000008eFM8UAM
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-02-10
original_price__c, 1295000
overall_days_on_market__c, 90
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Rotational,Size Limited,Tandem Garage
parking_type__c, On Site - Unassigned (Condo Only)
pba__pendingdate__c, 2020-02-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
id, a0E1I00000QqiHfUAJ
sale_date__c, 2020-03-13
sale_price__c, 1470000
selling_agent_mls_id__c, 804837
selling_agent_name__c, John L. LePage
selling_agent_number__c, 166014530
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Zephyr Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Waller
subdist__c, Haight Ashbury
ffd_name, 1580 Waller Street, San Francisco, CA, 94117
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94117
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359458-1.jpg
ListingId, a0E1I00000QqiHfUAJ