meta_query='key:subdist__c;value:Inner Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212498' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12159
[post_author] => 4
[post_date] => 2018-10-30 00:24:04
[post_date_gmt] => 2018-10-30 00:24:04
[post_content] => On the foggy side but not too far. With tongue in cheek, call it Outer Cole Valley if you really can’t stomach life west of Arguello. Classic Edwardians, modern transit, Golden Gate Park adjacent.
[post_title] => Inner Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => inner-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:19:54
[post_modified_gmt] => 2024-03-19 19:19:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12159
[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, 717 Kirkham Street, San Francisco, CA, 94122
ffd_mls_id, 498943
ffd_salesforce_id, a0E1I00000SKanjUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 2
address2__c, 717 Kirkham Street, San Francisco, CA, 94122
pba__address_pb__c, 717 Kirkham Street, San Francisco, CA, 94122
agent_only_remarks__c, Private showing only. To schedule please use CALENDLY link: https://calendly.com/sabina-sf/30-minutes Provide PEAD form prior the showing appointment. Email [email protected] with any questions. Escrow opened with Bethe Battalio Fidelity National Title. Escrow No.: FSFM-0062001032. Offers will be reviewed on Thursday, June 18th @ 2pm. Please download disclosures at the following link: www.sq-re.com/717-kirkham-disclosures
appliances__c, Dishwasher;Gas Range;Disposal;Refrigerator;Hood Over Range;ENERGY STAR Qualified Appliances;Ice Maker;Self/Cont Clean Oven
architectural_style__c, Modern/High Tech
bath_features__c, Tub w/Shower Over;Shower Stall(s);Tub;Tile;Low-Flow Toilet(s);Low-Flow Shower(s)
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 2016
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kelvin Kam
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-06-11T10:47:52.000+0000
days_on_market__c, 1133
dom__c, 8
ffd_description_pb, Set against the breathtaking views of Golden Gate Park, this modern masterpiece is ushering in a one-of-a-kind, sun-soaked dreamscape. This 3 bedroom/3.5 bath condo features hardwood floors, recessed lighting, a security intercom system, CAT-6 wiring, & in-ceiling speakers. Enjoy the chef's kitchen w/ waterfall Caesarstone counters, stainless steel Thermador appliances, & gorgeous pendant lighting. The main floor has a shared bath, secondary suite, & an additional bedroom. A chandelier-studded staircase leads to a breath-taking family room equipped w/ a wet bar, Sub-Zero wine storage and a gas fireplace. A sliding glass wall opens up to a deeded patio w/ stunning views. Beyond the powder room awaits a private master suite w/ a walk-in closet & a sleek, en-suite bath w/ a double vanity, an oversized shower stall, & soaking tub. Steps away from trendy restaurants, transportation, & great schools, this condo offers modern elegance in San Francisco's coveted Inner Sunset District.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Shared Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Starter
pba__floor__c, 0
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 300
pba__hoafees__c, 300
hoa_name__c, 715-717 Kirkham HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-25T15:23:49.000+0000
pba__latitude_pb__c, 37.76006
pba__latitude_property__c, 37.76006
laundry_appliances__c, Washer/Dryer,In Closet
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-05-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Sabina
pba__listing_agent_lastname__c, Alieva
listing_agent_mls_id__c, 811150
ffd_listingagentname, Sabina Alieva
listing_agent_number__c, 1050114
listing_co_agent_mls_id__c, 806118
listing_co_agent_number__c, 166016307
listing_co_office_mls_id__c, SEQUOIA
listing_co_office_name__c, Sequoia Real Estate
listing_co_office_number__c, 28359
listing_office_mls_id__c, SEQUOIA
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28359
pba__listingprice_pb__c, 1898000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/427897739
pba__longitude_pb__c, -122.46855
pba__lotsize_pb__c, 0
mls_id__c, 498943
main_level__c, Full Bath(s);Master Bedroom;Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
master_property__c, a0O1I000001Vi44UAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-06-11
original_price__c, 1898000
overall_days_on_market__c, 61
parking_access__c, Side by Side
parking_features__c, Garage Door Opener,Side-by-Side,Garage
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2020-06-19
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1153.14
pba__propertytype__c, Condominium
id, a0E1I00000SKanjUAD
roof__c, Bitumen
sale_date__c, 2020-07-07
sale_price__c, 2018000
selling_agent_mls_id__c, MLSL5067570
selling_agent_number__c, 981220716
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 1750
size__c, 1750
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Kirkham
subdist__c, Inner Sunset
ffd_name, 717 Kirkham Street, San Francisco, CA, 94122
transportation__c, 1 Block
view__c, Ocean;Panoramic;City Lights;Bay;Water;Downtown;Golden Gate Bridge;Mountains
website_property_type__c, Condominium
window_features__c, Weather Stripped;Caulked/Sealed
pba__yearbuilt_pb__c, 2016
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/363814-1.jpg
ListingId, a0E1I00000SKanjUAD