meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='339611' 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, 1696417734
ffd_listing_title, 345 Santa Clara Avenue, San Francisco, CA, 94127
ffd_mls_id, 423900019
ffd_salesforce_id, a0E8W00000cpesrUAA
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 345 Santa Clara Avenue, San Francisco, CA, 94127
pba__address_pb__c, 345 Santa Clara Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offers reviewed starting Tuesday 9/5 at 12 Noon. This is an 'AS IS' Trust Sale. Please use a SFAR Purchase Contract & stipulate that the buyer's initial deposit will be in escrow within one business day of acceptance. Escrow opened with WFG National Title Insurance Company, escrow officer Katerina Rosignuolo 415-919-9853. Please email [email protected] for all showings. (I do not receive text messages from the number listed).
appliances__c, Dishwasher;Hood Over Range;Double Oven;Built-In Refrigerator;Gas Cook Top;Gas Plumbed
bath_features__c, Tub w/Shower Over;Tile;Jack & Jill
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:52:08.000+0000
days_on_market__c, 41
dom__c, 12
ffd_description_pb, Majestic Spanish Mediterranean view home perfectly situated on a gentle knoll, close to West Portal Village! An elegant lush garden entrance leads to a wonderful double-arched columned portico w/notable front door & into an impressive lobby-like foyer w/handsome wrought-iron open-banister staircase & convenient coat closet. Grand formal living rm w/high ceiling boasts an exquisite fireplace w/original stone mantel surround, large picture windows, crown moldings, gleaming hardwood floors & French doors that open to the garden. Remarkable banquet-size formal dining rm w/striking chandelier. Splendid updated kitchen w/spacious breakfast area showcases all stainless steel appliances incl a Bosch five-burner gas stovetop w/Broan hood, quartz counters, painted wood cabinets, big pantry closet & direct access to the yard. Terrific home office/4th BR. 3BR/2BA up incl the spectacular master suite w/Pacific Ocean views, walk-in closet w/artistic leaded-glass window, dressing rm w/built-in vanity & adjoining vintage tile en-suite bath w/pedestal sink & cast iron tub. Laundry/hobby rm. Beautiful walk-out landscaped backyard w/tradesman's entrance, brick patio & step-up terrace w/seating area, mature olive trees, sweeping lawn & blooming flowerbeds! Huge 2 car parking garage w/ample storage.
345 Santa Clara Avenue, San Francisco, CA, 94127 - Property Description
Majestic Spanish Mediterranean view home perfectly situated on a gentle knoll, close to West Portal Village! An elegant lush garden entrance leads to a wonderful double-arched columned portico w/notable front door & into an impressive lobby-like foyer w/handsome wrought-iron open-banister staircase & convenient coat closet. Grand formal living rm w/high ceiling boasts an exquisite fireplace w/original stone mantel surround, large picture windows, crown moldings, gleaming hardwood floors & French doors that open to the garden. Remarkable banquet-size formal dining rm w/striking chandelier. Splendid updated kitchen w/spacious breakfast area showcases all stainless steel appliances incl a Bosch five-burner gas stovetop w/Broan hood, quartz counters, painted wood cabinets, big pantry closet & direct access to the yard. Terrific home office/4th BR. 3BR/2BA up incl the spectacular master suite w/Pacific Ocean views, walk-in closet w/artistic leaded-glass window, dressing rm w/built-in vanity & adjoining vintage tile en-suite bath w/pedestal sink & cast iron tub. Laundry/hobby rm. Beautiful walk-out landscaped backyard w/tradesman's entrance, brick patio & step-up terrace w/seating area, mature olive trees, sweeping lawn & blooming flowerbeds! Huge 2 car parking garage w/ample storage.
