Home Search

Save
Ask
Tour
Hide
Share
$1,099,986
38 Days On Site

174 Warren Ave
Quincy, MA 02170

For Sale|Single Family Residence|Pending
5
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
4,797
SqFt
$229
/SqFt
1870
Built
County:
Norfolk
Call Now: 978-870-9260
Is this the listing for you? We can help make it yours.
978-870-9260
174 Warren Ave174 Warren Ave174 Warren Ave174 Warren Ave
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$5,019
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2025 Information is deemed reliable but not guaranteed.

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!

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,099,986
Days On Site 
38 Days
Bedrooms 
5
Inside Area (SqFt) 
4,797 sqft
Total Baths 
5
Full Baths 
4
Partial Baths 
1
Lot Size 
0.39 Acres
Year Built 
1870
MLS® Number 
73379071
Status 
Pending
Property Tax 
$13,688
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Other
Friends & Family
Recent Activity
4 weeks agoListing updated with changes from the MLS®
4 weeks agoStatus changed to Pending
a month agoListing first seen on site
General Features
Acres 
0.39
Disclosures 
The information herein may contain inaccuracies and is provided without warranty or guarantee of any kind. Agents & Buyers must independently verify any info they deem material or important to their purchase or any offered price thereunder. Solar panels to be assumed. Seller is a licensed R E broker.
Foundation 
Stone
Garage 
Yes
Garage Spaces 
2
Parking 
DetachedStorageGarage Faces SideOff StreetDrivewayPaved
Parking Spaces 
2
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
SqFt Above 
3606
SqFt Below 
1191
SqFt Total 
4797
Style 
Colonial
Water Source 
Public
Zoning 
RESA
Interior Features
Appliances 
Water HeaterRangeDishwasherMicrowaveRefrigeratorWasherDryerPlumbed For Ice Maker
Basement 
FullFinishedInterior Entry
Cooling 
Wall Unit(s)
Electric 
200+ Amp Service
Fireplace 
Yes
Fireplace Features 
Dining RoomLiving Room
Fireplaces 
2
Flooring 
TileLaminateHardwood
Heating 
BaseboardHot WaterSteamOil
Interior 
Walk-In Closet(s)Pantry
Laundry Features 
Gas Dryer HookupWasher HookupElectric Dryer Hookup
Spa 
Yes
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Frame
Exterior 
Rain GuttersStorageOutdoor Shower
Fencing 
Fenced
Lot Features 
Corner LotLevelLandscaped
Patio And Porch 
PorchDeckEnclosed
Pool Features 
In GroundPrivate
Private Pool 
Yes
Roof 
Shingle
Spa 
Yes
Spa Features 
Private
Waterfront Features 
Ocean FrontBeach Front
Community Features
Community Features 
Park
Listing courtesy of Matt Tasgin of United Brokers



The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors, landlords, and public records, and were compiled by MLS Property Information Network, Inc. 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, leasing or renting 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, leasing or renting. MLS Property Information Network, Inc. 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.

Last checked 2025-06-30 03:07 PM UTC

Neighborhood & Commute
Source: Walkscore
Community information and market data Powered by ATTOM Data Solutions. Copyright ©2019 ATTOM Data Solutions. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share