meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='326800' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15719
[post_author] => 4
[post_date] => 2018-11-02 19:54:35
[post_date_gmt] => 2018-11-02 19:54:35
[post_content] => Russian sailors were once buried upon this hill. That's why. Ground zero for the San Francisco high-rise revolt that began in the 1960s. Not coincidentally, also home to The Summit, The Royal Towers, Green Hill Tower, the so-called crookedest street in SF (the real crookedest street is in Potrero Hill), and the authentic inspiration for Armistead Maupin's magical Barbary Lane.
[post_title] => Russian Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => russian-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:40:15
[post_modified_gmt] => 2022-12-14 11:40:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15719
[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, 2028 Leavenworth 2030 Street, San Francisco, CA, 94133
ffd_mls_id, 423722943
ffd_salesforce_id, a0E8W00000bEouLUAS
num_of_rooms__c, 17
of_units__c, 2
address2__c, 2028 Leavenworth 2030 Street, San Francisco, CA, 94133
pba__address_pb__c, 2028 Leavenworth 2030 Street, San Francisco, CA, 94133
agent_only_remarks__c, Legal two-unit building, laid out well for one owner. Website here: www.RussianHillModern.com - For more information or to schedule a private tour, please email Kevin Delmore at [email protected]
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Refrigerator;Plumbed For Ice Maker;Built-In Electric Oven
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 2017
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-02-28T18:49:47.000+0000
days_on_market__c, 1
dom__c, 0
ffd_description_pb, Modern four-bedroom masterpiece by Vincent Leger/EAG Studio + Jeff Schlarb Design! 2028-30 Leavenworth offers connected entertaining rooms, three ensuite bedrooms on one level, studio/media room with private access, & more. A skylight & east-facing wall of glass with views of Telegraph Hill illuminate the family room & entertainer's kitchen. The living room's double-sided fireplace opens to a library with extensive millwork, concealed wall bed, coffered ceilings, & sliding privacy doors. A living wall'' staircase leads to a fully landscaped rooftop terrace with grill, lounge areas, & Alcatraz, Coit Tower & Bay Bridge views. The primary bedroom features a walk-in closet & spa-inspired bath with walk-in shower, soaking tub, custom lighting & privacy switch-glass.'' Two en-suite bedrooms + laundry complete this level. Private ground-level entry leads to a media/guest studio with sitting area, kitchenette, loggia with east bay views, & 2-car garage. A fitness room, wine cellar, & bath with steam shower complete the bonus level. Sophisticated infrastructure includes lighting, security, A/V, climate, EV charging, coded package box, & elevator to all levels. Short distance to the restaurants & shops of Russian Hill, North Beach, Cow Hollow & the Marina, as well as parks & waterfront.
district__c, SF District 8
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood;Stone
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2023-03-01T01:51:30.000+0000
pba__latitude_pb__c, 37.799875
pba__latitude_property__c, 37.799875
laundry_features__c, Washer/Dryer Hookups;In Each Unit;Washer/Dryer Owned;Varies by Unit
listed_date__c, 2022-09-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gregg
pba__listing_agent_lastname__c, Lynn
listing_agent_mls_id__c, 804728
ffd_listingagentname, Gregg Lynn
listing_agent_number__c, 166014390
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 9500000
pba__listingtype__c, Sale
pba__listing_website__c, http://russianhillmodern.com
pba__longitude_pb__c, -122.417247
mls_id__c, 423722943
parkingspaces__c, 2
on_market_date__c, 2023-02-28
original_price__c, 9500000
overall_days_on_market__c, -81507
parking_features__c, Attached,Garage,Garage Door Opener,Interior Access,Off Street,Tandem Garage
patio_and_porch_features__c, Enclosed Patio;Balcony/Deck;Roof Deck(s);Varies by Unit
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 1972.59
pba__propertytype__c, Duplex
ListingId, a0E8W00000bEouLUAS
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Video System;Security System Owned
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, 4816
size__c, 4816
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Leavenworth
subdist__c, Russian Hill
ffd_name, 2028 Leavenworth 2030 Street, San Francisco, CA, 94133
view__c, City;Panoramic;Bay;Water;Downtown;Bay Bridge;Hills;Mountains
website_property_type__c, Duplex
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 2017
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530584940-1.jpg