meta_query='key:subdist__c;value:Lake Street|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217234' 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, 28 5th Avenue, San Francisco, CA, 94118
ffd_mls_id, 421519954
ffd_salesforce_id, a0E1I00000Tvz55UAB
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 2
address2__c, 28 5th Avenue, San Francisco, CA, 94118
pba__address_pb__c, 28 5th Avenue, San Francisco, CA, 94118
agent_only_remarks__c, Tandem parking. Current arrangement is alternating garage every other year with top unit. Any in person showings subject to latest health department guidelines. Please provide PVOH & PEAD-V forms with showing request. Disclosures available via Disclosure.io. Contact Jeff Stephenson for showing requests or questions 415-577-2580 or [email protected].
bath_features__c, Tub w/Shower Over;Shower Stall(s);Double Sinks;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1917
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jeffrey A Stephenson
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-02-21T19:53:06.000+0000
days_on_market__c, 880
dom__c, 6
ffd_description_pb, Coveted North of Lake Street location! Elegant 3+ bed and 2 1/4 bath, single-family alternative. First time on the market and move-in ready. Updates include a remodeled eat-in kitchen with Wolf cook top, hood and built-in double oven. Fireplaces accent the formal living and dining rooms. Living space includes a media room and office/4th bedroom. Deeded walkout deck overlooking a fully landscaped shared garden with patio and bamboo privacy screen. The master suite includes a beautifully remodeled bath, walk-in closet, and dressing room with sink & vanity. Elevator access from the large entry foyer to the lower level for parking access and expansion potential. Rarely available, premium location, desirable for its low traffic and neighborhood feel. Not a through street, this block ends at the Presidio offering access to Mountain Lake Trail, Park, & Playground, and the Presidio Golf Course. Enjoy the nearby dining, cafs, and shops of Clement Street.
district__c, SF District 1
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Dining Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Steam
ffd_lastmodifieddate, 2022-01-25T15:45:18.000+0000
pba__latitude_pb__c, 37.788137
pba__latitude_property__c, 37.788137
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2021-02-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Brown
listing_agent_mls_id__c, 197834
ffd_listingagentname, Tim A Brown
listing_agent_number__c, 197834
listing_co_agent_mls_id__c, 808910
listing_co_agent_number__c, 1038477
listing_co_office_mls_id__c, KWRSF
listing_co_office_name__c, Keller Williams San Francisco
listing_co_office_number__c, 26158
listing_office_mls_id__c, KWRSF
listing_office_name__c, Keller Williams San Francisco
listing_office_number__c, 26158
pba__listingprice_pb__c, 2495000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.28-5th-ave.com
pba__longitude_pb__c, -122.463391
mls_id__c, 421519954
master_property__c, a0O1I00000C32zYUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-02-19
original_price__c, 2495000
overall_days_on_market__c, 346
parking_access__c, Tandem
parking_features__c, Attached,Enclosed,Restrictions,Other,See Remarks
parking_type__c, Other
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2021-02-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1000
pba__propertytype__c, Condominium
id, a0E1I00000Tvz55UAB
room_type__c, Storage;Office;Laundry;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom;Possible Guest;Media Room
sale_date__c, 2021-04-05
sale_price__c, 2700000
selling_agent_mls_id__c, 810333
selling_agent_number__c, 1045698
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, 2700
size__c, 2700
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 5th
subdist__c, Lake Street
ffd_name, 28 5th Avenue, San Francisco, CA, 94118
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94118
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530185503-1.jpg
ListingId, a0E1I00000Tvz55UAB