meta_query='key:subdist__c;value:Forest Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215377' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12152
[post_author] => 4
[post_date] => 2018-10-29 01:18:51
[post_date_gmt] => 2018-10-29 01:18:51
[post_content] => Adolph Sutro once owned all the land in Forest Hill, which his heirs sold to developers early in the 20th century. The first home in the neighborhood was sold in 1914, and it’s a safe bet that other than more mature trees and fancier cars in the garages, this stately neighborhood looks much the same as it did 100+ years ago.
[post_title] => Forest Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => forest-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-06-04 11:03:53
[post_modified_gmt] => 2024-06-04 18:03:53
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12152
[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, 45 Castenada Avenue, San Francisco, CA, 94116
ffd_mls_id, 507583
ffd_salesforce_id, a0E1I00000TRo1aUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 45 Castenada Avenue, San Francisco, CA, 94116
pba__address_pb__c, 45 Castenada Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Offers due Wednesday 10/21 by 12 noon. Use SFAR Purchase Contract only. Stipulate on Purchase Contract that Buyer's initial deposit to be in escrow within one business day of acceptance. Escrow opened with First American Title, Liz Paglinawan 415-682-1112. Do NOT Send Text Messages. Email ONLY for ALL showing requests, we are not using ShowingTime and will not respond to any automated messages. Property is being marketed under Covid19 guidelines. Buyer's agent must provide their buyer's signed PEAD-V and pre-approval letter or POF before viewing home. All visitors must wear masks & use hand sanitizer. 3D Tour available on the MLS, just click on visual media. Floor plans are on property brochure in the last two photos.
appliances__c, Dishwasher;Microwave;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Double Oven
architectural_style__c, Traditional;Arts & Crafts
bath_features__c, Tub w/Shower Over;Remodeled;Marble;Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-10-07T22:46:06.000+0000
days_on_market__c, 1015
dom__c, 14
ffd_description_pb, Exquisite remodeled Craftsman home tucked away on enormous lot & wonderful block, close to Forest Hill MUNI Station! Storybook garden entrance w/patio, lawn, fountain & colorful plants & trees. Magnificent formal living rm boasts fireplace w/classic mantel, recessed ceiling & lights, wide moldings & hardwood flrs. Stunning open dining rm w/striking six-tiered chandelier & huge picture window w/views of a romantic sylvan setting! Spectacular gourmet kitchen w/skylight showcases all built-in stainless-steel Thermador appliances incl a six-burner gas range top w/pot-filler & double-oven, coffee station, white quartz counters w/glass tile backsplash, custom wood cabinets, fun breakfast bar & double sliding glass doors that open to a walk-out balcony w/views to Twin Peaks. 3BR/2BA on the same floor incl master suite w/walk-out patio/garden, huge walk-in closet & marble tile bath w/dual vanity sink. Terrific playroom, laundry area, wine/storage rm. Bucolic parklike backyard w/amazing deck!
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Wood
hoa_dues__c, 1444
pba__hoafees__c, 1444
pba__hoafrequency_pb__c, Annually
hoa_name__c, Forest Hill HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:37:03.000+0000
pba__latitude_pb__c, 37.750366
pba__latitude_property__c, 37.750366
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-10-07
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, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.andrewherrera.com/
pba__longitude_pb__c, -122.461673
pba__lotsize_pb__c, 0.18
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Master Bedroom
mls_id__c, 507583
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-10-07
original_price__c, 1995000
overall_days_on_market__c, 182
parking__c, Garage,Auto Door
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Deck(s);Patio(s)
pba__pendingdate__c, 2020-10-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 947.65
pba__propertytype__c, Single Family Residence
id, a0E1I00000TRo1aUAD
room_type__c, Wine Cellar
sale_date__c, 2020-11-23
sale_price__c, 2100000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 808563
selling_agent_name__c, Sherry Juneja
selling_agent_number__c, 1036824
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 2216
size__c, 2216
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Castenada
subdist__c, Forest Hill
ffd_name, 45 Castenada Avenue, San Francisco, CA, 94116
view__c, City Lights;Partial;Twin Peaks;Hills;Forest
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371813-1.jpg
ListingId, a0E1I00000TRo1aUAD
