meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='327852' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15719
[post_author] => 4
[post_date] => 2018-11-02 19:54:35
[post_date_gmt] => 2018-11-02 19:54:35
[post_content] => Russian sailors were once buried upon this hill. That's why. Ground zero for the San Francisco high-rise revolt that began in the 1960s. Not coincidentally, also home to The Summit, The Royal Towers, Green Hill Tower, the so-called crookedest street in SF (the real crookedest street is in Potrero Hill), and the authentic inspiration for Armistead Maupin's magical Barbary Lane.
[post_title] => Russian Hill
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => russian-hill
[to_ping] =>
[pinged] =>
[post_modified] => 2022-12-14 03:40:15
[post_modified_gmt] => 2022-12-14 11:40:15
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15719
[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, 1150 Lombard Street #3, San Francisco, CA, 94109
ffd_mls_id, 423727596
ffd_salesforce_id, a0E8W00000bFquuUAC
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 42
address2__c, 1150 Lombard Street #3, San Francisco, CA, 94109
pba__address_pb__c, 1150 Lombard Street #3, San Francisco, CA, 94109
agent_only_remarks__c, Exceptional townhouse/condo at The Lombardia - three levels of living with an elevator to each floor directly from the garage. Pre-sale escrow open with Kevin Thompson, First American Title. Call or email Pattie with any questions or for showings: 415-309-7836, [email protected]
appliances__c, Dishwasher;Disposal;Electric Cook Top;Free Standing Refrigerator;Built-In Electric Oven
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1990
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-03-16T13:48:06.000+0000
days_on_market__c, 11
dom__c, 10
ffd_description_pb, Rare, private villa with Golden Gate Bridge views and lush patios and terraces at The Lombardia, a full service luxury building on Russian Hill. One of the largest townhomes, this exceptional home is ideally sited with access through the formal lobby, near the fountain, with a private entrance and front patio. This three story home has an elevator to all levels, gorgeous light and five private terraces or patios. The expansive floor plan includes a bright living room with terrace with Golden Gate views, elegant dining area, eat-in kitchen with breakfast area and terrace. The spacious primary suite has a wonderful view terrace and custom closet/dressing area. The house-like condominium has three additional bedrooms, gracious family room (or additional bedroom suite) with verdant patio and separate kitchenette with a wet bar for easy entertaining, laundry room, two car side by side parking, and three storage rooms. The Lombardia is a serene sanctuary set in urban elegance near Polk, Hyde, and Union Street shops and restaurants. Just a block from the cable car line, and across the street from Alice Marble Tennis Courts and George Sterling Park and just two blocks from newly opened neighborhood gem, Francisco Park.
district__c, SF District 8
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard
external_listing__c, 1
fireplace_features__c, Gas Log
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Door Person,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Security,Trash,Water
pba__hoafees__c, 2868
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 1150 Lombard Homeowners' Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2023-03-25T12:47:32.000+0000
pba__latitude_pb__c, 37.8021
pba__latitude_property__c, 37.8021
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2023-03-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Patricia
pba__listing_agent_lastname__c, Lawton
listing_agent_mls_id__c, 800774
ffd_listingagentname, Patricia A Lawton
listing_agent_number__c, 800774
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 2800000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4205967
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Street Entrance
mls_id__c, 423727596
main_level__c, Full Bath(s);Bedroom(s);Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Soaking Tub
master_property__c, a0O1I000001VhhOUAS
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-03-15
open_house_end__c, 2023-03-26T13:00:00.000+0000
open_house_start__c, 2023-03-26T11:00:00.000+0000
original_price__c, 2800000
overall_days_on_market__c, -81522
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Guest Parking Available
parking_type__c, On Site - Assigned (Condo Only)
patio_and_porch_features__c, Uncovered 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, 804.37
pba__propertytype__c, Condominium
ListingId, a0E8W00000bFquuUAC
room_type__c, Laundry;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 3481
size__c, 3481
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Lombard
subdist__c, Russian Hill
ffd_name, 1150 Lombard Street #3, San Francisco, CA, 94109
view__c, City Lights;Garden/Greenbelt;Bay;Golden Gate Bridge
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1990
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530591285-1.jpg