meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='240299' 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 827 North Point Street #2, San Francisco, CA, 94109
ffd_mls_id 422703651
ffd_salesforce_id a0E8W00000ZLjpGUAT
num_of_fireplaces__c 0
num_of_rooms__c 0
of_units__c 3
address2__c 827 North Point Street #2, San Francisco, CA, 94109
pba__address_pb__c 827 North Point Street #2, San Francisco, CA, 94109
agent_only_remarks__c No keybox on property. Showings by appointment only, with listing agent. Please text Greg to schedule: 805-835-2082.
appliances__c Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Refrigerator
architectural_style__c Modern/High Tech
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 3
year_build_text__c 2014
pba__city_pb__c San Francisco
listing_co_agent_name__c Greg Mundia
pba__contingentdate__c 2023-01-05
ffd_createddate 2022-10-20T20:48:12.000+0000
days_on_market__c 78
dom__c 77
ffd_description_pb This distinguished Russian Hill 2-level penthouse condominium was constructed in 2014 with inspired design and exquisite craftsmanship. Ideally configured for entertaining you, it has its own private elevator that accesses each level. You will wow your guests with your private roof deck with 360-degree views of both the city and bay, including straight-on views of Alcatraz. The dramatic great room includes a skylit chef's kitchen which boasts Calacatta marble counters and Miele appliances along with high-quality custom cabinetry. The lower level includes 3 bedrooms including the primary bedroom with stunning en-suite bath featuring Carrera marble, dual sinks, French limestone, Waterworks fixtures and bay views. Two additional bedrooms, a full guest bathroom, in-unit laundry, radiant floor heat, and 1 car parking complete this home. A stone's throw from Ghirardelli Square, Aquatic Park, Fisherman's Wharf, the Embarcadero and the new Francisco Park.
district__c SF District 8
electric__c 220 Volts in Laundry
entry_level__c 0
exterior_features__c Balcony
external_listing__c 1
pba__floortype_pb__c Wood
hoa_fee_includes__c Elevator
pba__hoafees__c 400
pba__hoafrequency_pb__c Monthly
hoa__c Yes
pba__halfbathrooms_pb__c 0
pba__heatingtype_pb__c Radiant Floor
interior_features__c Skylight(s)
ffd_lastmodifieddate 2023-01-06T01:46:29.000+0000
pba__latitude_pb__c 37.8055975
pba__latitude_property__c 37.8055975
laundry_features__c Laundry Closet;Washer/Dryer Stacked Included
listed_date__c 2022-10-20
pba__listing_agent_email__c cobywilson@kw.com
pba__listing_agent_firstname__c Coby
pba__listing_agent_lastname__c Wilson
listing_agent_mls_id__c 816056
ffd_listingagentname Coby Wilson
listing_agent_number__c 1075055
listing_co_agent_mls_id__c 815389
listing_co_agent_number__c 1072748
listing_co_office_mls_id__c KWADVSF
listing_co_office_name__c KW Advisors
listing_co_office_number__c 28861
listing_office_mls_id__c KWADVSF
listing_office_name__c KW Advisors
listing_office_number__c 28861
pba__listingprice_pb__c 2695000
pba__listingtype__c Sale
pba__longitude_pb__c -122.4209505
mls_id__c 422703651
master_property__c a0O1I000004VY4CUAW
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 1
on_market_date__c 2022-10-20
original_price__c 2900000
overall_days_on_market__c -81376
parking_access__c Side by Side
parking_features__c Enclosed,Garage Facing Front
parking_type__c On Site - Mapped (Condo Only)
patio_and_porch_features__c Roof Deck
pba__pendingdate__c 1800-01-01
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 1699.24
pba__propertytype__c Condominium
ListingId a0E8W00000ZLjpGUAT
sale_date__c 1800-01-01
sale_price__c 0
selling_agent_number__c 0
selling_co_agent_number__c 0
selling_co_office_number__c 0
pba__status__c Contingent - Show
pba__totalarea_pb__c 1586
size__c 1586
pba__state_pb__c CA
stories__c 2
pba__street_pb__c North Point
subdist__c Russian Hill
ffd_name 827 North Point Street #2, San Francisco, CA, 94109
view__c Park;Panoramic;City Lights;Bay;Bay Bridge;San Francisco;Golden Gate Bridge;Hills;Mountains;Mt Tamalpais
website_property_type__c Condominium
pba__yearbuilt_pb__c 2014
pba__postalcode_pb__c 94109
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530545188-1.jpg
_wp_old_slug 827-north-point-street-san-francisco-ca-94109