meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='323621' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70679
[post_author] => 4
[post_date] => 2018-11-30 20:31:16
[post_date_gmt] => 2018-11-30 20:31:16
[post_content] => As south as you can go and still be in San Francisco. Once home to Candlestick Park, now home to office parks and several condominium developments. While the Candlestick Recreation Area may be windswept and solitary today, the future for this neighborhood calls for thousands of homes and a new neighborhood core.
[post_title] => Candlestick Point
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => candlestick-point
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:22:40
[post_modified_gmt] => 2024-04-09 17:22:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70679
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 501 Crescent Way #5410, San Francisco, CA, 94134
ffd_mls_id, 422713237
ffd_salesforce_id, a0E8W00000a7odOUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 176
address2__c, 501 Crescent Way #5410, San Francisco, CA, 94134
pba__address_pb__c, 501 Crescent Way #5410, San Francisco, CA, 94134
agent_only_remarks__c, Exciting future project in the area/transportations: https://www.candlesticksf.com Bank of West is offering a lender credit (to help with closing costs or to buy down the rate) of $10,500 and very familiar with Candlestick Point the Cove - Contact [email protected] |510.599.8499. First Republic Eagle Community Loan Program with closing credit of $4K/no prepayment penalty, discount rate (4.8% 30 year fixed as of January) Easy to Show - Book your tour on Calendly here > https://calendly.com/501crescent5410/tour - Pls follow showing instructions you receive via email and there is a lockbox onsite and let security know at the gate that you are visiting 5410. Call/text Mia 415.728.2596 | [email protected] for combo number & more info. There is a total special assessment of approx $36K per unit which is paid monthly and this amount is priced into the list price of $699K (HOA has decreased by 7% in 2023). Common area construction are expected be completed in a month or so. Offers to be on SFAR 7 page contract. Escrow opened with Mijael Schmidt at First American Title. Pls follow offer instructions on the disclosure.io > https://app.disclosures.io/link/501-Crescent-Way-5410-rk3j48jk
appliances__c, Dishwasher;Microwave;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator;Gas Cook Top
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Granite
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2006
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-02-21
ffd_createddate, 2023-01-20T23:45:57.000+0000
days_on_market__c, 182
dom__c, 54
ffd_description_pb, Spectacular 2BR/2BA condo at Candlestick Point showcasing panoramic Bay views w a private terrace! Expansive living/dining area w access to exclusive balcony - perfect for breakfast, coffee or dining al fresco! The sparkling Gourmet Kitchen feat gas stove, ample granite counter space & refreshed modern cabinets. Primary Bedroom feat Bay views, walk in closet + ensuite bath w new vanity light & playful tiled shower/tub. Desirable layout w generously sized guest BR on opposite side for privacy. Large 2nd Bathroom w new vanity light & upgraded glass shower doors. Enjoy fresh designer paint, W/D in unit & 1 parking. Gated community w secured parking, onsite gym, BBQ area & recreation seating areas w Bay view lookouts. Unparalleled natural setting near Bayview Park + Candlestick Point picnic areas, fishing piers, fitness courses, windsurfing & hiking trails. Weekly farmers markets + free commuter shuttle to Caltrain, BART, Muni. Close to 101 freeway, apprx 10min to SFO & quick drive to Downtown SF/South Bay.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Laminate
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Elevator,Maintenance Exterior,Recreation Facility,Sewer,Trash,Water
pba__hoafees__c, 578
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_monthly_parking_fees__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T18:15:06.000+0000
pba__latitude_pb__c, 37.7118768
pba__latitude_property__c, 37.7118768
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-12-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Miyuki Mia
pba__listing_agent_lastname__c, Takami
listing_agent_mls_id__c, 806485
ffd_listingagentname, Miyuki Mia Takami
listing_agent_number__c, 166017050
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, 699000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.3886217
mls_id__c, 422713237
master_bathroom_features__c, Tub w/Shower Over;Granite
master_property__c, a0O1I000001Vhj1UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-18
original_price__c, 699000
overall_days_on_market__c, -81466
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Garage Door Opener,Guest Parking Available,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-03-15
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 800.46
pba__propertytype__c, Condominium
ListingId, a0E8W00000a7odOUAQ
room_type__c, Kitchen;Living Room;Baths Other;Primary Bathroom;Primary Bedroom
sale_date__c, 2023-03-16
sale_price__c, 698000
security_features__c, Security Gate;Secured Access;Guarded Gate
selling_agent_mls_id__c, MLSL5070449
selling_agent_number__c, 981222300
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Berkshire Hathaway HomeServices DrysdaleProperties
pba__status__c, Closed
pba__totalarea_pb__c, 872
size__c, 872
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Crescent
subdist__c, Candlestick Point
ffd_name, 501 Crescent Way #5410, San Francisco, CA, 94134
view__c, Marina;Bay;Water;San Francisco;Mountains
website_property_type__c, Condominium
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/530568188_70d3b550-35e8-4bbb-b9a9-6c28a977d507.jpg