Skip main navigation
Sold for $1,220,000 on 07/01/25
  • $1,220,000

    174 Warren Ave, Quincy, MA 02170

    5beds
    4,797sqft
    Single Family Residence
    Built in 1870
    0.39 Acres Lot
    $1,220,300 Zestimate®
    $254/sqft
    $5,479 Estimated rent

    What's special

    A True Masterpiece! Nestled in the heart of Quincy, this extraordinary Colonial blends timeless charm with unparalleled space and amenities! Boasting nearly 5,000 sqft of living space, this one-of-a-kind 21 Rooms/5 Beds/4.5 Baths residence offers an exceptional layout perfect for both grand entertaining and comfortable living. First floor houses classic architectural details and flows beautifully into generous living areas, kitchen, dining, office, laundry rooms and half bath. Upstairs features 4 beds and 3 baths including primary bath. Finished attic and basement with kitchen and full bath, offering endless potential for au-pair or guest suite. Outside, your personal retreat awaits! Sited on an expansive lot (17,010 sqft), 2 car garage and in-ground pool with a pool house (a shower & changing rooms), even a private basketball court, rare find in any neighborhood. This home is truly a rare gem!

    Zillow last checked: 7 hours ago

    Listing updated: July 01, 2025 at 10:21am

    Listed by:

    Matt Tasgin,

    United Brokers

    Bought with:

    Alan Nguyen

    Choose Boston, LLC

    Source: MLS PIN,MLS#: 73379071

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    • Main level bathrooms: 1
    Primary bedroom
    • Features: Bathroom - Full, Closet, Flooring - Hardwood
    • Level: Second
    • Area: 221.37
    • Dimensions: 14.1 x 15.7
    Bedroom 2
    • Features: Closet, Flooring - Hardwood
    • Level: Second
    • Area: 228
    • Dimensions: 15 x 15.2
    Bedroom 3
    • Features: Closet, Flooring - Hardwood
    • Level: Second
    • Area: 198.44
    • Dimensions: 16.4 x 12.1
    Bedroom 4
    • Features: Closet, Flooring - Hardwood
    • Level: Second
    • Area: 119.21
    • Dimensions: 9.1 x 13.1
    Bedroom 5
    • Features: Cedar Closet(s), Closet, Flooring - Laminate
    • Level: Third
    • Area: 243.84
    • Dimensions: 19.2 x 12.7
    Primary bathroom
    • Features: Yes
    Bathroom 1
    • Features: Bathroom - Half, Flooring - Laminate
    • Level: Main,First
    • Area: 44.25
    • Dimensions: 5.9 x 7.5
    Bathroom 2
    • Features: Bathroom - Full, Bathroom - Tiled With Shower Stall, Bathroom - With Tub, Flooring - Laminate, Enclosed Shower - Fiberglass
    • Level: Second
    • Area: 49.41
    • Dimensions: 8.1 x 6.1
    Bathroom 3
    • Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile
    • Level: Second
    • Area: 102.7
    • Dimensions: 7.9 x 13
    Dining room
    • Features: Flooring - Hardwood
    • Level: Main,First
    • Area: 253.8
    • Dimensions: 14.1 x 18
    Family room
    • Features: Closet
    • Level: Basement
    • Area: 461.97
    • Dimensions: 26.1 x 17.7
    Kitchen
    • Features: Bathroom - Half, Beamed Ceilings, Flooring - Laminate, Window(s) - Picture, Pantry, Breakfast Bar / Nook, Deck - Exterior, Exterior Access
    • Level: Main,First
    • Area: 225.72
    • Dimensions: 17.1 x 13.2
    Living room
    • Features: Ceiling Fan(s), Flooring - Hardwood, Exterior Access
    • Level: Main,First
    • Area: 223.5
    • Dimensions: 15 x 14.9
    Office
    • Features: Flooring - Hardwood
    • Level: Main
    • Area: 232.88
    • Dimensions: 16.4 x 14.2
    Heating
    • Baseboard, Hot Water, Steam, Oil
    Cooling
    • Wall Unit(s)
    Appliances
    • Laundry: Flooring - Laminate, Gas Dryer Hookup, Washer Hookup, First Floor, Electric Dryer Hookup
    Features
    • Bathroom - Full, Bathroom - Tiled With Tub, Bathroom - 3/4, Bathroom - With Shower Stall, Dining Area, Pantry, Breakfast Bar / Nook, Walk-In Closet(s), Bathroom, Kitchen, Office, Sun Room, Entry Hall, Laundry Chute
    • Flooring: Tile, Laminate, Hardwood, Flooring - Hardwood, Flooring - Vinyl
    • Basement: Full,Finished,Interior Entry,Slab
    • Number of fireplaces: 2
    • Fireplace features: Dining Room, Living Room
    Interior area
    • Total structure area: 4,797
    • Total interior livable area: 4,797 sqft
    • Finished area above ground: 3,606
    • Finished area below ground: 1,191

    Property

    Parking
    • Total spaces: 2
    • Parking features: Detached, Storage, Garage Faces Side, Off Street, Driveway, Paved
    • Garage spaces: 2
    • Has uncovered spaces: Yes
    Features
    • Patio & porch: Porch, Porch - Enclosed, Deck, Deck - Wood
    • Exterior features: Porch, Porch - Enclosed, Deck, Deck - Wood, Pool - Inground, Rain Gutters, Hot Tub/Spa, Storage, Professional Landscaping, Fenced Yard, Outdoor Shower
    • Has private pool: Yes
    • Pool features: In Ground
    • Has spa: Yes
    • Spa features: Private
    • Fencing: Fenced
    • Waterfront features: Ocean, 1 to 2 Mile To Beach, Beach Ownership(Public)
    Lot
    • Size: 0.39 Acres
    • Features: Corner Lot, Level
    Details
    • Parcel number: M:5183 B:12 L:1,189785
    • Zoning: RESA

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    • Property subtype: Single Family Residence
    Materials
    • Frame
    • Foundation: Stone
    • Roof: Shingle
    Condition
    • Year built: 1870

    Utilities & green energy

    • Electric: 200+ Amp Service, Generator Connection
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: for Gas Range, for Gas Oven, for Electric Dryer, Washer Hookup, Icemaker Connection, Generator Connection

    Community & neighborhood

    Community
    • Community features: Public Transportation, Shopping, Park, Walk/Jog Trails, Medical Facility, Laundromat, Highway Access, House of Worship, Public School, T-Station
    Location
    • Region: Quincy
    Services availability
    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $1,220,300

    Get a cash offer in 3 minutes

    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.

    Estimated market value

    $1,220,300