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 2954 23rd Street, San Francisco, CA, 94110
ffd_mls_id 493687
ffd_salesforce_id a0E1I00000RqcvPUAR
num_of_fireplaces__c 1
num_of_rooms__c 8
of_units__c 0
address2__c 2954 23rd Street, San Francisco, CA, 94110
pba__address_pb__c 2954 23rd Street, San Francisco, CA, 94110
agent_only_remarks__c OFFERS DUE WED, 3/11/20 BY 3:00 PM. No Preemptive Offers. Disclosures and Offer Instructions available via Disclosure.io link above. Trust Sale. No court confirmation. Property to be sold in its As-Is condition with no warranties expressed or implied. Property on Supra iBox and easy to show. WATER SERVICE TURNED OFF DUE TO LEAK IN YARD. Safe in office is included in the sale. (Seller has combination.) Pre-escrow (0216030299-DB) opened w/ David Banker at Old Republic Title Co. 415-239-6165. Seller reserves the right to accept, reject or counter any and all offer(s). No Preemptive Offers. Buyer to pay for all energy and water compliance work. Listing Broker is also an attorney and a partner at the Law Offices of Paolini & Mori.
bath_features__c Tub w/Shower Over
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 3
year_build_text__c 1924
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
ffd_createddate 2020-02-28T11:46:07.000+0000
days_on_market__c 965
dom__c 13
ffd_description_pb Incredible fixer opportunity in the Inner Mission. Ideal project for investors or developers. Upper unit consists of 2 bedrooms, 1 bath, formal living room with fireplace, dining room and spacious kitchen with breakfast nook and large pantry area. Lower unit (2954 A) consists of 1 bedroom, 1 bath, kitchen / living room combo, and office. Lower unit may be unwarranted (buyers to investigate). Separate laundry / mechanical room. One car garage and secluded yard. Excellent Mission location - Walk Score 99; Transit Score 84; and Bike Score 98. Close to BART, freeway and tech shuttles.
Incredible fixer opportunity in the Inner Mission. Ideal project for investors or developers. Upper unit consists of 2 bedrooms, 1 bath, formal living room with fireplace, dining room and spacious kitchen with breakfast nook and large pantry area. Lower unit (2954 A) consists of 1 bedroom, 1 bath, kitchen / living room combo, and office. Lower unit may be unwarranted (buyers to investigate). Separate laundry / mechanical room. One car garage and secluded yard. Excellent Mission location - Walk Score 99; Transit Score 84; and Bike Score 98. Close to BART, freeway and tech shuttles.
