meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='239794' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12175
[post_author] => 4
[post_date] => 2018-10-30 00:43:30
[post_date_gmt] => 2018-10-30 00:43:30
[post_content] => Mention Midtown Terrace to many San Franciscans and you’ll be met with a quizzical gaze. Where is it? What is it? It’s a mid-century neighborhood on the west side of Twin Peaks. Think single-family homes, fully detached, with both front and rear yards, lots of green space, and peace and quiet.
[post_title] => Midtown Terrace
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => midtown-terrace-2
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:45:03
[post_modified_gmt] => 2022-12-14 11:45:03
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12175
[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, 345 Dellbrook Avenue, San Francisco, CA, 94131
ffd_mls_id, 422701811
ffd_salesforce_id, a0E8W00000ZLVw7UAH
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 345 Dellbrook Avenue, San Francisco, CA, 94131
pba__address_pb__c, 345 Dellbrook Avenue, San Francisco, CA, 94131
agent_only_remarks__c, Trust sale, no court confirmation. Pre-sale escrow opened with Old Republic Title (Chris Mattews, 24th St.) Call or text questions to Eric: 415-717-3355. Seller requests offers, in any, on or after 12-noon Monday 10/24. Disclosures: https://app.disclosures.io/link/345-Dellbrook-Avenue-vytc9m0p
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;ENERGY STAR Qualified Appliances;Free Standing Refrigerator;Ice Maker
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1958
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-10-13T17:46:21.000+0000
days_on_market__c, 46
dom__c, 11
ffd_description_pb, Classic mid-century home centrally located in the heart of the city and surrounded by trees and green spaces. This fully detached home offers refinished hardwood floors, an updated kitchen, new appliances and a brick fireplace. The large bath features a separate shower and tub. The oversized 2-car garage offers great expansion potential and includes a workbench, ample storage plus laundry area. The setting is both tranquil and private, with no front or rear neighbors. It is central to the many hiking and biking trails of Mt. Sutro and Twin Peaks and is a short walk to the MTT Playground and Clarendon Elementary. This location is amazingly central to the shopping & dining areas of the Inner Sunset, Cole Valley / Haight, The Castro, Noe Valley and West Portal and is also close to the Forest Hill subway station. Welcome home!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-11-01T21:46:15.000+0000
pba__latitude_pb__c, 37.7522898
pba__latitude_property__c, 37.7522898
laundry_features__c, In Garage;Hookups Only;Gas Hook-Up
listed_date__c, 2022-10-13
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Eric
pba__listing_agent_lastname__c, Geleynse
listing_agent_mls_id__c, 803993
ffd_listingagentname, Eric Geleynse
listing_agent_number__c, 166013384
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STERL
listing_office_name__c, Sterling Premier Properties
listing_office_number__c, 25590
pba__listingprice_pb__c, 1250000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4525359
mls_id__c, 422701811
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-10-13
original_price__c, 1250000
overall_days_on_market__c, -81369
parking_access__c, Side by Side
parking_features__c, 24'+ Deep Garage,Attached,Garage Facing Front,Interior Access,Private,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-10-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-11-01T08:30:53.000+0000
price_per_square_foot__c, 1229.69
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZLVw7UAH
sale_date__c, 2022-10-31
sale_price__c, 1317000
selling_agent_mls_id__c, 805814
selling_agent_number__c, 166015866
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1071
size__c, 1071
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Dellbrook
subdist__c, Midtown Terrace
ffd_name, 345 Dellbrook Avenue, San Francisco, CA, 94131
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1958
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530542022-1.jpg
