meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='220794' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70653
[post_author] => 4
[post_date] => 2018-11-30 20:30:26
[post_date_gmt] => 2018-11-30 20:30:26
[post_content] => Charming single-family homes on streets that made sense before the University of San Francisco left its footprint on the neighborhood. The most charming circular street you'll ever meet (hello, Ewing Terrace). Discontiguous streets and student life just north of the North Panhandle.
[post_title] => Lone Mountain
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lone-mountain
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-14 12:49:00
[post_modified_gmt] => 2024-11-14 20:49:00
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70653
[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, 196 Ewing Terrace, San Francisco, CA, 94118
ffd_mls_id, 421592081
ffd_salesforce_id, a0E1I00000V00C9UAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 196 Ewing Terrace, San Francisco, CA, 94118
pba__address_pb__c, 196 Ewing Terrace, San Francisco, CA, 94118
agent_only_remarks__c, By appointment only, call/text listing agent. Seller is a trust selling the property in its present or existing AS-IS condition. Disclosures: https://app.disclosures.io/link/196-Ewing-Terrace-61tvzr54 The main level features an elegant living room with fireplace, formal dining room, beautifully kept original hardwood floors, a large eat-in kitchen and two spacious bedrooms; one with direct access to the common Bathroom. The upper level includes the primary bedroom with large walk-in closets, storage and an en-suite bathroom. Adjacent to the primary bedroom is another spacious bedroom with a light filled bonus room/office. The lower garage level boasts an additional family room with a built-in wet bar. Huge storage area, laundry, garden access and a two-car tandem garage parking. There is an unwarranted in-law unit with a quarter bathroom. Mature trees and greenery cover the terraced garden in the backyard. With original period details, this home is ready for move in with simple cosmetic upgrades or an entire remodel to suit your preferences. Additional items included in the sale: Washer, dryer, piano, multi-function fitness equipment and home safe
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator;Solar Water Heater
architectural_style__c, Traditional;Mid-Century
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1940
pba__city_pb__c, San Francisco
listing_co_agent_name__c, David S Costello
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-09-07T19:48:22.000+0000
days_on_market__c, 680
dom__c, 13
ffd_description_pb, This beautiful single-family home sits on the coveted Lone Mountain cul-de-sac of Ewing Terrace. The large three-story home has been in the same family for many years and has been meticulously maintained in its original condition. This home sits on an oversized corner lot resulting in privacy and lots of natural light from the windows on three sides of the home. The exceptional location of this home offers city living at its best on a quiet sought-after residential circle with no through traffic. Each level of the home's floor plan flows seamlessly throughout. There are four bedrooms and two and a half baths in total. This rarely available home affords a lot of privacy, Golden Gate bridge towers views, natural light and extraordinary potential on a quiet residential enclave in the heart of the city.
district__c, SF District 1
driveway_sidewalks__c, Paved Sidewalk
electric__c, 220 Volts in Laundry,Solar Plumbed
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced;Full
fireplace_features__c, Wood Burning;Family Room
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Solar Heating
interior_features__c, Skylight(s);Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T16:00:47.000+0000
pba__latitude_pb__c, 37.7806163
pba__latitude_property__c, 37.7806163
laundry_features__c, In Garage;In Basement;Washer Included;Dryer Included;Chute
listed_date__c, 2021-09-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andres
pba__listing_agent_lastname__c, Ardila
listing_agent_mls_id__c, 815676
ffd_listingagentname, Andy Ardila
listing_agent_number__c, 1073945
listing_co_agent_mls_id__c, 810541
listing_co_agent_number__c, 1046798
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2595000
pba__listingtype__c, Sale
pba__listing_website__c, http://196ewing.com
pba__longitude_pb__c, -122.4490942
lower_level__c, Bedroom(s),Family Room,Garage,Partial Bath(s),Retreat,Street Entrance
mls_id__c, 421592081
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Sitting Area
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-09-07
original_price__c, 2595000
overall_days_on_market__c, 365
parking_access__c, Tandem
parking_features__c, Tandem Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-09-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 828.31
pba__propertytype__c, Single Family Residence
id, a0E1I00000V00C9UAJ
roof__c, Tar/Gravel
room_type__c, Office;Bonus Room;Laundry;Kitchen;Living Room;Master Bathroom;Solarium;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-10-21
sale_price__c, 2750000
security_features__c, Fire Alarm;Carbon Mon Detector;Video System;Security System Prewired;Double Strapped Water Heater;Window Security Bars
selling_agent_mls_id__c, 807382
selling_agent_number__c, 1016936
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, 3320
size__c, 3320
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Ewing
subdist__c, Lone Mountain
ffd_name, 196 Ewing Terrace, San Francisco, CA, 94118
view__c, City;Bay;San Francisco;Golden Gate Bridge
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1940
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530317863-1.jpg
ListingId, a0E1I00000V00C9UAJ