174 Warren Ave, Quincy MA 02170

$ 1,099,986
174 Warren Ave, Quincy MA 02170,

Description

Open House tomorrow (05/25) from 12:30-2pm! 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!

Address: 174 Warren Ave, Quincy MA 02170
City:
State/County:
Zip: 02170
Country: US

Property Id: 984100
Price: $ 1,099,986
Property Size: 4,797 ft2
Property Lot Size: 0 ft2
Rooms: 21
Bedrooms: 5
Bathrooms: 4.5
BuildingAreaSource: Other
Basement: Full,Finished,Interior Entry,Slab
BathroomsFull: 4
BathroomsHalf: 1
CommunityFeatures: Public Transportation,Shopping,Park,Walk/Jog Trails,Medical Facility,Laundromat,Highway Access,House of Worship,Public School,T-Station
BuildingAreaTotal: 4797
Directions: GPS!
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 RE broker.
IDXParticipationYN: 1
ListAgentMlsId: CN238940
ListOfficeMlsId: BB9067
ListingAgreement: Exclusive Right To Sell
Cooling: Wall Unit(s)
CoveredSpaces: 2
Electric: 200+ Amp Service,Generator Connection
FireplaceFeatures: Dining Room,Living Room
FireplacesTotal: 2
Flooring: Tile,Laminate,Hardwood,Flooring - Hardwood,Flooring - Vinyl
GarageSpaces: 2
MLSPIN_DISCLOSURE: N
Heating: Baseboard,Hot Water,Steam,Oil
LaundryFeatures: Flooring - Laminate,Gas Dryer Hookup,Washer Hookup,First Floor,Electric Dryer Hookup
MLSPIN_LEAD_PAINT: Unknown
MLSPIN_LISTING_ALERT: No
MLSPIN_LIST_PRICE_PER_SQFT: 229.31
MLSPIN_MAIN_LO: BB9067
ListingContractDate: 2025-05-22
ListingId: 73379071
LotFeatures: Corner Lot,Level
LotSizeArea: 0.39
LotSizeSquareFeet: 17010
MLSPIN_OFFLINE_LIST_NO: 3919991
MLSPIN_OH_FLAG: 1
MLSPIN_PAGE: 301
MLSPIN_PRICE_PER_SQFT: 229.31
ParcelNumber: M:5183 B:12 L:1,189785
ParkingFeatures: Detached,Storage,Garage Faces Side,Off Street,Driveway,Paved
MLSPIN_SQUARE_FEET_INCL_BASE: Yes
PoolFeatures: In Ground
MainLevelBathrooms: 1
Roof: Shingle
MlsStatus: New
ModificationTimestamp: 2025-05-24T19:39:00.000Z
OriginalEntryTimestamp: 2025-05-22T22:10:00.000Z
OriginalListPrice: 1099986
OriginatingSystemID: mlspin
OriginatingSystemKey: mlspin
OriginatingSystemName: MLS Property Information Network
ParkingTotal: 2
PatioAndPorchFeatures: Porch,Porch - Enclosed,Deck,Deck - Wood
PhotosChangeTimestamp: 2025-05-23T14:56:54.719Z
PhotosCount: 42
PostalCodePlus4: 4025
PrivateOfficeRemarks: Offers, if any, please email the complete offer package in one PDF (not Dotloop) to Matt@MattTasgin.com and make offers good for 24 hours for review/response. Seller has the right to accept an offer anytime! Property is owned by an LLC and the manager of the LLC has a real estate license. The seller never occupied the premises. Solar panels to be assumed.
RoadFrontageType: Public
RoomBathroom1Area: 44.25
RoomBathroom1Features: Bathroom - Half,Flooring - Laminate
RoomBathroom1Length: 5.9
RoomBathroom1Level: Main,First
RoomBathroom1Width: 7.5
RoomBathroom2Area: 49.41
RoomBathroom2Features: Bathroom - Full,Bathroom - Tiled With Shower Stall,Bathroom - With Tub,Flooring - Laminate,Enclosed Shower - Fiberglass
RoomBathroom2Length: 8.1
RoomBathroom2Level: Second
RoomBathroom2Width: 6.1
RoomBathroom3Area: 102.7
RoomBathroom3Features: Bathroom - Full,Bathroom - Double Vanity/Sink,Bathroom - Tiled With Tub & Shower,Flooring - Stone/Ceramic Tile
RoomBathroom3Length: 7.9
RoomBathroom3Level: Second
RoomBathroom3Width: 13
RoomBedroom2Area: 228
RoomBedroom2Features: Closet,Flooring - Hardwood
RoomBedroom2Length: 15
RoomBedroom2Level: Second
RoomBedroom2Width: 15.2
RoomBedroom3Area: 198.439999
RoomBedroom3Features: Closet,Flooring - Hardwood
RoomBedroom3Length: 16.4
RoomBedroom3Level: Second
RoomBedroom3Width: 12.1
RoomBedroom4Area: 119.21
RoomBedroom4Features: Closet,Flooring - Hardwood
RoomBedroom4Length: 9.1
RoomBedroom4Level: Second
RoomBedroom4Width: 13.1
RoomBedroom5Area: 243.839999
RoomBedroom5Features: Cedar Closet(s),Closet,Flooring - Laminate
RoomBedroom5Length: 19.2
RoomBedroom5Level: Third
RoomBedroom5Width: 12.7
RoomDiningRoomArea: 253.799999
RoomDiningRoomFeatures: Flooring - Hardwood
RoomDiningRoomLength: 14.1
RoomDiningRoomLevel: Main,First
RoomDiningRoomWidth: 18
RoomFamilyRoomArea: 461.97
RoomFamilyRoomFeatures: Closet
RoomFamilyRoomLength: 26.1
RoomFamilyRoomLevel: Basement
RoomFamilyRoomWidth: 17.7
RoomKitchenArea: 225.72
RoomKitchenFeatures: Bathroom - Half,Beamed Ceilings,Flooring - Laminate,Window(s) - Picture,Pantry,Breakfast Bar / Nook,Deck - Exterior,Exterior Access
RoomKitchenLength: 17.1
RoomKitchenLevel: Main,First
RoomKitchenWidth: 13.2
RoomLivingRoomArea: 223.5
RoomLivingRoomFeatures: Ceiling Fan(s),Flooring - Hardwood,Exterior Access
RoomLivingRoomLength: 15
RoomLivingRoomLevel: Main,First
RoomLivingRoomWidth: 14.9
RoomMasterBathroomFeatures: Yes
RoomMasterBedroomArea: 221.369999
RoomMasterBedroomFeatures: Bathroom - Full,Closet,Flooring - Hardwood
RoomMasterBedroomLength: 14.1
RoomMasterBedroomLevel: Second
RoomMasterBedroomWidth: 15.7
RoomOfficeArea: 232.879999
RoomOfficeFeatures: Flooring - Hardwood
RoomOfficeLength: 16.4
RoomOfficeLevel: Main
RoomOfficeWidth: 14.2
Sewer: Public Sewer
ShowingInstructions: Accompanied Showings,Appointment Required,Email List Agent,Other (See Special Showing Instructions),Open House Tomorrow (05/25) From 12:30-2pm!
SpaFeatures: Private
StateOrProvince: MA
StatusChangeTimestamp: 2025-05-22T22:10:00.000Z
StreetName: Warren Ave
StreetNumber: 174
StreetNumberNumeric: 174
TaxAnnualAmount: 13688
TaxAssessedValue: 1187200
TaxBookNumber: 42298
TaxYear: 2025
TransactionBrokerCompensation: 1
TransactionBrokerCompensationType: %
Utilities: for Gas Range,for Gas Oven,for Electric Dryer,Washer Hookup,Icemaker Connection,Generator Connection
WaterSource: Public
WaterfrontFeatures: Beach Front,Ocean,1 to 2 Mile To Beach,Beach Ownership(Public)
YearBuiltDetails: Approximate
YearBuiltSource: Public Records
Zoning: RESA
YearBuilt: 1870
Office Name: united brokers
Member Name: matt tasgin

