meta_query='key:subdist__c;value:Russian Hill|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338526' 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, 955 Green Street #1, San Francisco, CA, 94133
ffd_mls_id, 423907829
ffd_salesforce_id, a0E8W00000dSVp7UAG
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 6
address2__c, 955 Green Street #1, San Francisco, CA, 94133
pba__address_pb__c, 955 Green Street #1, San Francisco, CA, 94133
agent_only_remarks__c, Please send your clients the website link: 955greenst1.com Showings by appointment & no open houses. Building exterior is currently being painted.
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Refrigerator
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 3
year_build_text__c, 2002
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-15T10:47:55.000+0000
days_on_market__c, 6
dom__c, 6
ffd_description_pb, Exclusive listing at 955 Green with North Bay View of Alcatraz. Three bedrooms including large primary suite with his and hers dressing rooms and baths. Three car parking spaces plus guest parking. Separate storage room. All on One level with elevator (no stairs) with 3 car parking! The homes at 955 Green are built on a single belief: fine architecture cultivates fine lives. Proportion, light, space - these intangibles are the greatest luxuries. From formal entertaining to the minutia of everyday life, this home is designed to create a sense of ease. The circulation between rooms fosters effortless flow and interaction. Public and private spaces are carefully delineated. Bedroom suites serve as spacious refuges overlooking city water views or gardens. All have marble or limestone bathrooms and large walk in closets. Kitchen is laid out and equipped to serve as intimate family gathering places, casual entertainment hubs, or formal catering facilities.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Elevator,Maintenance Exterior,Maintenance Grounds,Management,Security,Trash
pba__hoafees__c, 3595
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 955 Green Street Homeowners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2023-09-21T21:46:47.000+0000
pba__latitude_pb__c, 37.7986233
pba__latitude_property__c, 37.7986233
laundry_features__c, Inside Room;Washer Included;Dryer Included;Cabinets;Sink
listed_date__c, 2023-08-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Monica
pba__listing_agent_lastname__c, Pauli
listing_agent_mls_id__c, 802345
ffd_listingagentname, Monica M Pauli
listing_agent_number__c, 802345
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 3750000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.955greenst1.com
pba__longitude_pb__c, -122.4147567
mls_id__c, 423907829
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Family Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Double Sinks;Soaking Tub
master_property__c, a0O8W00000KTK2TUAX
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-09-15
open_house_end__c, 2023-09-26T11:00:00.000+0000
open_house_start__c, 2023-09-26T09:00:00.000+0000
original_price__c, 3750000
overall_days_on_market__c, -81706
parking_access__c, Independent
parking_features__c, Attached,Enclosed,Garage Door Opener,Guest Parking Available,Interior Access,Side-by-Side
parking_type__c, On Site - Assigned (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, 1243.78
pba__propertytype__c, Condominium
ListingId, a0E8W00000dSVp7UAG
room_type__c, Storage;Laundry;Kitchen;Living Room;Baths Other;Dining Room;Family Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Security Gate;Secured Access;Carbon Mon Detector;Video System
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, 3015
size__c, 3015
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Green
subdist__c, Russian Hill
ffd_name, 955 Green Street #1, San Francisco, CA, 94133
view__c, City Lights;Bay;Water
website_property_type__c, Condominium
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 2002
pba__postalcode_pb__c, 94133
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530673234-1.jpg
