meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='217144' 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 #5309, San Francisco, CA, 94134
ffd_mls_id, 421519891
ffd_salesforce_id, a0E1I00000Tvv3TUAR
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 40
address2__c, 501 Crescent Way #5309, San Francisco, CA, 94134
pba__address_pb__c, 501 Crescent Way #5309, San Francisco, CA, 94134
appliances__c, Microwave;Disposal;Hood Over Range;Built-In Gas Range;Built-In Gas Oven;ENERGY STAR Qualified Appliances;Wine Refrigerator;Built-In Refrigerator;Gas Plumbed
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2006
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Christian Elbeck
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-02-16T01:39:40.000+0000
days_on_market__c, 884
dom__c, 12
ffd_description_pb, Perched above the picturesque backdrop of unencumbered San Francisco Bay views, is a magnificent, newly remodeled 3 Bedroom, 2 Bath luxury condominium, safely tucked away, behind a 24 Hour Security Attended Gated Community, at 501 Crescent Way, San Francisco. This newly reimagined and remodeled 3 Bedroom property, high above the San Francisco bay evokes a feeling of light, openness, as water views from each primary room in the home dominate the timelessly elegant ambiance. New sun-washed hardwood-wood flooring, custom recessed lighting, all new luxury baths, a no-expense-spared complete kitchen remodel, custom-built closets and super-high-capacity washer/dryer stack are only some of the ultra-desirable attributes of this unparalleled 3 Bedroom home. A private patio off of the dining room, is a mesmerizing location from which to take coffee or tea. A complete, on-site gym is downstairs from the property, an expansive, manicured courtyard, in addition to meandering walking paths.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 675
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Electric
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2022-01-25T15:44:58.000+0000
pba__latitude_pb__c, 37.7118768
pba__latitude_property__c, 37.7118768
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-02-15
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, John
pba__listing_agent_lastname__c, Murphy
listing_agent_mls_id__c, 814555
ffd_listingagentname, Jack Murphy
listing_agent_number__c, 1067076
listing_co_agent_mls_id__c, 815055
listing_co_agent_number__c, 1070419
listing_co_office_mls_id__c, COMP12PUI
listing_co_office_name__c, Compass
listing_co_office_number__c, 27690
listing_office_mls_id__c, COMP12PUI
listing_office_name__c, Compass
listing_office_number__c, 27690
pba__listingprice_pb__c, 974000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=CfH5zL2FaqQ
pba__longitude_pb__c, -122.3886217
mls_id__c, 421519891
master_property__c, a0O1I000001Vhj1UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-02-15
original_price__c, 974000
overall_days_on_market__c, 89
parking_features__c, Covered,Garage Door Opener,Guest Parking Available,Mechanical Lift,Private
pba__pendingdate__c, 2021-02-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 683.99
pba__propertytype__c, Condominium
id, a0E1I00000Tvv3TUAR
room_type__c, Master Bathroom;Dining Room;Family Room;Master Bedroom
sale_date__c, 2021-04-13
sale_price__c, 974000
selling_agent_mls_id__c, 666666
selling_agent_number__c, 666666
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, ReMax Gold
pba__status__c, Closed
pba__totalarea_pb__c, 1424
size__c, 1424
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Crescent
subdist__c, Candlestick Point
ffd_name, 501 Crescent Way #5309, San Francisco, CA, 94134
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/530183411-1.jpg
ListingId, a0E1I00000Tvv3TUAR