Array
(
[ID] => 15724
[post_author] => 4
[post_date] => 2018-11-02 19:54:44
[post_date_gmt] => 2018-11-02 19:54:44
[post_content] => The grand estates of San Francisco. Commanding views. Lavishly large lots. Neighbors that you could name drop, but that's not your style. Pacific Heights says it all, without saying a word.
ffd_listing_title, 1864 Green Street, San Francisco, CA, 94123
ffd_mls_id, 423742443
ffd_salesforce_id, a0E8W00000awBZTUA2
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 3
address2__c, 1864 Green Street, San Francisco, CA, 94123
pba__address_pb__c, 1864 Green Street, San Francisco, CA, 94123
agent_only_remarks__c, Easy to show by appointment. Truly a spectacular unit. Please email [email protected] for showings or disclosures. Home has 2 parking spots. One is independent and the 2nd is tandem when neighbor has a 2nd car. Seller might want to participate in a 1031 exchange.
appliances__c, Dishwasher;Hood Over Range;Wine Refrigerator;Built-In Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-05-17T19:48:47.000+0000
days_on_market__c, 594
dom__c, 7
ffd_description_pb, With incredible iconic views of the Golden Gate Bridge and the San Francisco Bay, this top floor 3 bed, 2 bath condo combines an ideal location, tasteful modern design, and superior construction. Natural light shines through the many floor-to-ceiling windows and skylights. The centerpiece of the home is the open-concept kitchen, dining area, and living room that leads to the walkout private deck, all with full panoramic views. The chef's kitchen benefits from marble countertops, high-end stainless steel appliances, a wine fridge, and a six-burner range. 2 of the 3 bedrooms are south facing and soaked in sunlight. The primary bedroom has an incredible marble bathroom with a dual vanity and a walk-in shower. A second remodeled bathroom is placed perfectly between the social rooms and the bedrooms. The building has been completely remodeled with steel beams and structural upgrades. Hardwood floors, radiant floor heating, a large elevator opening directly into the unit, 2-car parking, storage, a shared roof deck with a fire pit and BBQ, and a large turfed garden are only some of the home's many features. When you combine those with the home's location, just steps from the many restaurants and shops on Union Street, you have truly one of the spectacular homes in San Francisco.
district__c, SF District 7
entry_level__c, 0
exterior_features__c, Balcony;Fire Pit
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Elevator,Insurance on Structure,Maintenance Grounds,Trash
1864 Green Street, San Francisco, CA, 94123 - Property Description
With incredible iconic views of the Golden Gate Bridge and the San Francisco Bay, this top floor 3 bed, 2 bath condo combines an ideal location, tasteful modern design, and superior construction. Natural light shines through the many floor-to-ceiling windows and skylights. The centerpiece of the home is the open-concept kitchen, dining area, and living room that leads to the walkout private deck, all with full panoramic views. The chef's kitchen benefits from marble countertops, high-end stainless steel appliances, a wine fridge, and a six-burner range. 2 of the 3 bedrooms are south facing and soaked in sunlight. The primary bedroom has an incredible marble bathroom with a dual vanity and a walk-in shower. A second remodeled bathroom is placed perfectly between the social rooms and the bedrooms. The building has been completely remodeled with steel beams and structural upgrades. Hardwood floors, radiant floor heating, a large elevator opening directly into the unit, 2-car parking, storage, a shared roof deck with a fire pit and BBQ, and a large turfed garden are only some of the home's many features. When you combine those with the home's location, just steps from the many restaurants and shops on Union Street, you have truly one of the spectacular homes in San Francisco.
