meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210986' 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, 246 27th 248 Avenue, San Francisco, CA, 94121
ffd_mls_id, 507437
ffd_salesforce_id, a0E1I00000TTPHxUAP
vacant__c, 2
num_of_rooms__c, 0
of_units__c, 2
address2__c, 246 27th 248 Avenue, San Francisco, CA, 94121
pba__address_pb__c, 246 27th 248 Avenue, San Francisco, CA, 94121
agent_only_remarks__c, OFFERS DUE WED, 11/4/2020 @ 12PM (after election day. Get out & Vote and then write a great offer!) Send PEAD to [email protected]. Please schedule covid-compliant showing via Calendly: https://calendly.com/ashley-petty/246-24827thave?month=2020-10 Bonus space on garage level is owner-occupied, but will be delivered vacant. Permit status of bonus space is unknown. Buyers to verify to their own satisfaction. Seller may need a rentback. No showings of bonus space until a contract is ratified. Presale Escrow opened with North American Title, E/O Steve Salviejo.
appliances__c, Disposal;Free Standing Refrigerator;Free Standing Oven/Range
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1922
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Pat Lee
pba__contingentdate__c, 2020-11-04
ffd_createddate, 2020-10-22T10:46:55.000+0000
days_on_market__c, 1000
dom__c, 20
ffd_description_pb, Well-maintained VACANT 2-unit building in the coveted Lake District. Each unit has a 2 bed, 1 split bath, sunroom, spacious living room, dining room, kitchen, and in-unit laundry. The sunroom is a great flexible space that can be used as a a third bedroom, office, nursery, or zoom room. Real hardwood floors and wood-burning fireplace. Lower unit (#248) has a patio accessible from the sunroom. 2 car tandem parking. Large flat backyard is great for entertaining and gardening. Coveted Lake District location for access to Baker Beach, The Presidio, Lincoln Park, Lands End, Mountain Lake Park, and Golden Gate Park. Close proximity to restaurants, cafes, grocery stores on Clement St and Geary Blvd. Conveniently located near public transit. Minutes to The Great Highway and 19th Ave for commutes south and north. All Interior photos are of the upper unit #246.
district__c, SF District 1
est_total_expenses__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
gross_annual_income__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T13:32:10.000+0000
pba__latitude_pb__c, 37.784766
pba__latitude_property__c, 37.784766
laundry_features__c, Washer/Dryer;In Each Unit
listed_date__c, 2020-10-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Norman
pba__listing_agent_lastname__c, Fung
listing_agent_mls_id__c, 807901
ffd_listingagentname, Norm Fung
listing_agent_number__c, 1028392
listing_co_agent_mls_id__c, 806248
listing_co_agent_number__c, 166016601
listing_co_office_mls_id__c, MOSAIK
listing_co_office_name__c, Mosaik Real Estate
listing_co_office_number__c, 27803
listing_office_mls_id__c, MOSAIK
listing_office_name__c, Mosaik Real Estate
listing_office_number__c, 27803
pba__listingprice_pb__c, 1888000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.lakedistrictduplex.com/?mls
pba__longitude_pb__c, -122.486893
pba__lotsize_pb__c, 0.07
mls_id__c, 507437
master_property__c, a0O8W00000DaF4oUAF
parkingspaces__c, 2
on_market_date__c, 2020-10-22
original_price__c, 2488000
overall_days_on_market__c, 70
parking__c, Attached,Garage
parking_features__c, Attached,Garage
patio_and_porch_features__c, Balcony/Deck
pba__pendingdate__c, 2020-11-11
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 700.93
pba__propertytype__c, Duplex
id, a0E1I00000TTPHxUAP
sale_date__c, 2020-12-11
sale_price__c, 2100000
selling_agent_mls_id__c, 813236
selling_agent_name__c, Jonathan Ng
selling_agent_number__c, 1060379
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, 2996
size__c, 2996
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 27th
subdist__c, Lake Street
ffd_name, 246 27th 248 Avenue, San Francisco, CA, 94121
type__c, Duplex
website_property_type__c, Duplex
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 1922
pba__postalcode_pb__c, 94121
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371499-1.jpg
ListingId, a0E1I00000TTPHxUAP
