meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212865' 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, 135 15th Avenue, San Francisco, CA, 94118
ffd_mls_id, 500096
ffd_salesforce_id, a0E1I00000SKe4YUAT
num_of_fireplaces__c, 2
num_of_rooms__c, 12
of_units__c, 0
address2__c, 135 15th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 135 15th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, 5th bedroom is legally considered an office; window measurements do not meet code for 2nd means of egress. Please email [email protected] for showings, disclosures, and questions. Escrow opened with Liz Paglinawan @ First American, [email protected], escrow #4104-6247983. COVID-compliant showings available by appointment for pre-approved buyers with signed PEAD. We have received several square footage numbers. Please see Square Footage Advisory. Garage fits two small to mid-size cars or one large car. Buyers advised to test cars.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Hood Over Range;Double Oven
bath_features__c, Shower Stall(s);Tub;Marble;Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-06-19T17:46:15.000+0000
days_on_market__c, 1125
dom__c, 7
ffd_description_pb, 135 15th Avenue is a spectacularly remodeled home with a nod to classic design and a floor plan for modern living. Bright rooms & lush backyard w/ verdant outlooks exemplify California living in this 5 bed, 3.5 bath Lake Street home. The foyer leads to a bright formal living room w/ wood-burning fireplace. The dining room w/ wainscoting & box-beam ceilings flows into the heart of the home - a chef's kitchen & great room w/ island, breakfast bar, & gas fireplace. The eat-in kitchen w/ Wolf 6-burner range, 2 Bosch dishwashers, Thermador refrigerator & pantry, leads to a spacious deck w/ access to the gorgeous yard. Upstairs are 4 beds; the expansive master suite feat. luxury bath, walk-in closet & private deck. A lower level family room w/ wet bar is ideal for indoor/outdoor living w/ floor-to-ceiling doors to the garden. Laundry room, 2-car garage w/ interior access & storage complete this home a block to the Presidio & close t
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Decorative Only;Brick;Gas Piped;Family Room;Stone
pba__floortype_pb__c, Carpet;Marble;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
interior_features__c, Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-25T15:25:35.000+0000
pba__latitude_pb__c, 37.785527
pba__latitude_property__c, 37.785527
laundry_features__c, Inside Room;Washer/Dryer Included
listed_date__c, 2020-06-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Missy
pba__listing_agent_lastname__c, Wyant Smit
listing_agent_mls_id__c, 804067
ffd_listingagentname, Missy Wyant Smit
listing_agent_number__c, 166013500
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, 4590000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=c3DxjRaRQqQ
pba__longitude_pb__c, -122.474676
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 500096
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-06-19
original_price__c, 4590000
overall_days_on_market__c, 145
parking__c, Attached,Garage,Auto Door,Interior Access
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-06-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1167.81
pba__propertytype__c, Single Family Residence
id, a0E1I00000SKe4YUAT
room_type__c, Storage;Laundry
sale_date__c, 2020-07-14
sale_price__c, 4600000
security_features__c, Smoke Detector;Security Alarm(s)
selling_agent_mls_id__c, 809622
selling_agent_name__c, Tyler Stewart
selling_agent_number__c, 1050585
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3939
size__c, 3939
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 15th
subdist__c, Lake Street
ffd_name, 135 15th Avenue, San Francisco, CA, 94118
transportation__c, 1 Block
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/365038-1.jpg
ListingId, a0E1I00000SKe4YUAT