meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375917' 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
(
)
)
_yoast_indexnow_last_ping, 1713092282
ffd_listing_title, 452 Dellbrook Avenue, San Francisco, CA, 94131
ffd_mls_id, 424010931
ffd_salesforce_id, a0EUd000001FO37MAG
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 452 Dellbrook Avenue, San Francisco, CA, 94131
pba__address_pb__c, 452 Dellbrook Avenue, San Francisco, CA, 94131
agent_only_remarks__c, Supra installed on the front door, please go and show. Leave the lights on after showing. Disclosures link: https://app.disclosures.io/link/452-Dellbrook-Avenue-onm485gx
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Wine Refrigerator
architectural_style__c, Contemporary;Mid-Century
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1958
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Gogo Y Wu
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-23T19:47:33.000+0000
days_on_market__c, 51
dom__c, 17
ffd_description_pb, Welcome to 452 Dellbrook Ave, nestled in the heart of Midtown Terrace. This stunning home boasts 3 beds and 2.5 baths, offering ample space and natural lighting for comfortable living. The open kitchen, equipped w/ high-end appliances, is perfect for culinary enthusiasts and entertaining guests. Step out onto the deck off the kitchen and discover an amazing landscaped outdoor space, ideal for al fresco dining or simply relaxing after a full day of work. The main level also features a stylish fireplace with lit shelves. 2 beds and a beautiful modern bath on this level. The lower level offers a powder room & a stunning primary suite with a large walk-in-closet, a separate storage & primary bath. Double vanity sink, separate shower and stand-alone soaking tub. The primary suite also has direct access to the backyard. Other features include intelligent stairs lighting, bluetooth ceiling speaker system, etc. With its modern amenities and desirable location, this home presents an exceptional opportunity for discerning buyers seeking luxury living in the city yet be close to nature. The SF signature Sutro Tower is right above your foot step. Proximity to Twin Peak, parks, trails, Muni, groceries, shops, coffee shops, schools, etc. Come see it yourself!
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Wood
pba__hoafees__c, 18
pba__hoafrequency_pb__c, Annually
hoa_name__c, Midtown Terrace HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-04-14T10:47:02.000+0000
pba__latitude_pb__c, 37.7542596
pba__latitude_property__c, 37.7542596
laundry_features__c, Hookups Only
listed_date__c, 2024-01-31
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dennis
pba__listing_agent_lastname__c, Sanchez
listing_agent_mls_id__c, 812220
ffd_listingagentname, Dennis Sanchez
listing_agent_number__c, 1055597
listing_co_agent_mls_id__c, 810033
listing_co_agent_number__c, 1044403
listing_co_office_mls_id__c, KWADVPE
listing_co_office_name__c, KW Advisors
listing_co_office_number__c, 28862
listing_office_mls_id__c, KWADVPE
listing_office_name__c, KW Advisors
listing_office_number__c, 28862
pba__listingprice_pb__c, 1780000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4541381
lower_level__c, Full Bath(s),Garage,Primary Bedroom,Partial Bath(s)
mls_id__c, 424010931
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Soaking Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-23
original_price__c, 1388000
overall_days_on_market__c, -81867
parking_access__c, Tandem
parking_features__c, Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Covered Patio
pba__pendingdate__c, 2024-03-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-13T21:20:39.000+0000
price_per_square_foot__c, 1148.51
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001FO37MAG
room_type__c, Kitchen;Living Room;Primary Bathroom
sale_date__c, 2024-04-10
sale_price__c, 1740000
selling_agent_mls_id__c, MLSL5093262
selling_agent_number__c, 981390666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Premier Realty Associates
pba__status__c, Closed
pba__totalarea_pb__c, 1515
size__c, 1515
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Dellbrook
subdist__c, Midtown Terrace
ffd_name, 452 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/530735539-1.jpg