meta_query='key:subdist__c;value:Outer Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='338082' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12157
[post_author] => 4
[post_date] => 2018-10-29 01:19:09
[post_date_gmt] => 2018-10-29 01:19:09
[post_content] => Let’s play a San Francisco word association game. I say, “Outer Sunset.” You say, “Fog.” Right? Yes, it’s foggy -- sometimes -- but it’s also developed a reputation as a beach community with surfers, some excellent local restaurants, and quirky shops.
[post_title] => Outer Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => outer-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2023-06-23 11:43:41
[post_modified_gmt] => 2023-06-23 18:43:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12157
[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, 1351 46th 1353 Avenue, San Francisco, CA, 94122
ffd_mls_id, 423907887
ffd_salesforce_id, a0E8W00000dSDjyUAG
num_of_rooms__c, 8
of_units__c, 2
address2__c, 1351 46th 1353 Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1351 46th 1353 Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Vacant top two units. Protected tenant in lower level rooms, per the tenant estoppel. NOV with the city, building and health code violations, some cleared, some still active, see disclosure package for more details. See Disclosures and inspection for info on lower level rooms, tenants, condition, etc... All potential buyers to be accompanied by listing agent. There is a $600,000-700,000 pest report on this property. This is a cash sale. Please advise clients appropriately This is not a simple fixer. Call Radha for more details. Bring a mask. Offers reveiwsed as they come. Bring an offer! Thank you
appliances__c, Gas Water Heater;Free Standing Gas Oven;Free Standing Refrigerator;Varies By Unit
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 2
year_build_text__c, 1907
pba__city_pb__c, San Francisco
listing_co_agent_name__c, John C Barnette
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-09-08T10:54:05.000+0000
days_on_market__c, 16
dom__c, 16
ffd_description_pb, Major Fixer! Contractor/Developer Special...Bring your hammer. Tons of Potential! Developers & Contractors Dream! Fabulous Outer Sunset location!! Main Building is set on the back of lot. Charming old duplex with lower level in-law rooms. Upper level units are both one bedroom units and there are two rooms in the basement/lower level with tenant. Vacant top two units, lower rooms Subject to tenant rights, see disclosure package for details. Detached Separate garage in front of lot is in significant disrepair. Property has major deferred maintenance and unwarranted modifications. A Notice of Violation has been issued by the city. Shown by appointment only. Lower rooms with 24 hour notice or during scheduled showing times only. Probate sale NOT subject to court confirmation. Super trendy neighborhood attractions: Hook Fish, Outerlands, Damnfine Pizza, Blackbird Bookstore, Sunset Cantina, Palm City, Mollusk Surf Shop, Aqua Surf Shop, Yoga Beach, Damnfine Coffee, Day Moon Bakery, Pitts Pub, General Store, Woods Tavern, Thai Cottage, Tuesday Tattoo, Judalicious and you can Walk to Ocean Beach and Golden Gate Park!! Stroll on the Great Highway on weekends. Close to the N Judah and many bus lines. Fantastic Neighborhood!
district__c, SF District 2
external_listing__c, 1
pba__floortype_pb__c, Carpet;Laminate;Linoleum;Varies by Unit
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2023-09-23T22:49:12.000+0000
pba__latitude_pb__c, 37.761306
pba__latitude_property__c, 37.761306
listed_date__c, 2023-04-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Radha
pba__listing_agent_lastname__c, Tomassetti
listing_agent_mls_id__c, 802065
ffd_listingagentname, Radha Tomassetti
listing_agent_number__c, 802065
listing_co_agent_mls_id__c, 800222
listing_co_agent_number__c, 800222
listing_co_office_mls_id__c, COMP
listing_co_office_name__c, Compass
listing_co_office_number__c, 26293
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 699000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.50632
mls_id__c, 423907887
parkingspaces__c, 2
on_market_date__c, 2023-09-07
open_house_end__c, 2023-09-26T15:00:00.000+0000
open_house_start__c, 2023-09-26T13:00:00.000+0000
original_price__c, 699000
overall_days_on_market__c, -81698
parking_features__c, Covered,Detached,Garage,Off Street,Uncovered
pba__pendingdate__c, 1800-01-01
price_per_square_foot__c, 484.07
pba__propertytype__c, Duplex
ListingId, a0E8W00000dSDjyUAG
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1444
size__c, 1444
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 46th
subdist__c, Outer Sunset
ffd_name, 1351 46th 1353 Avenue, San Francisco, CA, 94122
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1907
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530673242-1.jpg