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

_yoast_indexnow_last_ping,1701951140

ffd_listing_title,946 Stockton Street #17A, San Francisco, CA, 94108

ffd_mls_id,423755565

ffd_salesforce_id,a0E8W00000co0ODUAY

num_of_fireplaces__c,0

num_of_rooms__c,0

of_units__c,72

address2__c,946 Stockton Street #17A, San Francisco, CA, 94108

pba__address_pb__c,946 Stockton Street #17A, San Francisco, CA, 94108

agent_only_remarks__c,Please email [email protected] and CC [email protected] for disclosures. Pre-escrow opened with Nancy Chan at Chicago Title Company. Please contact Janice for offer instructions.

appliances__c,Dishwasher;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Oven;Free Standing Electric Range

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,2

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-07-28T18:47:47.000+0000

days_on_market__c,132

dom__c,113

ffd_description_pb,Water & City views in this newly remodeled stunning 2BD/1.5BA rarely available coveted corner 17th floor end unit condo. One of the larger units in the building, this condo offers a bright newly remodeled open kitchen with new gorgeous stainless steel appliances. The living room & dining area offer spectacular views from the floor to ceiling sliding doors. This home feels brand new with modern flooring, fresh interior paint & new contemporary lighting. Bathrooms feature new vanities, medicine cabinets, lighting, resurfaced tub and tiles. There are only six units on the 17th floor & a laundry in the building. This concrete building is one of the few high rises in Chinatown with a doorman & an elevator. Conveniently located across the street from the new SF Central Subway Station, Mandarin Tower is close to all the shops, grocery stores, dining, transportation, the newly renovated Empress, R&G Lounge, tourist attractions, Downtown SF, North Beach, Chinese Hospital, The Embarcadero & Portsmouth Square. With a Walk Score 100, a 98 Transit score, all the conveniences of modern living can be found in this vibrant neighborhood.

district__c,SF District 8

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Laminate

hoa_fee_includes__c,Common Areas,Door Person,Elevator,Maintenance Exterior,Maintenance Grounds,Management,Roof,Sewer,Trash,Other

pba__hoafees__c,1223

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Hogan and Vest

hoa__c,Yes

pba__halfbathrooms_pb__c,1

has_3d_tour__c,1

ffd_lastmodifieddate,2023-12-07T11:47:26.000+0000

pba__latitude_pb__c,37.794707

pba__latitude_property__c,37.794707

laundry_features__c,Other

listed_date__c,2023-04-20

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Janice

pba__listing_agent_lastname__c,Lee

listing_agent_mls_id__c,805814

ffd_listingagentname,Janice Lee

listing_agent_number__c,166015866

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,COLD02

listing_office_name__c,Coldwell Banker Realty

listing_office_number__c,874

pba__listingprice_pb__c,749000

pba__listingtype__c,Sale

pba__listing_website__c,https://my.matterport.com/show/?m=Q3byYVtynEV

pba__longitude_pb__c,-122.407789

mls_id__c,423755565

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

master_property__c,a0O1I000001VhhzUAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,0

on_market_date__c,2023-07-28

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

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

original_price__c,799000

overall_days_on_market__c,-81657

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000co0ODUAY

sale_date__c,1800-01-01

sale_price__c,0

security_features__c,Smoke Detector;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,775

size__c,775

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Stockton

subdist__c,Financial District - Barbary Coast

ffd_name,946 Stockton Street #17A, San Francisco, CA, 94108

view__c,Ocean;City;Panoramic;Bay;Water;Downtown;Golden Gate Bridge;Bridges

website_property_type__c,Condominium

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94108

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1701778404

ffd_listing_title,570 Bush 580 Street, San Francisco, CA, 94108

ffd_mls_id,423924691

ffd_salesforce_id,a0EUd000000J9FhMAK

num_of_rooms__c,6

of_units__c,5

address2__c,570 Bush 580 Street, San Francisco, CA, 94108

pba__address_pb__c,570 Bush 580 Street, San Francisco, CA, 94108

agent_only_remarks__c,Pictures to follow. Seller is a licensed CA real estate broker. Each unit has its own APN and can be sold separately. Seller started the process but did not trigger it.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,1

year_build_text__c,0

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-11-29T23:48:44.000+0000

days_on_market__c,6

dom__c,6

ffd_description_pb,There are four residential units and one commercial unit: Three 1 BR 1 BA each ranging from 619-719 sq. ft. One 2BR 2 BA Penthouse 1270 sq. ft. One Commercial Unit 1628 sq. ft. There is a three car garage. All units are vacant except the commercial unit.

district__c,SF District 8

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2023-12-05T11:48:34.000+0000

pba__latitude_pb__c,37.790619

pba__latitude_property__c,37.790619

listed_date__c,2023-11-29

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Armand

pba__listing_agent_lastname__c,Der-Hacobian

listing_agent_mls_id__c,807976

ffd_listingagentname,Armand Der-Hacobian

listing_agent_number__c,1029359

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,STHB4

listing_office_name__c,Sotheby's International Realty

listing_office_number__c,28397

pba__listingprice_pb__c,5500000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.406727

mls_id__c,423924691

parkingspaces__c,3

on_market_date__c,2023-11-29

original_price__c,5500000

overall_days_on_market__c,-81781

parking_features__c,Covered,Garage,Interior Access

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,0

pba__propertytype__c,Other

ListingId,a0EUd000000J9FhMAK

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Bush

subdist__c,Financial District - Barbary Coast