Outdoor Space
Spa
Other Features
Bathroom
Bathroom - 3/4
Bathroom - Full
Bathroom - Tiled With Tub
Bathroom - With Shower Stall
Breakfast Bar / Nook
Deck
Deck - Wood
Dining Area
Dishwasher
Dryer
Entry Hall
Fenced Yard
Has Cooling System
Has Fireplace
Has Garage
Has Heating System
Has Pool
Hot Tub/Spa
Kitchen
Laundry Chute
Microwave
Office
Open Parking
Outdoor Shower
Pantry
Plumbed For Ice Maker
Pool - Inground
Porch
Porch - Enclosed
Professional Landscaping
Rain Gutters
Range
Refrigerator
Storage
Sun Room
Walk-In Closet(s)
Washer
Water Heater

$ 5,639.85
per month
  • Principal and Interest
  • Property Tax
  • HOA fee
$ 4,264.86

Similar Listings

$ 849,999
Residential Income

49 Smith St, Quincy MA 02169,Quincy,Norfolk,Residential Income

Discover this charming side-by-side two-family home nestled in a serene Quincy neighborhoo ...
Beds:
5
Baths:
2
Size:
2,105 ft2
MLS #
73307060
Listed by:
stuart st james, inc.
Philippe Felix
$ 3,200
Residential Lease
Sold

