meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214638' 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, 137 3rd Avenue, San Francisco, CA, 94118
ffd_mls_id, 505490
ffd_salesforce_id, a0E1I00000THhb5UAD
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 137 3rd Avenue, San Francisco, CA, 94118
pba__address_pb__c, 137 3rd Avenue, San Francisco, CA, 94118
agent_only_remarks__c, www.1373rdAvenue.com
architectural_style__c, Edwardian
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-09-11T10:46:33.000+0000
days_on_market__c, 1041
dom__c, 11
ffd_description_pb, Light, bright,and freshly updated,this stately Edwardian is the perfect blend of original details with a remodeled kitchen and new contemporary baths designed for the most discerning of buyers; a family home with an ultra-deep garden boasting mature plants, all-day sun, two lemon trees, and a sunny deck. Upon entering, you'll step into a gorgeous foyer with a dramatic staircase and 10' high ceilings, flanked by a light-filled, oversize living room with a wood-burning fireplace. Perfect for entertaining, the living room flows graciously into the large formal dining room. The kitchen offers new white marble countertops, brass fixtures, and a stunning new backsplash.The second floor boasts a spacious landing, three large bedrooms, and two newly remodeled bathrooms.Two large bonus rooms grace the third floor, perfect for today's work-at-home lifestyle.A beautifully updated full bathroom completes this floor. A rare find in the Lake District, this home offers scale and designer finishes.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2022-01-25T15:33:52.000+0000
pba__latitude_pb__c, 37.7860487
pba__latitude_property__c, 37.7860487
listed_date__c, 2020-09-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Val
pba__listing_agent_lastname__c, Steele
listing_agent_mls_id__c, 361136
ffd_listingagentname, Val Steele
listing_agent_number__c, 361136
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, 4399000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1373rdAvenue.com
pba__longitude_pb__c, -122.4616816
pba__lotsize_pb__c, 0
mls_id__c, 505490
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-09-11
original_price__c, 4399000
overall_days_on_market__c, 361
parking__c, Attached,Interior Access
parking_features__c, Attached,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-09-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1328.13
pba__propertytype__c, Single Family Residence
id, a0E1I00000THhb5UAD
room_type__c, Storage;Office;Laundry;Wine Cellar
sale_date__c, 2020-10-09
sale_price__c, 4250000
selling_agent_mls_id__c, 814299
selling_agent_name__c, Lauren Steinberg
selling_agent_number__c, 1065791
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 3200
size__c, 3200
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 3rd
subdist__c, Lake Street
ffd_name, 137 3rd Avenue, San Francisco, CA, 94118
transportation__c, 1 Block
website_property_type__c, Single Family Home
window_features__c, Dual Pane
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370012-1.jpg
ListingId, a0E1I00000THhb5UAD