meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235862' 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
(
)
)
ffd_listing_title, 2500 Leavenworth Street, San Francisco, CA, 94133
ffd_mls_id, 421614447
ffd_salesforce_id, a0E8W00000VtlVjUAJ
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2500 Leavenworth Street, San Francisco, CA, 94133
pba__address_pb__c, 2500 Leavenworth Street, San Francisco, CA, 94133
agent_only_remarks__c, Call/email Pattie with questions/showings 415-309-7836, [email protected]. Exquisite and expansive home with views and lush yard. Note that the home has been renovated since it was last on the market. New roof and new A/C on upper level. Pre-sale escrow open with Kallie Castro, First American Title.
appliances__c, Dishwasher;Hood Over Range;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Ashley Barrington-Mace
pba__contingentdate__c, 2022-03-16
cooling__c, Central
ffd_createddate, 2022-03-08T19:24:56.000+0000
days_on_market__c, 585
dom__c, 22
ffd_description_pb, Impressively scaled, beautifully detailed Victorian corner home with sparkling views maintains its handsome, preserved, turn-of-the-century architecture and benefits from meticulous, fine renovation. Set on an extra wide lot, this exquisite residence offers elegant entertaining spaces, 12-ft ceilings, hardwood floors, beautiful library (or guest bedroom) with fireplace, living/dining area with Coit Tower views, recently renovated kitchen and breakfast area. Upper level primary suite with fireplace, walk-in closets, deck with impressive Bay views, and guest bedroom. Lower level guest suite, laundry room, and a newly conceived family room (or guest bedroom) with covered porch leading to an enchanting, verdant garden, and detached garage. Iconic Russian Hill setting is so desirable just blocks from highly prized restaurants, easy shopping and downtown access, and just a block from both the delightfully quaint Fay Park, and from the eagerly awaited Francisco Park set to open Spring 2022.
district__c, SF District 8
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard;Wood
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-05-12T02:47:20.000+0000
pba__latitude_pb__c, 37.8042605
pba__latitude_property__c, 37.8042605
laundry_features__c, Inside Room;Cabinets;Sink
listed_date__c, 2021-11-12
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patricia
pba__listing_agent_lastname__c, Lawton
listing_agent_mls_id__c, 800774
ffd_listingagentname, Patricia A Lawton
listing_agent_number__c, 800774
listing_co_agent_mls_id__c, 803918
listing_co_agent_number__c, 166013282
listing_co_office_mls_id__c, STHB
listing_co_office_name__c, Sotheby's International Realty
listing_co_office_number__c, 2050
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 3995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4181225
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 421614447
main_level__c, Partial Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Tile;Walk-In Closet;Low-Flow Shower(s);Window;Sunken Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-12-11
original_price__c, 3995000
overall_days_on_market__c, -81063
parking_access__c, Independent
parking_features__c, Covered,Detached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Front Porch
pba__pendingdate__c, 2022-03-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-05-11T13:28:48.000+0000
price_per_square_foot__c, 1404.11
pba__propertytype__c, Single Family Residence
id, a0E8W00000VtlVjUAJ
road_surface_type__c, Asphalt
roof__c, Bitumen;Composition
room_type__c, Office;Laundry;Kitchen;Library;Living Room;Master Bathroom;Game Room;Guest Quarters;Family Room;Great Room
sale_date__c, 2022-05-05
sale_price__c, 4100000
security_features__c, Carbon Mon Detector
selling_agent_mls_id__c, 806718
selling_agent_number__c, 166017501
selling_co_agent_mls_id__c, 814525
selling_co_agent_number__c, 1066691
selling_co_office_mls_id__c, BRAVA
selling_co_office_name__c, Brava Real Estate
selling_co_office_number__c, 28638
selling_office_name__c, Brava Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2920
size__c, 2920
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Leavenworth
subdist__c, Russian Hill
ffd_name, 2500 Leavenworth Street, San Francisco, CA, 94133
view__c, City;Garden/Greenbelt;Bay;Downtown;Bay Bridge;San Francisco;Bridges
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530370230-1.jpg
ListingId, a0E8W00000VtlVjUAJ