meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='297042' 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] => 2021-12-01 19:11:15
[post_modified_gmt] => 2021-12-02 03:11:15
[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
(
)
)
_wp_page_template PropertyDetails.php
ListingId a0E1I00000UzzZJUAZ
pba__address_pb__c 1751 Lake Street, San Francisco, CA, 94121
pba__city_pb__c San Francisco
pba__fullbathrooms_pb__c 4
pba__bedrooms_pb__c 6
days_on_market__c 293
mls_id__c 421592032
pba__totalarea_pb__c 6027
pba__latitude_pb__c 37.785838
pba__longitude_pb__c -122.478522
pba__state_pb__c CA
pba__status__c Closed
pba__street_pb__c Lake
listed_date__c 2021-09-07
sale_date__c 2022-02-17
pba__propertytype__c Single Family Residence
pba__listingprice_pb__c 6425000
pba__listingtype__c Sale
sale_price__c 6000000
address2__c 1751 Lake Street, San Francisco, CA, 94121
pba__listing_agent_firstname__c Lisa
pba__listing_agent_lastname__c Wolfe
view__c Ocean;Park;Panoramic;Twin Peaks;Hills;Sutro Tower
pba__halfbathrooms_pb__c 2
parkingspaces__c 2
pba__postalcode_pb__c 94121
year_build_text__c 2001
size__c 6027
subdist__c Lake Street
listing_agent_mls_id__c 535823
selling_agent_mls_id__c 802914
listing_co_office_number__c 0
listing_office_number__c 26293
listing_office_name__c Compass
listing_office_mls_id__c COMP
of_units__c 0
district__c SF District 1
selling_agent_number__c 802914
selling_co_agent_number__c 0
selling_co_office_number__c 0
overall_days_on_market__c 174
dom__c 150
monthly_parking_fees__c 0
listing_co_agent_number__c 0
price_per_square_foot__c 995.52
selling_office_name__c Century 21 Realty Alliance Fine Homes and Estates
parking_type__c On Site (Single Family Only)
original_price__c 7385000
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.
pba__yearbuilt_pb__c 2001
pba__listing_agent_email__c [email protected]
monthlyrent__c 0
external_listing__c 1
pba__latitude_property__c 37.785838
listing_agent_number__c 535823
on_market_date__c 2021-09-07
architectural_style__c Contemporary
pba__listing_website__c https://vimeo.com/597757232
website_property_type__c Single Family Home
media Array
ListingUpdateDate 2022-06-28T03:42:49