meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='333768' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15556
[post_author] => 4
[post_date] => 2018-11-01 21:53:52
[post_date_gmt] => 2018-11-01 21:53:52
[post_content] => Not always sunny, shameless neighborhood self-promotion aside. Within walking distance to Glen Park BART, mostly single-family homes, bisected by Monterey Ave. Above, Sunnyside on a hill with some great southern views. Below, Sunnyside flatlands bounded by I-280 and City College to the south.
[post_title] => Sunnyside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sunnyside
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 12:14:17
[post_modified_gmt] => 2023-06-23 19:14:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15556
[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, 543 Foerster Street, San Francisco, CA, 94127
ffd_mls_id, 423737335
ffd_salesforce_id, a0E8W00000cJ70rUAC
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 543 Foerster Street, San Francisco, CA, 94127
pba__address_pb__c, 543 Foerster Street, San Francisco, CA, 94127
agent_only_remarks__c, Agents with interested buyers: please pull disclosures so I can communicate with you via io. Property was partially disassembled for a mold remediation. Cost to restore was quoted at $150,000 - $200,000. Seller decided to list as-is. Exit value restored, depending on level of finish, $1,250,000 - $1,350,000. Parking is on the lot with gate at Foerster. Lock box is on fence gate on Mangels @ Foerster. Schedule a private showing by emailing [email protected]. Feel free to text Wendy with questions: 415 519-6091. Buyers should perform any needed inspections prior to offering. We have the historical disclosures from 2008 in IO, it will be updated as additional documents come in: https://app.disclosures.io/link/543-Foerster-Street-hejrozoe Offers due on Mon 6/12 at 10am.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Cottage;Arts & Crafts;Bungalow;Chalet;Cabin
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-06-04T16:47:58.000+0000
days_on_market__c, 45
dom__c, 9
ffd_description_pb, Cash-only fixer, this fully detached cottage on a large corner lot, will make you smile once bath and kitchen finishes are re-installed! Perched on a hill it is surrounded by magnificent trees & winding paths of a once treasured garden. Inside this bright home are charming period details, gorgeous windows & skylights graced with nature themed stained glass still intact. A sensible main floor layout includes sunny atrium, living and dining with wood burning stove & 1/2 bath, spacious kitchen and laundry. Professional quality kitchen appliances are still on-site. Upstairs are sweeping views from a private deck off the primary. Good storage, separate shed, plus two gated parking spots on the lot complete this unique find. Mold remediation required removal of bath, some kitchen finishes, floor and wall finishes. Remediation complete. Would be an easy restoration BUT lenders require habitable condition.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T18:58:43.000+0000
pba__latitude_pb__c, 37.732937
pba__latitude_property__c, 37.732937
laundry_features__c, Washer/Dryer Stacked Included;Inside Area;Stacked Only
listed_date__c, 2023-06-04
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Wendy
pba__listing_agent_lastname__c, Storch
listing_agent_mls_id__c, 803139
ffd_listingagentname, Wendy Storch
listing_agent_number__c, 803139
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__listing_website__c, https://543foerster.com/
pba__longitude_pb__c, -122.44915
mls_id__c, 423737335
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-06-04
original_price__c, 799000
overall_days_on_market__c, -81603
parking_access__c, Independent
parking_features__c, No Garage,Uncovered Parking Space,See Remarks
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 2023-06-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 790.35
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJ70rUAC
room_type__c, Storage;Kitchen;Living Room;Solarium;Baths Other;Great Room
sale_date__c, 2023-06-20
sale_price__c, 901000
selling_agent_mls_id__c, 810310
selling_agent_number__c, 1045605
selling_co_agent_mls_id__c, 812201
selling_co_agent_number__c, 1055483
selling_co_office_mls_id__c, CBLUXURY
selling_co_office_name__c, Coldwell Banker Realty
selling_co_office_number__c, 2128
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1140
size__c, 1140
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Foerster
subdist__c, Sunnyside
ffd_name, 543 Foerster Street, San Francisco, CA, 94127
view__c, City Lights;Garden/Greenbelt;San Francisco;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530628429-1.jpg