meta_query='key:subdist__c;value:Telegraph Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='425860' 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
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-22 12:05:17
[post_modified_gmt] => 2024-11-22 20:05:17
[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, 1742609984
ffd_listing_title, 31 Romolo Place #6, San Francisco, CA, 94133
ffd_mls_id, 425021579
ffd_salesforce_id, a0EUd000004YZiiMAG
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 6
pba__address_pb__c, 31 Romolo Place #6, San Francisco, CA, 94133
address2__c, 31 Romolo Place #6, San Francisco, CA, 94133
agent_only_remarks__c, New development. Seller will consider offers with requests for concessions. Multiple units available starting at 799k, all with parking and access to view deck and garden. Roof deck area is permitted as a utility platform only. Call John 415-515-9211 or Laura at 415-990-0221 for access.
appliances__c, Dishwasher;Built-In Gas Range;Built-In Refrigerator
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1911
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Laura A Rogers
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-03-20T10:48:44.000+0000
days_on_market__c, 1
dom__c, 1
ffd_description_pb, Enjoy life in one of San Francisco's most iconic neighborhoods from this two bedroom, one bath residence. Tucked away on a side street near the heart of vibrant North Beach with its popular shopping, dining and nightlife, this home also has convenient access to Jackson Square, North Waterfront and downtown, making for an easy commute on those work from office days. This newly renovated top floor residence features an open floor plan and a clean, modern aesthetic with views towards Russian Hill. Upgrades include new kitchen with custom cabinetry and stainless steel appliances, remodeled bath with soaking tub, engineered wood floors, upgraded physical systems including new heating, plumbing and electrical and in unit washer/dryer hookups. Entertain in style with a shared roof deck with panoramic downtown and Bay Bridge views or chill out in the private rear garden/patio area. Offering includes one car side by side garage parking.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 655
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2025-03-22T01:47:08.000+0000
pba__latitude_pb__c, 37.7983472
pba__latitude_property__c, 37.7983472
laundry_features__c, Hookups Only;Gas Hook-Up
listed_date__c, 2025-03-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Farnham
listing_agent_mls_id__c, 802874
ffd_listingagentname, John C Farnham
listing_agent_number__c, 802874
listing_co_agent_mls_id__c, 803793
listing_co_agent_number__c, 803793
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 849000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4064623
mls_id__c, 425021579
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
monthly_parking_fees__c, 56
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2025-03-20
open_house_end__c, 2025-03-22T15:00:00.000+0000
open_house_start__c, 2025-03-22T13:00:00.000+0000
original_price__c, 849000
overall_days_on_market__c, -82258
parking_access__c, Side by Side
parking_features__c, Covered,Garage Door Opener,Side-by-Side
parking_type__c, On Site - Unassigned (Condo Only)
patio_and_porch_features__c, Roof 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, Tenancy In Common
ListingId, a0EUd000004YZiiMAG
sale_date__c, 1800-01-01
sale_price__c, 0
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, 0
pba__street_pb__c, Romolo
subdist__c, Telegraph Hill
ffd_name, 31 Romolo Place #6, San Francisco, CA, 94133
view__c, City Lights;San Francisco;Hills
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1911
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530963726-1.jpg