meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209565' 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] => 2022-12-05 02:56:12
[post_modified_gmt] => 2022-12-05 10:56:12
[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
(
)
)
ffd_listing_title 466 Vallejo Street, San Francisco, CA, 94133
ffd_mls_id 491778
ffd_salesforce_id a0E1I00000KcU1FUAV
num_of_fireplaces__c 1
num_of_rooms__c 0
of_units__c 4
address2__c 466 Vallejo Street, San Francisco, CA, 94133
pba__address_pb__c 466 Vallejo Street, San Francisco, CA, 94133
agent_only_remarks__c Very cool Tales of The City Telegraph Hill property just blocks/stairs from hustle and bustle. Two condominiums (466 & 464 Vallejo) have been been merged by an opening in the wall and are being sold together and function well together. Sellers have used the smaller unit for a guests and a home office. Each unit has a separate front door and garden, so Buyer would have future flexibility. Move in ready.
appliances__c Dishwasher;Disposal;Refrigerator;Cooktop Stove
bath_features__c Shower Stall(s);Tub;Remodeled;Marble;Skylight/Solar Tube
pba__fullbathrooms_pb__c 3
pba__bedrooms_pb__c 4
year_build_text__c 1900
pba__city_pb__c San Francisco
listing_co_agent_name__c Ted Bartlett
pba__contingentdate__c 2020-03-01
ffd_createddate 2019-11-08T23:46:57.000+0000
days_on_market__c 1077
dom__c 122
ffd_description_pb Telegraph Hill unique & beautiful. Secluded, park-like retreat with Golden Gate & City Views, Gardens,Decks, & Garage. Close to vibrant North Beach & the Financial District.
district__c SF District 8
entry_level__c 0
external_listing__c 1
pba__floor__c 0
hoa_dues__c 1306.89
hoa_fee_includes__c Trash,Homeowners Insurance,Water
pba__hoafees__c 1306
pba__hoafrequency_pb__c Monthly
hoa__c Yes
pba__halfbathrooms_pb__c 1
ffd_lastmodifieddate 2022-01-12T15:25:37.000+0000
pba__latitude_pb__c 37.799369
pba__latitude_property__c 37.799369
laundry_appliances__c In Laundry Room
laundry_features__c Inside Room
listed_date__c 2019-11-08
pba__listing_agent_email__c tina@bartlettre.com
pba__listing_agent_firstname__c Tina
pba__listing_agent_lastname__c Bartlett Hinckley
listing_agent_mls_id__c 263567
ffd_listingagentname Tina Bartlett Hinckley
listing_agent_number__c 263567
listing_co_agent_mls_id__c 801003
listing_co_agent_number__c 801003
listing_co_office_mls_id__c COMP12PUI
listing_co_office_name__c Compass
listing_co_office_number__c 27690
listing_office_mls_id__c COMP12PUI
listing_office_name__c Compass
listing_office_number__c 27690
pba__listingprice_pb__c 3900000
pba__listingtype__c Sale
pba__listing_website__c http://www.bartlettre.com/property/466-Vallejo-Street-San-Francsico-Telegraph-Hill/138
pba__longitude_pb__c -122.40522
pba__lotsize_pb__c 0
mls_id__c 491778
master_property__c a0O1I000007VrNGUA0
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 2
on_market_date__c 2019-11-08
original_price__c 4100000
overall_days_on_market__c 205
parking_access__c Tandem
parking_features__c Detached,Garage Door Opener,Private,Tandem Garage,Garage
parking_type__c On Site - Mapped (Condo Only)
pba__pendingdate__c 2020-03-09
possible_bedrooms__c 0
pba__pricechangedat__c 1800-01-01T00:00:00.000+0000
price_per_square_foot__c 1202.1
pba__propertytype__c Condominium
id a0E1I00000KcU1FUAV
sale_date__c 2020-04-14
sale_price__c 3325000
selling_agent_mls_id__c 981060
selling_agent_name__c Paul M. Radcliffe
selling_agent_number__c 981060
selling_co_agent_number__c 0
selling_co_office_number__c 0
selling_office_name__c Compass
pba__status__c Closed
pba__totalarea_pb__c 2766
size__c 2766
pba__state_pb__c CA
stories__c 0
pba__street_pb__c Vallejo
subdist__c Telegraph Hill
ffd_name 466 Vallejo Street, San Francisco, CA, 94133
view__c City Lights;Bay;Downtown;Golden Gate Bridge
website_property_type__c Condominium
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/358158-1.jpg
ListingId a0E1I00000KcU1FUAV