meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374505' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70653
[post_author] => 4
[post_date] => 2018-11-30 20:30:26
[post_date_gmt] => 2018-11-30 20:30:26
[post_content] => Charming single-family homes on streets that made sense before the University of San Francisco left its footprint on the neighborhood. The most charming circular street you'll ever meet (hello, Ewing Terrace). Discontiguous streets and student life just north of the North Panhandle.
[post_title] => Lone Mountain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lone-mountain
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-14 12:49:00
[post_modified_gmt] => 2024-11-14 20:49:00
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70653
[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, 1735680724
ffd_listing_title, 716 Arguello 718 A Boulevard, San Francisco, CA, 94118
ffd_mls_id, 424003019
ffd_salesforce_id, a0EUd000000r06jMAA
num_of_rooms__c, 9
of_units__c, 3
address2__c, 716 Arguello 718 A Boulevard, San Francisco, CA, 94118
pba__address_pb__c, 716 Arguello 718 A Boulevard, San Francisco, CA, 94118
agent_only_remarks__c, Incredible opportunity to transform this 3-unit vacant building into a property. The period details and deep rear yard contribute to its potential charm. The close proximity to Rossi Park, USF, UCSF, and the amenities of Golden Gate Park, Lake Street, and Clement Street enhances the property's appeal and makes it convenient for residents and potential tenants. The easy access to public transportation and direct access to the Golden Gate Bridge are significant advantages. First time on the market in 50 years. Property to be sold in "AS IS"condition.Listing agents cannot verify the condition of the property.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 0
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Susan McBride
pba__contingentdate__c, 2024-03-01
ffd_createddate, 2024-01-17T23:47:53.000+0000
days_on_market__c, 349
dom__c, 56
ffd_description_pb, Incredible opportunity to transform this 3-unit vacant building into a property. The period details and deep rear yard contribute to its potential charm. The close proximity to Rossi Park, USF, UCSF, and the amenities of Golden Gate Park, Lake Street, and Clement Street enhances the property's appeal and makes it convenient for residents and potential tenants. The easy access to public transportation and direct access to the Golden Gate Bridge are significant advantages. First time on the market in 50 years. Property to be sold in "AS IS"condition.Listing agents cannot verify the condition of the property.
district__c, SF District 1
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard;Electric;Gas
ffd_lastmodifieddate, 2024-03-22T10:52:22.000+0000
pba__latitude_pb__c, 37.77447311
pba__latitude_property__c, 37.77447311
listed_date__c, 2024-01-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lisa
pba__listing_agent_lastname__c, Wolfe
listing_agent_mls_id__c, 535823
ffd_listingagentname, Lisa J Wolfe
listing_agent_number__c, 535823
listing_co_agent_mls_id__c, 216934
listing_co_agent_number__c, 216934
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1650000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.47175309
mls_id__c, 424003019
parkingspaces__c, 0
on_market_date__c, 2024-01-17
original_price__c, 1800000
overall_days_on_market__c, -81830
pba__pendingdate__c, 2024-03-13
price_per_square_foot__c, 500
pba__propertytype__c, Triplex
ListingId, a0EUd000000r06jMAA
sale_date__c, 2024-03-21
sale_price__c, 1600000
selling_agent_mls_id__c, 814790
selling_agent_number__c, 1068306
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3200
size__c, 3200
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Arguello
subdist__c, Lone Mountain
ffd_name, 716 Arguello 718 A Boulevard, San Francisco, CA, 94118
website_property_type__c, Triplex
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530720884-1.jpg