meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235352' 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-11-21 16:39:16
[post_modified_gmt] => 2024-11-22 00:39:16
[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, 2707 Larkin Street, San Francisco, CA, 94109
ffd_mls_id, 422621710
ffd_salesforce_id, a0E8W00000VsUzQUAV
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2707 Larkin Street, San Francisco, CA, 94109
pba__address_pb__c, 2707 Larkin Street, San Francisco, CA, 94109
agent_only_remarks__c, All offers to be written on SFAR Purchase Contract. Pre-escrow opened with Mike Schmidt at First American Title. For showings, disclosures, or questions please contact Hanne Vastveit [email protected] 415.535.2550. The seller desires to sell 100 Culebra (MLS #422622210), an adjacent vacant lot to the buyer of 2707 Larkin, however this is not a requirement of the sale. For clarity, should the buyer of 2707 Larkin not wish to also purchase the 100 Culebra the easement to access 100 Culebra from 2707 Larkin would be voided and door in the fence from 2707 Larkin would be removed. The seller will be responsible for the associated costs. Taking photos at the property is limited to those persons preparing appraisal or inspection reports.
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Built-In BBQ;Built-In Refrigerator;Warming Drawer
bath_features__c, Radiant Heat
pba__fullbathrooms_pb__c, 6
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Justin Fichelson
pba__contingentdate__c, 2022-03-23
ffd_createddate, 2022-02-13T01:46:27.000+0000
days_on_market__c, 1053
dom__c, 42
ffd_description_pb, Situated on a quiet cul-de-sac, 2707 Larkin St offers panoramic views from all levels spanning the Golden Gate Bridge, the SF Bay, and Marin Headlines. Newly renovated, the home features four bedrooms, including three en suites, a gym, an office, a library, a wine cellar, a spacious two-car garage, and plenty of space for grand-scale entertaining. The formal entry opens up to the primary living areas which include a living room, a formal dining room, and a large family room with a built-in fireplace. Chic and airy, the adjacent kitchen features marble counters, top-of-the-line appliances, and ample natural light. Offering quintessential California indoor/outdoor living, the expansive downstairs family room opens to the tranquil limestone patio and the private terraced garden. A beautifully finished elevator provides alternative access to all levels. 2707 Larkin St is a rare opportunity to own a trophy property on one of the most coveted blocks in Russian Hill
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Radiant Floor
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-04-19T11:46:38.000+0000
pba__latitude_pb__c, 37.8030258
pba__latitude_property__c, 37.8030258
laundry_features__c, Inside Room;Washer/Dryer Stacked Included
listed_date__c, 2021-12-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Hanne
pba__listing_agent_lastname__c, Vastveit
listing_agent_mls_id__c, 815942
ffd_listingagentname, Hanne Vastveit
listing_agent_number__c, 1074944
listing_co_agent_mls_id__c, 807721
listing_co_agent_number__c, 1024451
listing_co_office_mls_id__c, AVNU
listing_co_office_name__c, Avenue 8 Inc.
listing_co_office_number__c, 28244
listing_office_mls_id__c, AVNU
listing_office_name__c, Avenue 8 Inc.
listing_office_number__c, 28244
pba__listingprice_pb__c, 10500000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/676135142
pba__longitude_pb__c, -122.4218187
mls_id__c, 422621710
master_bathroom_features__c, Shower Stall(s);Tub;Soaking Tub;Window;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-02-12
original_price__c, 10500000
overall_days_on_market__c, -81126
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-03-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-04-18T22:37:36.000+0000
price_per_square_foot__c, 1833.92
pba__propertytype__c, Single Family Residence
id, a0E8W00000VsUzQUAV
room_type__c, Office;Laundry;Den;Kitchen;Wine Cellar;Master Bedrooms 2+;Living Room;Dining Room;Family Room;Great Room
sale_date__c, 2022-04-18
sale_price__c, 9850000
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, 5371
size__c, 5371
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Larkin
subdist__c, Russian Hill
ffd_name, 2707 Larkin Street, San Francisco, CA, 94109
view__c, Garden/Greenbelt;Bay;San Francisco;Golden Gate Bridge
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530387795-1.jpg
ListingId, a0E8W00000VsUzQUAV
_yoast_indexnow_last_ping, 1735676735