meta_query='key:subdist__c;value:Haight Ashbury|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='377213' 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
(
)
)
_yoast_indexnow_last_ping, 1735681194
ffd_listing_title, 718 Ashbury Street, San Francisco, CA, 94117
ffd_mls_id, 424017307
ffd_salesforce_id, a0EUd000001WeGPMA0
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 3
address2__c, 718 Ashbury Street, San Francisco, CA, 94117
pba__address_pb__c, 718 Ashbury Street, San Francisco, CA, 94117
agent_only_remarks__c, Offers, if any, should be presented by 12 noon on Wednesday March 27th via email on a SFAR Purchase Agreement to [email protected]. If you choose to present an offer, please provide proof of funds and the ability to close escrow and please allow 24 hours for a response. Disclosures are available. Sirkin TIC agreement. Fractional financing options including 30-year fixed at competitive rates is now available! For more information and showing requests, contact Jeff Stephenson [email protected] / 415-577-2580
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1904
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mark Brown
pba__contingentdate__c, 2024-03-27
ffd_createddate, 2024-03-22T10:48:38.000+0000
days_on_market__c, 284
dom__c, 11
ffd_description_pb, Welcome to 718 Ashbury Street, your quintessential San Francisco Victorian dream home! Nestled in the heart of the iconic Haight-Ashbury neighborhood, this enchanting single-family alternative offers a perfect blend of historic charm and modern convenience. With three bedrooms, one bathroom, and an additional hallway water closet, this home provides ample space for comfortable living. Step inside and be captivated by the intricate moldings and inlaid hardwood floors. The elegant living spaces are bathed in natural light, creating an inviting atmosphere for relaxing or entertaining guests. The kitchen boasts contemporary upgrades while maintaining its vintage appeal. In-unit washer/dryer. A large garage fits two tandem cars with ample storage space and workshop checks all the boxes. The rear yard is perfect for hosting al fresco dining. A spacious side yard runs the length of the building offering endless possibilities for gardening and activities. Conveniently located near eclectic shops, trendy cafes, and iconic landmarks, 718 Ashbury Street epitomizes the vibrant spirit of San Francisco living. Don't miss the opportunity to make this delightful residence your own!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2024-05-07T10:46:56.000+0000
pba__latitude_pb__c, 37.768462
pba__latitude_property__c, 37.768462
listed_date__c, 2024-03-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 807124
listing_co_agent_number__c, 166018264
listing_co_office_mls_id__c, KWADVSF
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28861
listing_office_mls_id__c, KWADVSF
listing_office_name__c, KW Advisors
listing_office_number__c, 28861
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.716-718ashbury.com/
pba__longitude_pb__c, -122.446324
mls_id__c, 424017307
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-03-22
original_price__c, 1695000
overall_days_on_market__c, -81895
parking_access__c, Tandem
parking_features__c, Garage Facing Front
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-04-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-05-06T16:29:12.000+0000
price_per_square_foot__c, 842.59
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000001WeGPMA0
sale_date__c, 2024-05-01
sale_price__c, 1820000
selling_agent_mls_id__c, MLSL5100161
selling_agent_number__c, 981400588
selling_co_agent_mls_id__c, MLSL5100162
selling_co_agent_number__c, 981400589
selling_co_office_mls_id__c, NTERO-4
selling_co_office_name__c, Intero Real Estate Services
selling_co_office_number__c, 981046055
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 2160
size__c, 2160
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Ashbury
subdist__c, Haight Ashbury
ffd_name, 718 Ashbury Street, San Francisco, CA, 94117
website_property_type__c, Tenancy In Common
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/530748816-1.jpg