ffd_listing_title,188 Minna Street #33E, San Francisco, CA, 94105

ffd_mls_id,423911505

ffd_salesforce_id,a0E8W00000dTglUUAS

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,100

address2__c,188 Minna Street #33E, San Francisco, CA, 94105

pba__address_pb__c,188 Minna Street #33E, San Francisco, CA, 94105

agent_only_remarks__c,Pre-escrow is opened with Sharon Chan of ORTC. For showings and inquiries, please call ilya at 415.872.2222. Please note, swimming pool and spa are currently not accessible. 1 self-parking space will convey with the property at $300/mo. Second valet parking space is available for an additional $300/mo.

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Gas Range;Free Standing Refrigerator;Free Standing Electric Range

architectural_style__c,Contemporary

bath_features__c,Tub w/Shower Over

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,2005

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central,MultiZone

ffd_createddate,2023-09-22T18:47:14.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,The epitome of grandeur and elegance, the St. Regis is one of the premier luxury buildings in San Francisco. It consists of the hotel component and a rare collection of magnificent private homes. Brilliant and capacious, residence #33E is one of the most desirable units in the building. Timeless design of this home strikes an effortless balance between an elegant past and all the comforts of a contemporary living. With 27 sizable window panels, the home is not only awash in natural light, but also provides 270 degrees of captivating views. The residence consists of 3 bedrooms and 3.5 bathrooms. A sliding wall connects the secondary bedroom to the living room, providing versatility where the secondary room becomes a part of the entertaining area. Soaring ceilings heights, multiple heating and air conditioning zones, automated window coverings and the meticulously chosen lush finishes are all a part of the luxurious living experience. St. Regis Residences provides a private lobby, fully staffed with security, concierge and valet services, available 24 hours a day. The building is equipped with a world-class amenities, such as fitness center, overlook terrace with cabanas, bar/lounge, restaurant, conference room and so much more.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Tile;Wood

hoa_fee_includes__c,Common Areas,Door Person,Earthquake Insurance,Elevator,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Pool,Recreation Facility,Security,Sewer,Trash,Water

pba__hoafees__c,786

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Baseboard;Central;MultiZone

ffd_lastmodifieddate,2023-09-23T01:47:57.000+0000

pba__latitude_pb__c,37.786313

pba__latitude_property__c,37.786313

laundry_features__c,Washer/Dryer Stacked Included;Dryer Included

listed_date__c,2023-09-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ilya

pba__listing_agent_lastname__c,Tsay

listing_agent_mls_id__c,808677

ffd_listingagentname,ILYA Tsay

listing_agent_number__c,1037584

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VANG06

listing_office_name__c,Vanguard Properties

listing_office_number__c,25987

pba__listingprice_pb__c,4999000

pba__listingtype__c,Sale

pba__listing_website__c,http://stregissf.com

pba__longitude_pb__c,-122.4013812

mls_id__c,423911505

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

master_bathroom_features__c,Shower Stall(s);Tub;Double Sinks;Marble

master_property__c,a0O8W00000KThEZUA1

monthly_parking_fees__c,300

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-22

open_house_end__c,2023-09-24T13:30:00.000+0000

open_house_start__c,2023-09-24T12:00:00.000+0000

original_price__c,4999000

overall_days_on_market__c,-81713

parking_access__c,Side by Side

parking_features__c,Attached,Covered,Enclosed,Garage Door Opener,Side-by-Side

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTglUUAS

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Carbon Mon Detector;Security Patrol

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

size__c,2670

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Minna

subdist__c,Yerba Buena

ffd_name,188 Minna Street #33E, San Francisco, CA, 94105

view__c,City;Panoramic;City Lights;Bay;Water;Downtown;San Francisco

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2005

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,1 Hawthorne Street #24B, San Francisco, CA, 94105

ffd_mls_id,423900316

ffd_salesforce_id,a0E8W00000dTglRUAS

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,165

address2__c,1 Hawthorne Street #24B, San Francisco, CA, 94105

pba__address_pb__c,1 Hawthorne Street #24B, San Francisco, CA, 94105

agent_only_remarks__c,Please email [email protected] for showing requests and questions. Property is shown by private appointment with 24 hours advance notice as the property is seller occupied. Property website with photos and floor plan available here: wwww.OneHawthorne24B.com. 2015 sqft per graphic artist. 1943 sqft per tax records. One Hawthorne Penthouse Residences rarely become available offering a unique opportunity to acquire a luxury Penthouse in a boutique full amenity building with onsite building manager, valet parking, and 24-hour manned lobby attendant. A tremendous value compared to other luxury high-rises in the area.

appliances__c,Dishwasher;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator

architectural_style__c,Contemporary

