meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328698' 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] => 2023-03-09 10:10:48
[post_modified_gmt] => 2023-03-09 18:10:48
[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, 111 Diamond Cove Terrace, San Francisco, CA, 94134
ffd_mls_id, 422711577
ffd_salesforce_id, a0E8W00000bEGNUUA4
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 111 Diamond Cove Terrace, San Francisco, CA, 94134
pba__address_pb__c, 111 Diamond Cove Terrace, San Francisco, CA, 94134
agent_only_remarks__c, Owner Occupied - Please view at dedicated open house times or by appointment with advanced notice. Disclosures are in process, please email requests. Offer Date is Monday, February 27th at 11am. Escrow open with Katerina Rosignuolo at DOMA Title.
appliances__c, Dishwasher;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Modern/High Tech
bath_features__c, Tub
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2010
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-02-27
ffd_createddate, 2023-02-17T18:48:17.000+0000
days_on_market__c, 39
dom__c, 13
ffd_description_pb, Modern three-level home features 3 bedrooms and 4 bathrooms in the desirable Candlestick Cove community. This home is one of a handful of the premier townhomes in the community to include both a backyard and a private front balcony. As a corner unit, it is detached on three sides leading to bright & natural light inside. You will find a combination of charming architectural design, luxurious finishes and a superior floor-plan. The entry level has a generous sized bedroom, full bath and access to a 2-car garage with abundant storage. On the main level is an open living room and wide-plank hardwood floors. A contemporary kitchen has an abundance of cabinets, granite countertops, stainless appliances and a bar seating. Completing this level is a full dining area, half bath and large covered balcony. The top floor has two en-suite bedrooms including a spacious primary suite and a bonus office space. Beautiful landscaping throughout and a community park with playground and an onsite BBQ area. Hiking trails in the back of the community and within Candlestick Recreation Area including picnic areas throughout. Free commuter shuttles to BART, Caltrain, Muni. Easy access to 101 & 280 freeways and minutes to downtown SF, SFO and Peninsula.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Earthquake Insurance,Insurance on Structure,Maintenance Grounds,Management,Water
pba__hoafees__c, 455
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Candlestick Cove
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-03-28T10:48:00.000+0000
pba__latitude_pb__c, 37.713153
pba__latitude_property__c, 37.713153
laundry_features__c, Laundry Closet
listed_date__c, 2022-12-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kevin
pba__listing_agent_lastname__c, Birmingham
listing_agent_mls_id__c, 802374
ffd_listingagentname, Kevin Birmingham
listing_agent_number__c, 802374
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 1038000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.394851
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 422711577
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Double Sinks
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-02-17
original_price__c, 1038000
overall_days_on_market__c, -81496
parking_access__c, Independent
parking_features__c, Garage Door Opener,Guest Parking Available
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-03-02
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-27T20:19:55.000+0000
price_per_square_foot__c, 596.29
pba__propertytype__c, Townhouse
ListingId, a0E8W00000bEGNUUA4
room_type__c, Kitchen;Dining Room;Primary Bathroom
sale_date__c, 2023-03-27
sale_price__c, 1028000
security_features__c, Security System Prewired
selling_agent_mls_id__c, 807882
selling_agent_number__c, 1028110
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1724
size__c, 1724
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Diamond Cove
subdist__c, Candlestick Point
ffd_name, 111 Diamond Cove Terrace, San Francisco, CA, 94134
website_property_type__c, Townhouse
pba__yearbuilt_pb__c, 2010
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530560883-1.jpg