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 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
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