meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423182' 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-11-09 21:58:24
[post_modified_gmt] => 2024-11-10 05:58:24
[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
(
)
)
_yoast_indexnow_last_ping, 1738462853
ffd_listing_title, 197 21st 199 Avenue, San Francisco, CA, 94121
ffd_mls_id, 425002945
ffd_salesforce_id, a0EUd0000044euDMAQ
num_of_rooms__c, 10
of_units__c, 2
pba__address_pb__c, 197 21st 199 Avenue, San Francisco, CA, 94121
address2__c, 197 21st 199 Avenue, San Francisco, CA, 94121
agent_only_remarks__c, Vacant, use Supra lockbox to show any time. To get into the room and bath down, use the backdoor at 199 to go down. To access the garage, there are two garage remotes hung on the rod in back of the front door of 197. Any problems, please text/call John at 415-465-0505. Thank you! Disclosures: https://app.disclosures.io/link/197199-21st-Avenue-1ddvn3jo
appliances__c, Gas Water Heater;Disposal;Built-In Gas Oven;Free Standing Refrigerator;Double Oven;Gas Cook Top
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1915
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-01-17T11:50:31.000+0000
days_on_market__c, 16
dom__c, 16
ffd_description_pb, Great price for two vacant corner flats in Central Richmond north of Geary close to Sea Cliff, Golden Gate Park, beach, schools, restaurants, parks, MUNI, and all conveniences! Both units have two bedrooms, one bath, living room with fireplace, and formal dining room. Lower level has two separate garages, extra storage, and a bonus room and bath. Other features include original cabinets, chandeliers, and periodic detail! Perfect property for investors, large households, buyers looking for additional income, or TIC partners for condo conversion! Hurry, won't last!
district__c, SF District 1
exterior_features__c, Fenced Yard
external_listing__c, 1
pba__floortype_pb__c, Carpet
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Natural Gas
ffd_lastmodifieddate, 2025-02-02T01:47:48.000+0000
pba__latitude_pb__c, 37.7813454
pba__latitude_property__c, 37.7813454
laundry_features__c, Washer/Dryer Hookups
listed_date__c, 2025-01-16
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 244954
ffd_listingagentname, John M Lee
listing_agent_number__c, 244954
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.497668
mls_id__c, 425002945
parkingspaces__c, 2
on_market_date__c, 2025-01-16
original_price__c, 1695000
overall_days_on_market__c, -82195
parking_features__c, Attached,Garage,Garage Door Opener
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 614.13
pba__propertytype__c, Duplex
ListingId, a0EUd0000044euDMAQ
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 2760
size__c, 2760
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 21st
subdist__c, Lake Street
ffd_name, 197 21st 199 Avenue, San Francisco, CA, 94121
website_property_type__c, Duplex
window_features__c, Window Coverings;Bay Window(s);Window Screens
pba__yearbuilt_pb__c, 1915
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530932037-1.jpg