690 Market Street #2204, San Francisco, CA, 94104 - Property Description

_yoast_indexnow_last_ping,1721991365

ffd_listing_title,333 Bush Street #3804, San Francisco, CA, 94104

ffd_mls_id,424038872

ffd_salesforce_id,a0EUd000002Jl5JMAS

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,45

address2__c,333 Bush Street #3804, San Francisco, CA, 94104

pba__address_pb__c,333 Bush Street #3804, San Francisco, CA, 94104

agent_only_remarks__c,Please use current 8 page SFAR purchase agreement. Please submit offers on current 8 page SFAR contract and include proof of funds, lender approval and signed disclosures. Pre-escrow,#3552400324, has been opened with Michael Yip at Chicago Title.Escrow is open with Michael Yip/Chicago Title.

appliances__c,Dishwasher;Microwave;Disposal;Free Standing Refrigerator;Ice Maker;Free Standing Electric Range

bath_features__c,Tub w/Shower Over;Tile

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,1987

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-06-14T21:50:33.000+0000

days_on_market__c,42

dom__c,42

ffd_description_pb,Residence 3804 sits high up in the 333 Bush Tower and offers spectacular panoramic vistas from all rooms. Located on the 38th floor, this spacious, approx. 1510 sq.ft., corner residence features extra large floor to ceiling windows that frame architecturally fascinating views of San Francisco. Enjoy panoramic vistas of San Francisco Bay, city lights and a peek at the Bay Bridge. The kitchen and baths have been tastefully remodeled with high end finishes. The home's open concept living and dining area combination is perfect for entertaining. The extra large primary bedroom suite features a large walk-in closet and ensuite bath. The ensuite bath features a soaking tub. The second bedroom features wood flooring and two large windows with city and bay views. The 45 exclusive homes at the top of the tower enjoy their own residential atrium entrance and an elegant, secure lobby with a full time 24/7 doorstaff. Just steps from the residence is a large dedicated storage room. This prestigious full-service building includes residential valet parking and guest parking. The residents have access to a fitness center. Enjoy urban Manhattan style living in this premier downtown location just steps from fine dining, entertainment, the theater district and shopping. Live it Up in San Francisco!

district__c,SF District 8

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Wood;Stone

hoa_fee_includes__c,Cable TV,Door Person,Internet,Maintenance Grounds,Management,Sewer,Trash,Water

pba__hoafees__c,1740

pba__hoafrequency_pb__c,Monthly

hoa_name__c,333 Bush HOA

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_monthly_parking_fees__c,1

pba__heatingtype_pb__c,Electric

ffd_lastmodifieddate,2024-07-26T10:48:05.000+0000

pba__latitude_pb__c,37.7905919

pba__latitude_property__c,37.7905919

laundry_features__c,Laundry Closet;Washer/Dryer Stacked Included

listed_date__c,2024-06-04

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Robyn

pba__listing_agent_lastname__c,Kaufman

listing_agent_mls_id__c,804796

ffd_listingagentname,Robyn Kaufman

listing_agent_number__c,166014477

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,VIVRE

listing_office_name__c,Vivre Real Estate

listing_office_number__c,28694

pba__listingprice_pb__c,1399000

pba__listingtype__c,Sale

pba__listing_website__c,https://drive.google.com/file/d/1xZ9Pl2sCDBi4daJTQsyTon324nW3vPsg/view

pba__longitude_pb__c,-122.4030568

mls_id__c,424038872

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

master_bathroom_features__c,Tub w/Shower Over;Tile

master_property__c,a0O8W00000DagtdUAB

monthly_parking_fees__c,350

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-06-14

open_house_end__c,2024-07-28T16:00:00.000+0000

open_house_start__c,2024-07-28T14:00:00.000+0000

original_price__c,1399000

overall_days_on_market__c,-81979

parking_access__c,Independent

parking_features__c,Valet

parking_type__c,On Site ' Monthly Fee (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,926.49

pba__propertytype__c,Condominium

ListingId,a0EUd000002Jl5JMAS

room_type__c,Storage;Kitchen;Baths Other;Great Room;Primary Bathroom;Primary Bedroom 2+

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

