meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237784' 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, 118 9th Avenue, San Francisco, CA, 94118
ffd_mls_id, 422659652
ffd_salesforce_id, a0E8W00000XlMAqUAN
num_of_fireplaces__c, 0
num_of_rooms__c, 9
of_units__c, 0
address2__c, 118 9th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 118 9th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, House now vacant, painted, & staged! New fabulous look! Sellers reserved the right to accept or reject any offers.
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1904
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-08-03
cooling__c, None
ffd_createddate, 2022-07-22T16:47:05.000+0000
days_on_market__c, 426
dom__c, 49
ffd_description_pb, This grand 1904 house, on 9th Avenue off Lake was lovingly updated by the current owners. Original details combined with modern finishes create a comfortably luxurious home that retains the best of its turn-of-the-last-century-character. Old wood floors were reclaimed & refreshed, & radiant heating was added throughout. The original decorative banister was meticulously recreated to extend to the new lower level. On the main floor, an impressive entry leads to a formal living room & an expansive open-plan kitchen-dining area, designed with entertaining in mind. A powder room completes this floor. 4 bedrooms are upstairs, one with bath ensuite, while a second full bathroom is in the hallway. Originally storage, the legal lower level has a 1-car garage, second powder room, laundry room, & spacious family room with direct access to the yard. Outdoor space includes a large deck off the kitchen & tiled patio area, perfect for relaxing or entertaining. Once here, you'll never leave.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2023-07-13T17:10:19.000+0000
pba__latitude_pb__c, 37.7861181
pba__latitude_property__c, 37.7861181
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2022-05-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jim
pba__listing_agent_lastname__c, Fisher
listing_agent_mls_id__c, 803844
ffd_listingagentname, Jim Fisher
listing_agent_number__c, 166013107
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 4200000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4676504
lower_level__c, Partial Bath(s),Garage,Family Room
mls_id__c, 422659652
main_level__c, Partial Bath(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-05-19
original_price__c, 4895000
overall_days_on_market__c, -81222
parking_access__c, Independent
parking_features__c, Enclosed
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Front Porch
pba__pendingdate__c, 2022-08-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1506.63
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000XlMAqUAN
sale_date__c, 2022-08-30
sale_price__c, 4205000
selling_agent_mls_id__c, 803577
selling_agent_number__c, 803577
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Golden Gate Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2791
size__c, 2791
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 9th
subdist__c, Lake Street
ffd_name, 118 9th Avenue, San Francisco, CA, 94118
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530458660-1.jpg