Location filter
  • Any
  • Boston
  • Boston - Allston
  • Boston - Back Bay
  • Boston - Bay Village
  • Boston - Beacon Hill
  • Boston - Brighton
  • Boston - Charlestown
  • Boston - Chinatown
  • Boston - Dorchester
  • Boston - Downtown
  • Boston - East Boston
  • Boston - Fenway
  • Boston - Fort Hill
  • Boston - Hyde Park
  • Boston - Jamaica Plain
  • Boston - Mattapan
  • Boston - Mission Hill
  • Boston - North End
  • Boston - Roslindale
  • Boston - Roxbury
  • Boston - Seaport
  • Boston - South Boston
  • Boston - South End
  • Boston - West End
  • Boston - West Roxbury
  • Abington
  • Andover
  • Arlington
  • Belmont
  • Beverly
  • Billerica
  • Braintree
  • Bridgewater
  • Brookline
  • Burlington
  • Cambridge
  • Canton
  • Chelsea
  • Cohasset
  • Danvers
  • Dedham
  • Everett
  • Framingham
  • Gloucester
  • Hingham
  • Lawrence
  • Lexington
  • Lowell
  • Lynn
  • Lynnfield
  • Malden
  • Marlborough
  • Medford
  • Melrose
  • Methuen
  • Milton
  • Natick
  • Needham
  • Newton
  • North Reading
  • Norwood
  • Peabody
  • Pembroke
  • Plymouth
  • Quincy
  • Randolph
  • Reading
  • Revere
  • Salem
  • Saugus
  • Sharon
  • Somerville
  • Stoneham
  • Stoughton
  • Swampscott
  • Taunton
  • Wakefield
  • Waltham
  • Watertown
  • Wayland
  • Wellesley
  • Westwood
  • Weymouth
  • Wilmington
  • Winthrop
  • Woburn
Contingent
42
$1,099,986
5 Beds 5 Baths
HOA
N/A
SQFT
4797
174 Warren Ave
Quincy, MA 02170
View Map

Property Description

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!

Property Details

Amenities

  • Highway Access
  • House of Worship
  • Laundromat
  • Medical Facility
  • Park
  • Public School
  • Public Transportation
  • Shopping
  • T-Station
  • Walk/Jog Trails

Kitchen, Dining, and Appliances

  • Kitchen Dimensions: 17'1"X13'2"
  • Bathroom - Half, Breakfast Bar / Nook, Ceiling - Beamed, Deck - Exterior, Exterior Access, Flooring - Laminate, Pantry, Window(s) - Picture
  • Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer, Washer Hookup
  • Dining Room Dimensions: 14'1"X18
  • Dining Room Features: Fireplace, Flooring - Hardwood

Bathrooms

  • Full Baths: 4
  • Half Baths 1
  • Master Bath: 1
  • Bathroom 1 Dimensions: 5'11"X7'6"
  • Bathroom 1 Features: Bathroom - Half, Flooring - Laminate
  • Bathroom 2 Dimensions: 8'1"X6'1"
  • Bathroom 2 Level: Second Floor
  • Bathroom 2 Features: Bathroom - Full, Bathroom - Tiled With Shower Stall, Bathroom - With Tub, Enclosed Shower - Fiberglass, Flooring - Laminate
  • Bathroom 3 Dimensions: 7'11"X13
  • Bathroom 3 Level: Second Floor
  • Bathroom 3 Features: Bathroom - Double Vanity/Sink, Bathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile

Bedrooms

  • Bedrooms: 5
  • Master Bedroom Dimensions: 14'1"X15'8"
  • Master Bedroom Level: Second Floor
  • Master Bedroom Features: Bathroom - Full, Closet, Flooring - Hardwood
  • Bedroom 2 Dimensions: 15X15'2"
  • Bedroom 2 Level: Second Floor
  • Master Bedroom Features: Closet, Flooring - Hardwood
  • Bedroom 3 Dimensions: 16'5"X12'1"
  • Bedroom 3 Level: Second Floor
  • Master Bedroom Features: Closet, Flooring - Hardwood

Other Rooms

  • Total Rooms: 21
  • Living Room Dimensions: 15X14'11"
  • Living Room Features: Ceiling Fan(s), Exterior Access, Fireplace, Flooring - Hardwood
  • Family Room Dimensions: 26'1"X17'8"
  • Family Room Level: Basement
  • Family Room Features: Closet
  • Laundry Room Features: Finished, Full, Interior Access, Other (See Remarks), Slab

Utilities

  • Heating: Central Heat, Common, Electric Baseboard, Geothermal Heat Source, Heat Pump, Hot Water Baseboard, Hot Water Radiators, Individual, Oil, Other (See Remarks), Steam, Steam
  • Hot Water: Other (See Remarks), Varies Per Unit
  • Cooling: Wall AC
  • Electric Info: 200 Amps
  • Utility Connections: for Electric Dryer, for Gas Oven, for Gas Range, Generator Connection, Icemaker Connection, Washer Hookup
  • Water: City/Town Water, Private
  • Sewer: City/Town Sewer, Private

Garage & Parking

  • Garage Parking: Detached, Side Entry, Storage
  • Garage Spaces: 2
  • Parking Features: 1-10 Spaces, Improved Driveway, Off-Street, Paved Driveway
  • Parking Spaces: 2

Interior Features

  • Square Feet: 4797
  • Fireplaces: 2
  • Interior Features: Laundry Chute
  • Accessability Features: Unknown

Construction

  • Year Built: 1870
  • Type: Detached
  • Style: Colonial, Detached,
  • Construction Type: Aluminum, Frame
  • Foundation Info: Fieldstone
  • Roof Material: Aluminum, Asphalt/Fiberglass Shingles
  • Flooring Type: Hardwood, Laminate, Tile
  • Lead Paint: Unknown
  • Warranty: No

Exterior & Lot

  • Lot Description: Corner, Level
  • Exterior Features: Deck, Deck - Wood, Fenced Yard, Gutters, Hot Tub/Spa, Outdoor Shower, Pool - Inground, Porch, Professional Landscaping, Storage Shed
  • Road Type: Public
  • Waterfront Features: Ocean
  • Distance to Beach: 1 to 2 Mile
  • Beach Ownership: Public
  • Beach Description: Ocean

Other Information

  • MLS ID# 73379071
  • Last Updated: 05/26/25
  • HOA: No
  • Reqd Own Association: Unknown

Mortgage Calculator

Click to see breakdown

Map

Seller's Representative: Matt Tasgin, United Brokers
Sub Agent Compensation: n/a
Buyer Agent Compensation: 2
Facilitator Compensation: 1
Compensation Based On: Net Sale Price
Sub-Agency Relationship Offered: No

© 2025 MLS Property Information Network, Inc.. All rights reserved.

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

MLS PIN data last updated at 2025-05-26 20:53:00

Related Properties