size__c,1510

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Bush

subdist__c,Financial District - Barbary Coast

ffd_name,333 Bush Street #3804, San Francisco, CA, 94104

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

website_property_type__c,Condominium

pba__yearbuilt_pb__c,1987

pba__postalcode_pb__c,94104

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1717423049

ffd_listing_title,690 Market Street #1902, San Francisco, CA, 94104

ffd_mls_id,424033022

ffd_salesforce_id,a0EUd000002CCnRMAW

num_of_fireplaces__c,0

num_of_rooms__c,5

of_units__c,75

address2__c,690 Market Street #1902, San Francisco, CA, 94104

pba__address_pb__c,690 Market Street #1902, San Francisco, CA, 94104

agent_only_remarks__c,Some Photos are copied from the previous listing. Seller is the listing broker. Prepared SIX MONTHS HOA fee by seller prior to close of escrow. HOA covers insurance, reserves, water, central heat and air conditioning, recology, valet parking,, use of conference room, two levels of gym, 4 days week wine tasting and use of social room....

appliances__c,Dishwasher;Microwave;Disposal;Built-In Gas Range;Built-In Gas Oven;Wine Refrigerator;Double Oven;Self/Cont Clean Oven;Built-In Refrigerator;Built-In Freezer;Gas Plumbed

architectural_style__c,Contemporary;Traditional

bath_features__c,Tub w/Shower Over;Marble;Sunken Tub

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2007

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,Central

ffd_createddate,2024-06-03T10:46:54.000+0000

days_on_market__c,0

dom__c,0

ffd_description_pb,Introducing an exquisite addition to the illustrious Ritz Carlton Residence, this opulent condo resides majestically on the 19th floor, boasting breathtaking vistas of downtown city lights and the tranquil bay. Featuring 2 lavish bedroom en-suites and 2.5 meticulously crafted bathrooms, this abode, freshly erected in 2007, offers an unparalleled living experience. Step into a grand marble foyer, where luminosity and expansiveness greet you warmly. The living and dining areas showcase gleaming hardwood floors and panoramic views of Union Square from every angle. Delight in culinary creations within the kitchen, adorned with top-tier Viking appliances, luxurious wood cabinetry, and a sumptuous granite breakfast bar. In unit laundry room with stacked washer and dryer add to the convenience. An array of amenities awaits, including a vigilant 24-hour doorman, attentive parking valet, dedicated concierge, state-of-the-art fitness center, inviting resident's lounge, and a serene patio terrace. Immerse yourself in the finer aspects of life with complimentary wine tastings four times a week and access to a conference room for professional endeavors. Ideally situated with a coveted 99.9 walking score, revel in the convenience of proximity to all the wonders the Bay Area has to offer.

district__c,SF District 8

driveway_sidewalks__c,Gated,Shared Driveway

electric__c,220 Volts

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Wood

pba__hoafees__c,9837

pba__hoafrequency_pb__c,Quarterly

hoa__c,Yes

pba__halfbathrooms_pb__c,1

pba__heatingtype_pb__c,Central

interior_features__c,Formal Entry

ffd_lastmodifieddate,2024-06-03T13:46:29.000+0000

pba__latitude_pb__c,37.788239

pba__latitude_property__c,37.788239

laundry_features__c,Washer/Dryer Stacked Included;Washer Included;Dryer Included

listed_date__c,2024-05-13

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Karen

pba__listing_agent_lastname__c,Lum

listing_agent_mls_id__c,802104

ffd_listingagentname,Karen F Lum

listing_agent_number__c,802104

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,FCSR

listing_office_name__c,Focus Realty

listing_office_number__c,1058

pba__listingprice_pb__c,1238000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.403189

mls_id__c,424033022

master_bathroom_features__c,Shower Stall(s);Double Sinks;Low-Flow Shower(s);Sunken Tub

master_property__c,a0O1I000001VhiKUAS

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-06-03

original_price__c,1238000

overall_days_on_market__c,-81968

parking_access__c,Independent

parking_features__c,EV Charging,Garage Door Opener,Unassigned

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

pba__propertytype__c,Condominium

