meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='381893' 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-2
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 14:22:20
[post_modified_gmt] => 2024-03-19 21:22:20
[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, 1725533572
ffd_listing_title, 186 Francisco Street #4, San Francisco, CA, 94133
ffd_mls_id, 424031784
ffd_salesforce_id, a0EUd000002XohfMAC
num_of_fireplaces__c, 2
num_of_rooms__c, 6
of_units__c, 20
address2__c, 186 Francisco Street #4, San Francisco, CA, 94133
pba__address_pb__c, 186 Francisco Street #4, San Francisco, CA, 94133
agent_only_remarks__c, Priced to sell and super easy to show. All showings will be conducted by Kate Stephenson in our office. (415) 370-6531, [email protected]. A range of square footage figures exist from 2479 sqft to 3163 sqft; please see disclosures. Neither Seller nor Broker warrants; buyers are advised to investigate. Pet policy allows for one usual and ordinary household pet such as a dog, cat or bird. Maximum pet weight is 60 lbs. HOA dues of $3057 per month include refuse collection, water, building & earthquake insurance, nighttime guard security service, Bay Alarm monitoring, outside professional management, building & grounds maintenance, common area electric and a contribution to reserves. Telegraph Terrace consists of 6 units in the more intimate lower building where 186 Francisco #4 is located and 14 units in the upper building. www.186Francisco4.com
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Range;Double Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Contemporary;Mediterranean
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Marble;Tile;Window
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1988
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-11T10:48:51.000+0000
days_on_market__c, 56
dom__c, 56
ffd_description_pb, Residence No. 4 offers a 3-level townhouse-style, corner view condominium at lushly landscaped Telegraph Terrace, nestled on Telegraph Hill's northern slope. Enjoy the peaceful gated location & exceptional indoor-outdoor living while delighting in the easy access to the vibrant heart of San Francisco. Commanding panoramic views include Golden Gate Bridge, Alcatraz, Angel Island, Berkeley Hills, Coit Tower, Bay Bridge. Five private outdoor spaces, abundant natural light, 2 gas fireplaces, sunken living room, dining room. Updated gas kitchen opens to terrace for al fresco dining and grilling. Awesome views from primary suite & its terrace. Suite includes plenty of closet space, large bath. Lower level 2BR, both ensuite baths; laundry. Brilliant floor plan. Direct access to 2 side by side parking spaces in garage - right outside the unit's door. Telegraph Terrace, in visually exciting Telegraph Hill neighborhood, is ideally located in close proximity to the Ferry Building with the city's best Farmers' Market, Exploratorium, Jackson Square, North Beach, Washington Square Park, Francisco Park & Financial District. Ride the vintage streetcars, enjoy the Embarcadero, superb casual and fine dining options are everywhere. Priced to sell. Seller has offered to pay for 1 Year of HOA dues.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room;Stone;Gas Log;Primary Bedroom
pba__floortype_pb__c, Carpet;Marble;Tile;Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Security,Trash,Water
pba__hoafees__c, 3057
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2024-09-05T10:47:51.000+0000
pba__latitude_pb__c, 37.8055488
pba__latitude_property__c, 37.8055488
laundry_features__c, Laundry Closet;Inside Area;Washer Included;Dryer Included
listed_date__c, 2024-05-09
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rebecca
pba__listing_agent_lastname__c, Schumacher
listing_agent_mls_id__c, 805929
ffd_listingagentname, Rebecca Schumacher
listing_agent_number__c, 166016017
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, 2600000
pba__listingtype__c, Sale
pba__listing_website__c, https://186Francisco4.com
pba__longitude_pb__c, -122.4083361
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 424031784
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks;Walk-In Closet;Marble;Closet;Window;Outside Access
master_property__c, a0O1I000001VhnQUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-07-11
open_house_end__c, 2024-09-07T16:00:00.000+0000
open_house_start__c, 2024-09-07T14:00:00.000+0000
original_price__c, 2600000
overall_days_on_market__c, -82006
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered Deck;Uncovered Patio
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, 0
pba__propertytype__c, Condominium
ListingId, a0EUd000002XohfMAC
room_type__c, Kitchen;Living Room;Baths Other;Dining Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security Gate;Secured Access;Security Patrol
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Francisco
subdist__c, Telegraph Hill
ffd_name, 186 Francisco Street #4, San Francisco, CA, 94133
view__c, Panoramic;City Lights;Bay;Water;Bay Bridge;San Francisco;Golden Gate Bridge;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1988
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530803758-1.jpg