meta_query='key:subdist__c;value:Silver Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332037' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70687
[post_author] => 4
[post_date] => 2018-11-30 20:41:49
[post_date_gmt] => 2018-11-30 20:41:49
[post_content] => Silver Terrace is very central yet oddly aloof thanks to geographical fate. Bordered to the north, south, and east by freeway and industrial park, it perches above the Bayview, and select homes offer stunning bridge views.
[post_title] => Silver Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => silver-terrace
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 11:46:04
[post_modified_gmt] => 2024-04-11 18:46:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70687
[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, 175 Charter Oak Avenue, San Francisco, CA, 94124
ffd_mls_id, 422713155
ffd_salesforce_id, a0E8W00000a66ftUAA
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 175 Charter Oak Avenue, San Francisco, CA, 94124
pba__address_pb__c, 175 Charter Oak Avenue, San Francisco, CA, 94124
agent_only_remarks__c, There are actually 2 bedrooms and 1 bath, although assessor records indicate 0 bedrooms. This is an AS-IS sale which may have to have probate court approval. All lot and home dimensions need to be verified by the Buyer. Home is occupied. Please do not disturb the occupants. Sellers may need a 3 to 6 week rent-back. When presenting your offer, please include proof of funds or a Pre-approval letter from an approved Lender. Escrow has been opened at DOMA with Donna Andersen at (650) 343-6282. Donna has done background research on this listing to facilitate a smooth and swift closing. Contact listing agent with any questions (Charles Clerkley, 415-218-8473 call/text), or by email [email protected].
architectural_style__c, Ranch
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 0
year_build_text__c, 1917
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-01-27
cooling__c, Ceiling Fan(s)
ffd_createddate, 2022-12-25T01:45:36.000+0000
days_on_market__c, 211
dom__c, 35
ffd_description_pb, Rare FIXER available in sought after Silver Terrace neighborhood of San Francisco. Lots of upside potential. There is SOLAR installed on the roof which the owner/occupants say is paid for. It was installed in 2016. The house occupies 2 lots with separate APNs (5377-035 & 5377-034). Both are included in this sale. Exceptional location near Thurgood Marshall High School and Willie L. Brown Jr. Academy, Cornerstone Academy-Silver Campus is nearby, new Soccer Field (Silver Terrace Althletic Fields) 1 block away. San Bruno Ave commercial district is 3 blocks away. 101 Fwy & 280 Fwy are blocks away. 7 mins to downtown and 10 mins to SFO airport.
district__c, SF District 10
driveway_sidewalks__c, Unpaved
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
height_limit__c, Unknown
ffd_lastmodifieddate, 2023-07-13T18:12:46.000+0000
pba__latitude_pb__c, 37.734837
pba__latitude_property__c, 37.734837
laundry_features__c, Inside Area
listed_date__c, 2022-12-17
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charles
pba__listing_agent_lastname__c, Clerkley
listing_agent_mls_id__c, 812794
ffd_listingagentname, Charles E Clerkley
listing_agent_number__c, 1058270
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REMS
listing_office_name__c, RE/MAX Star Properties
listing_office_number__c, 199021441
pba__listingprice_pb__c, 699000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4043115
mls_id__c, 422713155
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Family Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 4
on_market_date__c, 2022-12-20
original_price__c, 799000
overall_days_on_market__c, -81437
parking_access__c, Tandem
parking_features__c, No Garage,Uncovered Parking Spaces 2+
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Front Porch
pba__pendingdate__c, 2023-01-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 586.96
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a66ftUAA
road_surface_type__c, Asphalt
roof__c, Shingle
room_type__c, Laundry;Kitchen;Living Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 2023-02-27
sale_price__c, 675000
security_features__c, Smoke Detector;Window Security Bars
selling_agent_mls_id__c, 808467
selling_agent_number__c, 1035533
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1150
size__c, 1150
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Charter Oak
subdist__c, Silver Terrace
ffd_name, 175 Charter Oak Avenue, San Francisco, CA, 94124
view__c, City;City Lights;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530564267-1.jpg