meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218439' 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-08-27 14:39:07
[post_modified_gmt] => 2024-08-27 21:39:07
[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, 109 Seal Cove Terrace, San Francisco, CA, 94134
ffd_mls_id, 421537320
ffd_salesforce_id, a0E1I00000USMeEUAX
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 150
address2__c, 109 Seal Cove Terrace, San Francisco, CA, 94134
pba__address_pb__c, 109 Seal Cove Terrace, San Francisco, CA, 94134
agent_only_remarks__c, Offer Date: Wednesday, May 12 @ 10:00 am. Please, no preemptives. View virtual media at www.109SealCove.com or in MLS links. Covid compliant showings available by Calendly appointment, https://calendly.com/embracesanfrancisco/sealcove. Please do NOT email PEAD earlier than 24 hrs before your appointment. PEAD-V & PPE required for all showings. Disclosure Package available via Disclosures io. Click on 'Request Disclosures.io' box above or through this link, https://app.disclosures.io/link/109-Seal-Cove-Terrace-r102sqn9. Pre-escrow opened with Chicago Title, Barbara Jimenez #3652100375. Seller reserves the right to accept, reject, and counter any and all offers. Questions - call/text Kelly Quon @ 415-244-1798, [email protected].
appliances__c, Dishwasher;Gas Water Heater;Microwave;Disposal;Free Standing Refrigerator;Self/Cont Clean Oven;Gas Cook Top
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Quartz
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 2013
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sabrina Gee-Shin
pba__contingentdate__c, 2021-05-12
ffd_createddate, 2021-04-30T10:48:04.000+0000
days_on_market__c, 810
dom__c, 13
ffd_description_pb, Gorgeous, spacious, move-in ready townhouse is situated in one of the sunniest neighborhoods in the City. This modern home offers a generous 1968 sq. feet of living space, thoughtfully designed with 4 bedrooms and 3 full bathrooms. The main floor features a beautiful open living/dining/kitchen layout, 2 bedrooms (each with a walk-in closet!), a full bath and a laundry room. The top floor has an office space/loft, a primary bedroom with en suite bathroom and two walk-in closets, while the first floor has a spacious bedroom and full bath. This townhouse lives like a single family home. Situated in a quiet, neighborly community, Candlestick Cove is a wonderful balance between urban living and suburban tranquility. Rarely on the market, this size townhouse is perfect for anyone who desires more space and is a great alternative to a single family home. Quick access to 101 N/S and just minutes away from downtown and easy convenience to the Peninsula.
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 on Structure,Maintenance Exterior,Maintenance Grounds,Management,Water
pba__hoafees__c, 456
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Candlestick Cove Homeowners' Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, MultiZone
ffd_lastmodifieddate, 2022-01-25T15:50:23.000+0000
pba__latitude_pb__c, 37.7118256
pba__latitude_property__c, 37.7118256
laundry_features__c, Inside Room;Upper Floor;Washer Included;Dryer Included;Cabinets
listed_date__c, 2021-03-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Kelly
pba__listing_agent_lastname__c, Quon Lutz
listing_agent_mls_id__c, 810315
ffd_listingagentname, Kelly Quon Lutz
listing_agent_number__c, 1045621
listing_co_agent_mls_id__c, 804986
listing_co_agent_number__c, 166014733
listing_co_office_mls_id__c, CGL06
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28275
listing_office_mls_id__c, CGL06
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28275
pba__listingprice_pb__c, 958000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Co3qn5wTyPu
pba__longitude_pb__c, -122.3945964
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 421537320
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Quartz;Double Sinks;Window
master_property__c, a0O1I00000CchQ8UAJ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-04-30
original_price__c, 958000
overall_days_on_market__c, 147
parking_access__c, Side by Side
parking_features__c, Attached,Enclosed,Garage Door Opener,Interior Access,Private,Side-by-Side
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2021-05-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 558.94
pba__propertytype__c, Condominium
id, a0E1I00000USMeEUAX
room_type__c, Laundry;Den;Kitchen;Living Room;Master Bathroom;Dining Room;Master Bedroom;Possible Guest
sale_date__c, 2021-06-11
sale_price__c, 1100000
security_features__c, Smoke Detector;Fire Alarm;Security Fence;Carbon Mon Detector
selling_agent_mls_id__c, 813600
selling_agent_number__c, 1062442
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, 1968
size__c, 1968
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Seal Cove
subdist__c, Candlestick Point
ffd_name, 109 Seal Cove Terrace, San Francisco, CA, 94134
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Screens;Storm Windows
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/530223838-1.jpg
ListingId, a0E1I00000USMeEUAX