meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218631' 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, 170 10th Avenue, San Francisco, CA, 94118
ffd_mls_id, 421544174
ffd_salesforce_id, a0E1I00000USTPOUA5
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 170 10th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 170 10th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Tastefully reimagined. Please call/text Melanie Leung at 415.680.8286 or Kalok Law at 415.819.4137 to schedule private tours or for any questions. Please submit PEAD form and preapproval/proof of funds 24 hours before showing appointment. Please adhere to all CDC/SF social distancing guidelines. Face coverings are required. Disclosures are available upon request. Please email [email protected] & [email protected] for disclosures. Thank you!
appliances__c, Dishwasher;Insulated Water Heater;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Built-In Gas Oven;Built-In Refrigerator;Gas Plumbed
architectural_style__c, Modern/High Tech;Craftsman
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Low-Flow Toilet(s);Dual Flush Toilet;Skylight/Solar Tube;Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1907
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kalok Law
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-05-04T10:47:02.000+0000
days_on_market__c, 806
dom__c, 8
ffd_description_pb, The pinnacle of luxury starts here. Welcome to this stunning newly rebuilt 3600+ sqft Lake District smart home. Thoughtful design blends form & function, embodying the future of urban living w/ a nod to the past. Modern amenities & a spacious open floor plan intersect w/ timeless finishes & a minimal, utilitarian design sensibility. The main floor w/ its 10 foot ceilings is flanked by a formal living room & a flexible family & dining room lined w/ multi-sliding La Cantina doors. The kitchen is built as a gathering place for the entire family. With custom paneled appliances, a 13 foot island & Tom Dixon lighting, the kitchen is your new work from home & distance learning hub. Go upstairs to your 4 beds, 3 baths & laundry. The lower unit is separate w/ its own entrance, complete w/ bedroom, bathroom, laundry closet & great room w/ integrated kitchen & eat-in counter. La Cantina doors open onto the patio & main outdoor space. A 240V outlet makes this home EV ready.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood;Fenced;Full
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant Floor;Gas;Fireplace(s);Natural Gas
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:51:15.000+0000
pba__latitude_pb__c, 37.785194
pba__latitude_property__c, 37.785194
laundry_features__c, Inside Room;Laundry Closet;Upper Floor;Inside Area;Washer Included;Dryer Included;Gas Hook-Up;Cabinets
listed_date__c, 2021-04-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Melanie
pba__listing_agent_lastname__c, Leung
listing_agent_mls_id__c, 806887
ffd_listingagentname, Melanie P Leung
listing_agent_number__c, 166017801
listing_co_agent_mls_id__c, 808192
listing_co_agent_number__c, 1031846
listing_co_office_mls_id__c, SQRE
listing_co_office_name__c, Sequoia Real Estate
listing_co_office_number__c, 28627
listing_office_mls_id__c, SQRE
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28627
pba__listingprice_pb__c, 4799000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=bpf7aJsPeGf
pba__longitude_pb__c, -122.468665
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 421544174
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, 1
on_market_date__c, 2021-05-04
original_price__c, 4799000
overall_days_on_market__c, 147
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-05-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1318.68
pba__propertytype__c, Single Family Residence
id, a0E1I00000USTPOUA5
roof__c, Bitumen
room_type__c, Laundry;Kitchen;Master Bedrooms 2+;Living Room;Master Bathroom;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-06-21
sale_price__c, 4800000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 807674
selling_agent_number__c, 1023667
selling_co_agent_mls_id__c, 803159
selling_co_agent_number__c, 803159
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, 3640
size__c, 3640
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 10th
subdist__c, Lake Street
ffd_name, 170 10th Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Bay Window(s);Window Screens;Weather Stripped
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530229969-1.jpg
ListingId, a0E1I00000USTPOUA5