meta_query='key:subdist__c;value:Silver Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209900' 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, 250 Bridgeview Drive, San Francisco, CA, 94124
ffd_mls_id, 494187
ffd_salesforce_id, a0E1I00000Qo65QUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 250 Bridgeview Drive, San Francisco, CA, 94124
pba__address_pb__c, 250 Bridgeview Drive, San Francisco, CA, 94124
agent_only_remarks__c, Offers To be reviewed next Monday 2/10 at 3 PM. Be sure to lock up and secure the building after showing. The front gate is a little loose, so make sure it is secured. Graphic artist measurements are larger than tax records. We are making no claim to the legal square footage of the home. Buyer advised to do their own measurements and due diligence. Review 3R. All work appears to be permitted. Pre escrow is opened with Chicago Title at 3001 Junipero Serra Blvd. with Kathie Ng 415-405-1315. Escrow #3541901550.
architectural_style__c, Traditional
bath_features__c, Remodeled;Dual Flush Toilet
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1949
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-02-10
ffd_createddate, 2020-01-26T23:45:17.000+0000
days_on_market__c, 1270
dom__c, 17
ffd_description_pb, A rare opportunity in San Francisco's Silver Terrace. From the moment you walk through the front door you realize you have entered a very unique home. Featuring 3 bedrooms and 2 full baths and plenty of room to expand. Largely remodeled with environmentally conscious materials; this home exudes a thoughtful elegance that capitalizes on the panoramic views from its reverse plan layout. The rear deck descends into a park-like backyard setting, perfect for entertaining. With easy access to both the 280 and 101 freeways; and with commercial corridors along 3rd Street and San Jose Avenue nearby; this property has a removed open feel while still being very close to the action and that embodies soul of San Francisco.
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:27:02.000+0000
pba__latitude_pb__c, 37.73422
pba__latitude_property__c, 37.73422
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-01-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Todd
pba__listing_agent_lastname__c, Wiley
listing_agent_mls_id__c, 804390
ffd_listingagentname, Todd Wiley
listing_agent_number__c, 166013929
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 998000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.39778
pba__lotsize_pb__c, 0.05
lower_level__c, Full Bath(s),Master Bedroom
mls_id__c, 494187
main_level__c, Full Bath(s);Bedroom(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-01-26
original_price__c, 998000
overall_days_on_market__c, 156
parking_access__c, Tandem
parking_features__c, Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-02-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000Qo65QUAR
roof__c, Tar/Gravel
room_type__c, Storage;Bonus Room;Den
sale_date__c, 2020-03-02
sale_price__c, 1250000
selling_agent_mls_id__c, EB286560
selling_agent_number__c, 981313966
selling_co_agent_mls_id__c, 812558
selling_co_agent_name__c, Anthony E. Booker
selling_co_agent_number__c, 1057037
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Bridgeview
subdist__c, Silver Terrace
ffd_name, 250 Bridgeview Drive, San Francisco, CA, 94124
transportation__c, 1 Block
view__c, Panoramic
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1949
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359641-1.jpg
ListingId, a0E1I00000Qo65QUAR