meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237095' 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] => 2024-03-19 14:29:22
[post_modified_gmt] => 2024-03-19 21:29:22
[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, 999 Green Street #3202, San Francisco, CA, 94133
ffd_mls_id, 422662290
ffd_salesforce_id, a0E8W00000Wk2wsUAB
num_of_fireplaces__c, 2
num_of_rooms__c, 7
of_units__c, 112
address2__c, 999 Green Street #3202, San Francisco, CA, 94133
pba__address_pb__c, 999 Green Street #3202, San Francisco, CA, 94133
agent_only_remarks__c, A once-in-a-lifetime opportunity to secure not one, but two penthouse apartments at The Summit. Please visit thesummitpenthouses.com for more information. This is a trust sale and requires a minimum of two weeks of marketing. If you have any questions or would like to set up a showing please call Karen Mendelsohn Gould at 415-871-1597. These properties are pure SF magic!
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;Double Oven;Built-In Refrigerator
architectural_style__c, Mid-Century
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1964
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Maximillian Armour
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-05-25T22:47:57.000+0000
days_on_market__c, 420
dom__c, 35
ffd_description_pb, The crown jewel of San Francisco's skyline, 999 Green Street's spectacular penthouse apartments afford panoramic views from The Summit's glass-encased tower. Designed by famed developer, Joseph Eichler, and owned by San Francisco's most beloved couple George Shultz and Charlotte Maillard Shultz, both North and South-facing penthouses evoke a statement-making sense of grandeur with floor-to-ceiling glass and grand staircases that link two lavish levels. Sold together or separately, these one-of-a-kind penthouses have come to the market just twice since inception in 1973. Set within a full-service, luxury sky-rise with 24-hour doorman, and located in prime Russian Hill near hip cafes and eateries, penthouse living includes deeded parking and extra storage. Thoughtfully designed with shared common areas, including two connecting hallways and on-floor storage, both North and South towers have the capacity to operate independently or together as one.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Wood Burning
pba__floortype_pb__c, Carpet;Stone
hoa_fee_includes__c, Cable TV,Common Areas,Door Person,Insurance,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c, 6266
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 999 Summit Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry;Skylight(s);Cathedral Ceiling
ffd_lastmodifieddate, 2023-07-13T17:11:14.000+0000
pba__latitude_pb__c, 37.798451
pba__latitude_property__c, 37.798451
laundry_features__c, Inside Area;Cabinets;Sink
listed_date__c, 2022-05-25
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Karen
pba__listing_agent_lastname__c, Mendelsohn Gould
listing_agent_mls_id__c, 401740
ffd_listingagentname, Karen Mendelsohn Gould
listing_agent_number__c, 401740
listing_co_agent_mls_id__c, 804422
listing_co_agent_number__c, 166013971
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 12000000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.thesummitpenthouses.com/
pba__longitude_pb__c, -122.415218
mls_id__c, 422662290
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Living Room;Dining Room
master_bathroom_features__c, Tub;Double Sinks;Stone;Steam
master_property__c, a0O1I000001VhiUUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-05-25
original_price__c, 12000000
overall_days_on_market__c, -81228
parking_access__c, Side by Side
parking_features__c, EV Charging,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
patio_and_porch_features__c, Covered Deck;Covered Patio
pba__pendingdate__c, 2022-06-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 2431.61
pba__propertytype__c, Condominium
record_id, a0E8W00000Wk2wsUAB
room_type__c, Office;Kitchen;Loft;Living Room;Game Room;Guest Quarters;Great Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2022-07-18
sale_price__c, 12000000
selling_agent_mls_id__c, 804728
selling_agent_number__c, 166014390
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 4935
size__c, 4935
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Russian Hill
ffd_name, 999 Green Street #3202, San Francisco, CA, 94133
view__c, City;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Golden Gate Bridge;Twin Peaks;Mountains;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1964
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530465423-1.jpg
ListingId, a0E8W00000Wk2wsUAB