Turn-Key Mixed-Use Investment or Owner-User Opportunity in Prime Gravesend Welcome to 174 Avenue S, a masterfully updated mixed-use property situated in the heart of Gravesend, Brooklyn. Offering the perfect blend of commercial visibility and residential luxury, this property is a rare find for savvy investors or business owners looking to offset their overhead with premium rental income. Recently undergoing an extensive gut renovation? and extension, the building features 3?,907 sqft of versatile interior space?, approximately 1,514 sqft on the ground floor, 1,185 sqft on the second floor, and a cellar level of approx 1,208 sqft, in addition there are two outdoor spaces, a rear yard of about 485 sqft and a roof terrace of 305 sqft. With all major mechanical, electrical, and plumbing systems modernized to contemporary standards, the property stands as a turn-key asset designed for minimal maintenance and long-term efficiency. The street level offers a premier commercial storefront, benefiting from high-visibility foot and vehicle traffic along the Avenue S corridor. Masterfully configured for professional use, the layout includes a sleek reception, an expansive open floor plan, and dual private offices featuring glass partitions. This versatile space is further enhanced by soaring ceilings, ADA-compliant facilities, and modern climate control, ensuring it is ready for immediate retail or professional occupation. With seamless access to a private backyard and a fully integrated cellar - which also enjoys a dedicated street entrance - this level provides exceptional functional flexibility. Perched above the professional suite, the residential levels showcase two masterfully finished units. Each residence is defined by premium craftsmanship, featuring contemporary kitchens equipped with stainless steel appliances, vented hoods, and gas cooking, all harmonizing with polished hardwood floors throughout. The front layout offers an efficiently designed two-bedroom, one-bathroom configuration, while the rear residence serves as a sophisticated retreat, offering a unique one-bedroom, two-bathroom floor plan further elevated by a light-filled skylight and access to a generous private recreation terrace. A standout feature of this property is the generous outdoor space, including a private backyard? and a roof terrace. Additionally, the property offers exclusive roof rights and potential unused FAR (Floor Area Ratio) of 1,?300 sqft unused FAR, providing massive upside for future expansion or customization. SUMMARY Block/Lot 7082/3 R5B / C2-3 /S2 Lot 2,000 SF (20'x100') Building 3,907.61 SF Gross Unused FAR 1,300 SF Gut renovated in 2017 CO for 1 store/commercial unit and 2 residential units First floor 1,514.09 SF / currently office use / ADA bathroom / powder room / back yard Second floor 1,185.19 SF / two dwellings / Front unit 2 beds 1 bath / Rear unit 1 bed 2 baths with roof terrace Full cellar level / one powder room / separate exit to street level 2025/26 annual taxes $13,955 Deliver vacant N Train 0.2 mile / F Train 0.4 mile Conveniently located just blocks from the N train and within close proximity to the F train, and surrounded by the thriving retail and dining corridors of Gravesend, this location offers unparalleled convenience for both commercial tenants and residential occupants. The property will be delivered ?vacant. Don’t miss out on this prime Brooklyn asset. Contact us today to schedule a private tour!