meta_query='key:subdist__c;value:Mission Dolores|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423794' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15110
[post_author] => 4
[post_date] => 2018-10-31 19:36:27
[post_date_gmt] => 2018-10-31 19:36:27
[post_content] => Not quite the Mission, not quite the Castro, Mission Dolores is a bustling, centrally located neighborhood with some iconic San Francisco attractions. The crown jewels of the neighborhood are Dolores Park and Mission Dolores, the oldest Spanish Mission church in San Francisco. Sun worshippers flock to Dolores Park on warm and cool days alike, and the church welcomes worshippers for regular services.
[post_title] => Mission Dolores
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => mission-dolores
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-15 12:13:19
[post_modified_gmt] => 2024-11-15 20:13:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15110
[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, 1738585033
ffd_listing_title, 780 Guerrero Street, San Francisco, CA, 94110
ffd_mls_id, 425006242
ffd_salesforce_id, a0EUd000004CAcPMAW
num_of_rooms__c, 40
of_units__c, 14
pba__address_pb__c, 780 Guerrero Street, San Francisco, CA, 94110
address2__c, 780 Guerrero Street, San Francisco, CA, 94110
agent_only_remarks__c, Offering Memorandum is in the attached documents tab on MLS. Disclosures available. Shown by pre-arranged scheduled showing times, contract Trigg Splenda (415) 308-6560 for dates and times. Do not go direct and don't disturb tenants.
appliances__c, See Remarks
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 0
year_build_text__c, 1916
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-02-03T02:47:44.000+0000
days_on_market__c, 1
dom__c, 1
ffd_description_pb, Prime Investment Opportunity in the heart of San Francisco's vibrant Mission District. This stunning 14-unit building, built in 1916, combines timeless period details with modern upgrades. This property features a versatile mix of two studios, nine formal one-bedroom units, and three thoughtfully converted two-bedroom units. The converted units showcase tasteful modern renovations, maximizing space while achieving higher rents. The unconverted units exude classic San Francisco charm showcasing original built-in cabinets, Glass French doors, and spacious, light-filled kitchens with vintage details. This building is designed for operational efficiency, featuring separate gas and electric meters for all units. Two domestic water heaters and a newer style boiler servicing all units. A durable tar-and-gravel roof covers the structure. Future upside can be realized with the future implementation of a Ratio Utility Billing System, additional floor plan conversions, and monetization of storage areas. Nestled in one of San Francisco's most desirable neighborhoods, this asset is a block from Dolores park, surrounded by trendy dining, boutique shopping, and cultural landmarks, ensuring strong tenant demand and long-term value. Don't miss this extraordinary opportunity.
district__c, SF District 5
external_listing__c, 1
pba__floortype_pb__c, Varies by Unit
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, See Remarks
interior_features__c, Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2025-02-03T11:47:29.000+0000
pba__latitude_pb__c, 37.7586753
pba__latitude_property__c, 37.7586753
laundry_features__c, In Common Area
listed_date__c, 2025-02-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Trigg
pba__listing_agent_lastname__c, Splenda
listing_agent_mls_id__c, 981347
ffd_listingagentname, Trigg Splenda
listing_agent_number__c, 981347
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, TRIG
listing_office_name__c, Trigg Splenda, Broker
listing_office_number__c, 29106
pba__listingprice_pb__c, 6250000
pba__listingtype__c, Sale
pba__listing_website__c, https://video.wixstatic.com/video/a21358_73375e1d6e3049caba2a78fe30f84b89/720p/mp4/file.mp4
pba__longitude_pb__c, -122.4237058
mls_id__c, 425006242
parkingspaces__c, 0
on_market_date__c, 2025-02-02
open_house_end__c, 2025-02-04T14:00:00.000+0000
open_house_start__c, 2025-02-04T12:00:00.000+0000
original_price__c, 6250000
overall_days_on_market__c, -82212
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 507.26
pba__propertytype__c, 5 or More Unit
ListingId, a0EUd000004CAcPMAW
roof__c, Tar/Gravel;See Remarks
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, 12321
size__c, 12321
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Guerrero
subdist__c, Mission Dolores
ffd_name, 780 Guerrero Street, San Francisco, CA, 94110
website_property_type__c, 5 or More Unit
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1916
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530939848-1.jpg