meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='418370' 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, 1727485000
ffd_listing_title, 1834 Hyde Street, San Francisco, CA, 94109
ffd_mls_id, 424049889
ffd_salesforce_id, a0EUd000003DfObMAK
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 1834 Hyde Street, San Francisco, CA, 94109
pba__address_pb__c, 1834 Hyde Street, San Francisco, CA, 94109
agent_only_remarks__c, An incredible and lush sanctuary in the heart of the city! Home and gardens have been thoughtfully updated and improved ($100K+) since the 2018 purchase. First showings 2-4p 9/28. Disclosure Package available on 9/30.
appliances__c, Dishwasher;Microwave;Hood Over Range;Built-In Gas Range;Ice Maker;Built-In Refrigerator;Built-In Freezer
architectural_style__c, Contemporary;Victorian
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Marble;Tile
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1906
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Baxter Smith
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-09-27T18:49:03.000+0000
days_on_market__c, 0
dom__c, 0
ffd_description_pb, Welcome to your private oasis in the heart of Russian Hill, where the allure of an incredible hidden, verdant garden invites you into this one-of-a-kind home. This exquisitely maintained residence has been thoughtfully reimagined to blend timeless charm with modern sensibilities. Bathed in natural light through multiple skylights and oversized windows, the open floor plan allows seamless flow between living spaces. The soaring ceilings and wood-burning fireplace set the stage for relaxed gatherings, while the chef's kitchenwith an adjacent outdoor herb gardenoffers the perfect environment for culinary creativity. The home's three bedrooms are conveniently on the same level, hardwood floors and elegant crown moldings throughout accentuate the craftsmanship of the home. Elevated Indoor-outdoor living with direct access from both levels to wisteria-draped decks and mature gardens. Designed for both entertaining and everyday enjoyment, the property features a multi-zone Sonos sound system, expansive two-car garage (with individual garage doors for each space), laundry room, abundant indoor and outdoor storage, and a walk-in wine cellar. Located in the epicenter of Russian Hill, moments from celebrated dining, shopping, and parks.
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Hot Water;Central;Gas
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2024-09-28T00:47:20.000+0000
pba__latitude_pb__c, 37.7978891
pba__latitude_property__c, 37.7978891
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2024-06-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Alexander
pba__listing_agent_lastname__c, Lurie
listing_agent_mls_id__c, 810063
ffd_listingagentname, Alexander F Lurie
listing_agent_number__c, 1044526
listing_co_agent_mls_id__c, 810357
listing_co_agent_number__c, 1045827
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4184906
lower_level__c, Bedroom(s),Full Bath(s),Primary Bedroom
mls_id__c, 424049889
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-09-27
open_house_end__c, 2024-09-28T16:00:00.000+0000
open_house_start__c, 2024-09-28T14:00:00.000+0000
original_price__c, 2995000
overall_days_on_market__c, -82084
parking_access__c, Independent
parking_features__c, Detached,Garage Door Opener
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-09-27T10:21:14.000+0000
price_per_square_foot__c, 1433.01
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003DfObMAK
roof__c, Bitumen
room_type__c, Storage
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate
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, 2090
size__c, 2090
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hyde
subdist__c, Russian Hill
ffd_name, 1834 Hyde Street, San Francisco, CA, 94109
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Coverings
pba__yearbuilt_pb__c, 1906
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530811004-1.jpg