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, 872 Union Street, San Francisco, CA, 94133
ffd_mls_id, 423911359
ffd_salesforce_id, a0E8W00000dTglXUAS
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 4
address2__c, 872 Union Street, San Francisco, CA, 94133
pba__address_pb__c, 872 Union Street, San Francisco, CA, 94133
agent_only_remarks__c, This is a newly renovated building consisting of 3 condominium homes + the brand new construction single family home condominium at 31 Aladdin Terrace. CC&Rs have been recorded and an Temporary Certificate of Completion has been issued. Final recording of Certificate of Final Completion is pending and imminent. Square foot totals are per draftsmen measurements and differ from condominium map. Buyers to verify. HOA dues are estimated. Please call/text Stephanie House for showings 619.964.4709, [email protected]
appliances__c, Dishwasher;Microwave;Disposal;Built-In Gas Range;Wine Refrigerator;Built-In Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 0
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Edward R Deleski
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-22T18:47:14.000+0000
days_on_market__c, 69
dom__c, 69
ffd_description_pb, This exquisite, Russian Hill condominium residence offers luxurious living space throughout and an ideal location within close proximity to neighborhood restaurants, cafes, shops and amenities . Rebuilt, renovated and completed in 2023, this home boasts a Great Room designed with an open floor plan, creating an inviting atmosphere for grand scale dining and entertaining, and boasting high ceilings and huge windows. The living room showcases a gas-burning fireplace, while the spacious dining room with a Murano glass chandelier adds to the elegance. The chef's kitchen is equipped with high-end Thermador appliances, a sizable center island, custom cabinetry and designer finishes, including gorgeous Italian design porcelain surfaces. The primary bedroom suite boasts luxurious spa-like finishes, with an additional bedroom and bathroom + spacious in-unit laundry. The property also includes convenient 1-car garage parking with direct interior access to the home. Situated just minutes away from the vibrant heart of Russian Hill and North Beach, you'll enjoy easy access to a variety of eateries, restaurants, shops, and cafes.
district__c, SF District 8
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 350
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 870-872-874 Union / 31 Aladdin Ter HOA
872 Union Street, San Francisco, CA, 94133 - Property Description
This exquisite, Russian Hill condominium residence offers luxurious living space throughout and an ideal location within close proximity to neighborhood restaurants, cafes, shops and amenities . Rebuilt, renovated and completed in 2023, this home boasts a Great Room designed with an open floor plan, creating an inviting atmosphere for grand scale dining and entertaining, and boasting high ceilings and huge windows. The living room showcases a gas-burning fireplace, while the spacious dining room with a Murano glass chandelier adds to the elegance. The chef's kitchen is equipped with high-end Thermador appliances, a sizable center island, custom cabinetry and designer finishes, including gorgeous Italian design porcelain surfaces. The primary bedroom suite boasts luxurious spa-like finishes, with an additional bedroom and bathroom + spacious in-unit laundry. The property also includes convenient 1-car garage parking with direct interior access to the home. Situated just minutes away from the vibrant heart of Russian Hill and North Beach, you'll enjoy easy access to a variety of eateries, restaurants, shops, and cafes.
