meta_query='key:subdist__c;value:Midtown Terrace|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210222' 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, 78 Longview Court, San Francisco, CA, 94131
ffd_mls_id, 495457
ffd_salesforce_id, a0E1I00000RN4tkUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 78 Longview Court, San Francisco, CA, 94131
pba__address_pb__c, 78 Longview Court, San Francisco, CA, 94131
agent_only_remarks__c, Lock box installed on railing. Disclosure package available on Disclosures IO. All offers to be on SFAR purchase agreements. offer date is 3/11 by 11:00 am. prefer submissions through disclosures IO rather than email if possible. Lower level bedroom and bathroom are unwarranted
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;ENERGY STAR Qualified Appliances
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1955
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Anna L Barbagelata
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-27T03:45:44.000+0000
days_on_market__c, 1239
dom__c, 14
ffd_description_pb, 78 Longview Court is situated in the tranquil residential neighborhood of Midtown Terrace, yet accessible to a variety of diverse neighborhoods and attractions such as Twin Peaks, Glen Park, Castro and West Portal Village, Inner Sunset, UCSF Parnassus Campus, Forest Hill Station and 280/101 freeway access. There are two upper level bedrooms facing northwest, one with a large deck highlighting peaceful lookouts to Mount Sutro Forest and the Pacific Ocean. On the lower level is an additional bedroom and bath with garden outlooks and built in shelving. Both bathrooms are fresh with new vanities and light fixtures, updated plumbing fixtures and flooring. The updated kitchen features fresh new tile flooring, Bosch dishwasher and stainless appliances. This bright space has ample cabinets and counter space which makes it fully functional. The terraced landscaped backyard is surrounded by garden greenery, wood deck, and shaded patio. Garage can potentially fit 2 cars! plus storage
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
hoa_name__c, Midtown Terrace Homeowner Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:28:28.000+0000
pba__latitude_pb__c, 37.7484
pba__latitude_property__c, 37.7484
laundry_features__c, In Garage;Washer/Dryer Included
listed_date__c, 2020-02-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sandra
pba__listing_agent_lastname__c, Gandolfo
listing_agent_mls_id__c, 803790
ffd_listingagentname, Sandy Gandolfo
listing_agent_number__c, 803790
listing_co_agent_mls_id__c, 223465
listing_co_agent_number__c, 223465
listing_co_office_mls_id__c, BARBCO
listing_co_office_name__c, BarbCo
listing_co_office_number__c, 28297
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1350000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.78LongviewCourt.com
pba__longitude_pb__c, -122.4514
pba__lotsize_pb__c, 0.08
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 495457
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, 2020-02-26
original_price__c, 1350000
overall_days_on_market__c, 52
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Interior Access,Tandem Garage,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-03-11
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1302.13
pba__propertytype__c, Single Family Residence
id, a0E1I00000RN4tkUAD
sale_date__c, 2020-04-20
sale_price__c, 1586000
selling_agent_mls_id__c, 803029
selling_agent_name__c, Jennifer Rosdail
selling_agent_number__c, 803029
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams San Francisco
pba__status__c, Closed
pba__totalarea_pb__c, 1218
size__c, 1218
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Longview
subdist__c, Midtown Terrace
ffd_name, 78 Longview Court, San Francisco, CA, 94131
view__c, Ocean
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1955
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360814-1.jpg
ListingId, a0E1I00000RN4tkUAD