meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='333878' 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] => 2023-06-23 07:14:44
[post_modified_gmt] => 2023-06-23 14:14:44
[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, 1101 Green Street #1101, San Francisco, CA, 94109
ffd_mls_id, 423749745
ffd_salesforce_id, a0E8W00000cJjsWUAS
num_of_fireplaces__c, 0
num_of_rooms__c, 6
of_units__c, 64
address2__c, 1101 Green Street #1101, San Francisco, CA, 94109
pba__address_pb__c, 1101 Green Street #1101, San Francisco, CA, 94109
agent_only_remarks__c, Great opportunity for prospective buyers to invest in a residential condominium with 180 degrees of incredible sweeping views of the city. This half-floor condo provides you the opportunity to design according to your usage and lifestyle. Showing by appointment with 24 hour notice. Trust Sale. Pre-opened escrow with Fidelity National Title Ocean Avenue office with Lynn Chan. Seller reserves the right to accept, reject or counter any or all offers.
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1930
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-06-22T17:48:37.000+0000
days_on_market__c, 89
dom__c, 73
ffd_description_pb, Irreplaceable Views! 2 Condo Units in 1 very spacious half-floor residence with 180 degrees views of the city's most iconic Landmarks. Experience the epitome of The Exclusive Lifestyle at The Bellaire Tower, a historic Art Deco designer building by H.C. Baumann, where elegance meets natural beauty! Nestled in the heart of San Francisco's Russian Hill, this 2-bedroom 2-bath residential condominium floor plan offers panoramic sweeping views of the iconic Golden Gate Bridge, the shimmering water of the bay, the vibrant Downtown San Francisco cityscape with all the favorite landmarks like the Transamerica Pyramid Skyscraper, Salesforce Tower, Sutro Tower, Coit Tower, Bay Bridge to East Bay, and much more. The Bellaire Tower boasts 64 grand residences and amenities include a 24-hour lobby attendant, valet parking, a rooftop deck with Grand Views of the city, as well as easy access to world-class dining, entertainment, cultural landmarks, and renowned shopping districts. The residence features a welcoming Foyer, a Grand Living Room connecting to 2 bonus rooms, a separate Formal Dining Room, 2 spacious Bedrooms w/ walk-in Closets, 2 Full Bathrooms, a storage room with closets and lots of storage spaces throughout the unit. Majestic City and Water Views from every window. Must see!
district__c, SF District 8
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Door Person,Security,Trash
pba__hoafees__c, 2556
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Bel Aire Tower Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2023-09-19T21:46:08.000+0000
pba__latitude_pb__c, 37.798234
pba__latitude_property__c, 37.798234
listed_date__c, 2023-06-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Edison
pba__listing_agent_lastname__c, Ongpian
listing_agent_mls_id__c, 803559
ffd_listingagentname, Edison Ongpian
listing_agent_number__c, 803559
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, JODI
listing_office_name__c, JODI Group
listing_office_number__c, 15618
pba__listingprice_pb__c, 1875000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=KuHaZXaTdgq&mls=1
pba__longitude_pb__c, -122.417394
mls_id__c, 423749745
master_bathroom_features__c, Shower Stall(s);Tub;Closet;Window
master_property__c, a0O1I000001VhqqUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-22
open_house_end__c, 2023-09-19T11:00:00.000+0000
open_house_start__c, 2023-09-19T09:00:00.000+0000
original_price__c, 2388000
overall_days_on_market__c, -81621
parking_access__c, Tandem
parking_features__c, Valet
parking_type__c, On Site - Unassigned (Condo Only)
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, 1014.06
price_reduced__c, 1
pba__propertytype__c, Condominium
ListingId, a0E8W00000cJjsWUAS
room_type__c, Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom 2+
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Secured Access
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, 1849
size__c, 1849
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Russian Hill
ffd_name, 1101 Green Street #1101, San Francisco, CA, 94109
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1930
pba__postalcode_pb__c, 94109
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530634286-1.jpg