bath_features__c,Shower Stall(s);Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,3

year_build_text__c,2010

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Marcus A Lee

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2023-09-22T18:47:14.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Indulge in resort-style living in the heart of downtown San Francisco from one of the city's most centrally located amenity buildings. From a commanding 24th floor elevation, Residence #24B enjoys breathtaking southwest-facing panoramas of the city and rolling hills of Twin Peaks. The 3-BD + Den, 2.5 Bathroom penthouse's open floor plan includes a spacious dining and living room with a wall of floor-to-ceiling windows looking out over the city. The kitchen features a suite of premium European appliances (Sub Zero, Thermador) quartz countertops, a large island, and Studio Becker cabinetry. The primary suite offers excellent sunlight via floor-to-ceiling windows, a large walk-in closet with a custom-designed closet organizer, and an en-suite bath with premium fixtures and finishes. The 2nd and 3rd bedrooms also feature floor-to-ceiling windows, ample closet space, and access to an adjacent hall powder room and a full bath. Includes a den space, full-sized washer and dryer, and 1-car valet parking. Amenities include a 26th-floor rooftop deck with an outdoor kitchenette, seating, and dining areas; an attended lobby; 24-hour valet parking; and a fitness center with an outdoor cooling terrace. Easy access to Bay Bridge, 280 and 101 freeways, and regional transportation.

district__c,SF District 9

driveway_sidewalks__c,Paved Driveway,Paved Sidewalk,Shared Driveway

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Tile;Wood

hoa_fee_includes__c,Common Areas,Door Person,Elevator,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Security,Sewer,Trash,Water

pba__hoafees__c,1209

pba__hoafrequency_pb__c,Monthly

hoa_name__c,One Hawthorne Owners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-23T01:47:32.000+0000

pba__latitude_pb__c,37.785779

pba__latitude_property__c,37.785779

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2023-09-18

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Todd

pba__listing_agent_lastname__c,Montgomery

listing_agent_mls_id__c,807753

ffd_listingagentname,Todd Montgomery

listing_agent_number__c,1025356

listing_co_agent_mls_id__c,804756

listing_co_agent_number__c,166014430

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

pba__listingtype__c,Sale

pba__listing_website__c,http://wwww.OneHawthorne24B.com

pba__longitude_pb__c,-122.398933

mls_id__c,423900316

main_level__c,Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom

master_bathroom_features__c,Shower Stall(s);Tub;Double Sinks;Tile

master_property__c,a0O1I000001VhotUAC

monthly_parking_fees__c,442

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-22

original_price__c,2900000

overall_days_on_market__c,-81713

parking_access__c,Side by Side

parking_features__c,Garage Facing Front,Interior Access,Valet