118 Holmes # 405, Quincy MA 02171,Quincy,Norfolk,Residential Lease

Sprawling penthouse in bustling North Quincy! With panoramic south of Boston views, this s ...
Beds:
2
Baths:
2
Size:
1,342 ft2
MLS #
73310731
Listed by:
coldwell banker realty - boston
Philippe Felix
$ 924,900
Residential Income
Sold

4-8 Watson Rd, Quincy MA 02169,Quincy,Norfolk,Residential Income

Very spacious two family home with 4 beds/2 baths on 1st and 2nd floors. 2 bed/1bath on th ...
Beds:
6
Baths:
3
Size:
2,809 ft2
MLS #
73284600
Listed by:
elite realty advisors
Philippe Felix
$ 2,000
Residential Lease
Active

82 Verchild St # 4, Quincy MA 02169

Great 1 bedroom short walk to Quincy Adams Station. Newly updated. Kitchen has new white c ...
Beds:
1
Baths:
1
Size:
550 ft2
MLS #
73319426
Listed by:
lauchlin real estate group
Philippe Felix
174 Warren Ave, Quincy MA 02170 © 2024 YOUR COMPANY NAME. ALL MATERIAL PRESENTED HEREIN IS INTENDED FOR INFORMATION PURPOSES ONLY. WHILE, THIS INFORMATION IS BELIEVED TO BE CORRECT, IT IS REPRESENTED SUBJECT TO ERRORS, OMISSIONS, CHANGES OR WITHDRAWAL WITHOUT NOTICE. ALL PROPERTY INFORMATION, INCLUDING, BUT NOT LIMITED TO SQUARE FOOTAGE, ROOM COUNT, NUMBER OF BEDROOMS AND THE SCHOOL DISTRICT IN PROPERTY LISTINGS SHOULD BE VERIFIED BY YOUR OWN ATTORNEY, ARCHITECT OR ZONING EXPERT. EQUAL HOUSING OPPORTUNITY. THE SOURCE OF THE DISPLAYED DATA IS EITHER THE PROPERTY OWNER OR PUBLIC RECORD PROVIDED BY NON-GOVERNMENTAL THIRD PARTIES. IT IS BELIEVED TO BE RELIABLE BUT NOT GUARANTEED. THIS INFORMATION IS PROVIDED EXCLUSIVELY FOR CONSUMERS’ PERSONAL, NON-COMMERCIAL USE.

Compare Listings

Philippe Felix