meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='384694' 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, 1726008778
ffd_listing_title, 375 Green Street, San Francisco, CA, 94133
ffd_mls_id, 424059377
ffd_salesforce_id, a0EUd000002vqqNMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 6
address2__c, 375 Green Street, San Francisco, CA, 94133
pba__address_pb__c, 375 Green Street, San Francisco, CA, 94133
agent_only_remarks__c, Escrow opened with Paula Seigal at Fidelity National Title. Property photos from previous listing. Property is NOT staged.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-08-23T16:46:45.000+0000
days_on_market__c, 18
dom__c, 18
ffd_description_pb, North Beach top floor detail rich Edwardian with incredible Coit Tower, GG bridge, Marin, and Bay views! Refinished Douglass fir floors, ornate crown molding, coved ceilings, and incredible light throughout. The main living space features 10 foot+ ceilings, built in bench seating in the dining room, and an ornate fireplace. The large bedroom features two closets, crown molding, and two large windows. Located at the back of the building the bedroom is the quietest room in the house. The kitchen features plenty of storage in the ceiling height cabinetry, SS gas range, refrigerator, built in microwave, and dishwasher. 360 Degree views can be had from the spectacular roof deck. Unparalleled nearly 360 degree views of the City, Bay, GG Bridge, Coit Tower, etc just 1 short flight of stairs out your back door. Walk to all your favorite shops, restaurants, public transit, and FIDI within minutes.
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fireplace_features__c, Dining Room
pba__floortype_pb__c, Other;Wood
pba__hoafees__c, 354
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2024-09-10T22:48:04.000+0000
pba__latitude_pb__c, 37.7998386
pba__latitude_property__c, 37.7998386
laundry_features__c, See Remarks
listed_date__c, 2024-08-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marco
pba__listing_agent_lastname__c, Carvajal
listing_agent_mls_id__c, 808180
ffd_listingagentname, Marco A Carvajal
listing_agent_number__c, 1031722
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, VANG02
listing_office_name__c, Vanguard Properties
listing_office_number__c, 166013449
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4053903
mls_id__c, 424059377
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-08-23
open_house_end__c, 2024-09-14T16:00:00.000+0000
open_house_start__c, 2024-09-14T14:00:00.000+0000
original_price__c, 799000
overall_days_on_market__c, -82049
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, 1072.48
pba__propertytype__c, Tenancy In Common
ListingId, a0EUd000002vqqNMAQ
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Secured Access
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, 745
size__c, 745
pba__state_pb__c, CA
stories__c, 1
pba__street_pb__c, Green
subdist__c, Telegraph Hill
ffd_name, 375 Green Street, San Francisco, CA, 94133
view__c, Ocean;Marina;City;City Lights;Bay;Water;San Francisco;Golden Gate Bridge;Mt Tamalpais;Bridges
website_property_type__c, Tenancy In Common
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530830854-1.jpg
