meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='222382' 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, 1751 Lake Street, San Francisco, CA, 94121
ffd_mls_id, 421592032
ffd_salesforce_id, a0E1I00000UzzZJUAZ
num_of_fireplaces__c, 2
num_of_rooms__c, 11
of_units__c, 0
address2__c, 1751 Lake Street, San Francisco, CA, 94121
pba__address_pb__c, 1751 Lake Street, San Francisco, CA, 94121
agent_only_remarks__c, Introducing a truly rare find, this unique oasis sits between the edge of the city and the Pacific Ocean. Newly built in 2001 with a full cosmetic renovation completed in August 2021, this property of grand proportions is situated perfectly on a prime block of desirable Lake Street. The expansive property reflects a vision of the ideal home for modern living, featuring classic architecture style and details, an open floor plan featuring easy access to indoor/outdoor living on all four levels, as well as ample outdoor space and wrap-around view deck on the top floor. This four-level, perfectly-proportioned, light-filled home boasts an ideal balance of public and private spaces, providing maximum flexibility. Whether working from home, enjoying modern, fast-paced family living, entertaining either small or large groups or merely retreating to one of its quiet and serene areas, this home truly has space for everything and everybody.
appliances__c, Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 2001
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-01-25
ffd_createddate, 2021-09-07T16:46:49.000+0000
days_on_market__c, 680
dom__c, 150
ffd_description_pb, Introducing a truly rare find, this unique oasis sits between the edge of the city and the Pacific Ocean. Newly built in 2001 with a full cosmetic renovation completed in August 2021, this property of grand proportions is situated perfectly on a prime block of desirable Lake Street. The expansive property reflects a vision of the ideal home for modern living, featuring classic architecture style and details, an open floor plan featuring easy access to indoor/outdoor living on all four levels, as well as ample outdoor space and wrap-around view deck on the top floor. This four-level, perfectly-proportioned, light-filled home boasts an ideal balance of public and private spaces, providing maximum flexibility. Whether working from home, enjoying modern, fast-paced family living, entertaining either small or large groups or merely retreating to one of its quiet and serene areas, this home truly has space for everything and everybody.
district__c, SF District 1
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Starter
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-02-18T11:49:16.000+0000
pba__latitude_pb__c, 37.785838
pba__latitude_property__c, 37.785838
listed_date__c, 2021-09-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Lisa
pba__listing_agent_lastname__c, Wolfe
listing_agent_mls_id__c, 535823
ffd_listingagentname, Lisa J Wolfe
listing_agent_number__c, 535823
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, 6425000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/597757232
pba__longitude_pb__c, -122.478522
mls_id__c, 421592032
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-09-07
original_price__c, 7385000
overall_days_on_market__c, 174
parking_access__c, Side by Side
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-02-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-02-17T14:23:55.000+0000
price_per_square_foot__c, 995.52
pba__propertytype__c, Single Family Residence
id, a0E1I00000UzzZJUAZ
sale_date__c, 2022-02-17
sale_price__c, 6000000
selling_agent_mls_id__c, 802914
selling_agent_number__c, 802914
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Century 21 Realty Alliance Fine Homes and Estates
pba__status__c, Closed
pba__totalarea_pb__c, 6027
size__c, 6027
pba__state_pb__c, CA
stories__c, 4
pba__street_pb__c, Lake
subdist__c, Lake Street
ffd_name, 1751 Lake Street, San Francisco, CA, 94121
view__c, Ocean;Park;Panoramic;Twin Peaks;Hills;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2001
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530317732-1.jpg
ListingId, a0E1I00000UzzZJUAZ