meta_query='key:subdist__c;value:Forest Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320145' 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-04-11 08:30:04
[post_modified_gmt] => 2024-04-11 15:30:04
[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, 102 Castenada Avenue, San Francisco, CA, 94116
ffd_mls_id, 422695855
ffd_salesforce_id, a0E8W00000ZMB3mUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 102 Castenada Avenue, San Francisco, CA, 94116
pba__address_pb__c, 102 Castenada Avenue, San Francisco, CA, 94116
agent_only_remarks__c, VACANT with 2 SUPRA LOCKBOXES located on front door via FRONT stairs on CASTENADA or REAR garden door at garage via long driveway off of ALTON WAY. Offers welcome 11/15/22 by 10:00 am. This is a Trust sale with NO court confirmation. HOA of Forest Hill is $690.00 per year. Buyer to use SFAR purchase contract. Buyer to sign disclosure package and sign MANDATORY addenda. Buyer to provide proof if funds with offer. Seller reserves the right to reject any offer.
architectural_style__c, Mid-Century
bath_features__c, Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1960
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Katie A Tostanoski
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-10-31T15:45:57.000+0000
days_on_market__c, 266
dom__c, 21
ffd_description_pb, PRICE REDUCED! Contemporary and fully detached PANORAMIC VIEW HOME has rare DUAL ACCESS from BOTH Castenada Avenue via the stairway and/or DRIVEWAY off ALTON WAY that leads to the TWO CAR SIDE by SIDE garage. Constructed in 1960, this SPLIT LEVEL spacious residence has great FOREST HILL location and boasts FOUR BEDROOMS and THREE BATHROOMS including a large MASTER SUITE. Lots of excellent amenities include: FULL AU-PAIR level with private entrance, NEWLY PAINTED interior, CUSTOM HARDWOOD floors, GORGEOUS double-paned WINDOWS, SLIDING GLASS DOORS, Solar Panels, SKYLIGHT, Three large DECKS, LARGE-COMBO living/dining room with cozy RAISED wood-burning FIREPLACE, newer STAINLESS STEEL APPLIANCES. BEST PRICE IN SF, COME SEE QUICK!
district__c, SF District 4
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Wood Burning;Brick
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Other
pba__hoafees__c, 690
pba__hoafrequency_pb__c, Annually
hoa_name__c, Forest Hill Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-07-13T18:03:19.000+0000
pba__latitude_pb__c, 37.749503
pba__latitude_property__c, 37.749503
laundry_features__c, Laundry Closet
listed_date__c, 2022-10-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Hawko
listing_agent_mls_id__c, 378394
ffd_listingagentname, Tim Hawko
listing_agent_number__c, 378394
listing_co_agent_mls_id__c, 810040
listing_co_agent_number__c, 1044436
listing_co_office_mls_id__c, PKNO
listing_co_office_name__c, Park North Real Estate
listing_co_office_number__c, 24343
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 1528000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.462247
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 422695855
main_level__c, Full Bath(s);Kitchen;Living Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-10-26
original_price__c, 1688000
overall_days_on_market__c, -81382
parking_access__c, Side by Side
parking_features__c, Detached,Garage Facing Rear,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-11-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 785.99
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZMB3mUAH
room_type__c, In Law Apartment;Great Room
sale_date__c, 2022-12-06
sale_price__c, 1605000
security_features__c, Security System Owned
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_mls_id__c, 812384
selling_co_agent_number__c, 1056340
selling_co_office_mls_id__c, EXPRE
selling_co_office_name__c, eXp Realty of California, Inc
selling_co_office_number__c, 26334
selling_office_name__c, eXp realty
pba__status__c, Closed
pba__totalarea_pb__c, 2042
size__c, 2042
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Castenada
subdist__c, Forest Hill
ffd_name, 102 Castenada Avenue, San Francisco, CA, 94116
view__c, Hills;Sutro Tower;Forest;Ridge
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1960
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530549204-1.jpg