meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='340727' 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] => 2023-10-31 10:41:20
[post_modified_gmt] => 2023-10-31 17:41:20
[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, 1701346454
ffd_listing_title, 737 Chestnut Street, San Francisco, CA, 94133
ffd_mls_id, 423918667
ffd_salesforce_id, a0E8W00000dwZzZUAU
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 3
address2__c, 737 Chestnut Street, San Francisco, CA, 94133
pba__address_pb__c, 737 Chestnut Street, San Francisco, CA, 94133
agent_only_remarks__c, 737 Chestnut, 735 Chestnut, and 735A Chestnut (Owner Occupied) will need to close simultaneously. Property website: www.737Chestnut.com DO NOT BOOK through SHOWINGTIME! Please call/text Tyron at (415) 728-2294 for more information or to schedule an appointment. Pre-escrow opened with Michael Gaffney at Fidelity Title. Please submit offers on 7 page SFAR contact, with POF/lender approval letter and signed disclosures within 24hrs of acceptance.
appliances__c, Dishwasher;Free Standing Gas Oven;Free Standing Refrigerator
architectural_style__c, Spanish
bath_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1928
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-25T01:46:44.000+0000
days_on_market__c, 37
dom__c, 37
ffd_description_pb, Uncover the charm of this expansive Spanish Revival-style flat, adorned with captivating windows that frame the awe-inspiring vistas. Dating back to the 1920s, detached on three sides, this top-floor unit is drenched in natural light, offering enhanced privacy and delivering panoramic views of SF and the Bay from every perspective. As you step into this delightful home, you'll be greeted by a spacious living room that opens up to sweeping views of Alcatraz and Bay, providing a truly spectacular backdrop for your everyday living. Separate dining room creates a warm and inviting stage for entertaining that seamlessly flows into the large kitchen with S/S appliances. Down the hall, you'll discover 3 beds & 1 and half bath. Space is enhanced with exquisite classic period details, including ornate fireplace with built-in bookshelves, intricate plaster molding, & beautiful hardwood flooring. For added convenience, there's a separate laundry room, as well as one parking space & storage. This prime location provides abundant opportunities for exploration & entertainment. You'll be just steps away from the lively neighborhoods of Russian Hill/North Beach, offering a plethora of dining options, bakeries, coffee shops, & the iconic St. Peter and Paul's Church. Your Russian Hill dream!
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
ffd_lastmodifieddate, 2023-11-30T11:47:35.000+0000
pba__latitude_pb__c, 37.8033032
pba__latitude_property__c, 37.8033032
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-10-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tyron
pba__listing_agent_lastname__c, Hooper
listing_agent_mls_id__c, 806486
ffd_listingagentname, Tyron J Hooper
listing_agent_number__c, 166017051
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CIP14
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28965
pba__listingprice_pb__c, 1495000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/877404839?share=copy
pba__longitude_pb__c, -122.4155803
mls_id__c, 423918667
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
monthly_parking_fees__c, 0
monthlyrent__c, 2848
parkingspaces__c, 1
on_market_date__c, 2023-10-24
open_house_end__c, 2023-12-03T15:00:00.000+0000
open_house_start__c, 2023-12-03T13:00:00.000+0000
original_price__c, 1495000
overall_days_on_market__c, -81745
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener
parking_type__c, On Site - Mapped (Condo Only)
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, 755.05
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000dwZzZUAU
room_type__c, Laundry;Kitchen;Living Room;Dining Room;Primary Bathroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Fence;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, 1980
size__c, 1980
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Chestnut
subdist__c, Russian Hill
ffd_name, 737 Chestnut Street, San Francisco, CA, 94133
view__c, City;City Lights;Bay;Water;Downtown;San Francisco
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1928
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530696630-1.jpg