_yoast_indexnow_last_ping,1696389048

ffd_listing_title,401 Crescent Court #4101, San Francisco, CA, 94134

ffd_mls_id,423760326

ffd_salesforce_id,a0E8W00000coQKfUAM

num_of_fireplaces__c,0

num_of_rooms__c,3

of_units__c,550

address2__c,401 Crescent Court #4101, San Francisco, CA, 94134

pba__address_pb__c,401 Crescent Court #4101, San Francisco, CA, 94134

agent_only_remarks__c,Presale escrow WFG National Title Insurance Company - Connie Choy. Showing by APT only contact Samantha at 415-640-7602. Renovated home, disclosures available upon request. Seller reserves the right to counter, reject and accept any offers. Back on market, buyer had issues with their loan.

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

bath_features__c,Double Sinks

pba__fullbathrooms_pb__c,1

pba__bedrooms_pb__c,1

year_build_text__c,2007

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

cooling__c,None

ffd_createddate,2023-08-03T00:48:31.000+0000

days_on_market__c,62

dom__c,46

ffd_description_pb,Luxurious, rarely available corner unit condo featuring high ceilings with extra large patio! Tastefully renovated home with modern wood flooring, upgraded kitchen with waterfall island, quartz countertops and stainless steel appliances. Designer upgrades in bathrooms with quartz countertops and contemporary hardware. Spacious bedroom with two large closets. Washer/dryer in-unit. Deeded 1 car parking. Convenient location, close to Highway 101 and the Caltrain Station providing easy access to SF Downtown, Airport & the Peninsula. Free shuttle to BART Station. Gated community with 247 security. HOAAmenities include: Gym, guest parking, BBQ area and free commuter shuttle service.

district__c,SF District 10

driveway_sidewalks__c,Gated

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Wood

pba__hoafees__c,529

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Candlestick Point

hoa__c,Yes

pba__halfbathrooms_pb__c,0

has_3d_tour__c,1

pba__heatingtype_pb__c,Electric;Wall Furnace

ffd_lastmodifieddate,2023-10-04T02:46:44.000+0000

pba__latitude_pb__c,37.7111133

pba__latitude_property__c,37.7111133

laundry_features__c,Laundry Closet;Washer Included;Dryer Included;Stacked Only

listed_date__c,2023-08-02

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Samantha

pba__listing_agent_lastname__c,Huang

listing_agent_mls_id__c,809630

ffd_listingagentname,Samantha J Huang

listing_agent_number__c,1042187

listing_co_agent_number__c,0

listing_co_office_number__c,0

listing_office_mls_id__c,CIP01

listing_office_name__c,Corcoran Icon Properties

listing_office_number__c,28939

pba__listingprice_pb__c,588888

pba__listingtype__c,Sale

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

pba__longitude_pb__c,-122.3883061

mls_id__c,423760326

master_bathroom_features__c,Tub w/Shower Over

master_property__c,a0O1I000001VhnJUAS

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-08-02

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

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

original_price__c,598888

overall_days_on_market__c,-81662

parking_access__c,Independent

parking_features__c,Attached,Garage Facing Side

parking_type__c,On Site - Mapped (Condo Only)

patio_and_porch_features__c,Uncovered Patio

pba__pendingdate__c,1800-01-01

possible_bedrooms__c,0

pba__pricechangedat__c,2023-10-03T13:16:18.000+0000

price_per_square_foot__c,706.1

price_reduced__c,1

pba__propertytype__c,Condominium

ListingId,a0E8W00000coQKfUAM

room_type__c,Kitchen;Living 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,834

size__c,834

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Crescent

subdist__c,Candlestick Point

ffd_name,401 Crescent Court #4101, San Francisco, CA, 94134

website_property_type__c,Condominium

pba__yearbuilt_pb__c,2007

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530655506_e3da7e30-7cf5-465a-96de-7828a1a25bcd.jpg

