meta_query='key:subdist__c;value:St. Francis Wood|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337835' 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] => 2023-06-23 12:11:32
[post_modified_gmt] => 2023-06-23 19:11:32
[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
(
)
)
ffd_listing_title, 254 Santa Paula Avenue, San Francisco, CA, 94127
ffd_mls_id, 423758203
ffd_salesforce_id, a0E8W00000cqLlUUAU
num_of_fireplaces__c, 3
num_of_rooms__c, 11
of_units__c, 0
address2__c, 254 Santa Paula Avenue, San Francisco, CA, 94127
pba__address_pb__c, 254 Santa Paula Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Easy to show by appt call Dona 415-310-5933. Scheduled showings: 9/16 2-4pm; 9/17 2-4pm; 9/19 1-3pm
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Wine Refrigerator;Double Oven;Ice Maker;Built-In Refrigerator;Gas Cook Top;Built-In Freezer;Plumbed For Ice Maker;Built-In Electric Oven
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Sauna;Radiant Heat;Jetted Tub;Window;Jack & Jill
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1958
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Therese Nugent
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-06T02:46:11.000+0000
days_on_market__c, 13
dom__c, 13
ffd_description_pb, This timeless masterpiece is a spacious, detached 4BR/3.5BA residence linking open and dramatic interiors to the surrounding parks and panoramas of St. Francis Wood. The gourmet kitchen, with chef's table area, features overhead natural light plus a south facing patio & herb garden, for BBQ's and sunning. An adjoining formal dining room enjoys bay window views, has built-in cherry wood cabinetry and is adjacent the great room featuring vaulted ceilings, corner fireplace, intimate seating alcove, powder room, wet bar and tall glass doors that open to the wide deck for stunning views of the ocean and surrounding hills. This entry level enjoys interior access from the front garage. 3BR/2BA on midlevel radiate around a large family room with fireplace, butler's kitchen bar and wide view windows. Hardwood floors on top two floors. Radiant heat throughout. The primary suite and spa on the lower level includes a sauna, generous walk-in closet/dressing room + laundry & housekeeping office, all with contemporary loft-style concrete floors and high ceilings. Amenities include fireplace and a glass sliding wall that opens to a protected sunny balcony surrounded by hillside landscaping and lighting. This level benefits from its proximity to the green-roof rear garage and extra storage.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped;Family Room;Primary Bedroom
This timeless masterpiece is a spacious, detached 4BR/3.5BA residence linking open and dramatic interiors to the surrounding parks and panoramas of St. Francis Wood. The gourmet kitchen, with chef's table area, features overhead natural light plus a south facing patio & herb garden, for BBQ's and sunning. An adjoining formal dining room enjoys bay window views, has built-in cherry wood cabinetry and is adjacent the great room featuring vaulted ceilings, corner fireplace, intimate seating alcove, powder room, wet bar and tall glass doors that open to the wide deck for stunning views of the ocean and surrounding hills. This entry level enjoys interior access from the front garage. 3BR/2BA on midlevel radiate around a large family room with fireplace, butler's kitchen bar and wide view windows. Hardwood floors on top two floors. Radiant heat throughout. The primary suite and spa on the lower level includes a sauna, generous walk-in closet/dressing room + laundry & housekeeping office, all with contemporary loft-style concrete floors and high ceilings. Amenities include fireplace and a glass sliding wall that opens to a protected sunny balcony surrounded by hillside landscaping and lighting. This level benefits from its proximity to the green-roof rear garage and extra storage.
