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.
ffd_listing_title, 900 Green Street #400, San Francisco, CA, 94133
ffd_mls_id, 493807
ffd_salesforce_id, a0E1I00000Q0etOUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 11
address2__c, 900 Green Street #400, San Francisco, CA, 94133
pba__address_pb__c, 900 Green Street #400, San Francisco, CA, 94133
agent_only_remarks__c, Entrance on Taylor at Green. Please use SFAR purchase contract and accompany with fully executed disclosure package.
appliances__c, Dishwasher;Gas Range
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1989
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-02-11
ffd_createddate, 2020-01-18T18:46:42.000+0000
days_on_market__c, 1278
dom__c, 30
ffd_description_pb, Breathtaking Views from all directions! Atop the North East corner of 900 Green sits a wonderful 3 BR/2.5 BA with stupendous VIEWS from almost every room. Two of the bedrooms capture gorgeous Eastern views of Coit Tower, Bay Bridge, & the water. The living room, dining room & kitchen capture unobstructed views of Alcatraz and Bay. The large walk out terrace captures both Northern & Eastern views and can be accessed from dining room, kitchen or living room. Two of the bedrooms have ensuite bathrooms. Enjoy the fireplace in the living room while taking in views of Alcatraz & the Bay, or entertain on your large terrace while taking in the phenomenal views North & East. This condo has a great, spacious floor plan, very house-like feeling. Two car side by side parking, in-unit washer/dryer, ample closet space & deeded storage complete this fabulous condo. It's in a boutique 11-unit building, HOA dues include Earthquake insurance. Come see the magical views...you won't be disappointed!
900 Green Street #400, San Francisco, CA, 94133 - Property Description
Breathtaking Views from all directions! Atop the North East corner of 900 Green sits a wonderful 3 BR/2.5 BA with stupendous VIEWS from almost every room. Two of the bedrooms capture gorgeous Eastern views of Coit Tower, Bay Bridge, & the water. The living room, dining room & kitchen capture unobstructed views of Alcatraz and Bay. The large walk out terrace captures both Northern & Eastern views and can be accessed from dining room, kitchen or living room. Two of the bedrooms have ensuite bathrooms. Enjoy the fireplace in the living room while taking in views of Alcatraz & the Bay, or entertain on your large terrace while taking in the phenomenal views North & East. This condo has a great, spacious floor plan, very house-like feeling. Two car side by side parking, in-unit washer/dryer, ample closet space & deeded storage complete this fabulous condo. It's in a boutique 11-unit building, HOA dues include Earthquake insurance. Come see the magical views...you won't be disappointed!
