meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='379402' 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, 1718103450
ffd_listing_title, 460 Filbert Street #2, San Francisco, CA, 94133
ffd_mls_id, 424014118
ffd_salesforce_id, a0EUd000001ORL4MAO
num_of_fireplaces__c, 1
num_of_rooms__c, 3
of_units__c, 3
address2__c, 460 Filbert Street #2, San Francisco, CA, 94133
pba__address_pb__c, 460 Filbert Street #2, San Francisco, CA, 94133
agent_only_remarks__c, $761,750 is the MINIMUM opening bid at Court Hearing. Partition Sale Hearing set for Thursday, April 25th at 9:30am at 400 McAllister St, Dept 501. This is a Partition Sale subject to court confirmation and overbid. VACANT CONDO with SUPRA lockbox. Call for CBS code. All overbidders must attend hearing in order to bid. All overbidders MUST have cashier's check in the amount of $22,852.50 to bid in person only. Cashier check must be payable to Chicago Title, 455 Market St, Escrow Officer Maria Santos. Any and all overbidders must sign seller disclosure package and MANDATORY ADDENDA and submit to listing agents PRIOR to court hearing in order to bid. There are NO contingencies allowed for purchase at the Court Sale. Commission to be split 50/50 with successful bidding broker only at close of escrow.
appliances__c, Hood Over Range;Free Standing Gas Oven
architectural_style__c, Mid-Century
bath_features__c, Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1957
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Katie A Tostanoski
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-08T21:47:10.000+0000
days_on_market__c, 95
dom__c, 48
ffd_description_pb, Mid-Century modern condo in an intimate three unit building. Location, location, location! Half block to Coit Tower and a half block to the shops and cafes of Grant Street. Set back from the street which provides a surprising level of privacy in an urban location. This full floor unit includes a private deck and a common roof deck that has spectacular views of downtown, North Beach, Coit Tower and the Golden Gate Bridge. The open living area has natural light, wood stove and access to the deck. The kitchen has an abundance of wood cabinetry, Wolf Stove and newer appliances. The generous sized bedroom looks onto the front patio and includes a wall to wall closet with mirrored doors and is adjacent to an office alcove. The full bath includes a designer floating vanity, European style fixtures and a tub with glass doors. This unit includes a deeded parking space and storage closet. The common area includes a washer/dryer and a serene rear yard with mature trees including a palm tree.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Insurance,Trash,Water
pba__hoafees__c, 600
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
ffd_lastmodifieddate, 2024-06-11T10:47:19.000+0000
pba__latitude_pb__c, 37.801937
pba__latitude_property__c, 37.801937
laundry_features__c, Ground Floor
listed_date__c, 2024-03-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kevin
pba__listing_agent_lastname__c, Birmingham
listing_agent_mls_id__c, 802374
ffd_listingagentname, Kevin Birmingham
listing_agent_number__c, 802374
listing_co_agent_mls_id__c, 810040
listing_co_agent_number__c, 1044436
listing_co_office_mls_id__c, PKNO
listing_co_office_name__c, Park North Real Estate
listing_co_office_number__c, 24343
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 761750
pba__listingtype__c, Sale
pba__listing_website__c, https://460filbertst2.com/mls
pba__longitude_pb__c, -122.407192
mls_id__c, 424014118
master_property__c, a0O1I000004VWtQUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-08
original_price__c, 688000
overall_days_on_market__c, -81881
parking_access__c, Independent
parking_features__c, Garage Facing Front
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Roof Deck
pba__pendingdate__c, 2024-04-25
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-06-10T19:11:12.000+0000
price_per_square_foot__c, 953.95
pba__propertytype__c, Condominium
ListingId, a0EUd000001ORL4MAO
sale_date__c, 2024-06-07
sale_price__c, 725000
security_features__c, Security Gate
selling_agent_mls_id__c, EB719688
selling_agent_number__c, 981358235
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, The GRUBB Company
pba__status__c, Closed
pba__totalarea_pb__c, 760
size__c, 760
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Filbert
subdist__c, Telegraph Hill
ffd_name, 460 Filbert Street #2, San Francisco, CA, 94133
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1957
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530742113-1.jpg