ffd_listing_title,874 Union Street, San Francisco, CA, 94133

ffd_mls_id,423747259

ffd_salesforce_id,a0E8W00000cJKQTUA4

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,4

address2__c,874 Union Street, San Francisco, CA, 94133

pba__address_pb__c,874 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;Hood Over Range;Free Standing Gas Oven;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-06-10T01:48:37.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,This exquisite, Russian Hill penthouse condominium residence offers luxurious living space throughout and an expansive roof terrace with panoramic views from the Bay to the Transamerica Building. Newly renovated and reimagine in 2023, this home features grand living space throughout. The Great Room, designed with an open floor plan, creates an inviting atmosphere for grand scale dining and entertaining. The living room showcases a gas-burning fireplace, while the spacious dining room adds to the elegance. The chef's kitchen is equipped with high-end Thermador appliances, a sizable center island, and designer finishes. The primary bedroom suite boasts luxurious spa-like finishes, and there is an additional guest bedroom with a luxurious bathroom and in-unit laundry. The exclusive-use rooftop terrace offers multiple outdoor seating areas, a fire pit, a fountain, and breathtaking views. The property also includes convenient 1-car garage parking. 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,Gas Piped

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Homeowners Insurance,Insurance,Sewer,Trash,Water

pba__hoafees__c,400

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Radiant

ffd_lastmodifieddate,2023-06-10T10:49:07.000+0000

pba__latitude_pb__c,37.79995366

pba__latitude_property__c,37.79995366

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2023-03-01

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,2595000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.4135782

mls_id__c,423747259

master_property__c,a0O8W00000Jb4mKUAR

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-06-09

open_house_end__c,2023-06-11T16:00:00.000+0000

open_house_start__c,2023-06-11T14:00:00.000+0000

original_price__c,2595000

overall_days_on_market__c,-81608

parking_access__c,Side by Side

parking_features__c,Garage Facing Front,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,1495.68

pba__propertytype__c,Condominium

ListingId,a0E8W00000cJKQTUA4

room_type__c,Kitchen;Living Room;Dining Room;Great Room;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Security Gate

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,1735

size__c,1735

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Union

subdist__c,Russian Hill

ffd_name,874 Union Street, San Francisco, CA, 94133

view__c,Water;Downtown;San Francisco

website_property_type__c,Condominium

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/530631540-1.jpg

ffd_listing_title,870 Union Street, San Francisco, CA, 94133

ffd_mls_id,423747250

ffd_salesforce_id,a0E8W00000cJKQUUA4

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,4

address2__c,870 Union Street, San Francisco, CA, 94133

pba__address_pb__c,870 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

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-06-10T01:48:37.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Exquisite Russian Hill townhome condominium residence offers luxurious living space in a serene garden setting. Newly renovated and reimagined in 2023, this home features grand living space throughout. The Great Room, designed with an open floor plan, creates an inviting atmosphere for grand scale dining and entertaining. The living room showcases a gas-burning fireplace, while the spacious dining room adds to the elegance +a powder room for your guests. The chef's kitchen is equipped with high-end Thermador appliances, a sizable center island, and designer finishes. The primary bedroom suite boasts luxurious spa-like finishes, and there is an additional guest bedroom with a luxurious bathroom and in-unit laundry. The property also includes convenient 1-car garage parking. 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,Gas Piped

pba__hoafees__c,400

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

ffd_lastmodifieddate,2023-06-10T10:49:07.000+0000

pba__latitude_pb__c,37.800157

pba__latitude_property__c,37.800157

listed_date__c,2023-03-15

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,1995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.41366

mls_id__c,423747250

master_property__c,a0O8W00000Jb4mLUAR

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-06-09

open_house_end__c,2023-06-11T16:00:00.000+0000

open_house_start__c,2023-06-11T14:00:00.000+0000

original_price__c,1995000

overall_days_on_market__c,-81608

parking_access__c,Side by Side

parking_features__c,Assigned,Garage Door Opener,Interior Access,Mechanical Lift

