meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217895' 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, 440 Panorama Drive, San Francisco, CA, 94131
ffd_mls_id, 421531386
ffd_salesforce_id, a0E1I00000TxGzLUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 440 Panorama Drive, San Francisco, CA, 94131
pba__address_pb__c, 440 Panorama Drive, San Francisco, CA, 94131
agent_only_remarks__c, Offer date set for Tuesday April 6th by 12pm. *Square footage shown includes unwarranted room and bath down.* Ways to see the property: www.440Panorama.com. In person showings by appointment at: https://calendly.com/deborahnguyen/440-panorama-drive Must deliver a signed Covid-19 PEAD form and pre-approval letter no more than 24 hours prior to your appointment. Property is staged and shows beautifully. Please see below the link to the Disclosures.IO for 440 Panorama Dr. https://app.disclosures.io/link/440-Panorama-Drive-ci40rf8e
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Low-Flow Toilet(s);Low-Flow Shower(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, Tanya S Dzhibrailova
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-03-26T16:05:06.000+0000
days_on_market__c, 845
dom__c, 11
ffd_description_pb, Classic Midtown Terrace 3 bedroom, 2 bath home with 2 car parking and an expansive room and bath down. Fully detached, this modern home features a warm and inviting living room with WB fireplace and a lovely dining area perfect for cozy dinners or holiday meals. A recently refreshed eat-in kitchen offers quartz counters, marble backsplash and new stainless Samsung appliances. All 3 bedrooms (including a primary bedroom and bath) are ideally located on the main level. The bright room and bath downstairs with outlooks to the manicured garden is perfect for guests or for today's work from home lifestyle (neither Sellers nor Agents warrant legality of these rooms). Located in the center of the City, this secret neighborhood is only minutes to some of the best shopping, dining, schools, parks and playgrounds around. Nature lovers rejoice - this property is surrounded by rustling trees, open spaces and hiking/walking paths around Twin Peaks and Mt. Sutro Reserve.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__floortype_pb__c, Carpet;Marble;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2022-01-25T15:48:13.000+0000
pba__latitude_pb__c, 37.7523434
pba__latitude_property__c, 37.7523434
laundry_features__c, In Garage
listed_date__c, 2021-02-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Deborah
pba__listing_agent_lastname__c, Nguyen
listing_agent_mls_id__c, 390430
ffd_listingagentname, Deborah Nguyen
listing_agent_number__c, 390430
listing_co_agent_mls_id__c, 804560
listing_co_agent_number__c, 183503881
listing_co_office_mls_id__c, CGL03
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28281
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4512715
mls_id__c, 421531386
main_level__c, Bedroom(s);Kitchen;Dining Room
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-03-26
original_price__c, 1395000
overall_days_on_market__c, 154
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-04-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1054.04
pba__propertytype__c, Single Family Residence
id, a0E1I00000TxGzLUAV
road_surface_type__c, Paved
room_type__c, Bonus Room;Kitchen;Living Room;Dining Room
sale_date__c, 2021-05-10
sale_price__c, 1775000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 802842
selling_agent_number__c, 802842
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Global Living
pba__status__c, Closed
pba__totalarea_pb__c, 1684
size__c, 1684
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Panorama
subdist__c, Midtown Terrace
ffd_name, 440 Panorama Drive, San Francisco, CA, 94131
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Greenhouse Window(s)
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/530206910-1.jpg
ListingId, a0E1I00000TxGzLUAV