meta_query='key:subdist__c;value:Silver Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237006' 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, 475 Thornton Avenue, San Francisco, CA, 94124
ffd_mls_id, 422660716
ffd_salesforce_id, a0E8W00000WjOjYUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 475 Thornton Avenue, San Francisco, CA, 94124
pba__address_pb__c, 475 Thornton Avenue, San Francisco, CA, 94124
agent_only_remarks__c, Lovely home and ready for a family! Located in affordable Silver Terrace neighborhood. Newer roof, forced-air heating, circuit breakers, extra storage area, etc. Supra lockbox placed already. Offer accepted. Looking for back up 1.25 mil.. Please sign off on disclosures and include proof of funds and preapproval letter with your offer. Escrow already opened with Chicago Title in Daly City. Any questions? Please contact Richard Cairo cell: 650.303.2490 or [email protected] Here are your clean disclosures. https://app.disclosures.io/link/475-Thornton-Avenue-bv0uyzhq
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Skylight/Solar Tube
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1950
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-05-29
ffd_createddate, 2022-05-18T21:48:09.000+0000
days_on_market__c, 427
dom__c, 11
ffd_description_pb, Beautiful and well maintained home in sunny Silver Terrace, SF. Main Level: Tunnel entrance w/ terrazzo steps, 2 Bedroom , 1 full/large bath with skylight, Living/dining room combo, living room w/ fireplace, wood floors throughout, custom ceilings, remodeled kitchen, low maintenance yard with new stairs leading to yard. Lower level: 3rd bedroom, 2nd bath with permit per owner, 1 car enclosed parking w/ auto-garage door, security gate.
district__c, SF District 10
driveway_sidewalks__c, Gated,Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:10:19.000+0000
pba__latitude_pb__c, 37.731349
pba__latitude_property__c, 37.731349
laundry_features__c, Hookups Only
listed_date__c, 2022-03-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Richard
pba__listing_agent_lastname__c, Cairo
listing_agent_mls_id__c, 336724
ffd_listingagentname, Rich J Cairo
listing_agent_number__c, 336724
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, INTR13
listing_office_name__c, Intero Real Estate Services
listing_office_number__c, 26723
pba__listingprice_pb__c, 948888
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.398283
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 422660716
main_level__c, Full Bath(s);Bedroom(s);Living Room;Street Entrance
master_bathroom_features__c, Low-Flow Toilet(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-05-18
original_price__c, 948888
overall_days_on_market__c, -81221
parking_access__c, Tandem
parking_features__c, Covered,Enclosed
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-05-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 716.42
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000WjOjYUAV
road_surface_type__c, Asphalt,Gravel
room_type__c, Bonus Room
sale_date__c, 2022-06-26
sale_price__c, 1200000
security_features__c, Smoke Detector;Security Gate;Security Fence;Carbon Mon Detector
selling_agent_mls_id__c, 805761
selling_agent_number__c, 166015806
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 1675
size__c, 1675
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Thornton
subdist__c, Silver Terrace
ffd_name, 475 Thornton Avenue, San Francisco, CA, 94124
view__c, City
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1950
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530460709-1.jpg
ListingId, a0E8W00000WjOjYUAV