parking_type__c,On Site - Unassigned (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,1439.21

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTglRUAS

room_type__c,Office;Kitchen;Living Room;Baths Other;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,2015

size__c,2015

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Hawthorne

subdist__c,Yerba Buena

ffd_name,1 Hawthorne Street #24B, San Francisco, CA, 94105

view__c,City

website_property_type__c,Condominium

window_features__c,Window Coverings

pba__yearbuilt_pb__c,2010

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,301 Mission Street #33C, San Francisco, CA, 94105

ffd_mls_id,423911539

ffd_salesforce_id,a0E8W00000dTgEiUAK

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,419

address2__c,301 Mission Street #33C, San Francisco, CA, 94105

pba__address_pb__c,301 Mission Street #33C, San Francisco, CA, 94105

agent_only_remarks__c,Please contact James Testa for private showing. 415.515.6097. Kindly allow for 24 hours notice for showing appointment. Listing agent will be happy to chat about current lending options for Millennium tower.

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,2009

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-22T13:46:44.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Commanding Bay Bridge views - This luminous three bedroom Grand Residence compliments the dynamic SF downtown skyline with refined handcrafted finishes, muted color palette, and voluminous interiors. Meticulously refurbished, the free flowing salon, dining room, and streamlined kitchen are seamlessly oriented east, with floor-to-ceiling windows, overlooking The East Cut and the San Francisco Bay. Each of three en suite bedrooms are flooded with natural light as well as city and bay views. Millennium Tower is in the final phase of a multi-year retrofit, highlighting the exceptional service and amenity offerings, only available to the residents and their guests. The Club Level mirrors the luxurious offerings of the most discerning5 star hotel. Each morning is welcomed with complimentary coffee and tea service in the Owner's Lounge. As the day unfolds, the state-of-the-art gym, Pilates room, yoga studio, and indoor pool are often used to recreate. The screen room, wine tasting room and private dining room are the perfect areas to round out your day. Michael Mina's International Smoke provides full table and bar service beginning in the late afternoon.

district__c,SF District 9

entry_level__c,0

external_listing__c,1

pba__hoafees__c,2959

pba__hoafrequency_pb__c,Monthly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_monthly_parking_fees__c,1

ffd_lastmodifieddate,2023-09-23T02:47:15.000+0000

pba__latitude_pb__c,37.79077

pba__latitude_property__c,37.79077

listed_date__c,2023-09-09

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,James

pba__listing_agent_lastname__c,Testa

listing_agent_mls_id__c,807137

ffd_listingagentname,James Testa

listing_agent_number__c,166018280

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COMP

listing_office_name__c,Compass

listing_office_number__c,26293

pba__listingprice_pb__c,1995000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.395754

mls_id__c,423911539

master_property__c,a0O1I000001VhhvUAC

monthly_parking_fees__c,412

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-22

original_price__c,1995000

overall_days_on_market__c,-81713

parking_access__c,Independent

parking_features__c,Valet

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTgEiUAK

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

size__c,2170

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Mission

subdist__c,Yerba Buena

ffd_name,301 Mission Street #33C, San Francisco, CA, 94105

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2009

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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

ffd_listing_title,246 2nd Street #1701, San Francisco, CA, 94105

ffd_mls_id,423911368

ffd_salesforce_id,a0E8W00000dTPUIUA4

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,70

address2__c,246 2nd Street #1701, San Francisco, CA, 94105

pba__address_pb__c,246 2nd Street #1701, San Francisco, CA, 94105

agent_only_remarks__c,Penthouse residence is two units combined with two APN's and two property tax bills. Buyer to verify. Escrow is open with Mijael Schmidt at First American Title Co. Offers as they come. Two car parking and two large storage units come with the home.

appliances__c,Disposal;Hood Over Range;Electric Cook Top;Wine Refrigerator

architectural_style__c,Contemporary

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,2000

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Andrew J Warren

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-21T20:47:03.000+0000

days_on_market__c,1

dom__c,1

ffd_description_pb,This three-bedroom, three bathroom combined penthouse residence is set in the energetic Yerba Buena neighborhood and is just steps from Salesforce Park, Oracle Park (Home of the San Francisco Giants), several technology headquarters (LinkedIn, CNET, Salesforce) and within blocks of some of The City's most famous attractions, shopping areas and restaurants. The top floor penthouse residence is set on the north side of the building with two large terraces (one off the main living area and the second off the primary suite) and offers stunning views of the San Francisco skyline while boasting over 2,900 SQFT of living space with tremendous light on three sides of the home. The building has two, high speed elevators, a spacious lobby for welcoming guests. The penthouse residence is complete with two parking spaces and two large, deeded storage areas. Residence 1701 at 246 2nd Street is an incredible home in one of San Francisco's most vibrant areas.

district__c,SF District 9

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,1682

pba__hoafrequency_pb__c,Monthly

hoa_name__c,246 2nd Street Homeowners Association

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry;Wet Bar

ffd_lastmodifieddate,2023-09-23T01:47:32.000+0000

pba__latitude_pb__c,37.785714

pba__latitude_property__c,37.785714

laundry_features__c,Inside Room;Washer Included;Dryer Included;Cabinets

listed_date__c,2023-09-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Frank

pba__listing_agent_lastname__c,Nolan

listing_agent_mls_id__c,803037

ffd_listingagentname,Frank A Nolan

listing_agent_number__c,803037

listing_co_agent_mls_id__c,807776

listing_co_agent_number__c,1025907

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

pba__listingtype__c,Sale

pba__listing_website__c,http://2ndStreetPenthouse.com

pba__longitude_pb__c,-122.397471

mls_id__c,423911368

master_bathroom_features__c,Double Sinks;Sitting Area;Walk-In Closet 2+;Outside Access

master_property__c,a0O1I000001VhmaUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,2

on_market_date__c,2023-09-21

open_house_end__c,2023-09-23T17:00:00.000+0000

open_house_start__c,2023-09-23T15:00:00.000+0000

original_price__c,2995000

overall_days_on_market__c,-81712

parking_access__c,Independent

parking_features__c,Enclosed,Garage Door Opener,Interior Access

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dTPUIUA4

room_type__c,Laundry;Kitchen;Dining Room;Family Room;Primary Bedroom;Primary Bedroom 2+

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;Fire Suppression System;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,2905

size__c,2905

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,2nd

subdist__c,Yerba Buena

ffd_name,246 2nd Street #1701, San Francisco, CA, 94105

view__c,City;City Lights;Downtown;San Francisco

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Window Screens

pba__yearbuilt_pb__c,2000

pba__postalcode_pb__c,94105

ffd_media,Array

ffd_media_tags,Array

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