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
(
)
)
_yoast_indexnow_last_ping, 1727952774
ffd_listing_title, 822 Shotwell Street, San Francisco, CA, 94110
ffd_mls_id, 424064670
ffd_salesforce_id, a0EUd000003FFhnMAG
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 822 Shotwell Street, San Francisco, CA, 94110
pba__address_pb__c, 822 Shotwell Street, San Francisco, CA, 94110
agent_only_remarks__c, Call listing agent to show. Do not disturb the occupants. Lots of moving and removing of items after three generations of habitation. If bringing clients please be careful and mindful of the boxes and storage of items. Offers are accepted as they come in. Always Escrow opened at WFG Title with Steve Salviejo File# 24-186975 - much obliged to keep it there. Disclosures are here: https://app.disclosures.io/link/822-Shotwell-Street-qke1sce1
appliances__c, Insulated Water Heater;Free Standing Gas Range;Free Standing Refrigerator
ffd_description_pb, First time on the market in over 70 years! This Edwardian style family gem needs the right visionary to come and realize the remarkable potential that this property presents. The local zoning (RH3) allows for easy construction of an ADU in the backyard area of the 142 foot parcel. Oak hardwood floors have been refinished and time period character adorns the interior. The kitchen has been partially updated with appliances and counter tops. Other portions of the house is awaiting further updating, polish, and finishing touches to bring this three story diamond in the rough glisten in the 21st century. This is the perfect property for multi-family and investment opportunities.
district__c, SF District 9
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
822 Shotwell Street, San Francisco, CA, 94110 - Property Description
First time on the market in over 70 years! This Edwardian style family gem needs the right visionary to come and realize the remarkable potential that this property presents. The local zoning (RH3) allows for easy construction of an ADU in the backyard area of the 142 foot parcel. Oak hardwood floors have been refinished and time period character adorns the interior. The kitchen has been partially updated with appliances and counter tops. Other portions of the house is awaiting further updating, polish, and finishing touches to bring this three story diamond in the rough glisten in the 21st century. This is the perfect property for multi-family and investment opportunities.
