meta_query='key:subdist__c;value:Lone Mountain|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='334269' 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-04-17 07:57:25
[post_modified_gmt] => 2024-04-17 14:57:25
[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, 332 Ewing Terrace, San Francisco, CA, 94118
ffd_mls_id, 423744733
ffd_salesforce_id, a0E8W00000cJ9LNUA0
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 332 Ewing Terrace, San Francisco, CA, 94118
pba__address_pb__c, 332 Ewing Terrace, San Francisco, CA, 94118
agent_only_remarks__c, Offers will be reviewed on Thursday, 6/15, at 2pm. Please call Taylor at 925.216.8813 for showing requests. Buyer to verify sq ft and parking to satisfaction prior to submitting offer.
appliances__c, Wine Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1940
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-06-05T17:48:13.000+0000
days_on_market__c, 44
dom__c, 11
ffd_description_pb, Discover the epitome of tranquility and convenience in center of SF! This remarkable 3BD, 2BA single-family home boasts a coveted location tucked away on a serene cul-de-sac near Nopa & the Inner Richmond. Immerse yourself in a thoughtfully designed home w/ a blend of charming details & modern touches. Step into the inviting top level featuring a cozy living room w/ a wood-burning fireplace, arched hallways, & timeless character. The spacious kitchen with stainless steel appliances, wine fridge, and breakfast bar seamlessly connects to the dining room. This level also includes a bathroom with soaking tub & shower, two spacious, sunny facing bedrooms w/ frenchdoors to a large, sunny deck. Downstairs you'll find abundant storage, a versatile home office, and a flexible primary bedroom with a large walk in closet, luxe en-suite bathroom & access to the expansive backyard. The south facing yard is a haven for outdoor entertainment, adorned w/ lush plants and a fruitful lemon tree. Additional highlights include integrated sound throughout the home, a one-car garage w/ side-by-side W/D, new roof, lots of storage. Enjoy the convenience of shopping & groceries nearby, with an array of amenities just blocks away on California, Divisadero and Geary St. Walkscore: 91. Offers due 6/15 @ 2pm.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-07-13T18:58:43.000+0000
pba__latitude_pb__c, 37.7795101
pba__latitude_property__c, 37.7795101
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2023-05-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Erin
pba__listing_agent_lastname__c, Thompson
listing_agent_mls_id__c, 806326
ffd_listingagentname, Erin Thompson
listing_agent_number__c, 166016753
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.332EwingTerrace.com
pba__longitude_pb__c, -122.4483209
mls_id__c, 423744733
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-05
original_price__c, 1995000
overall_days_on_market__c, -81604
parking_access__c, Independent
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-06-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1269.75
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJ9LNUA0
sale_date__c, 2023-06-30
sale_price__c, 2250000
selling_agent_mls_id__c, 807419
selling_agent_number__c, 1017981
selling_co_agent_mls_id__c, 809716
selling_co_agent_number__c, 1042949
selling_co_office_mls_id__c, COMP
selling_co_office_name__c, Compass
selling_co_office_number__c, 26293
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1772
size__c, 1772
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Ewing
subdist__c, Lone Mountain
ffd_name, 332 Ewing Terrace, San Francisco, CA, 94118
website_property_type__c, Single Family Home
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/530628646-1.jpg