meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375526' 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, 1712660378
ffd_listing_title, 39 Gladeview Way, San Francisco, CA, 94131
ffd_mls_id, 424022139
ffd_salesforce_id, a0EUd000001flaHMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 0
address2__c, 39 Gladeview Way, San Francisco, CA, 94131
pba__address_pb__c, 39 Gladeview Way, San Francisco, CA, 94131
agent_only_remarks__c, Tenant occupied - single person, month to month.
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Mid-Century
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-08T01:47:05.000+0000
days_on_market__c, 2
dom__c, 2
ffd_description_pb, Best Midtown Terrace location, Mid-Century Modern Architecture, fully detached + large street to street lot. Exceptional views through exceptionally large windows, desirable open floor plan, dreamy wood-burning fireplace, solid oak hardwood floors, ideal gourmet kitchen, two car side-by-side parking and ideal storage space. Excellent opportunity to expand the downstairs area although the home is already spacious. The neighborhood features mid-century modern homes arranged in rows on terraced streets, surrounded by greenbelts, forests, reservoirs, and open space including pretty amazing hiking and biking trails. The land occupied by Midtown Terrace (approximately 150 acres) was once part of Rancho San Miguel, a large 4,400-acre parcel originally granted in 1846 to Don Jose de Jesus Noe, the first mayor of Yerba Buena (the pre-cursor to San Francisco). The land then changed hands several times, with ownership eventually being acquired by Adolph Sutro, a prominent engineer and developer and a San Francisco mayor from 1894 to 1896. To transform its bleak appearance, Adolph Sutro had eucalyptus trees planted on a significant portion of his property, which eventually became Sutro Forest. Midtown Terrace is a rather central San Francisco location.
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Fireplace
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-04-09T10:48:11.000+0000
pba__latitude_pb__c, 37.7508464
pba__latitude_property__c, 37.7508464
laundry_features__c, Inside Area
listed_date__c, 2024-04-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Kirkpatrick
listing_agent_mls_id__c, 802848
ffd_listingagentname, John M Kirkpatrick
listing_agent_number__c, 802848
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1395000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4507157
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 424022139
main_level__c, Bedroom(s);Kitchen;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-04-07
open_house_end__c, 2024-04-14T15:00:00.000+0000
open_house_start__c, 2024-04-14T13:00:00.000+0000
original_price__c, 1395000
overall_days_on_market__c, -81911
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001flaHMAQ
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Gladeview
subdist__c, Midtown Terrace
ffd_name, 39 Gladeview Way, San Francisco, CA, 94131
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530757189-1.jpg
