meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238303' 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, 104 Seal Cove Terrace, San Francisco, CA, 94134
ffd_mls_id, 422649907
ffd_salesforce_id, a0E8W00000YYIlxUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 104 Seal Cove Terrace, San Francisco, CA, 94134
pba__address_pb__c, 104 Seal Cove Terrace, San Francisco, CA, 94134
agent_only_remarks__c, Disclosures available upon request. Escrow open with Fidelity National Title- Bethe Battalio escrow # fsfm-0062200746. Buyer to verify square footage.
appliances__c, Dishwasher;Microwave;Disposal;Free Standing Gas Oven;ENERGY STAR Qualified Appliances
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 2013
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Bistra V Bejanski
pba__contingentdate__c, 2022-08-23
cooling__c, Ceiling Fan(s),Central
ffd_createddate, 2022-08-15T20:47:28.000+0000
days_on_market__c, 338
dom__c, 30
ffd_description_pb, Welcome to this 4BD/4BA multi-generational townhome. A least one bedroom on every level perfect for extended family visits or a nice home office. On the entry level you'll find 1 guest bedroom, a full bathroom storage and the 2-Car side by side parking garage. Located on the main level is a spacious living/dining room combo. A gourmet kitchen with stainless steel appliances and laundry area with full size washer and dryer. The second bedroom/home office and full bath. On the top floor is the 3rd guest room with ensuite bedroom and the large primary bedroom and ensuite bathroom. Recent improvements include newly painted interior walls, hardwood floors in living area, kitchen marble counter tops, and AC installation in 2021.This home is located in Candlestick Point, San Francisco. Convenient to beautiful walking trails and freeway access for busy commuters.
district__c, SF District 10
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance,Maintenance Exterior,Management,Sewer,Water
pba__hoafees__c, 461
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-07-13T17:08:27.000+0000
pba__latitude_pb__c, 37.7115928
pba__latitude_property__c, 37.7115928
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2022-04-18
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, William
pba__listing_agent_lastname__c, Freeman
listing_agent_mls_id__c, 807756
ffd_listingagentname, William H Freeman
listing_agent_number__c, 1025442
listing_co_agent_mls_id__c, 810091
listing_co_agent_number__c, 1044671
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP33
listing_office_name__c, Compass
listing_office_number__c, 27897
pba__listingprice_pb__c, 1099000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/738930919
pba__longitude_pb__c, -122.3945839
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 422649907
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-08-15
original_price__c, 1099000
overall_days_on_market__c, -81310
parking_access__c, Independent
parking_features__c, Attached,Garage Facing Rear,Interior Access,Side-by-Side
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2022-09-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 664.05
pba__propertytype__c, Townhouse
ListingId, a0E8W00000YYIlxUAH
sale_date__c, 2022-09-24
sale_price__c, 1099000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 802848
selling_agent_number__c, 802848
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, 1655
size__c, 1655
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Seal Cove
subdist__c, Candlestick Point
ffd_name, 104 Seal Cove Terrace, San Francisco, CA, 94134
view__c, Garden/Greenbelt;Bay
website_property_type__c, Townhouse
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 2013
pba__postalcode_pb__c, 94134
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530439837-1.jpg
_wp_old_slug, 104-seal-cove-terrace-san-francisco-ca-94134-2