meta_query='key:subdist__c;value:Ingleside Terraces|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218354' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12176
[post_author] => 4
[post_date] => 2018-10-30 00:43:33
[post_date_gmt] => 2018-10-30 00:43:33
[post_content] => Towering pillars denote neighborhood entrances to this classic residential park. Suburban, ex-urban, ahead of its time or perfectly timed? Wide streets, large lots, and fully detached homes gently grace what was once the hottest horse race in town.
[post_title] => Ingleside Terraces
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => ingleside-terraces
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-11 08:28:59
[post_modified_gmt] => 2024-04-11 15:28:59
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12176
[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, 70 Cerritos Avenue, San Francisco, CA, 94127
ffd_mls_id, 421538987
ffd_salesforce_id, a0E1I00000US9kFUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 70 Cerritos Avenue, San Francisco, CA, 94127
pba__address_pb__c, 70 Cerritos Avenue, San Francisco, CA, 94127
agent_only_remarks__c, 70Cerritosviews.com for more information. To show please send PEAD and enforce COVID precautions pre approved clients only pls Calendly https://calendly.com/marianne-schier/70-cerritos Send PEAD to [email protected] and please comply with all COVID regulations. email marianne.schier@compass and or text 415-999-0979 for questions Offer date Friday April 23rd at 11 am to [email protected]
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven
architectural_style__c, Arts & Crafts
bath_features__c, Marble
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1912
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sharon S Bacigalupi
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-22T21:32:27.000+0000
days_on_market__c, 824
dom__c, 7
ffd_description_pb, Own a piece of San Francisco history!This Joseph Leonard designed home in prestigious Ingleside Terraces was considered a model home in 1912.Today after only a handful of owners the exquisite craftsmanship and details survive in this magnificent remodeled mini mansion.Upon entering you are greeted by a stately living room perched high above the street providing beautiful vistas in every direction with original wood detailing and a prominently restored wood burning fireplace.The grand dining room is flooded with natural light and features a built in china cabinet leading you to the large open remodeled chefs kitchen and family room or breakfast area with perfect access to the landscaped grounds, garage and outdoor patio great for entertaining.A bedroom,full bath and laundry room complete this level.Up the impressive staircase one will find 4 good sized bedrooms, large office and two beautifully remodeled baths.The lower level basement has a wine cellar and plenty of room for storage.
district__c, SF District 4
electric__c, 220 Volts in Kitchen
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Wood Burning;Brick
pba__floortype_pb__c, Wood
pba__hoafees__c, 40
pba__hoafrequency_pb__c, Annually
hoa_name__c, Ingleside Terraces
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:50:00.000+0000
pba__latitude_pb__c, 37.726651
pba__latitude_property__c, 37.726651
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-04-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marianne
pba__listing_agent_lastname__c, Bacigalupi Schier
listing_agent_mls_id__c, 971052
ffd_listingagentname, Marianne Bacigalupi Schier
listing_agent_number__c, 971052
listing_co_agent_mls_id__c, 369072
listing_co_agent_number__c, 369072
listing_co_office_mls_id__c, COMP12PUI
listing_co_office_name__c, Compass
listing_co_office_number__c, 27690
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 2699000
pba__listingtype__c, Sale
pba__listing_website__c, http:/
pba__longitude_pb__c, -122.468271
mls_id__c, 421538987
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-16
original_price__c, 2699000
overall_days_on_market__c, 105
parking_access__c, Independent
parking_features__c, Covered,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2021-04-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 949.37
pba__propertytype__c, Single Family Residence
id, a0E1I00000US9kFUAT
roof__c, Other
room_type__c, Storage;Office;Laundry;Kitchen;Wine Cellar;Living Room;Baths Other;Dining Room
sale_date__c, 2021-05-28
sale_price__c, 3225000
security_features__c, Smoke Detector;Carbon Mon Detector;Security System Leased
selling_agent_mls_id__c, 803790
selling_agent_number__c, 803790
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, BarbCo
pba__status__c, Closed
pba__totalarea_pb__c, 3397
size__c, 3397
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Cerritos
subdist__c, Ingleside Terraces
ffd_name, 70 Cerritos Avenue, San Francisco, CA, 94127
view__c, Ocean;City;San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530220701-1.jpg
ListingId, a0E1I00000US9kFUAT