meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='375679' 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
(
)
)
_yoast_indexnow_last_ping, 1714474708
ffd_listing_title, 401 Crescent Court #4101, San Francisco, CA, 94134
ffd_mls_id, 424020231
ffd_salesforce_id, a0EUd000001hCQNMA2
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.
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, 2024-04-10T10:46:43.000+0000
days_on_market__c, 20
dom__c, 20
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
pba__heatingtype_pb__c, Electric;Wall Furnace
ffd_lastmodifieddate, 2024-04-30T10:47:14.000+0000
pba__latitude_pb__c, 37.711125
pba__latitude_property__c, 37.711125
laundry_features__c, Laundry Closet;Washer Included;Dryer Included;Stacked Only
listed_date__c, 2024-04-04
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, 575000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/-cyyKy_E7UY?si=mycZQPS3oxZ3yiRd
pba__longitude_pb__c, -122.388246
mls_id__c, 424020231
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, 2024-04-10
open_house_end__c, 2024-04-30T16:00:00.000+0000
open_house_start__c, 2024-04-30T14:00:00.000+0000
original_price__c, 575000
overall_days_on_market__c, -81914
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, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 689.45
pba__propertytype__c, Condominium
ListingId, a0EUd000001hCQNMA2
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/530756057-1.jpg