meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='330772' 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, 1142 York Street, San Francisco, CA, 94110
ffd_mls_id, 423729793
ffd_salesforce_id, a0E8W00000bGGcdUAG
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 4
address2__c, 1142 York Street, San Francisco, CA, 94110
pba__address_pb__c, 1142 York Street, San Francisco, CA, 94110
agent_only_remarks__c, https://my.matterport.com/show/?m=5535bZQB4dx https://www.remco.solutions/1142-york All offers to be submitted on a San Francisco Purchase Agreement with TIC Addendum. If you do not have access to this document, kindly let me know and we can provide one for you. Sirkin TIC Agreement in place. MeriWest and NCB are lined up to lend! Please call or text for the CBS code.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1907
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-04-14
ffd_createddate, 2023-03-25T15:47:36.000+0000
days_on_market__c, 116
dom__c, 27
ffd_description_pb, 1142 York Street is a sunny Inner Mission home with 2 beds, 2 full baths, 1 car parking w/EV charger & lots more! You will find that 1907 charm masterfully meets a modern remodel! The home underwent a down to the studs renovation in 2015 with high end finishes: marble countertops and gourmet appliances including a gas Bertazzoni stove, Leibherr refrigerator, Bosch dishwasher, in-unit Bosch w/d. You get all of this while maintaining the character with high ceilings + douglas fir hardwood floors. The floor plan is a popular open plan with the kitchen, living and dining areas seamlessly flowing from one to the other. The living area is sophisticated with a gas fireplace, a large and bright bay window and recessed lighting. The primary suite is really spectacular with built-ins and a custom closet, recessed lighting & large en suite bathroom and soaking tub. The 2nd BR is spacious with a full closet and two windows. The shared backyard is just out back of the unit--it's sunny with built-in seating and an alfresco kitchen with grill and refrigerator. Your new city home is merely feet away from the Mission's trendy 24th and 20th street restaurants and shopping, and close to all sorts of transportation, including BART + freeways. Welcome home!
district__c, SF District 9
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Decorative Only
pba__hoafees__c, 300
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2023-07-13T18:37:18.000+0000
pba__latitude_pb__c, 37.753678
pba__latitude_property__c, 37.753678
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2023-01-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Katie
pba__listing_agent_lastname__c, Fones
listing_agent_mls_id__c, 812832
ffd_listingagentname, Katie Fones
listing_agent_number__c, 1058392
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP50
listing_office_name__c, Compass
listing_office_number__c, 28741
pba__listingprice_pb__c, 879000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=5535bZQB4dx
pba__longitude_pb__c, -122.408546
mls_id__c, 423729793
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-03-25
original_price__c, 879000
overall_days_on_market__c, -81532
parking_access__c, Independent
parking_features__c, Assigned,EV Charging,Garage Door Opener,Garage Facing Front
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-04-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000bGGcdUAG
sale_date__c, 2023-05-01
sale_price__c, 820000
selling_agent_mls_id__c, 809572
selling_agent_number__c, 1049895
selling_co_agent_mls_id__c, EB328999
selling_co_agent_number__c, 981344269
selling_co_office_mls_id__c, 37277
selling_co_office_name__c, KW Advisors
selling_co_office_number__c, 981074045
selling_office_name__c, eXp Realty of California, Inc
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, York
subdist__c, The Mission
ffd_name, 1142 York Street, San Francisco, CA, 94110
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94110
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530595239-1.jpg
