meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222055' 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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:25:06
[post_modified_gmt] => 2024-03-19 19:25:06
[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, 80 Dellbrook Avenue, San Francisco, CA, 94131
ffd_mls_id, 421613816
ffd_salesforce_id, a0E8W00000V26WOUAZ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 80 Dellbrook Avenue, San Francisco, CA, 94131
pba__address_pb__c, 80 Dellbrook Avenue, San Francisco, CA, 94131
agent_only_remarks__c, Wow, we have been overwhelmed with the response to this listing. Received 3 Pre-Emptives after just 1 Day on the market. There will be no Open Houses or Brokers Tours. Property is vacant and on Supra Lockbox. Go and show anytime. No appointment necessary. Do NOT use Showing Time. Please use pre-sale escrow with Michelle Patterson at North American Title. Escrow #56604-21-01641 [email protected] 415-549-0993 Downstairs rooms may have been built without benefit of permits. Buyers should satisfy themselves as to the legality of the space.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1956
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jonathan Davis
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-12-01T18:46:09.000+0000
days_on_market__c, 595
dom__c, 1
ffd_description_pb, Classic, detached 3 bed/2 bath mid-century home on an extra large lot. On the ground floor there's a garage with plenty of room for 1 car, storage & a newer washer/dryer. The downstairs room comes with a built-in Murphy bed, a walk-in closet & en-suite bath. It's the perfect flex space for working at home while maintaining a guest room. The sliding glass door leads to a rear patio; with access to the trails that go in & around Laguna Honda. The Forest Hill Muni station is less than a 20 minute walk away! Upstairs you'll find refinished hardwood floors & a freshly painted interior. The living room boasts its original wood burning fireplace, double pane windows & recessed lighting. The newly refreshed kitchen features SS appliances. Step out onto your large, west facing deck to enjoy the afternoon sun, sylvan setting, & privacy. There are no rear neighbors! The bedrooms upstairs are front & back, so they don't share that adjoining wall. It's the perfect floorplan to maximize privacy.
district__c, SF District 4
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Wood;Simulated Wood
pba__hoafees__c, 18
pba__hoafrequency_pb__c, Annually
hoa_name__c, Midtown Terrace HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2022-01-25T16:06:36.000+0000
pba__latitude_pb__c, 37.7492079
pba__latitude_property__c, 37.7492079
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-11-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
ffd_listingagentname, Tim J Gullicksen
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, CGL06
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28275
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=i2ZQiysko2B
pba__longitude_pb__c, -122.4543341
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 421613816
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-12-01
original_price__c, 1095000
overall_days_on_market__c, 85
parking_access__c, Independent
parking_features__c, 24'+ Deep Garage,Attached,Garage Door Opener,Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-12-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1215.43
pba__propertytype__c, Single Family Residence
id, a0E8W00000V26WOUAZ
road_surface_type__c, Asphalt
roof__c, Elastomeric
sale_date__c, 2021-12-27
sale_price__c, 1670000
security_features__c, Smoke Detector;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 806284
selling_agent_number__c, 166016666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1374
size__c, 1374
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Dellbrook
subdist__c, Midtown Terrace
ffd_name, 80 Dellbrook Avenue, San Francisco, CA, 94131
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1956
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530369325-1.jpg
ListingId, a0E8W00000V26WOUAZ