meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='426836' 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, 1745637504
ffd_listing_title, 2882 Golden Gate 2884 Avenue, San Francisco, CA, 94118
ffd_mls_id, 425025764
ffd_salesforce_id, a0EUd000004hVPdMAM
num_of_rooms__c, 8
of_units__c, 2
pba__address_pb__c, 2882 Golden Gate 2884 Avenue, San Francisco, CA, 94118
address2__c, 2882 Golden Gate 2884 Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Open House 4/27 Sun 1-3pm. 2882 is tenant occupied and subject to tenant rights. Property to be sold as-is. Disclosure package will be available upon request. Buyers and/or buyers' agent due diligence to verify permits, building square footage & lot size with city authorities and professional surveyor(s) before writing an offer. Seller reserves the right to accept, counter, reject any offers received. Please call 415-823-1731 for showing instructions and any questions.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 6
year_build_text__c, 1924
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-04-05T20:46:47.000+0000
days_on_market__c, 20
dom__c, 20
ffd_description_pb, First time on the market in over 50 years! Situated in the Lone Mountain Neighborhood is this 2 unit building offering an updated 3/2 top floor vacant flat, an income producing lower level 3/2 flat and a deep garage/basement with ADU possibilities. Minutes to Rossi Park, Golden Gate Park, USF, Presidio, Arguello Super Market and the bustling Clement and Geary corridors of shops and restaurants. A duplex presenting an attractive opportunity in a prime SF location!
district__c, SF District 1
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2025-04-26T02:47:56.000+0000
pba__latitude_pb__c, 37.7764412
pba__latitude_property__c, 37.7764412
laundry_features__c, In Common Area
listed_date__c, 2025-03-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marlon
pba__listing_agent_lastname__c, Austria
listing_agent_mls_id__c, 805165
ffd_listingagentname, Marlon Austria
listing_agent_number__c, 199010471
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, DRMH
listing_office_name__c, Realty World Bay Area Real Estate
listing_office_number__c, 166014045
pba__listingprice_pb__c, 2638888
pba__listingtype__c, Sale
pba__listing_website__c, http://2882-2884goldengateave.com
pba__longitude_pb__c, -122.4580491
mls_id__c, 425025764
parkingspaces__c, 2
on_market_date__c, 2025-04-05
open_house_end__c, 2025-04-27T15:00:00.000+0000
open_house_start__c, 2025-04-27T13:00:00.000+0000
original_price__c, 2638888
overall_days_on_market__c, -82274
parking_features__c, Attached
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 785.38
pba__propertytype__c, Duplex
ListingId, a0EUd000004hVPdMAM
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 3360
size__c, 3360
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Golden Gate
subdist__c, Lone Mountain
ffd_name, 2882 Golden Gate 2884 Avenue, San Francisco, CA, 94118
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1924
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530974409-1.jpg