meta_query='key:subdist__c;value:Candlestick Point|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='211852' 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, 115 Seal Cove Terrace, San Francisco, CA, 94134
ffd_mls_id, 495436
ffd_salesforce_id, a0E1I00000SMArzUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 10
of_units__c, 142
address2__c, 115 Seal Cove Terrace, San Francisco, CA, 94134
pba__address_pb__c, 115 Seal Cove Terrace, San Francisco, CA, 94134
agent_only_remarks__c, Virtual Tour: http://www.115sealcoveter.com | The opportunity is back! BOM. No fault of the seller. Truly a beautiful single-family-home-like home. Rarely available. Disclosure is in io. Please contact Aimee for questions.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range;ENERGY STAR Qualified Appliances
architectural_style__c, Contemporary
bath_features__c, Tub w/Shower Over;Shower Stall(s);Remodeled;Fiberglass
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 2013
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-03-19T02:45:56.000+0000
days_on_market__c, 1224
dom__c, 71
ffd_description_pb, Welcome to this beautiful tri-level townhome in the serene and sunny Candlestick Cove community. This home is perfect for relaxing and enjoying family life. With a feel of a single-family home and an ideal layout, this 7-year-old home boasts four bedrooms, four full baths (including two en-suites), open floor plan, tall ceilings, light filled environment, and contemporary amenities. It is also a unique balance between urban living and suburban tranquility. Quick access to 101 N/S and just minutes away from downtown SF and easy convenience to the Peninsula and the South Bay. Neighborhood shuttle to Balboa BART and Caltrain stations. Spacious two-car side by side garage with interior access and plenty of storage space to complete this just right home. A must see!
district__c, SF District 10
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 3
external_listing__c, 1
pba__floor__c, 3
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_dues__c, 426.26
hoa_fee_includes__c, Management,Maintenance Exterior,Maintenance Grounds,Homeowners Insurance,Water
pba__hoafees__c, 426
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:20:08.000+0000
pba__latitude_pb__c, 37.711877
pba__latitude_property__c, 37.711877
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-02-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Juanjuan
pba__listing_agent_lastname__c, Huang
listing_agent_mls_id__c, 808889
ffd_listingagentname, Aimee J Huang
listing_agent_number__c, 1038314
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 928000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.39431
pba__lotsize_pb__c, 0
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 495436
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000009FoMiUAK
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-03-12
original_price__c, 928000
overall_days_on_market__c, 110
parking_access__c, Side by Side
parking_features__c, Guest Parking Available,Interior Access,Private,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-06-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 553.98
pba__propertytype__c, Townhouse
id, a0E1I00000SMArzUAH
room_type__c, Storage;Laundry
sale_date__c, 2020-07-31
sale_price__c, 975000
selling_agent_mls_id__c, 814605
selling_agent_name__c, Margaret Shen
selling_agent_number__c, 1067505
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, JC Property Investment
pba__status__c, Closed
pba__totalarea_pb__c, 1760
size__c, 1760
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Seal Cove
subdist__c, Candlestick Point
ffd_name, 115 Seal Cove Terrace, San Francisco, CA, 94134
transportation__c, 1 Block
website_property_type__c, Townhouse
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/361384-1.jpg
ListingId, a0E1I00000SMArzUAH