meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328196' 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, 2841 Larkin Street, San Francisco, CA, 94109
ffd_mls_id, 423727736
ffd_salesforce_id, a0E8W00000bFydKUAS
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2841 Larkin Street, San Francisco, CA, 94109
pba__address_pb__c, 2841 Larkin Street, San Francisco, CA, 94109
agent_only_remarks__c, Buyers to verify all information provided to satisfaction. Schedule a private showing via ShowingTime (see Button top right). Disclosures available via disclosures.io, send email to listing agent. Escrow opened with Heather Schiffer at First American Title. Offer date tbd, contact agent.
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1925
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-03-20T18:48:36.000+0000
days_on_market__c, 59
dom__c, 58
ffd_description_pb, Originally built in 1925 and fully remodeled in 2009. new seismic I-beam. Iconic views of the San Francisco Bay and Golden Gate Bridge. Excellent location on the north facing slope of Russian Hill just minutes to shopping, fine dining and Ghirardelli Square. Approximately 2,630 square feet of total living space on two levels with 4 bedrooms, 2 full bathrooms and 1 half-bath. Living room with fireplace and Bay views. Formal dining room with sweeping views. Gourmet kitchen with top-quality appliances. Master bedroom suite with Golden Gate Bridge views. Family bedroom with views and a large closet. Half-bath servicing the main level. Lower level includes a recreation room, dedicated office, two bedrooms and a full hallway bathroom. Stunning rear sanctuary garden with deck and hot tub spa. Attached 1-car garage with storage and front-loading washer and dryer. Close to The Presidio, Ghirardelli Square, Crissy Field, marina yacht clubs, Marina Green, Fort Mason and the Russian Hill Park green space just up the Larkin Street Stairs.
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Wood Burning;Brick;Gas Starter
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2023-05-18T00:49:16.000+0000
pba__latitude_pb__c, 37.8042083
pba__latitude_property__c, 37.8042083
laundry_features__c, In Garage;Ground Floor;Washer Included;Dryer Included
listed_date__c, 2023-02-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Harold
pba__listing_agent_lastname__c, Deblander
listing_agent_mls_id__c, 809042
ffd_listingagentname, Harold Deblander
listing_agent_number__c, 1039971
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 3399900
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=phSa8oi3mjD&mls=1
pba__longitude_pb__c, -122.4219577
lower_level__c, Bedroom(s),Full Bath(s),Garage,Retreat,Street Entrance
mls_id__c, 423727736
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Tile;Stone;Multiple Shower Heads;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-03-20
open_house_end__c, 2023-05-20T16:00:00.000+0000
open_house_start__c, 2023-05-20T14:00:00.000+0000
original_price__c, 3399900
overall_days_on_market__c, -81527
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front,Interior Access,Private
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered 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, 1292.74
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bFydKUAS
road_surface_type__c, Asphalt
room_type__c, Storage;Office;Kitchen;Living Room;Dining Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 2630
size__c, 2630
spa__c, 1
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Larkin
subdist__c, Russian Hill
ffd_name, 2841 Larkin Street, San Francisco, CA, 94109
view__c, Bay;Water;San Francisco;Golden Gate Bridge;Hills;Other
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1925
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530592884-1.jpg