meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218584' 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, 119 2nd Avenue, San Francisco, CA, 94118
ffd_mls_id, 421542274
ffd_salesforce_id, a0E1I00000USLsvUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 11
of_units__c, 0
address2__c, 119 2nd Avenue, San Francisco, CA, 94118
pba__address_pb__c, 119 2nd Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Book showings through Calendly: https://calendly.com/nina-161/119-2nd-by-appt
appliances__c, Dishwasher;Disposal;Hood Over Range;Double Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Victorian
bath_features__c, Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-03
cooling__c, Central
ffd_createddate, 2021-04-29T20:47:02.000+0000
days_on_market__c, 811
dom__c, 5
ffd_description_pb, Wonderful Victorian home in a coveted Lake Street location, right off the Presidio. Elegant period details with a modernized interior and flexible, spacious floorplan. On the main level are fabulous entertaining spaces including a living room w/fireplace, den/home office, updated open chef's kitchen with island and breakfast bar, half bath, formal dining room, and fantastic family room with attached deck. Downstairs are 3 bedrooms and 2 bathrooms on the lower level, including laundry, a roomy 1 car garage, and a wonderful primary suite with French doors to the yard. On the top floor is an additional bedroom and bathroom, plus sitting room or office. Across the sunny backyard is a separate 2-level guest cottage, perfect for guests or as an in-law suite, complete with a family room w/wet bar, bedroom, bathroom, and office. The superior location just off quiet Lake Street affords easy access to the Presidio, Mountain Lake Park, 101, and shopping and dining on Clement & Sacramento Streets.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:51:05.000+0000
pba__latitude_pb__c, 37.786435
pba__latitude_property__c, 37.786435
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-04-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Nina
pba__listing_agent_lastname__c, Hatvany
listing_agent_mls_id__c, 372883
ffd_listingagentname, Nina Hatvany
listing_agent_number__c, 372883
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 3795000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.119-2ndave.com/
pba__longitude_pb__c, -122.460702
lower_level__c, Bedroom(s),Garage,Master Bedroom
mls_id__c, 421542274
main_level__c, Kitchen;Dining Room;Family Room;Street Entrance
master_bathroom_features__c, Double Sinks;Tile;Jetted Tub;Marble
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-29
original_price__c, 3795000
overall_days_on_market__c, 93
parking_access__c, Independent
parking_features__c, Attached,Enclosed
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Uncovered Deck;Uncovered Patio;Awning
pba__pendingdate__c, 2021-05-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1149.43
pba__propertytype__c, Single Family Residence
id, a0E1I00000USLsvUAH
sale_date__c, 2021-07-16
sale_price__c, 4000000
selling_agent_mls_id__c, MLSL5079121
selling_agent_number__c, 981336033
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Legacy Real Estate & Associates
pba__status__c, Closed
pba__totalarea_pb__c, 3480
size__c, 3480
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 2nd
subdist__c, Lake Street
ffd_name, 119 2nd Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530228534-1.jpg
ListingId, a0E1I00000USLsvUAH