parking_type__c,On Site - Mapped (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,1308.2

pba__propertytype__c,Condominium

ListingId,a0E8W00000cJKQUUA4

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,1525

size__c,1525

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Union

subdist__c,Russian Hill

ffd_name,870 Union Street, San Francisco, CA, 94133

website_property_type__c,Condominium

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/530631542-1.jpg

ffd_listing_title,1450 Greenwich Street #201, San Francisco, CA, 94109

ffd_mls_id,423748379

ffd_salesforce_id,a0E8W00000cJK8KUAW

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,24

address2__c,1450 Greenwich Street #201, San Francisco, CA, 94109

pba__address_pb__c,1450 Greenwich Street #201, San Francisco, CA, 94109

agent_only_remarks__c,For all showings and link to DP, please call or text Luke at 650-773-8110 or email [email protected] Alternatively contact Kevin at 415-298-4142 or email [email protected] Please submit all offers to [email protected] and cc [email protected] All offers must be on SFAR purchase agreement, accompanied with proof of funds, pre-approval letter and signed DP coversheet. Preference for AVID, signed DP and EMD within 24 hours. Sellers reserve the right to accept or reject any offer. Escrow must remain with: ORTC/Yvette Gonzalez. www.1450Greenwich201.com

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Plumbed For Ice Maker

architectural_style__c,Spanish;Mediterranean

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,1928

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Kevin Wakelin

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2023-06-09T21:48:48.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,Located in the iconic Redstone built by famed 20th Century architect Henry Clay Smith, residence #201 is not to be missed. The home enjoys a large combined living and dining room space, with expansive windows offering southern views of the city. Bold and beautiful, well-appointed and logically configured, this airy one-bedroom and one-bathroom home offers traditional period detailing, exposed ceiling beams, hardwood floors, an adobe-styled Mission fireplace, and bespoke design details throughout. A perfectly casual dining room provides a sense of formal dining, while the updated kitchen creates a gourmet chef's dream. Directly off the kitchen you'll find a relaxing private covered patio, creating a perfect al-fresco spot to sip your morning coffee, read a book, or simply get some fresh air. Rounding out this exquisite home is a renovated bathroom adorned with terra cotta tiling, a shower and soaking tub, and a dual sink vanity. The home also features an abundance of closets and storage, and a cute studio office tucked away off the main hallway. Residents enjoy an expansive roofdeck and owner's lounge with staggering views of the bay and the Golden Gate Bridge. Rarely available, don't miss your opportunity to own in this coveted building.

district__c,SF District 8

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Living Room;Wood Burning;Stone

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Sewer,Trash,Water

pba__hoafees__c,932

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Redstone Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry;Storage Area(s);Open Beam Ceiling

ffd_lastmodifieddate,2023-06-10T10:49:07.000+0000

pba__latitude_pb__c,37.800756

pba__latitude_property__c,37.800756

laundry_features__c,In Basement

listed_date__c,2023-06-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Luke

pba__listing_agent_lastname__c,Ford

listing_agent_mls_id__c,817374

ffd_listingagentname,Luke Ford

listing_agent_number__c,1076249

listing_co_agent_mls_id__c,809116

listing_co_agent_number__c,1040475

listing_co_office_mls_id__c,COMP12

listing_co_office_name__c,Compass

listing_co_office_number__c,28739

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,1045000

pba__listingtype__c,Sale

pba__listing_website__c,http://my.matterport.com/show/?m=ndLe9rpvzhH

pba__longitude_pb__c,-122.42356

mls_id__c,423748379

main_level__c,Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom

master_bathroom_features__c,Tub w/Shower Over;Double Sinks;Tile;Window

master_property__c,a0O1I000001Vi0bUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2023-06-09

open_house_end__c,2023-06-10T16:00:00.000+0000

open_house_start__c,2023-06-10T14:00:00.000+0000

original_price__c,1045000

overall_days_on_market__c,-81608

patio_and_porch_features__c,Covered Patio

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,1161.11

pba__propertytype__c,Condominium

ListingId,a0E8W00000cJK8KUAW

road_surface_type__c,Paved

room_type__c,Office;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Secured Access;Carbon Mon Detector

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,900

size__c,900

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Greenwich

subdist__c,Russian Hill

ffd_name,1450 Greenwich Street #201, San Francisco, CA, 94109

view__c,City

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1928

pba__postalcode_pb__c,94109

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530631346-1.jpg

ffd_listing_title,1750 Taylor Street #1202, San Francisco, CA, 94133

ffd_mls_id,423747176

ffd_salesforce_id,a0E8W00000cJJ7dUAG

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,0

address2__c,1750 Taylor Street #1202, San Francisco, CA, 94133

pba__address_pb__c,1750 Taylor Street #1202, San Francisco, CA, 94133

agent_only_remarks__c,Showings by appointment only starting on Saturday, June 10 with 24 hours notice. There is a board approval process. For showings or disclosures, contact Carol Solfanelli at (415) 297-7031 or [email protected] PLEASE DO NOT USE SHOWTIME. Escrow opened with Yvette Gonzalez at Old Republic. Cable Car runs 1/2 block away on Mason. It goes to Fisherman's Wharf and to Union Square.

appliances__c,Dishwasher;Microwave;Electric Cook Top;Built-In Refrigerator;Built-In Electric Oven

architectural_style__c,Contemporary;Modern/High Tech

bath_features__c,Tub w/Shower Over;Shower Stall(s)

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1964

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-06-09T14:47:58.000+0000

days_on_market__c,1

dom__c,0

ffd_description_pb,New Look and Great New Price! Step into luxury at the Royal Towers, San Francisco's most distinguished address, as the elevator quietly whisks you up to the 12th floor and unit 1202. Enter this sleek two bedroom, two bath Southwest corner Co-op with world-class views across Downtown, Russian Hill and out to the GG Bridge and the Bay. This unit was transformed in 2002 by highly regarded architect Cass Calder Smith into a sophisticated, open concept floor plan. This is unique for an 02 unit in this building and takes full advantage of its panoramic views. A southern terrace allows one to sit out on a nice evening and bask in these stunning views. The layout includes a chef's kitchen with custom cabinetry, stone counters, high-end appliances including two ovens and rich wood flooring. There is a primary suite with a walk-in closet and an inviting bath with shower. The building is professionally managed with a 24 hour doorman. The stunning 2022 renovation of the ODADA-designed common areas includes a fitness center, heated outdoor pool with retractable cover, dog run, and terrace room with catering kitchen.

district__c,SF District 8

driveway_sidewalks__c,Paved Driveway

entry_level__c,0

exterior_features__c,Balcony;Dog Run

external_listing__c,1

hoa_fee_includes__c,Door Person,Elevator,Insurance,Maintenance Exterior,Maintenance Grounds,Management,Pool,Trash,Water

pba__hoafees__c,2215

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Royal Towers Apartment Corporation

hoa__c,Yes

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2023-06-09T20:49:11.000+0000

pba__latitude_pb__c,37.798607

pba__latitude_property__c,37.798607

laundry_features__c,Laundry Closet;Washer Included;Dryer Included

listed_date__c,2022-01-23

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Carol

pba__listing_agent_lastname__c,Solfanelli

listing_agent_mls_id__c,803025

ffd_listingagentname,Carol L Solfanelli

listing_agent_number__c,803025

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP12

listing_office_name__c,Compass

listing_office_number__c,28739

pba__listingprice_pb__c,2595000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.413205

mls_id__c,423747176

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-06-09

open_house_end__c,2023-06-13T11:00:00.000+0000

open_house_start__c,2023-06-13T09:00:00.000+0000

original_price__c,2595000

overall_days_on_market__c,-81608

parking_access__c,Independent

parking_features__c,Enclosed,Garage Facing Front,Interior Access

parking_type__c,On Site - Assigned (Condo Only)

pba__pendingdate__c,1800-01-01

pba__pool_pb__c,1

possible_bedrooms__c,0

pba__pricechangedat__c,1800-01-01T00:00:00.000+0000

price_per_square_foot__c,1774.97

pba__propertytype__c,Stock Cooperative

ListingId,a0E8W00000cJJ7dUAG

room_type__c,Storage;Living Room;Dining Room;Primary Bathroom;Primary Bedroom

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Secured Access

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,1462

size__c,1462

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Taylor

subdist__c,Russian Hill

ffd_name,1750 Taylor Street #1202, San Francisco, CA, 94133

view__c,Panoramic;City Lights;Bay;Downtown;Bay Bridge;Golden Gate Bridge;Twin Peaks;Mt Tamalpais

website_property_type__c,Stock Cooperative

pba__yearbuilt_pb__c,1964

pba__postalcode_pb__c,94133

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530630980-1.jpg