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 Street. Final recording of Certificate of Final Completion and CC&Rs is pending and imminent. Square foot totals are per draftsmen measurements and differ from condominium map. Buyers to verify. HOA dues are estimated
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,1
dom__c,1
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
hoa__c,Yes
pba__halfbathrooms_pb__c,0
pba__heatingtype_pb__c,Radiant Floor
ffd_lastmodifieddate,2023-09-23T01:47:57.000+0000
pba__latitude_pb__c,37.800157
pba__latitude_property__c,37.800157
laundry_features__c,Laundry Closet;Washer Included;Dryer Included
listed_date__c,2023-07-02
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Jean-Paul
pba__listing_agent_lastname__c,Samaha
listing_agent_mls_id__c,804997
ffd_listingagentname,Jean-Paul Samaha
listing_agent_number__c,166014752
listing_co_agent_mls_id__c,807512
listing_co_agent_number__c,1020319
listing_co_office_mls_id__c,VANG02
listing_co_office_name__c,Vanguard Properties
listing_co_office_number__c,166013449
listing_office_mls_id__c,VANG02
listing_office_name__c,Vanguard Properties
listing_office_number__c,166013449
pba__listingprice_pb__c,2095000
pba__listingtype__c,Sale
pba__longitude_pb__c,-122.41366
mls_id__c,423911359
master_property__c,a0O8W00000KThEaUAL
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,1
on_market_date__c,2023-09-21
open_house_end__c,2023-09-24T16:00:00.000+0000
open_house_start__c,2023-09-24T14:00:00.000+0000
original_price__c,2095000
overall_days_on_market__c,-81712
parking_access__c,Side by Side
parking_features__c,Garage Facing Front,Interior Access,Mechanical Lift
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,1285.28
pba__propertytype__c,Condominium
ListingId,a0E8W00000dTglXUAS
roof__c,Tar/Gravel
room_type__c,Kitchen;Living Room;Dining Room;Great Room;Primary Bedroom
sale_date__c,1800-01-01
sale_price__c,0
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,1630
size__c,1630
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,Union
subdist__c,Russian Hill
ffd_name,872 Union Street, San Francisco, CA, 94133
view__c,San Francisco
website_property_type__c,Condominium
window_features__c,Dual Pane Full
pba__yearbuilt_pb__c,0
pba__postalcode_pb__c,94133
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530681531-1.jpg