meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='374928' 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, 1714006627
ffd_listing_title, 900 North Point Street #CB34J, San Francisco, CA, 94109
ffd_mls_id, 424018815
ffd_salesforce_id, a0EUd000001auMTMAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 550
address2__c, 900 North Point Street #CB34J, San Francisco, CA, 94109
pba__address_pb__c, 900 North Point Street #CB34J, San Francisco, CA, 94109
agent_only_remarks__c, Small window of time to sell at a DISCOUNTED PRICE - ACT NOW! This offering is for a 1/10th ownership stake at the Fairmont Heritage Place, Ghirardelli Square. The purchase is for the rights to use a 2 bedroom, 2 bathroom unit 35 nights out of each year. You can upgrade to a 3/3 for an additional price, at the time of your chosen stay. Annual HOA dues for 2/2 are $14,575.46 - paid quarterly. Call me for the BUY IT NOW price. 415-307-7991. Showings are on a scheduled basis; Monday - Friday 9:00 AM - 5:00 PM. No lockbox. Call me for more details. Perfect for your clients who visit SF a few times a year but don't want to have to maintain a property. Offers are reviewed as they come. Disclosures .IO LINK COMING SOON.
appliances__c, Microwave;Built-In Gas Range;Built-In Refrigerator;Other
architectural_style__c, Traditional;Other;Colonial
bath_features__c, Tile;Stone;Other
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 0
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-28T22:47:40.000+0000
days_on_market__c, 27
dom__c, 27
ffd_description_pb, Indulge in the best of San Francisco living with fractional ownership at the Fairmont Heritage Place, Ghirardelli Square. A luxurious residence club that offers the perfect blend of renowned 5-star Fairmont luxury, and the convenience of a fully furnished, well-maintained second home. With this 1/10th deeded fractional ownership, you have access to an array of stunning 2-bedroom, 2-bathroom residences for 35 days out of each year. All units include a gourmet kitchen, comfortable living/dining rooms, bedrooms w/king or queen beds all topped w/plush pillows & fine linens. Also included; spacious bathrooms w/toiletries & towels, private washer/dryers w/soaps & softener + much more. The benefits for owners are endless, from valet parking (up to 2 vehicles), personal item storage, to concierge services that can arrange everything from local dinner reservations to Napa/Sonoma wine tours. Located within the historic building is a private owner's lounge, a fitness center & several outdoor spaces equipped w/ a fire pit, lounge chairs, & a covered gazebo- but most importantly unobstructed VIEWS of the sparking San Francisco Bay. As an owner, you also have the opportunity to leverage your status at other Accor network properties WORLDWIDE! Come to SF, but travel the globe, Fairmont style!
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Uncovered Courtyard;Fire Pit
external_listing__c, 1
pba__floortype_pb__c, Carpet;Other;Tile
pba__hoafees__c, 3644
pba__hoafrequency_pb__c, Quarterly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-04-25T00:47:48.000+0000
pba__latitude_pb__c, 37.805788
pba__latitude_property__c, 37.805788
laundry_features__c, Laundry Closet;Stacked Only
listed_date__c, 2024-03-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Samantha
pba__listing_agent_lastname__c, Hailer
listing_agent_mls_id__c, 813131
ffd_listingagentname, Samantha Hailer
listing_agent_number__c, 1059614
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB4
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 28397
pba__listingprice_pb__c, 168000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/368326906
pba__longitude_pb__c, -122.423009
mls_id__c, 424018815
master_bathroom_features__c, Tile;Stone
master_property__c, a0OUd000005PAHRMA4
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-03-28
original_price__c, 198000
overall_days_on_market__c, -81901
parking_access__c, Side by Side
parking_features__c, Unassigned,Underground Parking,Valet,Other,See Remarks
parking_type__c, On Site - Unassigned (Condo Only);Other
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-19T08:27:06.000+0000
price_per_square_foot__c, 147.24
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0EUd000001auMTMAY
room_type__c, Kitchen;Living Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, See Remarks
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, 1141
size__c, 1141
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, North Point
subdist__c, Russian Hill
ffd_name, 900 North Point Street #CB34J, San Francisco, CA, 94109
view__c, Water;San Francisco;Other
website_property_type__c, Condominium
window_features__c, Window Coverings
pba__yearbuilt_pb__c, 0
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530752018-1.jpg