Array
(
[ID] => 15720
[post_author] => 4
[post_date] => 2018-11-02 19:54:37
[post_date_gmt] => 2018-11-02 19:54:37
[post_content] => Not quite Telegraph Hill. Definitely not North Beach. Home of Fisherman's Wharf (although locals don't discuss this, we just spend the tax revenue). It flies underneath the radar yet is walkable to downtown. Adjacent to all that an Embarcadero rebuilt after Loma Prieta now has to offer.
[post_title] => North Waterfront
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => north-waterfront
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-18 22:56:24
[post_modified_gmt] => 2024-11-19 06:56:24
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15720
[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, 1735680896
ffd_listing_title, 150 Lombard Street #905, San Francisco, CA, 94111
ffd_mls_id, 424007915
ffd_salesforce_id, a0EUd0000015ieAMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 190
address2__c, 150 Lombard Street #905, San Francisco, CA, 94111
pba__address_pb__c, 150 Lombard Street #905, San Francisco, CA, 94111
agent_only_remarks__c, Probate sale, subject to court confirmation. First overbid amount was $1,365,500. Was overbid in court.
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1975
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-09T21:47:04.000+0000
days_on_market__c, 326
dom__c, 60
ffd_description_pb, Very desirable, top-floor 2BR/2BA end-unit condo with expansive San Francisco Bay and bridge-to-bridge views. A fabulous master suite opens into view deck, dining area (also opens to the deck) and spacious living room with fireplace, window walls with spectacular Bay views, original kitchen with custom tile. The whole condo was freshly painted and has all new carpeting throughout. All this, and an in-unit washer/dryer, one-car parking and a deeded extra storage room. Amenities include: spectacular panoramic-view roof deck, gym, secure courtyard and club room, plus 24-hour doorman. Excellent walk score of 91! Walk to Embarcadero restaurants, cafes, Pier 39, Ferry Building, Farmers Market, cruise terminal, parks & Downtown.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Carpet;Tile
hoa_fee_includes__c, Cable TV,Common Areas,Heat,Insurance on Structure,Maintenance Exterior,Trash,Water
150 Lombard Street #905, San Francisco, CA, 94111 - Property Description
Very desirable, top-floor 2BR/2BA end-unit condo with expansive San Francisco Bay and bridge-to-bridge views. A fabulous master suite opens into view deck, dining area (also opens to the deck) and spacious living room with fireplace, window walls with spectacular Bay views, original kitchen with custom tile. The whole condo was freshly painted and has all new carpeting throughout. All this, and an in-unit washer/dryer, one-car parking and a deeded extra storage room. Amenities include: spectacular panoramic-view roof deck, gym, secure courtyard and club room, plus 24-hour doorman. Excellent walk score of 91! Walk to Embarcadero restaurants, cafes, Pier 39, Ferry Building, Farmers Market, cruise terminal, parks & Downtown.
