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] => 2021-12-01 19:45:32
[post_modified_gmt] => 2021-12-02 03:45:32
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E8W00000WkdtxUAB
pba__address_pb__c 2175 Quesada Avenue, San Francisco, CA, 94124
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 5
days_on_market__c 23
mls_id__c 422665373
pba__totalarea_pb__c 0
pba__latitude_pb__c 37.738202
pba__longitude_pb__c -122.4004458
pba__state_pb__c CA
pba__status__c Active
pba__street_pb__c Quesada
listed_date__c 2022-06-02
sale_date__c 1800-01-01
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 1450000
pba__listingtype__c Sale
sale_price__c 0
address2__c 2175 Quesada Avenue, San Francisco, CA, 94124
pba__listing_agent_firstname__c Paula
pba__listing_agent_lastname__c Rose
view__c Garden/Greenbelt
pba__halfbathrooms_pb__c 0
parkingspaces__c 2
pba__postalcode_pb__c 94124
year_build_text__c 0
size__c 0
subdist__c Silver Terrace
listing_agent_mls_id__c 802963
listing_co_office_number__c 0
listing_office_number__c 28751
listing_office_name__c Compass
listing_office_mls_id__c COMP7
of_units__c 0
district__c SF District 10
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c -81237
dom__c 22
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 0
parking_type__c On Site (Single Family Only)
original_price__c 1450000
agent_only_remarks__c Brand New construction. Vacant and staged. Impeccable gem! Perfect set up for two units. Streamlined for the ADU process. Please call Paula for further information and disclosures at 415-724-3424 or with [email protected]
Brand New Construction! Welcome to 2175 Quesada, a stunning 5br + 3ba multi-level luxury residence that has been built with modern features and elegant finishes. A high-tech design created with warmth for your live/work enjoyment. High ceilings, hardwood floors, neutral colors and natural stones. An inviting and open floor plan with living room and gas burning fireplace along with dining room are bright and spacious. Gather at the island in the kitchen with quartz countertop and top of the line energy efficient appliances. The main level has 3 bedrooms and 2 bathrooms. The ensuite has large closets, a soaking tub and shower along with deck and garden access. The two additional bedrooms have easy access to the 2nd full bath. The lower level is the perfect retreat for friends, family and entertainment. There are 2 bedrooms, great room + bath. Explore the possibilities of creating an ADU. Pre-wired for your electronic devices. 2-3 car pkg. Easy fwy access. Close to Farmer's Market.
