meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='234801' 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] => 2024-03-19 14:29:22
[post_modified_gmt] => 2024-03-19 21:29:22
[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, 1097 Green Street #6, San Francisco, CA, 94133
ffd_mls_id, 422628565
ffd_salesforce_id, a0E8W00000VsJnCUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 4
of_units__c, 14
address2__c, 1097 Green Street #6, San Francisco, CA, 94133
pba__address_pb__c, 1097 Green Street #6, San Francisco, CA, 94133
agent_only_remarks__c, Bright corner unit you do not want to miss out on. Many open houses and opportunities to send your clients. Disclosure package: https://app.disclosures.io/link/1097-Green-Street-6-aysixnw. For showings, please email [email protected] and [email protected] Not Use Showing Time. Offers, if any, to be submitted Thursday 2/17 by 12PM.
appliances__c, Disposal;Built-In Gas Range;Free Standing Refrigerator;Wine Refrigerator
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, David G Cohen
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2022-02-11T15:48:06.000+0000
days_on_market__c, 523
dom__c, 6
ffd_description_pb, Located on one of Russian Hill's most desirable blocks, this tastefully updated Edwardian condo boasts the best of city living. Stately pocket doors allow the flexible floor plan to be used as a two-bedroom unit. With top-rated restaurants, cafes, and outdoor destinations outside your front door, this unit has location, location, location! Newly refinished hardwood floors compliment the tall wainscoting, high box-beam ceilings and original San Francisco details throughout. Gorgeous built-ins surround the dramatic fireplace in dining room. Large windows drench this corner unit in natural sunlight and even offer a partial view of the GGB. Recently renovated kitchen with gas range, stainless steel appliances and open shelving. Beautiful walkthrough pantry and bar. The large bedroom is of glorious scale and has not one, but two closets. Laundry room in unit with plenty of storage throughout. This trophy unit has a dedicated storage room and deeded one-car parking. This is not to be missed!
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Brick;Other;Dining Room
pba__floortype_pb__c, Wood;Stone
hoa_fee_includes__c, Common Areas,Gas,Heat,Insurance,Sewer,Trash,Water
pba__hoafees__c, 550
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Radiant
interior_features__c, Storage Area(s);Open Beam Ceiling
ffd_lastmodifieddate, 2022-03-22T11:46:25.000+0000
pba__latitude_pb__c, 37.79836
pba__latitude_property__c, 37.79836
laundry_features__c, Inside Room;Washer Included;Dryer Included
listed_date__c, 2022-02-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Susan Hewitt
pba__listing_agent_lastname__c, C.J. Nakagawa
listing_agent_mls_id__c, 355993
ffd_listingagentname, Susan Hewitt C.J. Nakagawa
listing_agent_number__c, 355993
listing_co_agent_mls_id__c, 804695
listing_co_agent_number__c, 166014347
listing_co_office_mls_id__c, CITYRE
listing_co_office_name__c, City Real Estate
listing_co_office_number__c, 27425
listing_office_mls_id__c, DECK01
listing_office_name__c, Golden Gate Sotheby's International Realty
listing_office_number__c, 166014716
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.417
mls_id__c, 422628565
master_property__c, a0O8W00000DaguLUAR
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-02-11
original_price__c, 1095000
overall_days_on_market__c, 139
parking_access__c, Independent
parking_features__c, See Remarks
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2022-02-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-03-21T22:25:54.000+0000
price_per_square_foot__c, 1442.31
pba__propertytype__c, Condominium
id, a0E8W00000VsJnCUAV
sale_date__c, 2022-03-21
sale_price__c, 1500000
selling_agent_mls_id__c, 802800
selling_agent_number__c, 802800
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1040
size__c, 1040
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Russian Hill
ffd_name, 1097 Green Street #6, San Francisco, CA, 94133
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530400120-1.jpg
ListingId, a0E8W00000VsJnCUAV
