meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='383399' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12174
[post_author] => 4
[post_date] => 2018-10-30 00:43:28
[post_date_gmt] => 2018-10-30 00:43:28
[post_content] => Welcome to Pacific Heights west. Developed beginning in the 1910s and 1920s on land that once belonged to Adolph Sutro, it'll make it clear right away that you've arrived in San Francisco's flagship residential park. The construction craze of the era featured the best of city amenities (sidewalks, street lights!) with wide streets, clear neighborhood boundaries, and plenty of green parks for play within the neighborhood.
[post_title] => St. Francis Wood
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => st-francis-wood
[to_ping] =>
[pinged] =>
[post_modified] => 2024-06-04 09:58:17
[post_modified_gmt] => 2024-06-04 16:58:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12174
[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, 1735681877
ffd_listing_title, 275 Santa Clara Avenue, San Francisco, CA, 94127
ffd_mls_id, 424045295
ffd_salesforce_id, a0EUd000002XWrBMAW
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 275 Santa Clara Avenue, San Francisco, CA, 94127
pba__address_pb__c, 275 Santa Clara Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Pre Escrow open with Katerina Rosignuolo at WFG National Title. Offer Date TBD. Offers to be submitted on 8 page SFAR Form. Disclosure package available upon request. Please call Jane 415.378.8635 with any questions. Note: LifeSource Water System is excluded from the sale.
appliances__c, Dishwasher;Insulated Water Heater;Gas Water Heater;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Traditional;Colonial
bath_features__c, Tub w/Shower Over;Tile;Quartz;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-10T18:47:12.000+0000
days_on_market__c, 174
dom__c, 7
ffd_description_pb, This distinguished Colonial Revival home impresses with its classic architecture, beautiful interiors, impeccable quality, sophisticated design & modern open floor plan. Extensively renovated in 2019, the home welcomes with a perfect blend of historic charm & contemporary lifestyle. The main level offers a grand style living room with gas fireplace, a spectacular open concept kitchen, charming half bath, laundry & home office. The enviable kitchen showcases custom cabinetry, slab quartz counters, center island & fully integrated appliances, including Thermador, Bosch & a unique French Blue Big Chill gas range. Tall windows & French doors connect the interior to the fenced backyard, w lush lawn, tranquil fountain, outdoor barbecue kitchen & fire pit. Upstairs are 3 bedrooms including the primary suite w custom walk-in closet & luxurious spa bath. The lower level hosts a comfortable family room with dry bar & deluxe temperature-controlled wine cellar, a perfect place to relax and entertain. Other amenities: a fully accessible 245 sq ft attic for extra storage, upgraded electrical & plumbing systems, new HVAC system, high-end fixtures, finishes & designer lighting. Situated in the heart of St. Francis Wood the home is steps away from Terrace Green Park & vibrant West Portal Village.
275 Santa Clara Avenue, San Francisco, CA, 94127 - Property Description
This distinguished Colonial Revival home impresses with its classic architecture, beautiful interiors, impeccable quality, sophisticated design & modern open floor plan. Extensively renovated in 2019, the home welcomes with a perfect blend of historic charm & contemporary lifestyle. The main level offers a grand style living room with gas fireplace, a spectacular open concept kitchen, charming half bath, laundry & home office. The enviable kitchen showcases custom cabinetry, slab quartz counters, center island & fully integrated appliances, including Thermador, Bosch & a unique French Blue Big Chill gas range. Tall windows & French doors connect the interior to the fenced backyard, w lush lawn, tranquil fountain, outdoor barbecue kitchen & fire pit. Upstairs are 3 bedrooms including the primary suite w custom walk-in closet & luxurious spa bath. The lower level hosts a comfortable family room with dry bar & deluxe temperature-controlled wine cellar, a perfect place to relax and entertain. Other amenities: a fully accessible 245 sq ft attic for extra storage, upgraded electrical & plumbing systems, new HVAC system, high-end fixtures, finishes & designer lighting. Situated in the heart of St. Francis Wood the home is steps away from Terrace Green Park & vibrant West Portal Village.
Main Level: Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
Exterior Features: BBQ Built-In;Kitchen
Window Features: Dual Pane Partial
Security Features: Smoke Detector;Carbon Mon Detector;Security System Prewired
Road Surface Type: Paved
Roof: Composition;Shingle;Fiberglass
Interior Features
Interior Features
Interior Features: Formal Entry;Storage Area(s)
Heating: Central;Fireplace(s);Natural Gas
Appliances: Dishwasher;Insulated Water Heater;Gas Water Heater;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Wine Refrigerator;Built-In Refrigerator