ffd_name,570 Bush 580 Street, San Francisco, CA, 94108

website_property_type__c,Other

pba__yearbuilt_pb__c,0

pba__postalcode_pb__c,94108

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1701832410

ffd_listing_title,1238 Stockton 1242 Street, San Francisco, CA, 94133

ffd_mls_id,423923943

ffd_salesforce_id,a0EUd000000EeFKMA0

num_of_rooms__c,12

of_units__c,3

address2__c,1238 Stockton 1242 Street, San Francisco, CA, 94133

pba__address_pb__c,1238 Stockton 1242 Street, San Francisco, CA, 94133

agent_only_remarks__c,Please contact Yiyi Zhong at [email protected] or Ning Ho at [email protected] for Marketing Package. All offers are due by noon on Friday, 12/8/2023.

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,8

year_build_text__c,1911

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-11-22T20:47:54.000+0000

days_on_market__c,13

dom__c,13

ffd_description_pb,1238-1242 Stockton St is a great three-story mixed-use building located on the main retail street in San Francisco Chinatown. Stockton Street is the neighborhood's main shopping and business street which offers many grocery stores, vegetable markets, popular restaurants, and retail stores. It is close to Portsmouth Square, Hilton Hotel, and City College. It is also within walking distance to Financial District, Union Square, and Downtown. Public transit is very convenient. 1238-1242 Stockton St is a 4,199 square-foot building located on a 1,507 square feet lot (Tax Record). This building consists of one commercial space with a full basement and two residential flats on the upper floors. The subject property's APN is 0161-024 and Zoning is Chinatown Residential Neighborhood Commercial (CRNC). The seismic retrofit has been completed. The subject property presents a great investment opportunity for professional investors or owner users to acquire a Commercial building in the classic Chinatown of San Francisco. All offers are due by noon on Friday, 12/8/2023.

district__c,SF District 8

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2023-12-06T02:47:49.000+0000

pba__latitude_pb__c,37.797293

pba__latitude_property__c,37.797293

listed_date__c,2023-11-22

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Ning

pba__listing_agent_lastname__c,Ho

listing_agent_mls_id__c,810266

ffd_listingagentname,Ning H Ho

listing_agent_number__c,1045343

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,M&ML

listing_office_name__c,Marcus & Millichap

listing_office_number__c,1464

pba__listingprice_pb__c,1500000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.408322

mls_id__c,423923943

parkingspaces__c,0

on_market_date__c,2023-11-22

original_price__c,1500000

overall_days_on_market__c,-81774

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,357.23

pba__propertytype__c,Other

ListingId,a0EUd000000EeFKMA0

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

size__c,4199

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Stockton

subdist__c,Financial District - Barbary Coast

ffd_name,1238 Stockton 1242 Street, San Francisco, CA, 94133

website_property_type__c,Other

pba__yearbuilt_pb__c,1911

pba__postalcode_pb__c,94133

ffd_media,Array

ffd_media_tags,Array

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

_yoast_indexnow_last_ping,1700921549

ffd_listing_title,550 Grant 552 Avenue, San Francisco, CA, 94108

ffd_mls_id,423923490

ffd_salesforce_id,a0EUd000000BxrBMAS

num_of_rooms__c,7

of_units__c,3

address2__c,550 Grant 552 Avenue, San Francisco, CA, 94108

pba__address_pb__c,550 Grant 552 Avenue, San Francisco, CA, 94108

pba__fullbathrooms_pb__c,0

pba__bedrooms_pb__c,2

year_build_text__c,1921

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-11-18T01:48:25.000+0000

days_on_market__c,8

dom__c,8

ffd_description_pb,One of the best mixed-use investment in the City for investor or owner-user! Located in the prime spot at SF Chinatown, the property has a huge retail store front at Grant Ave with many foot traffic like locals and tourists from all over the world. The store has a Mezzanine floor, a waterbar, a huge basement with an office and a restroom. The second floor has a 2 bedrooms/1 bathroom unit, and the third floor has a 3 bedrooms/1.5 bath unit. Both units have been updated, and the back are facing to the park. Seismic retrofit completed in 2002.

district__c,SF District 8

external_listing__c,1

pba__hoafees__c,0

hoa__c,No

pba__halfbathrooms_pb__c,0

ffd_lastmodifieddate,2023-11-25T13:47:14.000+0000

pba__latitude_pb__c,37.792116

pba__latitude_property__c,37.792116

listed_date__c,2023-11-17

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Kam Tong

pba__listing_agent_lastname__c,Chak

listing_agent_mls_id__c,813287

ffd_listingagentname,Gavin Chak

listing_agent_number__c,1060648

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,EXPRE

listing_office_name__c,eXp Realty of California, Inc

listing_office_number__c,26334

pba__listingprice_pb__c,1900000

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.405704

mls_id__c,423923490

parkingspaces__c,0

on_market_date__c,2023-11-17

original_price__c,1900000

overall_days_on_market__c,-81769

pba__pendingdate__c,1800-01-01

price_per_square_foot__c,0

pba__propertytype__c,Triplex

ListingId,a0EUd000000BxrBMAS

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

size__c,0

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Grant

subdist__c,Financial District - Barbary Coast

ffd_name,550 Grant 552 Avenue, San Francisco, CA, 94108

view__c,San Francisco

website_property_type__c,Triplex

pba__yearbuilt_pb__c,1921

pba__postalcode_pb__c,94108

ffd_media,Array

ffd_media_tags,Array

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