meta_query='key:subdist__c;value:The Mission|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238034' 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, 917 York Street, San Francisco, CA, 94110
ffd_mls_id, 422684091
ffd_salesforce_id, a0E8W00000YXq3OUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 917 York Street, San Francisco, CA, 94110
pba__address_pb__c, 917 York Street, San Francisco, CA, 94110
agent_only_remarks__c, Easy to show at any time by appointment. For showings and agent previews, please call, text or email Robert Callan at 415-748-1481 [email protected] or Barbara Callan at 415-806-7906 [email protected]
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Barbara J Callan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-08-05T19:47:42.000+0000
days_on_market__c, 348
dom__c, 18
ffd_description_pb, In the heart of San Francisco's sun belt! Great opportunity for a contractor/developer or an owner user to renovate to their own specifications & design. With great upside potential & amazing room for expansion on the lower floor/garage level. Two story floor plan of approximately 1,940 sqft of living space offers 2 bedrooms & a sunroom with a closet that could be a third bedroom on the main floor. There are 2 bedrooms on the top floor with peaked ceilings & garden views. Charming living room with bay windows, fireplace with lovely vintage mantle, & French doors that open into the spacious formal dining room. There is a good-sized eat-in kitchen with skylight & breakfast room. Lower level has a huge garage & basement area that opens out to the large sunny backyard. There is space for 4 cars in the garage. Charming facade, great location, large flat back yard with mature lemon tree & plants. Amazing location on a quiet block & among a delightful row of beautiful Victorian homes!
district__c, SF District 9
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Chain Link
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-07-13T17:27:06.000+0000
pba__latitude_pb__c, 37.757278
pba__latitude_property__c, 37.757278
laundry_features__c, Inside Area;Washer Included;Dryer Included;Sink
listed_date__c, 2022-02-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Robert
pba__listing_agent_lastname__c, Callan
listing_agent_mls_id__c, 804668
ffd_listingagentname, Robert R Callan Jr.
listing_agent_number__c, 166014312
listing_co_agent_mls_id__c, 215760
listing_co_agent_number__c, 215760
listing_co_office_mls_id__c, STHB4
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 28397
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 1500000
pba__listingtype__c, Sale
pba__listing_website__c, http://917York.com
pba__longitude_pb__c, -122.408338
lower_level__c, Garage,Partial Bath(s)
mls_id__c, 422684091
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2022-08-05
original_price__c, 1500000
overall_days_on_market__c, -81300
parking_access__c, Tandem
parking_features__c, Attached,Interior Access,Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-08-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 773.2
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000YXq3OUAT
room_type__c, Sun Room;Kitchen;Living Room;Dining Room
sale_date__c, 2022-09-13
sale_price__c, 1500000
security_features__c, Carbon Mon Detector
selling_agent_mls_id__c, 812207
selling_agent_number__c, 1055536
selling_co_agent_mls_id__c, 808482
selling_co_agent_number__c, 1035858
selling_co_office_mls_id__c, KWADVSF
selling_co_office_name__c, KW Advisors
selling_co_office_number__c, 28861
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, York
subdist__c, The Mission
ffd_name, 917 York Street, San Francisco, CA, 94110
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
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/530508634-1.jpg