meta_query='key:subdist__c;value:Inner Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='328398' 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] => 2018-10-30 00:24:04
[post_modified_gmt] => 2018-10-30 00:24:04
[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, 1223 18th Avenue, San Francisco, CA, 94122
ffd_mls_id, 422712465
ffd_salesforce_id, a0E8W00000a83sGUAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 1223 18th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1223 18th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Disclosure package available. Family owned for over 60 years, great bones. This home was lived in prior to coming on the market - someone will want to add a little (or perhaps a lot) work. End user or developer - ADU possibility(tradesman entrance) or units (refer to SB 9). See floor plans in attached Docs.
appliances__c, Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional;Arts & Crafts
bath_features__c, Tub w/Shower Over;Split Bath;Tile
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 4
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-26T11:48:36.000+0000
days_on_market__c, 56
dom__c, 7
ffd_description_pb, This handsome three story, 4 bedroom, 4 half-bath home is one block from Golden Gate Park and all the delights of iconic City living. Quality built, this home features weighty architectural details such as hardwood floors, a box beam ceiling and hefty moldings. The spacious floor plan is bathed in western light with outlooks to a verdant landscaped garden. The home's classic architectural heritage provides the perfect backdrop to create your dream home. Features include a large galley kitchen with a large pantry and sunlit breakfast room. A gracious living room with fireplace and formal dining room. Upstairs are 4 bedrooms and 2 generous half baths with space to add more. Downstairs flex space for a playroom, or office. One car garage. Explore nearby locations such as the Botanical Garden, Japanese Tea Garden and walking and biking trails in Golden Gate Park. Great restaurants and bakeries nearby, include Arizmendi Bakery, San Francisco's Hometown Creamery, Ebisu, Sam Tung and Tartine. Located close to public transportation. Jefferson Elementary, Woodside International School and St. Anne Elementary School.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 3
pba__heatingtype_pb__c, Central;Natural Gas
interior_features__c, Formal Entry;Storage Area(s)
ffd_lastmodifieddate, 2023-03-23T10:48:31.000+0000
pba__latitude_pb__c, 37.7649855
pba__latitude_property__c, 37.7649855
laundry_features__c, Laundry Closet;Inside Area
listed_date__c, 2022-09-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gael
pba__listing_agent_lastname__c, Bruno
listing_agent_mls_id__c, 803912
ffd_listingagentname, Gael C Bruno
listing_agent_number__c, 166013274
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 1595000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4763702
lower_level__c, Family Room,Partial Bath(s)
mls_id__c, 422712465
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-01-26
original_price__c, 1595000
overall_days_on_market__c, -81474
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only);On Site - Assigned (Condo Only)
pba__pendingdate__c, 2023-02-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-03-22T20:18:16.000+0000
price_per_square_foot__c, 610.24
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000a83sGUAQ
road_surface_type__c, Asphalt
room_type__c, Storage;Office;Bonus Room;Sun Room;Laundry;Kitchen;Living Room;Dining Room;Primary Bedroom
sale_date__c, 2023-03-08
sale_price__c, 1550000
selling_agent_mls_id__c, EB98098
selling_agent_number__c, 981304383
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Keller Williams Benchmark
pba__status__c, Closed
pba__totalarea_pb__c, 2540
size__c, 2540
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 18th
subdist__c, Inner Sunset
ffd_name, 1223 18th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530562953-1.jpg