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,12
dom__c,12
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-20T22:46:29.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-09-24T13:30:00.000+0000
open_house_start__c,2023-09-24T12: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
