{"id":25769,"date":"2026-04-15T08:00:00","date_gmt":"2026-04-15T15:00:00","guid":{"rendered":"https:\/\/thegoods-sf.com\/ricroc-marketupdate\/?p=25769"},"modified":"2026-04-15T08:00:00","modified_gmt":"2026-04-15T15:00:00","slug":"256-waterville-street","status":"publish","type":"listing","link":"https:\/\/thegoods-sf.com\/ricroc-marketupdate\/listing\/256-waterville-street\/","title":{"rendered":"256 Waterville Street"},"content":{"rendered":"<p>Introducing a rare, one-of-a-kind asset designed for discerning buyers seeking scale, flexibility, and exceptional upside. This expansive ~3,500 sq ft residence sits on an impressive 7,500 sq ft lot and features 6 en-suite bedrooms, delivering a level of privacy and functionality rarely found in the market. The property is further enhanced by a 3-bedroom, 1-bath in-law unit (unwarranted), creating a compelling opportunity for strong supplemental income or multi-generational living.From its generous footprint to its highly versatile layout, this property stands out as a premier investment and lifestyle acquisition.Key Highlights:6 en-suite bedrooms (rare configuration) Additional 3BD\/1BA in-law unit (unwarranted).Expansive 7,500 sq ft lot 2-car garage + parking for additional vehicles Significant income-producing and value-add potential    Opportunities of this caliber, size, and flexibility are seldom available.<\/p>\n","protected":false},"featured_media":0,"template":"","class_list":["post-25769","listing","type-listing","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/thegoods-sf.com\/ricroc-marketupdate\/wp-json\/wp\/v2\/listing\/25769","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thegoods-sf.com\/ricroc-marketupdate\/wp-json\/wp\/v2\/listing"}],"about":[{"href":"https:\/\/thegoods-sf.com\/ricroc-marketupdate\/wp-json\/wp\/v2\/types\/listing"}],"wp:attachment":[{"href":"https:\/\/thegoods-sf.com\/ricroc-marketupdate\/wp-json\/wp\/v2\/media?parent=25769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}