meta_query='key:subdist__c;value:Inner Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210300' 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, 1539 17th Avenue, San Francisco, CA, 94122
ffd_mls_id, 495740
ffd_salesforce_id, a0E1I00000RuFAxUAN
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 1539 17th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1539 17th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Sorry 2 preemptive offers received, and seller decided to move forward with it. Pre-sale escrow opened w/ Fidelity National Title @ 1900 Noriega St. For disclosures or questions, please contact listing agents Jason Chan via email: [email protected] or via text/cell: 415.215.1661 or Julie Chan via email: [email protected] or via text/cell: 415.672.7988. Please use San Francisco purchase agreement. Seller reserves right to accept, counter, & reject any offer. Thank you!
appliances__c, Dishwasher;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Built-In Oven
architectural_style__c, Marina
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1930
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-03-03T18:45:50.000+0000
days_on_market__c, 1233
dom__c, 1
ffd_description_pb, Newly renovated designer home featuring panoramic sweeping ocean views! This beautifully remodeled home offers open floor plan, 3 master suites with views, state of art finishes including custom-built cabinets, 8 feet doors, Marvin windows, Venetian plaster walls, brand new gas fireplace, Paperstone counter tops, and more! Top floor offer two master suites in the back with gorgeous ocean views, additional half bath, open kitchen to dining & living room. Lower level adds a 3rd master suite, additional 4th bedroom, family room, full bath, laundry room, one car parking in the garage, one car parking on the driveway, separate side entry, spacious deck perfect for entertaining, and large yard. Located just 1.5 blocks to MUNI lines, 2 short blocks to 19th Ave buses, and a few blocks to Golden Gate Park, Irving Street shops & restaurants.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:28:55.000+0000
pba__latitude_pb__c, 37.75914
pba__latitude_property__c, 37.75914
laundry_features__c, Inside Room;Hookups Only
listed_date__c, 2020-03-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jason
pba__listing_agent_lastname__c, Chan
listing_agent_mls_id__c, 802554
ffd_listingagentname, Jason C Chan
listing_agent_number__c, 802554
listing_co_agent_mls_id__c, 807828
listing_co_agent_number__c, 1027382
listing_co_office_mls_id__c, BARB
listing_co_office_name__c, BarbCo
listing_co_office_number__c, 670
listing_office_mls_id__c, BARB
listing_office_name__c, BarbCo
listing_office_number__c, 670
pba__listingprice_pb__c, 1895000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.474998
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 495740
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-03-03
original_price__c, 1895000
overall_days_on_market__c, 89
parking__c, Attached,Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-03-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1000
pba__propertytype__c, Single Family Residence
id, a0E1I00000RuFAxUAN
room_type__c, Laundry
sale_date__c, 2020-04-02
sale_price__c, 2558000
selling_agent_mls_id__c, 802851
selling_agent_name__c, Mollie W. Poe
selling_agent_number__c, 802851
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, 2558
size__c, 2558
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 17th
subdist__c, Inner Sunset
ffd_name, 1539 17th Avenue, San Francisco, CA, 94122
transportation__c, 2 Blocks
view__c, Ocean;Panoramic
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1930
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/361037-1.jpg
ListingId, a0E1I00000RuFAxUAN