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!

More Info

Basic Information

Bedrooms5
Mls StatusUnder Agreement
Bathroom5
Contingency Pending P&S
Lot Features Corner Lot, Level
Parcel Number M:5183 B:12 L:1,189785

Location

Address174 Warren Avenue
Building Number174
CountyNorfolk
StateMA
StreetWarren Avenue
TownQuincy
Zip02170

Building

BasementFull, Finished, Interior Entry, Slab
Building Area Units Square Feet
Construction Materials Frame
FireplaceYes
Fireplace Features Dining Room, Living Room
Fireplaces Total 2
FoundationStone
Garage Spaces2
Patio And Porch Features Porch, Porch - Enclosed, Deck, Deck - Wood
Property StyleColonial
Rooms21
Utilities
- For Electric Dryer
- For Gas Oven
- For Gas Range
- Generator Connection
- Icemaker Connection
- Washer Hookup
Year Built1870
Year Built Details Approximate
Year Built Source Public Records

Water Body

Miles to Beach2
Waterfront Features Beach Front, Ocean,1 to 2 Mile To Beach, Beach Ownership(Public)

Other

Buyer Agency Compensation2
Date Listed05/22/2025
Farm Land Area Units Square Feet
Spa Features Private
Transaction Broker Compensation1

Tax Information

Tax Assessed Value $1,187,200
Tax Year 2025
Taxes$13,688

Rooms

Bathroom 1 Main, First,5.9 x 7.5
Bathroom 2 Second,8.1 x 6.1
Bathroom 3 Second,7.9 x 13
Bathrooms Total Decimal 4.5
Bedroom 2 Second,15 x 15.2
Bedroom 3 Second,16.4 x 12.1
Bedroom 4 Second,9.1 x 13.1
Bedroom 5 Third,19.2 x 12.7
Dining Room Main, First,14.1 x 18
Family Room Basement,26.1 x 17.7
Full Bath4
Half Baths1
Kitchen Main, First,17.1 x 13.2
Living Room Main, First,15 x 14.9
Main Level Bathrooms 1
Master Bedroom Second,14.1
Office Main,16.4 x 14.2

Exterior

Exterior Features
- Deck
- Deck - Wood
- Fenced Yard
- Hot Tub/Spa
- Outdoor Shower
- Pool - Inground
- Porch
- Porch - Enclosed
- Professional Landscaping
- Rain Gutters
- Storage
Fencing Fenced
RoofShingle

Property Information

Square Feet4,797
Building Area Source Other
Living Area 4,797
Lot Size Square Feet 17,010
Lot Size Units Acres
Spa YN Yes

Legal

ZoningRESA

Parking

Parking Spaces2
Covered Spaces 2
Garage YN Yes
Open Parking YN Yes
Parking Features
- Detached
- Driveway
- Garage Faces Side
- Off Street
- Paved
- Storage

Basic Information

List Price$1,099,986
MLS Number73379071
Modification Date06/02/2025
Property SubTypeSingle Family Residence
PurchaseContractDate05/26/2025
Virtual TourView Tour

Property

Acreage0.39

Interior

Flooring Tile, Laminate, Hardwood, Flooring - Hardwood, Flooring - Vinyl
Interior Features
- Bathroom
- Bathroom - 3/4
- Bathroom - Full
- Bathroom - Tiled With Tub
- Bathroom - With Shower Stall
- Breakfast Bar / Nook
- Dining Area
- Entry Hall
- Kitchen
- Laundry Chute
- Office
- Pantry
- Sun Room
- Walk-In Closet(s)

Utilities

Cooling Wall Unit(s)
Cooling YN Yes
Electric 200+ Amp Service, Generator Connection
Heat SystemYes
Heating Baseboard, Hot Water, Steam, Oil
Sewer Public Sewer
Water Source Public

Amenities

Amenities
- Highway Access
- House of Worship
- Laundromat
- Medical Facility
- Park
- Public School
- Public Transportation
- Shopping
- T-Station
- Walk/Jog Trails
Appliances IncludedWater Heater, Range, Dishwasher, Microwave, Refrigerator, Washer, Dryer, Plumbed For Ice Maker
Pool Features In Ground
Pool Private YN Yes

The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. (MLSPIN) from third party sources, including sellers, lessors and public records, and were compiled by MLSPIN. The property listing data and information, and the Images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLSPIN and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the Images, set forth herein.

Name

Your Email Address

Phone

Message Send me the deed for 174 Warren Avenue Quincy MA 02170 (ID#:73379071)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Name

Your Email Address

Phone

Message Send me the survey or tax map for 174 Warren Avenue Quincy MA 02170 (ID#:73379071)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Name

Your Email Address

Phone

Message I would like more information for 174 Warren Avenue Quincy MA 02170 (ID#:73379071)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

174 Warren AvenueQuincy, MA 02170MLS Number 73379071

$/month over payments

Driving Directions

Ask A Question

More Info

Basic Information

Location

Building

Water Body

Other

Tax Information

Rooms

Exterior

Property Information

Legal

Parking

Basic Information

Property

Interior

Utilities

Amenities

Your Local Office

Share

174 Warren AvenueQuincy, MA 02170MLS Number 73379071

$/month over payments

Driving Directions

Ask A Question

More Info

Basic Information

Location

Building

Water Body

Other

Tax Information

Rooms

Exterior

Property Information

Legal

Parking

Basic Information

Property

Interior

Utilities

Amenities

Your Local Office

Share

Hi there! How can we help you?

Hi there! How can we help you?

Hi there! How can we help you?