meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='335913' 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-22 10:15:44
[post_modified_gmt] => 2024-11-22 18:15:44
[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, 514 Shrader 516 Street, San Francisco, CA, 94117
ffd_mls_id, 423743303
ffd_salesforce_id, a0E8W00000awLmjUAE
num_of_rooms__c, 9
of_units__c, 2
address2__c, 514 Shrader 516 Street, San Francisco, CA, 94117
pba__address_pb__c, 514 Shrader 516 Street, San Francisco, CA, 94117
agent_only_remarks__c, Also offered as TIC interests @ $799,000 and $1,085,000. Fully modernized, two furnaces, separate meters, no impediment to condo conversion. Attic possible expansion potential. Two laundry hook-ups only one set of laundry machines is installed. Disclosures: https://app.disclosures.io/link/514516-Shrader-St-rj8kh58l
appliances__c, ENERGY STAR Qualified Appliances
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 6
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-19T18:51:31.000+0000
days_on_market__c, 592
dom__c, 26
ffd_description_pb, Live-in and Invest or Family Compound Perfection! Quintessential Modern Victorian duplex, fully vacant, currently used as a single family home, is set on a lush, deep lot with a cottage in the back. Airy & bright, high ceilings, gorgeous wood flooring, thoughtfully updated, preserving the classic details & the ability to restore its use as a two flats. The layouts provide for robust utility: 2 bedrooms each, separate spaces for entertaining, study, office/zoom & music. Decks off each home provide access to verdant garden. Lower 4 rm flat with stunning kitchen designed to create open plan dining room & family room open to deck. Upstairs, 5 rooms includes living, FDR, lounge laundry & 1.5 baths. The sturdy, forthright redwood construction anchors the building in quality, the careful stewardship of its current owners provides a fresh modern feel. Walkable amenities incl. shopping, dining, & recreation Whole Foods, Golden Gate Park & Panhandle plus the iconic glories of the Haight close at hand.
district__c, SF District 5
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-27T10:50:16.000+0000
pba__latitude_pb__c, 37.77002
pba__latitude_property__c, 37.77002
laundry_features__c, In Each Unit;Washer/Dryer Owned
listed_date__c, 2023-05-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Storch
listing_agent_mls_id__c, 803139
ffd_listingagentname, Wendy Storch
listing_agent_number__c, 803139
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, 1960000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=mJyfzjLgiVX&mls=1
pba__longitude_pb__c, -122.45169
mls_id__c, 423743303
parkingspaces__c, 0
on_market_date__c, 2023-05-19
original_price__c, 1960000
overall_days_on_market__c, -81587
pba__pendingdate__c, 2023-06-14
price_per_square_foot__c, 869.18
pba__propertytype__c, Duplex
ListingId, a0E8W00000awLmjUAE
sale_date__c, 2023-07-24
sale_price__c, 1960000
selling_agent_mls_id__c, 807674
selling_agent_number__c, 1023667
selling_co_agent_mls_id__c, 812378
selling_co_agent_number__c, 1056316
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2255
size__c, 2255
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Shrader
subdist__c, Haight Ashbury
ffd_name, 514 Shrader 516 Street, San Francisco, CA, 94117
website_property_type__c, Duplex
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/530621299-1.jpg
_yoast_indexnow_last_ping, 1735679718