{"id":23197,"date":"2025-10-24T08:00:00","date_gmt":"2025-10-24T15:00:00","guid":{"rendered":"https:\/\/thegoods-sf.com\/thefrontsteps\/?p=23197"},"modified":"2025-10-24T08:00:00","modified_gmt":"2025-10-24T15:00:00","slug":"464-hoffman-avenue","status":"publish","type":"listing","link":"https:\/\/thegoods-sf.com\/thefrontsteps\/listing\/464-hoffman-avenue\/","title":{"rendered":"464 Hoffman Avenue"},"content":{"rendered":"<p>This isn&#8217;t a fixer. It&#8217;s a finisher. 464 Hoffman is a fully reimagined Noe Valley home waiting for someone to bring it across the finish line. The home has been extensively transformed with new electrical in 2024, plumbing, and HVAC systems, a reinforced foundation w\/steel beams, all-new siding, and a 2019 roof.The open-concept great room flows to the backyard through afour-panelaccordion door for effortless indoor-outdoor living. The kitchen has custom wood cabinetry, Caesarstone waterfall counters, a Thermador stove, and a Fischer &amp; Paykel fridge. Upstairs, you&#8217;ll find all three bedrooms, including a primary suite w\/ private deck and an upstairs laundry room where it actually belongs. The terraced yard feels like its own little park, anchored by a mature oak tree, complete with a gas line for your grill or firepit and a bonus detached shed. Now, the fine print (because we believe in transparency): the property is missing its final permit and has a few open Notices of Violation and abatements. Bring your architect and\/or contractor to understand the final vision.For the right buyer, it&#8217;s a dream project that&#8217;s part of the way there. And here&#8217;s the kicker: for qualified buyers, ask about a special loan offer!<\/p>\n","protected":false},"featured_media":0,"template":"","class_list":["post-23197","listing","type-listing","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/thegoods-sf.com\/thefrontsteps\/wp-json\/wp\/v2\/listing\/23197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thegoods-sf.com\/thefrontsteps\/wp-json\/wp\/v2\/listing"}],"about":[{"href":"https:\/\/thegoods-sf.com\/thefrontsteps\/wp-json\/wp\/v2\/types\/listing"}],"wp:attachment":[{"href":"https:\/\/thegoods-sf.com\/thefrontsteps\/wp-json\/wp\/v2\/media?parent=23197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}