174 Ave S, Brooklyn, NY 11223

$1,495,000
3
BD
6
BA
3,907
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Property Description

All Showings and Open Houses Are By Appointment Only. Please Email to Schedule.Turn-Key Mixed-Use Investment or Owner-User Opportunity in Prime GravesendWelcome 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 deepened cellar level of approx 1,208 sqft, in addition there are two outdoor spaces - a rear yard and a roof terrace. 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 recreation terraced. Additionally, the property offers exclusive roof rights and potential unused FAR (Floor Area Ratio) of 1300 sqft unused FAR, providing massive upside for future expansion or customization.SUMMARYBlock/Lot 7082/3R5B / C2-3 /S2Lot 2,000 SF (20’x100')Building 3,907.61 SF GrossUnused FAR 1,300 SF Gut renovated in 2017(Plumbing, Electrical, Hvac, Roof, Floor joist were all upgraded and basement was deepened to increase ceiling height)CO for 1 commercial unit and 2 residential unitsFirst floor 1,514.09 SF / currently office use / ADA bathroom / powder room / back yardSecond floor 1,185.19 SF / two dwellings / Front unit 2 beds 1 bath / Rear unit 1 bed 2 baths with roof terraceFull cellar level / one powder room / separate exit to street level2026/27 annual taxes $14,602Deliver vacantN Train 0.2 mile / F Train 0.4 mileConveniently 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!

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Listing courtesy of Listing Agent: Ka I Chan (galachan@modernspacesnyc.com) from Listing Office: Modern Spaces.

IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This information is not verified for authenticity or accuracy and is not guaranteed and may not reflect all real estate activity in the market. ©2026 The Real Estate Board of New York, Inc. All rights reserved.