ListingId,a0EUd000002CCnRMAW

room_type__c,Kitchen;Great Room

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;Fire Alarm;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,1192

size__c,1192

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Market

subdist__c,Financial District - Barbary Coast

ffd_name,690 Market Street #1902, San Francisco, CA, 94104

view__c,City;Bay;Water;Downtown

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Weather Stripped

pba__yearbuilt_pb__c,2007

pba__postalcode_pb__c,94104

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1720573092

ffd_listing_title,935 Kearny Street, San Francisco, CA, 94133

ffd_mls_id,424035098

ffd_salesforce_id,a0EUd0000025VDKMA2

num_of_rooms__c,153

of_units__c,153

address2__c,935 Kearny Street, San Francisco, CA, 94133

pba__address_pb__c,935 Kearny Street, San Francisco, CA, 94133

appliances__c,Microwave

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,0

year_build_text__c,1907

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2024-05-21T18:46:50.000+0000

days_on_market__c,49

dom__c,49

ffd_description_pb,935 Kearny Street is a four-story, mixed-use, corner apartment building located in the Financial District on Columbus Avenue. This property is conveniently located for any commuter working Downtown, the Embarcadero, or in SOMA. The building is steps from a wonderful assortment of restaurants, nightlife, and shopping in North Beach, Chinatown, and Nob Hill. For Sale: 935 Kearny Street offers investors an opportunity to acquire a high-yield income on a well-maintained building in Downtown, San Francisco. Residential Master Lease: A Master Lease that provides over 50% income upside potential. 935 Kearny is in a superb core location and is an excellent rental area for Downtown commuters. Call for a private showing today!

district__c,SF District 8

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2024-07-10T00:49:07.000+0000

pba__latitude_pb__c,37.796683

pba__latitude_property__c,37.796683

listed_date__c,2024-05-21

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Brad

pba__listing_agent_lastname__c,Lagomarsino

listing_agent_mls_id__c,981149

ffd_listingagentname,Brad Lagomarsino

listing_agent_number__c,981149

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CINT

listing_office_name__c,Colliers International

listing_office_number__c,24225

pba__listingprice_pb__c,19000000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.405538

mls_id__c,424035098

parkingspaces__c,0

on_market_date__c,2024-05-21

original_price__c,20000000

overall_days_on_market__c,-81955

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,517.71

price_reduced__c,1

pba__propertytype__c,5 or More Unit

ListingId,a0EUd0000025VDKMA2

roof__c,Bitumen

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

size__c,36700

pba__state_pb__c,CA

stories__c,4

pba__street_pb__c,Kearny

subdist__c,Financial District - Barbary Coast

ffd_name,935 Kearny Street, San Francisco, CA, 94133

view__c,Downtown

website_property_type__c,5 or More Unit

pba__yearbuilt_pb__c,1907

pba__postalcode_pb__c,94133

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1721955971

ffd_listing_title,170 Pacific Avenue #21, San Francisco, CA, 94111

ffd_mls_id,424033619

ffd_salesforce_id,a0EUd00000242N3MAI

num_of_fireplaces__c,1

num_of_rooms__c,0

of_units__c,53

address2__c,170 Pacific Avenue #21, San Francisco, CA, 94111

pba__address_pb__c,170 Pacific Avenue #21, San Francisco, CA, 94111

agent_only_remarks__c,For showings please call Judy Karam 415.279.1515 Seller says SELL. Reduced by $350K No other Golden Gateway Condo has this floorplan, plus the fresh modern design. Ideal for creatives who love natural light. This is a stunning loft style remodeled unit at Golden Gateway. Has not been lived in. Safe and secure. www.170PacificSF.com

appliances__c,Dishwasher;Microwave;Disposal;Electric Cook Top;Free Standing Refrigerator;Compactor;Free Standing Electric Oven

architectural_style__c,Contemporary

bath_features__c,Tub w/Shower Over;Shower Stall(s);Double Sinks;Skylight/Solar Tube;Window

pba__fullbathrooms_pb__c,3

pba__bedrooms_pb__c,3

year_build_text__c,1986

pba__city_pb__c,San Francisco

