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
(
)
)
_yoast_indexnow_last_ping, 1721991355
ffd_listing_title, 2045 Quesada Avenue, San Francisco, CA, 94124
ffd_mls_id, 424039809
ffd_salesforce_id, a0EUd000002FUkdMAG
num_of_fireplaces__c, 0
num_of_rooms__c, 13
of_units__c, 0
address2__c, 2045 Quesada Avenue, San Francisco, CA, 94124
pba__address_pb__c, 2045 Quesada Avenue, San Francisco, CA, 94124
agent_only_remarks__c, Escrow has been opened with Thuy Hurley @Chicago Title. Please contact LA Carina (415) 510-0631 or Hossam (650) 892-7730 for details. AS-IS Sale. Seller reserves the right to accept, counter or reject all or any offers. Offer is subject to seller 1031 exchange at no cost to buyer. DO NOT disturb occupant! Lockbox locates at the top of staircase. Open House: Sat 7/27 12-4pm & Sun 7/28 12-4pm. Disclosures available at: https://app.disclosures.io/link/2045-Quesada-Avenue-82xbfhuc
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range
ffd_description_pb, Welcome to your dream home! This expansive 4,335 sq. ft. residence offers luxury, comfort, and stunning views of the Bay Bridge and downtown skyline. As an environmentally conscious bonus, it's equipped with 30 solar panels on the roof. The main floor boasts three versatile rooms, including one with an attached half bath, a full bathroom, a family room, and a gourmet kitchen with a laundry closet. Access to the deck and backyard is via a wooden staircase connecting all floors. The upper floor features two master bedrooms, each with a full bathroom, a third full bathroom near the wet bar, an additional room, and a living room with breathtaking views. The ground floor offers two spacious rooms, a half bath, a cozy family room, and a one-car garage with an attached storage room. Outside, enjoy the low-maintenance backyard with artificial turf and a charming garden. With four separate entrances, this home ensures convenience and privacy for all occupants. Contact us today to schedule a private tour!
2045 Quesada Avenue, San Francisco, CA, 94124 - Property Description
Welcome to your dream home! This expansive 4,335 sq. ft. residence offers luxury, comfort, and stunning views of the Bay Bridge and downtown skyline. As an environmentally conscious bonus, it's equipped with 30 solar panels on the roof. The main floor boasts three versatile rooms, including one with an attached half bath, a full bathroom, a family room, and a gourmet kitchen with a laundry closet. Access to the deck and backyard is via a wooden staircase connecting all floors. The upper floor features two master bedrooms, each with a full bathroom, a third full bathroom near the wet bar, an additional room, and a living room with breathtaking views. The ground floor offers two spacious rooms, a half bath, a cozy family room, and a one-car garage with an attached storage room. Outside, enjoy the low-maintenance backyard with artificial turf and a charming garden. With four separate entrances, this home ensures convenience and privacy for all occupants. Contact us today to schedule a private tour!
