meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='425248' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15718
[post_author] => 4
[post_date] => 2018-11-02 19:54:34
[post_date_gmt] => 2018-11-02 19:54:34
[post_content] => Tourists flock to WPA murals that grace a monument to firefighters while parrots flock to whatever neighborhood park feels nice. Looking for a front row seat to sunrises and sunsets on the San Francisco Bay from your own slice of the hill? You've arrived, so sit back and enjoy the show.
[post_title] => Telegraph Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => telegraph-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-22 12:05:17
[post_modified_gmt] => 2024-11-22 20:05:17
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15718
[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, 1742469544
ffd_listing_title, 273 Chestnut Street, San Francisco, CA, 94133
ffd_mls_id, 425012522
ffd_salesforce_id, a0EUd000004SmqbMAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
pba__address_pb__c, 273 Chestnut Street, San Francisco, CA, 94133
address2__c, 273 Chestnut Street, San Francisco, CA, 94133
agent_only_remarks__c, For showings contact Jean-Paul at 415-279-0997, Mike at 415-580-9095 or Stephanie at 619-964-4709. Disclosures are ready. Thank you.
appliances__c, Dishwasher;Free Standing Refrigerator;Gas Cook Top;Built-In Electric Oven
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1904
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Mike R Keane-Stack
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-03-07T16:46:55.000+0000
days_on_market__c, 13
dom__c, 13
ffd_description_pb, Perched atop the coveted north slope of Telegraph Hill, this exceptional San Francisco compound offers breathtaking views of Coit Tower, the San Francisco Bay, the Golden Gate Bridge, the Bay Bridge, the TransAmerica Pyramid, and Downtown. Set on an oversized lot with dual street frontage on Chestnut and Whiting Street, this rare property includes a 3-bed, 3-bath main house and a 1-bed, 1-bath guest cottage, both fully detached for abundant natural light and sweeping views. The main house features a sunlit interior with rich hardwood floors, a south-facing kitchen with walls of glass, and a stunning roof deck showcasing panoramic 360-degree views. The guest cottage includes a full kitchen and a dedicated home office, ideal for remote work. A private courtyard oasis separates the two residences, creating a serene retreat. Additional highlights include a 2-car garage, a rare luxury in this location. Just steps from Coit Tower, North Beach, and the SF waterfront, this home is surrounded by world-class dining, parks, and cafes. Offering an unparalleled blend of elegance, privacy, and iconic views, this is a one-of-a-kind opportunity in one of San Francisco's most desirable neighborhoods.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Baseboard;Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2025-03-20T10:47:58.000+0000
pba__latitude_pb__c, 37.8043072
pba__latitude_property__c, 37.8043072
listed_date__c, 2024-12-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jean-Paul
pba__listing_agent_lastname__c, Samaha
listing_agent_mls_id__c, 804997
ffd_listingagentname, Jean-Paul Samaha
listing_agent_number__c, 166014752
listing_co_agent_mls_id__c, 808954
listing_co_agent_number__c, 1038676
listing_co_office_mls_id__c, VANG02
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 166013449
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 4500000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/1062983674
pba__longitude_pb__c, -122.4077111
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 425012522
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2025-03-07
open_house_end__c, 2025-03-23T15:00:00.000+0000
open_house_start__c, 2025-03-23T13:00:00.000+0000
original_price__c, 4500000
overall_days_on_market__c, -82245
parking_access__c, Side by Side
parking_features__c, Garage Facing Rear,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Roof 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, 1341.28
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004SmqbMAC
sale_date__c, 1800-01-01
sale_price__c, 0
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, 3355
size__c, 3355
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Chestnut
subdist__c, Telegraph Hill
ffd_name, 273 Chestnut Street, San Francisco, CA, 94133
view__c, City;Panoramic;City Lights;Bay;Water;Downtown;Bay Bridge;San Francisco;Golden Gate Bridge;Bridges
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1904
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530957243-1.jpg