meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212280' 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, 5735 California, San Francisco, CA, 94121
ffd_mls_id, 498183
ffd_salesforce_id, a0E1I00000Sxws2UAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 5735 California, San Francisco, CA, 94121
pba__address_pb__c, 5735 California, San Francisco, CA, 94121
agent_only_remarks__c, Please visit: www.5735California.com. Property vacant, easy to show under current SFAR guidelines. For private appointment call/text Andrew Paolucci c415-307-4082.
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator
architectural_style__c, Edwardian
bath_features__c, Remodeled;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-07-07T17:45:26.000+0000
days_on_market__c, 1107
dom__c, 16
ffd_description_pb, Stunning, remodeled home with ideal layout for family living, work-from-home flexibility and indoor/outdoor entertaining in fantastic Lake District location. MAIN level: Large entry foyer, formal living room, dining room opening to light filled chef's kitchen with sliding glass doors to outdoor deck and entertaining area is perfect for today's modern living. UPPER level: Spacious master suite with walk-in closet, 2 bedrooms plus sunroom/home office. LOWER level: Family/media room with skylight, bedroom/home-office, full bath, laundry room and interior access to garage. Incredible south facing yard and garden including deck with hot tub. 2 car parking plus storage room. A++ location close to shops, restaurants and caf with easy access to parks, open space, transportation and downtown.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Decorative Only
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-25T15:22:44.000+0000
pba__latitude_pb__c, 37.7839717
pba__latitude_property__c, 37.7839717
laundry_features__c, Inside Room
listed_date__c, 2020-04-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Andrew
pba__listing_agent_lastname__c, Paolucci
listing_agent_mls_id__c, 803836
ffd_listingagentname, Andrew J Paolucci
listing_agent_number__c, 166013097
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, 2995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4791501
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 498183
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-07-07
original_price__c, 2995000
overall_days_on_market__c, 106
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, Patio(s)
pba__pendingdate__c, 2020-07-23
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 878.26
pba__propertytype__c, Single Family Residence
id, a0E1I00000Sxws2UAB
room_type__c, Storage;Sun Room;Laundry
sale_date__c, 2020-08-10
sale_price__c, 2900000
security_features__c, Security Gate;Security Alarm(s)
selling_agent_mls_id__c, 808802
selling_agent_name__c, Amanda Z. Mulholland
selling_agent_number__c, 1037619
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass SF
pba__status__c, Closed
pba__totalarea_pb__c, 3302
size__c, 3302
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, California
subdist__c, Lake Street
ffd_name, 5735 California, San Francisco, CA, 94121
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363202-1.jpg
ListingId, a0E1I00000Sxws2UAB