meta_query='key:subdist__c;value:Inner Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='219865' 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-11-09 20:42:22
[post_modified_gmt] => 2024-11-10 04:42:22
[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, 1735 8th Avenue, San Francisco, CA, 94122
ffd_mls_id, 421570857
ffd_salesforce_id, a0E1I00000UUpbdUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1735 8th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1735 8th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Please contact the listing agents Stephanie Okabe Mates at 415-570-9176 [email protected] directly with any questions. UPDATE:Supra Lockbox to be installed after 1st Open House (7/10). Offers, if any, due on 7/14 @ 2 pm. No preemptive offers please. (Keep front gate open until you are done showing property--gate locks automatically. If you accidentally close the gate, you can either buzz yourself out with gate button inside front door or use the key to let yourself out.) Disclosures are available via GLIDE: [copy/paste] https://app.glide.com/share/1iq8fKoIuMq4lFVfB0geGZ/
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Electric Range
architectural_style__c, Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1919
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kelvin Kam
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2021-07-08T10:53:07.000+0000
days_on_market__c, 1273
dom__c, 7
ffd_description_pb, Situated in the highly desirable Inner Sunset district bordering lush Windsor Terrace and Golden Gate Heights while also being just blocks from Golden Gate Park, this 3 bedroom, 1 bathroom getaway is a splendor-filled retreat steeped in charm. Beyond the exquisite location is a uniquely splendid offering waiting to be enjoyed, complete with an array of thoughtful design details and custom finishes including hardwood floors throughout, classic wood paneling, stylish light fixtures, chandeliers, and more. For culinary experiences, a kitchen with an eat-in area sets the stage while a formal dining room affords ample space for hosting meals with friends and family. For calm and relaxation, a cozy living room comes complemented with a fireplace while 3 spacious bedrooms on the upper floor are the ideal place for rest and repose. As an added bonus, there is extra space in the basement that presents a multitude of possibilities, and a large backyard invites you to savor the California sun.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Brick
pba__floortype_pb__c, Carpet;Linoleum;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2022-01-25T15:56:47.000+0000
pba__latitude_pb__c, 37.7560004
pba__latitude_property__c, 37.7560004
laundry_features__c, In Garage;Hookups Only
listed_date__c, 2021-06-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Stephanie
pba__listing_agent_lastname__c, Mates
listing_agent_mls_id__c, 810180
ffd_listingagentname, Stephanie O Mates
listing_agent_number__c, 1044980
listing_co_agent_mls_id__c, 806118
listing_co_agent_number__c, 166016307
listing_co_office_mls_id__c, SQRE
listing_co_office_name__c, Sequoia Real Estate
listing_co_office_number__c, 28627
listing_office_mls_id__c, SQRE
listing_office_name__c, Sequoia Real Estate
listing_office_number__c, 28627
pba__listingprice_pb__c, 1695000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=9kMf4pUS2zC
pba__longitude_pb__c, -122.4648875
mls_id__c, 421570857
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-07-07
original_price__c, 1695000
overall_days_on_market__c, 152
parking_access__c, Independent
parking_features__c, Enclosed,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-07-14
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1178.7
pba__propertytype__c, Single Family Residence
id, a0E1I00000UUpbdUAD
room_type__c, Storage;Sun Room;Kitchen;Living Room;Dining Room;Master Bedroom
sale_date__c, 2021-08-05
sale_price__c, 2025000
selling_agent_mls_id__c, 806441
selling_agent_number__c, 166016962
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, 1718
size__c, 1718
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 8th
subdist__c, Inner Sunset
ffd_name, 1735 8th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1919
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530278270-1.jpg
ListingId, a0E1I00000UUpbdUAD
_yoast_indexnow_last_ping, 1735670244