meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221609' 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, 533 Dellbrook Avenue, San Francisco, CA, 94131
ffd_mls_id, 421603909
ffd_salesforce_id, a0E8W00000V0oevUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 0
address2__c, 533 Dellbrook Avenue, San Francisco, CA, 94131
pba__address_pb__c, 533 Dellbrook Avenue, San Francisco, CA, 94131
agent_only_remarks__c, Offers will be reviewed October 26th by noon. No pre-emptives please. Contact Agent for disclosures. To schedule showing, please use the following link: https://calendly.com/anthonychristen/533-dellbrook-ave-30-minute-showing
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Electric Range
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1959
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Liliana Perazich
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-15T10:49:35.000+0000
days_on_market__c, 642
dom__c, 12
ffd_description_pb, Located in the heart of SF, this classic Midtown Terrace home offers you tranquility within vibrant San Francisco. Mid-century design, 533 Dellbrook offers two spacious bedrooms, one bathroom, living room, dining room and kitchen on the main level. Newly refinished hardwood floors, marble fireplace, natural light fills the home through the gorgeous large dual-pane picture windows. The lower level provides ample space for storage with high ceilings. The washer/dryer are also located in the spacious garage that can fit 2 cars tandem. Enjoy cozy get togethers in your back fenced in patio area while surrounded by mature trees and lush foliage views. Only steps to Mt. Sutro Open Space and Twin Peaks walking trails and Midtown Terrace Playground. Close proximity to shopping, transportation, freeways and with easy access to virtually all that San Francisco has to offer. You won't want to miss seeing this gem. A perfect place to call home and make it your own.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant;Central
ffd_lastmodifieddate, 2022-01-25T16:04:37.000+0000
pba__latitude_pb__c, 37.755761
pba__latitude_property__c, 37.755761
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2021-10-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anthony
pba__listing_agent_lastname__c, Christen
listing_agent_mls_id__c, 802500
ffd_listingagentname, Anthony T Christen
listing_agent_number__c, 802500
listing_co_agent_mls_id__c, MLSL5072367
listing_co_agent_number__c, 981224134
listing_co_office_mls_id__c, CBR-25
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 981048259
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1195000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=QhLWuUqwbLK&brand=0
pba__longitude_pb__c, -122.454062
mls_id__c, 421603909
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-10-15
original_price__c, 1195000
overall_days_on_market__c, 182
parking_access__c, Tandem
parking_features__c, Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-10-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1468.71
pba__propertytype__c, Single Family Residence
id, a0E8W00000V0oevUAB
sale_date__c, 2021-11-05
sale_price__c, 1267500
selling_agent_mls_id__c, 803861
selling_agent_number__c, 166013126
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, 863
size__c, 863
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Dellbrook
subdist__c, Midtown Terrace
ffd_name, 533 Dellbrook Avenue, San Francisco, CA, 94131
website_property_type__c, Single Family Home
window_features__c, Dual Pane Partial
pba__yearbuilt_pb__c, 1959
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530341741-1.jpg
ListingId, a0E8W00000V0oevUAB