meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='349787' 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
(
)
)
_yoast_indexnow_last_ping, 1705492630
ffd_listing_title, 999 Green Street #1805, San Francisco, CA, 94133
ffd_mls_id, 423917967
ffd_salesforce_id, a0E8W00000dvwKEUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 112
address2__c, 999 Green Street #1805, San Francisco, CA, 94133
pba__address_pb__c, 999 Green Street #1805, San Francisco, CA, 94133
agent_only_remarks__c, Email listing agent for HomeLight Disclosure Package link. Instructions in Disclosure Package Coversheet: Please email offers to: [email protected] and [email protected] and use the current SFAR San Francisco Purchase Agreement and review & approve all disclosures prior to submitting an offer. Signed Coversheet to be included with offers. Please state in your offer that: "Fully executed Disclosure Package has been reviewed, approved and signed and will be furnished within 24-hours of ratification" and that the Initial Deposit shall be deposited within 1-day of ratification. Please include Lender contact info and pre-approval letter & POF. If acceptable, please continue the open Escrow with First American Title Company, Heather Shiffer. Thank you! 3-virtually staged images. 999Green1805.com
appliances__c, Microwave;Disposal;Electric Cook Top;Wine Refrigerator;Ice Maker;Built-In Electric Range;Built-In Electric Oven;Other
architectural_style__c, Contemporary;Mid-Century
bath_features__c, Shower Stall(s);Tile;Quartz;Stone
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1964
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Peter J Fatooh
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-20T15:47:05.000+0000
days_on_market__c, 89
dom__c, 79
ffd_description_pb, This sleek condominium showcases a superior re-envisioned design in the highly regarded Eichler Summit. Classic, contemporary details provide for a convenient lifestyle. Open concept living/dining/kitchen area is spacious and lends versatility to furniture placement and WFH options. Floor-to-ceiling windows in every room offer access to the stunning terrace and views of The Bay, Alcatraz, Coit Tower and downtown SF. Boasting sparkling nighttime views, it is truly breathtaking. The kitchen features a handsome, oversized island complete with retractable vent cooktop & wireless charging stations, s/s appliances, bev/wine cooler & more! The veined Carrera-Style quartz, brass-colored fixtures & the lovely, neutral palette throughout add to the ambience of quiet luxury. The bedroom features a custom walk-in closet with Elfa organizers. With stone and tile finishes, the full-bath presents a continuation of the elegant finishes and palette. Designer lighting, wide-plank hardwood flooring & radiant heat complete this lovely home. One-car garage parking & additional storage. Common-floor washer & dryer. The Summit amenities include 24/7 lobby attendant, on-site property management and a Plaza Level courtyard. This highly desirable Russian Hill location offers the best in city living!
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
pba__floortype_pb__c, Simulated Wood;Stone
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Heat,Insurance on Structure,Maintenance Exterior,Management,Sewer,Trash,Water
pba__hoafees__c, 1804
pba__hoafrequency_pb__c, Monthly
hoa_name__c, The 999 Summit HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Radiant;Radiant Floor
ffd_lastmodifieddate, 2024-01-17T11:47:13.000+0000
pba__latitude_pb__c, 37.798471
pba__latitude_property__c, 37.798471
laundry_features__c, Other
listed_date__c, 2023-08-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marie
pba__listing_agent_lastname__c, Randall
listing_agent_mls_id__c, 802476
ffd_listingagentname, Marie M Randall
listing_agent_number__c, 802476
listing_co_agent_mls_id__c, 900005
listing_co_agent_number__c, 900005
listing_co_office_mls_id__c, FATOOH
listing_co_office_name__c, Peter Fatooh Realty
listing_co_office_number__c, 28117
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 1488000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=A55n9oWUqyY&mls=1
pba__longitude_pb__c, -122.415347
mls_id__c, 423917967
main_level__c, Bedroom(s);Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Low-Flow Toilet(s);Quartz;Tile;Stone
master_property__c, a0O1I000001VhiUUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-10-20
original_price__c, 1488000
overall_days_on_market__c, -81741
parking_access__c, Independent
parking_features__c, Assigned,Attached,Enclosed,Interior Access
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-01-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-01-16T13:29:17.000+0000
price_per_square_foot__c, 1348.88
pba__propertytype__c, Condominium
ListingId, a0E8W00000dvwKEUAY
sale_date__c, 2024-01-16
sale_price__c, 1330000
security_features__c, Secured Access
selling_agent_mls_id__c, 803912
selling_agent_number__c, 166013274
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, 986
size__c, 986
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Russian Hill
ffd_name, 999 Green Street #1805, San Francisco, CA, 94133
view__c, City;City Lights;Bay;Downtown;Bay Bridge;Golden Gate Bridge
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/530695029-1.jpg
