meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221643' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70652
[post_author] => 4
[post_date] => 2018-11-30 20:30:25
[post_date_gmt] => 2018-11-30 20:30:25
[post_content] => A thin sliver of streets as north as you can be on the west side of town without being in the Presidio. Compared to the Richmond, you'll generally find larger homes on shorter streets with select homes opening up to back-door Presidio access. West Clay is an exclusive enclave of special homes within a special neighborhood.
[post_title] => Lake Street
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => lake-street
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 13:15:32
[post_modified_gmt] => 2024-04-09 20:15:32
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70652
[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, 104 Funston Avenue, San Francisco, CA, 94118
ffd_mls_id, 421604918
ffd_salesforce_id, a0E8W00000V0rzgUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 104 Funston Avenue, San Francisco, CA, 94118
pba__address_pb__c, 104 Funston Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Contact Tori ([email protected]) or Lauren ([email protected] or 415-860-1640) with questions and/or showing requests.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Oven;Free Standing Refrigerator;Wine Refrigerator;Gas Cook Top
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1913
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Tori Andrews
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-10-18T18:50:21.000+0000
days_on_market__c, 639
dom__c, 11
ffd_description_pb, Prominently positioned on the corner of Lake St, this grand scale Edwardian is just steps from Mountain Lake Park. This 5 bedroom, 3.5 bath residence has been recently renovated with quality finishes. Details include hardwood floors, soaring ceilings, and period details. On the entertaining level is an elegant living room w/ gas fireplace, stylish dining room adorned in grasscloth wallpaper, and powder room. The eat-in kitchen features double ovens, marble countertops, wet bar, and a convenient family room w/ direct garden access. Lush mature landscaping and water feature create a peaceful oasis. On the uppermost level are 4 bedrooms including the principal en-suite w/ spacious walk-in closet. The lower level is appointed w/ a family room, additional bedroom and bath, wine room, laundry room, and storage. Completing the home is a 1 car garage. Within a short walk of the Presidio, dining on Clement/California St, and the newly designated slow street along Lake Street.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T16:04:46.000+0000
pba__latitude_pb__c, 37.7861731
pba__latitude_property__c, 37.7861731
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-06-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lauren
pba__listing_agent_lastname__c, Fraser
listing_agent_mls_id__c, 811656
ffd_listingagentname, Lauren J Fraser
listing_agent_number__c, 1052937
listing_co_agent_mls_id__c, 808858
listing_co_agent_number__c, 1038063
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 3950000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/632685981
pba__longitude_pb__c, -122.472
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 421604918
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-10-18
original_price__c, 3950000
overall_days_on_market__c, 74
parking_access__c, Independent
parking_features__c, Enclosed,EV Charging
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-10-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1259.77
pba__propertytype__c, Single Family Residence
id, a0E8W00000V0rzgUAB
sale_date__c, 2021-11-08
sale_price__c, 4995000
selling_agent_mls_id__c, 805857
selling_agent_number__c, 177518611
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 3965
size__c, 3965
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Funston
subdist__c, Lake Street
ffd_name, 104 Funston Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1913
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530343431-1.jpg
ListingId, a0E8W00000V0rzgUAB