meta_query='key:subdist__c;value:North Waterfront|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378461' posts_per_page=4 post_type=property
bool(false)
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
(
)
)
_yoast_indexnow_last_ping, 1716980252
ffd_listing_title, 240 Lombard Street #839, San Francisco, CA, 94111
ffd_mls_id, 424008649
ffd_salesforce_id, a0EUd000001AwjjMAC
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 282
address2__c, 240 Lombard Street #839, San Francisco, CA, 94111
pba__address_pb__c, 240 Lombard Street #839, San Francisco, CA, 94111
agent_only_remarks__c, New Price! Motivated Sellers say "Bring us an offer!" This unit is easy to show with advance notice of at least 24 hours. Call, text or email Tim with the date and time you'd like to show. He will put your name on the list for key check out at the front desk. The staff will give you a set of keys in exchange for your ID while you show the unit.This property qualifies for a special loan program with competitive rates. With the US Bank American Dream mortgage a Buyer can put down as little as $10,970 and pay ZERO PMI. Disclosures are posted on IO, or use this link https://app.disclosures.io/link/240-Lombard-St-839-zji4nfga Please use pre-sale escrow opened with Joanne Kung at Chicago Title. Escrow # 3652400093. [email protected] 415-252-2770
appliances__c, Dishwasher;Disposal;Free Standing Refrigerator;Free Standing Electric Oven;Free Standing Electric Range
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1993
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jonathan Davis
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-02-15T23:46:59.000+0000
days_on_market__c, 104
dom__c, 83
ffd_description_pb, Largest one-bed floorplan at 240 Lombard St. You enter into a long hallway, perfect for showcasing your favorite artwork & photos. The new LVP flooring & paint throughout create a modern, unified style in the home. There's an updated kitchen with quartz countertops & SS appliances, large linen closet, an updated bath, & a coat closet in the entry hall. Hosting gatherings is a breeze in the expansive dining room. Relax & unwind in the generously sized bedroom, easily accommodating a king-sized bed along with additional furniture: complemented by a walk-in closet. Enjoy the tranquility of your own private retreat in this quiet end unit, away from the bustle of city life. With an impressive 91 Walk Score, indulge in the convenience of being mere steps from The Embarcadero and Levi's Plaza, offering an array of dining & entertainment options. Take leisurely strolls down to Pier 29 to marvel at cruise ships arriving or simply to watch sailboats on the bay. Experience full-service living with a 24/7 attended front desk, two elevators per building, a community room, a rentable guest suite, 2 free laundry rooms, & a gym, all at your disposal. There is 1 car assigned parking in the garage below - just an elevator ride away - free bike storage, & storage cages available for rent.
district__c, SF District 8
electric__c, 220 Volts in Kitchen
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
pba__floortype_pb__c, Simulated Wood
hoa_fee_includes__c, Common Areas,Elevator,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Roof,Security,Sewer,Trash,Water
pba__hoafees__c, 1053
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Lombard Plaza HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Electric;MultiUnits
ffd_lastmodifieddate, 2024-05-29T10:49:30.000+0000
pba__latitude_pb__c, 37.803967
pba__latitude_property__c, 37.803967
listed_date__c, 2024-02-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
ffd_listingagentname, Tim J Gullicksen
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, CIP14
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 28965
listing_office_mls_id__c, CIP14
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28965
pba__listingprice_pb__c, 650000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=noGHEguzLSu
pba__longitude_pb__c, -122.405281
mls_id__c, 424008649
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over
master_property__c, a0O1I000001VhhNUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-02-15
original_price__c, 699000
overall_days_on_market__c, -81859
parking_access__c, Side by Side
parking_features__c, Attached,Garage Facing Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-05-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 773.81
pba__propertytype__c, Condominium
ListingId, a0EUd000001AwjjMAC
sale_date__c, 2024-05-28
sale_price__c, 650000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, MLSL475255
selling_agent_number__c, 981206514
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams Palo Alto
pba__status__c, Closed
pba__totalarea_pb__c, 840
size__c, 840
pba__state_pb__c, CA
stories__c, 9
pba__street_pb__c, Lombard
subdist__c, North Waterfront
ffd_name, 240 Lombard Street #839, San Francisco, CA, 94111
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1993
pba__postalcode_pb__c, 94111
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530732343-1.jpg