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-03-19 14:33:44
[post_modified_gmt] => 2024-03-19 21:33:44
[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
(
)
)
ffd_listing_title, 101 Lombard Street #203E, San Francisco, CA, 94111
ffd_mls_id, 497412
ffd_salesforce_id, a0E1I00000SldTwUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 202
address2__c, 101 Lombard Street #203E, San Francisco, CA, 94111
pba__address_pb__c, 101 Lombard Street #203E, San Francisco, CA, 94111
agent_only_remarks__c, Easy to show by appt. Seller is doing 1031 exchange at no cost to buyer but needs to use a specific title agent.
appliances__c, Dishwasher;Electric Range;Microwave;Disposal;Refrigerator;Hood Over Range
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tile;Low-Flow Toilet(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1983
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-08-22
ffd_createddate, 2020-05-12T20:45:56.000+0000
days_on_market__c, 1163
dom__c, 150
ffd_description_pb, Best Deal on Northside of SF!!Enjoy the beauty of the Bay by day, and the twinkling lights of the Bay Bridge by night. This lovingly maintained condo offers the best of urban living along the N. Waterfront. Northeast outlooks present light all day long. A formal entry with great art walls, and a large coat closet and pantry with wine storage. The remodeled kitchen offers clean, modern finishes with plenty of cabinet space and is adjacent to the dining room with wall of windows offering views of the Bay Bridge, Pier 27 Cruise Ship Park to Treasure Island and the Waterfront. The living room flows from the dining, continuing the partial Bay views and is the perfect setting for entertaining with a dry bar, wood-burning fireplace and an attached deck to enjoy the temperate microclimate. 2 good sized bedrooms, a master suite w dressing area w double vanity, 2 closets, shower over tub. Guest bath has stall shower. 1 car pkg, x storage. Pool, doorman in sunbelt of SF.
101 Lombard Street #203E, San Francisco, CA, 94111 - Property Description
Best Deal on Northside of SF!!Enjoy the beauty of the Bay by day, and the twinkling lights of the Bay Bridge by night. This lovingly maintained condo offers the best of urban living along the N. Waterfront. Northeast outlooks present light all day long. A formal entry with great art walls, and a large coat closet and pantry with wine storage. The remodeled kitchen offers clean, modern finishes with plenty of cabinet space and is adjacent to the dining room with wall of windows offering views of the Bay Bridge, Pier 27 Cruise Ship Park to Treasure Island and the Waterfront. The living room flows from the dining, continuing the partial Bay views and is the perfect setting for entertaining with a dry bar, wood-burning fireplace and an attached deck to enjoy the temperate microclimate. 2 good sized bedrooms, a master suite w dressing area w double vanity, 2 closets, shower over tub. Guest bath has stall shower. 1 car pkg, x storage. Pool, doorman in sunbelt of SF.