listing_co_agent_name__c,Judy H Karam

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2024-05-18T01:48:00.000+0000

days_on_market__c,69

dom__c,69

ffd_description_pb,NEW PRICE Reduced by $350k. One-of-a-kind Loft Style condo -Manicured garden setting * Top floor condo *skylights * remodeled * floating staircase * art gallery walls * all en suite bedrms *2 private decks *gas fireplace *laundry in unit * secure bldg. * guest parking * walk score 99 Nestled within the urban tapestry lies a hidden gem a tranquil townhome retreat surrounded by impeccably manicured gardens. This exquisite, modern condo is a well-kept secret for city dwellers seeking calm refuge amidst the bustle. An extraordinarily inviting condominium has a skylight paneled ceiling, art gallery walls, a stunning floating staircase. The dramatic skylit living room features a gas fireplace + opens to a private deck, spacious dining rm, remodeled kitchen w/state-of-the-art appliances, Caesar stone countertops + custom cabinetry. An adjacent office, enclosed by glass doors, doubles as an ensuite bedrm. All rooms have city & garden views. The upper level highlights two en suite bedrms + a serene deck. Two full baths complete this level. This location offers a wealth of leisure and lifestyle amenities. Golden Gateway provides full-time maintenance and janitorial services, ensuring a seamless living experience. A wonderful place to call home

district__c,SF District 8

entry_level__c,0

exterior_features__c,Balcony

external_listing__c,1

fireplace_features__c,Living Room;Gas Piped

pba__floortype_pb__c,Wood

hoa_fee_includes__c,Common Areas,Elevator,Insurance,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Management,Security

pba__hoafees__c,1701

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Golden Gateway Commons III

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Central;Fireplace(s)

interior_features__c,Skylight(s);Cathedral Ceiling

ffd_lastmodifieddate,2024-07-26T00:48:00.000+0000

pba__latitude_pb__c,37.7983418

pba__latitude_property__c,37.7983418

laundry_features__c,Inside Room;Laundry Closet;Washer Included;Dryer Included;Sink

listed_date__c,2024-05-15

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Debbie

pba__listing_agent_lastname__c,Hemingway

listing_agent_mls_id__c,355987

ffd_listingagentname,Debbie Hemingway

listing_agent_number__c,355987

listing_co_agent_mls_id__c,800221

listing_co_agent_number__c,800221

listing_co_office_mls_id__c,STHB4

listing_co_office_name__c,Sotheby's International Realty

listing_co_office_number__c,28397

listing_office_mls_id__c,STHB

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,2050

pba__listingprice_pb__c,2249000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=Qz3upSCkm3e&mls=1

pba__longitude_pb__c,-122.3992918

mls_id__c,424033619

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

master_bathroom_features__c,Tub w/Shower Over;Low-Flow Toilet(s);Double Sinks;Soaking Tub;Window;Skylight/Solar Tube

master_property__c,a0O1I000001VhosUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2024-05-17

open_house_end__c,2024-07-27T16:00:00.000+0000

open_house_start__c,2024-07-27T14:00:00.000+0000

original_price__c,2600000

overall_days_on_market__c,-81951

parking_access__c,Independent

parking_features__c,Covered,Enclosed,Garage Door Opener,Guest Parking Available,Interior Access,Private,Size Limited

parking_type__c,On Site - Mapped (Condo Only)

patio_and_porch_features__c,Uncovered Deck

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

pba__propertytype__c,Condominium

ListingId,a0EUd00000242N3MAI

room_type__c,Laundry;Kitchen;Living Room;Dining Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+

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

size__c,1993

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Pacific

subdist__c,Financial District - Barbary Coast

ffd_name,170 Pacific Avenue #21, San Francisco, CA, 94111

view__c,City;City Lights;Garden/Greenbelt;Downtown;San Francisco

website_property_type__c,Condominium

window_features__c,Dual Pane Full;Window Screens

pba__yearbuilt_pb__c,1986

pba__postalcode_pb__c,94111

ffd_media,Array

ffd_media_tags,Array

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

_wp_old_slug,170-pacific-21-avenue-san-francisco-ca-94111