meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218155' 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
(
)
)
ffd_listing_title, 455 Vallejo Street #304, San Francisco, CA, 94133
ffd_mls_id, 421535337
ffd_salesforce_id, a0E1I00000TxtsxUAB
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 45
address2__c, 455 Vallejo Street #304, San Francisco, CA, 94133
pba__address_pb__c, 455 Vallejo Street #304, San Francisco, CA, 94133
agent_only_remarks__c, Offers welcome Thursday, April 15 at 1pm. P L E A S E NOTE: Zillow and Redfin show this unit sold last year. That's incorrect. THEY ARE REFERENCING a 1BD/1BA UNIT 104 AND NOT THIS UNIT FOR SALE. https://calendly.com/455vallejo304showing/455-vallejo-street-304 or email [email protected]. View disclosures https://app.disclosures.io/link/455-Vallejo-Street-304-fu5lftfk All entrants must sign a PEAD/BPPP before entry, acknowledge the Compass Covid Showing Protocol, and bring their own masks and gloves. Escrow opened with Michelle Patterson at First American. Please note that tax records are incorrect in that they reference the incorrect unit number, bedroom/bath count and square footage.
architectural_style__c, Contemporary;Modern/High Tech
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1973
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Alla Gershberg
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-04-07T22:55:28.000+0000
days_on_market__c, 833
dom__c, 9
ffd_description_pb, Situated above the Vallejo Street steps, this wonderful modern condo will delight you with its AMAZING views from every room & it's desirable Telegraph Hill location. The light filled open LV/DR combo has floor to ceiling windows w/views of Coit Tower & the Bay! This modern home has a remodeled kitchen w/counter seating & updated appliances. 2 spacious bedrooms w/ample closet space also have amazing water, Bay Bridge & iconic downtown views. The bathrooms have been beautifully remodeled & a W/D combo unit completes this urban delight! There is also designated pkg in the garage, Elevator, addt'l storage & on-site property management. Other building amenities include a community lounge & sundeck where you can enjoy the sweeping views of the Bay Bridge & the Transamerica building while you spin away on the community Peloton bike! Only steps to vibrant North Beach with its perfect 100 Walk Score, you'll enjoy the resurgence of urban life & return home to breathtaking iconic views!
district__c, SF District 8
driveway_sidewalks__c, Gated
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 943
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 455 Vallejo Condo Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:49:11.000+0000
pba__latitude_pb__c, 37.798793
pba__latitude_property__c, 37.798793
laundry_features__c, In Kitchen;Washer/Dryer Stacked Included
listed_date__c, 2021-02-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Dale
pba__listing_agent_lastname__c, Boutiette
listing_agent_mls_id__c, 806303
ffd_listingagentname, Dale T Boutiette
listing_agent_number__c, 166016715
listing_co_agent_mls_id__c, 803120
listing_co_agent_number__c, 803120
listing_co_office_mls_id__c, COMP7PAR
listing_co_office_name__c, Compass SF
listing_co_office_number__c, 27677
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=UTogH5V6KZN
pba__longitude_pb__c, -122.404789
mls_id__c, 421535337
master_bathroom_features__c, Shower Stall(s)
master_property__c, a0O1I000001VimgUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-04-07
original_price__c, 995000
overall_days_on_market__c, 123
parking_access__c, Side by Side
parking_features__c, Assigned,Covered,Enclosed,Interior Access,Underground Parking
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-04-16
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1243.81
pba__propertytype__c, Condominium
id, a0E1I00000TxtsxUAB
room_type__c, Living Room;Master Bathroom;Dining Room;Family Room
sale_date__c, 2021-05-26
sale_price__c, 1255000
security_features__c, Secured Access
selling_agent_mls_id__c, 805607
selling_agent_number__c, 166015599
selling_co_agent_mls_id__c, 807626
selling_co_agent_number__c, 1022603
selling_co_office_mls_id__c, CORE7
selling_co_office_name__c, Core7 Real Estate
selling_co_office_number__c, 25190
selling_office_name__c, Core7 Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1009
size__c, 1009
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Vallejo
subdist__c, Telegraph Hill
ffd_name, 455 Vallejo Street #304, San Francisco, CA, 94133
view__c, City;City Lights;Bay;Downtown;Bay Bridge;San Francisco;Bridges
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1973
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530213858-1.jpg
ListingId, a0E1I00000TxtsxUAB