meta_query='key:subdist__c;value:Silver Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327871' 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] => 2018-11-30 20:41:49
[post_modified_gmt] => 2018-11-30 20:41:49
[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, 151 Venus Street, San Francisco, CA, 94124
ffd_mls_id, 423727198
ffd_salesforce_id, a0E8W00000bFs3tUAC
num_of_fireplaces__c, 1
num_of_rooms__c, 12
of_units__c, 0
address2__c, 151 Venus Street, San Francisco, CA, 94124
pba__address_pb__c, 151 Venus Street, San Francisco, CA, 94124
agent_only_remarks__c, Recently renovated from ground up! Per seller's architect, the lower floor is not an ADU, and the second kitchen is legal. It is still a SFH. Please contact Aimee with questions. Offers are due Tuesday, 3/28 by noon. Disclosures can be viewed here: https://app.disclosures.io/link/151-Venus-Street-8ly77fcx
appliances__c, Gas Water Heater;Hood Over Range;Tankless Water Heater;Free Standing Gas Oven;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Fiberglass;Quartz
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1946
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-03-16T20:48:29.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, Stunning modern home in sunny Silver Terrace. Living is easy in this impressive, stylishly contemporary residence with a flexible floor plan for the modern pleasure-seeker. This gorgeous beauty is nestled on a quiet wider block in the convenient neighborhood. The floorplan encompasses three spacious bedrooms with plenty of space for work from home, study, entertainment, sleep & storage, three sleek bathrooms, two living rooms, and two stylish chef's kitchens that flow through to the tranquil garden. It is a two-story single-family home with a legal in-law quarter, which is ideal for a family with a private quarter for teens, in-laws, or guests. This home is also perfectly positioned to enjoy the proximity to parks, supermarkets, and public transit. Ideal quick access to freeway 101 & 280. Two-car parking space, including one-car garage and one-car in the deep driveway. Don't miss it!
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
fireplace_features__c, Living Room;Electric
pba__floortype_pb__c, Tile;Vinyl
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Gas;Fireplace Insert
interior_features__c, Skylight(s);Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2023-03-21T10:48:31.000+0000
pba__latitude_pb__c, 37.7307035
pba__latitude_property__c, 37.7307035
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2023-03-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Juanjuan
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 808889
ffd_listingagentname, Aimee J Huang
listing_agent_number__c, 1038314
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 1568000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=u8pDK1ZDo7L&brand=0
pba__longitude_pb__c, -122.3977041
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Kitchen,Street Entrance
mls_id__c, 423727198
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-03-16
open_house_end__c, 2023-03-21T16:00:00.000+0000
open_house_start__c, 2023-03-21T14:00:00.000+0000
original_price__c, 1568000
overall_days_on_market__c, -81523
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front,Guest Parking Available,Interior Access,Private
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 638.7
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFs3tUAC
room_type__c, Storage;Kitchen;In Law Apartment;Living Room;Baths Other;Dining Room;Family Room;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector;Video System
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2455
size__c, 2455
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Venus
subdist__c, Silver Terrace
ffd_name, 151 Venus Street, San Francisco, CA, 94124
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens;Caulked/Sealed
pba__yearbuilt_pb__c, 1946
pba__postalcode_pb__c, 94124
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530591474-1.jpg