ffd_listing_title,501 Crescent Way #5406, San Francisco, CA, 94134

ffd_mls_id,423900220

ffd_salesforce_id,a0E8W00000dSEOsUAO

num_of_fireplaces__c,0

num_of_rooms__c,4

of_units__c,176

address2__c,501 Crescent Way #5406, San Francisco, CA, 94134

pba__address_pb__c,501 Crescent Way #5406, San Francisco, CA, 94134

agent_only_remarks__c,Pre-escrow with ORTC, Karen Tam. Seller asks to stay there if it is possible. Please contact Kent at 415-933-7432 or [email protected] for any showings and questions.

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

bath_features__c,Tub w/Shower Over;Double Sinks

pba__fullbathrooms_pb__c,2

pba__bedrooms_pb__c,2

year_build_text__c,2006

pba__city_pb__c,San Francisco

pba__contingentdate__c,1800-01-01

ffd_createddate,2023-09-08T15:46:43.000+0000

days_on_market__c,20

dom__c,20

ffd_description_pb,Discover this remarkable top-floor 2 bed 2 bath corner unit, thoughtfully designed for exceptional privacy with bedrooms at opposite ends. Abundant natural light flows through the private balcony and expansive dual-paned windows, offering picturesque views of the surrounding landscape and bay throughout the unit. The master bedroom includes a spacious closet and an ensuite bathroom with a double vanity. Recent updates include new flooring, plush carpets, fresh interior paint, and refinished cabinetry. Other highlights include an in-unit washer/dryer, ample storage, and one designated parking space. Located within a quiet 24-hour gated community, this condo ensures residents' security and tranquility. Enjoy the added convenience of an on-site gym, elevator access, a communal outdoor BBQ area, proximity to major highway access points and a complimentary shuttle service to Bart and Caltrain stations.

district__c,SF District 10

entry_level__c,0

external_listing__c,1

pba__floortype_pb__c,Carpet;Vinyl

pba__hoafees__c,670

pba__hoafrequency_pb__c,Monthly

hoa_name__c,Candlestick Point The Cove

hoa__c,Yes

pba__halfbathrooms_pb__c,0

pba__heatingtype_pb__c,Central

ffd_lastmodifieddate,2023-09-28T11:46:24.000+0000

pba__latitude_pb__c,37.711839

pba__latitude_property__c,37.711839

laundry_features__c,Washer/Dryer Stacked Included

listed_date__c,2023-07-06

pba__listing_agent_email__c,[email protected]

pba__listing_agent_firstname__c,Kent

pba__listing_agent_lastname__c,Chen

listing_agent_mls_id__c,808521

ffd_listingagentname,Kent Chen

listing_agent_number__c,1036299

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

pba__listingtype__c,Sale

pba__longitude_pb__c,-122.388404

mls_id__c,423900220

master_property__c,a0O1I000001Vhj1UAC

monthly_parking_fees__c,0

monthlyrent__c,0

parkingspaces__c,1

on_market_date__c,2023-09-08

open_house_end__c,2023-10-01T15:00:00.000+0000

open_house_start__c,2023-10-01T13:00:00.000+0000

original_price__c,799000

overall_days_on_market__c,-81699

parking_access__c,Side by Side

parking_features__c,Garage Door Opener

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

pba__propertytype__c,Condominium

ListingId,a0E8W00000dSEOsUAO

room_type__c,Kitchen;Living Room

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

size__c,1156

pba__state_pb__c,CA

stories__c,0

pba__street_pb__c,Crescent

subdist__c,Candlestick Point

ffd_name,501 Crescent Way #5406, San Francisco, CA, 94134

view__c,Bay;Hills;Mountains

website_property_type__c,Condominium

window_features__c,Dual Pane Full

pba__yearbuilt_pb__c,2006

pba__postalcode_pb__c,94134

ffd_media,Array

ffd_media_tags,Array

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