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!
Sold for $1,220,000
Street View
$1,220,000
174 Warren Ave, Quincy, MA 02170
5beds
4,797sqft
Single Family Residence
Built in 1870
0.39 Acres Lot
$1,254,400 Zestimate®
$254/sqft
$5,122 Estimated rent
Home value
$1,254,400
$1.15M - $1.35M
$5,122/mo
Zestimate® history
Owner options
List your home for rent
$5,122/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,122/mo
Rent Zestimate®
Refinance and save
$6,195/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,195/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Pool houseClassic architectural detailsTimeless charmIn-ground poolExceptional layoutGuest suiteUnparalleled space
Zillow last checked:
Listing updated:
Listed by:
Matt Tasgin 857-361-8584,
United Brokers 781-629-2258
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
- Included: Water Heater, Range, Dishwasher, Microwave, Refrigerator, Washer, Dryer, Plumbed For Ice Maker
- 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: 4
- Parking features: Detached, Storage, Garage Faces Side, Off Street, Driveway, Paved
- Garage spaces: 2
- Uncovered spaces: 2
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
Price history
| Date | Event | Price |
|---|---|---|
| 7/1/2025 | Sold | $1,220,000+10.9%$254/sqft |
Source: MLS PIN #73379071 Report a problem | ||
| 5/27/2025 | Contingent | $1,099,986$229/sqft |
Source: MLS PIN #73379071 Report a problem | ||
| 5/22/2025 | Listed for sale | $1,099,986+35.8%$229/sqft |
Source: MLS PIN #73379071 Report a problem | ||
| 3/18/2025 | Sold | $810,000$169/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $13,688 +3.5% | $1,187,200 +1.2% |
| 2024 | $13,223 +7.6% | $1,173,300 +6.3% |
| 2023 | $12,288 +5.2% | $1,104,000 +13.2% |
| 2022 | $11,681 +1.1% | $975,000 +2.4% |
| 2021 | $11,557 -1.1% | $952,000 +1.3% |
| 2020 | $11,682 +4.4% | $939,800 +5.4% |
| 2019 | $11,188 +3.7% | $891,500 +10.3% |
| 2018 | $10,784 -1.5% | $808,400 +4.6% |
| 2017 | $10,951 +7.6% | $772,800 +9.1% |
| 2016 | $10,175 +7.2% | $708,600 +8.9% |
| 2015 | $9,496 +4.5% | $650,400 +6.4% |
| 2014 | $9,085 +7% | $611,400 +4.4% |
| 2013 | $8,488 +0.5% | $585,400 -4.7% |
| 2012 | $8,444 +4% | $614,100 +1.5% |
| 2011 | $8,118 -0.3% | $604,900 -1.8% |
| 2010 | $8,140 +4.5% | $615,700 -0.4% |
| 2009 | $7,791 +20.8% | $618,300 +3.8% |
| 2008 | $6,451 -7.6% | $595,700 -10.9% |
| 2007 | $6,980 +3.1% | $668,600 +2% |
| 2006 | $6,770 +1% | $655,400 +6% |
| 2005 | $6,701 | $618,200 |
Find assessor info on the county website
Neighborhood: 02170
Nearby schools
GreatSchools rating
- 9/10Wollaston SchoolGrades: K-5Distance: 0.3 mi
- 8/10Central Middle SchoolGrades: 6-8Distance: 0.4 mi
- 8/10North Quincy High SchoolGrades: 9-12Distance: 1.3 mi
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,254,400
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,254,400
- Massachusetts
- Norfolk County
- Quincy
- 02170
- 174 Warren Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Quincy Topics
