meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325513' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15716
[post_author] => 4
[post_date] => 2018-11-02 19:54:31
[post_date_gmt] => 2018-11-02 19:54:31
[post_content] => Ground zero for gentrification arguments in almost every housing cycle. Flat streets, sunny weather, historical cultural institutions, and colorful street life. Welcome to the Mission, where hipsters zoom down Valencia on tomorrow's transport idea while humble housekeepers hustle hard with their heads down.
[post_title] => The Mission
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => the-mission
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-05 02:53:28
[post_modified_gmt] => 2022-12-05 10:53:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15716
[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, 613 York Street, San Francisco, CA, 94110
ffd_mls_id, 423720304
ffd_salesforce_id, a0E8W00000bE1PSUA0
num_of_rooms__c, 10
of_units__c, 3
address2__c, 613 York Street, San Francisco, CA, 94110
pba__address_pb__c, 613 York Street, San Francisco, CA, 94110
agent_only_remarks__c, Please call listing agent for private showings. May need 24-48 hours notice.One vacant unit. Disclosures available upon request.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Rita V Schmid
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-15T11:52:02.000+0000
days_on_market__c, 37
dom__c, 36
ffd_description_pb, Hot investment opportunity in hippest, most vibrant part of the Mission. Mixed use space on one lot with two buildings and three units -- One commercial and two residential. Both residential units are 2 bed/ 1 bath. One of the residential units is vacant. Commercial space includes office, laundry (shared with 613A) and lots of storage. The commercial space is occupied by Aedan, an authentic Japanese kitchen and caterer. This unique property is surrounded by the Mission district's finest shops and restaurants, including Tartine Manufactory, Liliana, Osito, Flour + Water, Farmhouse Kitchen, Ernest, San Ho Won only blocks away.
district__c, SF District 9
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-03-24T00:50:14.000+0000
pba__latitude_pb__c, 37.761463
pba__latitude_property__c, 37.761463
laundry_features__c, Laundry Closet;In Common Area;Varies by Unit
listed_date__c, 2023-01-14
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Roxana
pba__listing_agent_lastname__c, Melgarejo
listing_agent_mls_id__c, 806810
ffd_listingagentname, Roxana L Melgarejo
listing_agent_number__c, 206525313
listing_co_agent_mls_id__c, 807120
listing_co_agent_number__c, 166018260
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 2499000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.408963
mls_id__c, 423720304
parkingspaces__c, 0
on_market_date__c, 2023-02-15
original_price__c, 2499000
overall_days_on_market__c, -81494
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 784.37
pba__propertytype__c, Triplex
ListingId, a0E8W00000bE1PSUA0
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, 3186
size__c, 3186
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, York
subdist__c, The Mission
ffd_name, 613 York Street, San Francisco, CA, 94110
website_property_type__c, Triplex
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530578131-1.jpg