meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='216583' 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] => 2024-03-19 14:14:15
[post_modified_gmt] => 2024-03-19 21:14:15
[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, 319 Lexington Street, San Francisco, CA, 94110
ffd_mls_id, 512324
ffd_salesforce_id, a0E1I00000TvuwMUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 2
address2__c, 319 Lexington Street, San Francisco, CA, 94110
pba__address_pb__c, 319 Lexington Street, San Francisco, CA, 94110
agent_only_remarks__c, Please contact Olivia Ongpin for showings: [email protected] or 415.374.0220. More info at 319lexington.com. Signed PEAD form required. Leased parking available at New Mission Bartlett Garage one block away. Pre-escrow opened with Janette Marcelo at Old Republic Title. Disclosures available at https://app.disclosures.io/link/319-Lexington-Street-crfha8dk
architectural_style__c, Victorian
bath_features__c, Shower Stall(s);Marble
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1876
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-03-06
ffd_createddate, 2021-02-15T23:30:33.000+0000
days_on_market__c, 902
dom__c, 81
ffd_description_pb, First flat available on a highly desirable block in 15 years! This street-level unit, set behind a small garden, boasts an unbeatable location in the heart of the Mission, on a quiet, lovely street just steps away from the Valencia Corridor. With its high ceilings, amazing natural light, hardwood floors, and original details, this historic Italianate's versatile layout can be used as a one or two-bedroom home. The large, sunny deeded deck connects to the laundry porch. Walk score of 99 and bike score of 94. Built by TREA (The Real Estate Associates) as part of San Francisco's first subdivision.
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:42:32.000+0000
pba__latitude_pb__c, 37.75821
pba__latitude_property__c, 37.75821
listed_date__c, 2021-01-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Olivia
pba__listing_agent_lastname__c, Ongpin
listing_agent_mls_id__c, 807270
ffd_listingagentname, Olivia O Ongpin
listing_agent_number__c, 1013344
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 879000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=sqsMyTEwEgp
pba__longitude_pb__c, -122.42026
mls_id__c, 512324
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O8W00000DaE3DUAV
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-01-28
original_price__c, 879000
overall_days_on_market__c, 249
parking_features__c, No Garage
pba__pendingdate__c, 2021-04-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1018.91
pba__propertytype__c, Tenancy In Common
id, a0E1I00000TvuwMUAR
sale_date__c, 2021-04-26
sale_price__c, 862000
selling_agent_mls_id__c, 812523
selling_agent_number__c, 1056853
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 846
size__c, 846
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lexington
subdist__c, The Mission
ffd_name, 319 Lexington Street, San Francisco, CA, 94110
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1876
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/375733-1.jpg
ListingId, a0E1I00000TvuwMUAR