meta_query='key:subdist__c;value:Sherwood Forest|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237115' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15557
[post_author] => 4
[post_date] => 2018-11-01 21:53:56
[post_date_gmt] => 2018-11-01 21:53:56
[post_content] => San Francisco’s smallest neighborhood, Sherwood Forest is an elevated enclave built beginning in the 1940s on some of the largest residential lots in the City. Stunning ocean and Bay views, mid-century homes, living in the shadow of the cross on Mount Davidson, and the highest residential street in the City are all quietly hidden away in this neighborhood you've likely never heard of.
[post_title] => Sherwood Forest
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sherwood-forest
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:35:18
[post_modified_gmt] => 2024-03-19 20:35:18
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15557
[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, 234 Casitas Avenue, San Francisco, CA, 94127
ffd_mls_id, 422668117
ffd_salesforce_id, a0E8W00000XicCkUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 234 Casitas Avenue, San Francisco, CA, 94127
pba__address_pb__c, 234 Casitas Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offer date Thursday June 23 by 12 Noon. Please use a SFAR Purchase Contract & stipulate that buyer's initial deposit will be in escrow within one business day of acceptance. Escrow opened with North American Title, Katerina Rosignuolo 415-919-9853. Please email [email protected] for all showings and do not send text messages as the phone number listed is a landline.
appliances__c, Dishwasher;Hood Over Range;Built-In Refrigerator;Gas Cook Top;Gas Plumbed
architectural_style__c, Contemporary;Mid-Century
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Closet
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-06-16T17:46:40.000+0000
days_on_market__c, 398
dom__c, 7
ffd_description_pb, Stunning Contemporary panoramic Pacific Ocean view home tucked away on a wonderful block & park-like setting! Romantic gated entrance w/wide walkway leads to a notable double door & into an enormous lobby-like foyer w/skylight, coat closet & snazzy wet-bar. Magnificent formal living rm w/vaulted ceiling boasts a fireplace, gleaming hardwood floors & a spectacular bank of wall-to-wall/floor-to-ceiling picture windows w/unobstructed views from the Olympic Club & Harding Park to Lake Merced & the Pacific Ocean. Dramatic dining rm w/striking light fixture! Remarkable gourmet kitchen w/spacious breakfast area, huge work-island, menu-planning desk, all stainless-steel appliances incl gas stove, quartz counters, extraordinary custom cabinets, recessed lighting, convenient pantry & terrific adj walk-out deck w/seating. Fabulous master suite w/gorgeous views, big home office/5th BR w/built-in bookshelves & views to a terraced garden, enormous family/media rm w/built-in cabinets, hobby/wine rm!
district__c, SF District 4
driveway_sidewalks__c, Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Skylight(s);Storage Area(s);Cathedral Ceiling;Wet Bar
ffd_lastmodifieddate, 2023-07-13T17:14:17.000+0000
pba__latitude_pb__c, 37.737051
pba__latitude_property__c, 37.737051
laundry_features__c, Washer Included;Dryer Included
listed_date__c, 2022-06-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Herrera II
listing_agent_mls_id__c, 404547
ffd_listingagentname, Andrew Herrera II
listing_agent_number__c, 404547
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, BHFP
listing_office_name__c, Berkshire Hathaway-Franciscan
listing_office_number__c, 1665
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.aryeo.com/v2/7ff4dba3-d4a0-47f3-ad1b-16fed07035d9/videos/86850
pba__longitude_pb__c, -122.460666
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 422668117
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tub;Quartz;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-06-16
original_price__c, 2495000
overall_days_on_market__c, -81250
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Garage Facing Front,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Front Porch
pba__pendingdate__c, 2022-06-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 811.83
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000XicCkUAJ
room_type__c, Storage;Kitchen;Library;Living Room;Baths Other;Dining Room;Family Room;Wine Storage Area;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-07-18
sale_price__c, 2800000
selling_agent_mls_id__c, 807775
selling_agent_number__c, 1025894
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Wigley Realty Investments
pba__status__c, Closed
pba__totalarea_pb__c, 3449
size__c, 3449
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Casitas
subdist__c, Sherwood Forest
ffd_name, 234 Casitas Avenue, San Francisco, CA, 94127
view__c, Ocean;Golf Course;Park;Panoramic;City Lights;Water;Hills;Lake
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530479280-1.jpg
ListingId, a0E8W00000XicCkUAJ