174 Warren Ave
$1,099,986
5
Beds
4/1
Baths
4,797
Sqft
- Request Info
- Call
- Save
-
More
- Mortgage Calculator
Property Tools
$1,099,986
5
Beds
4/1
Baths
4,797
Living Area
-
Property 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!
-
Highlights
- Cooling: Wall Unit(s)
- Parking Spots: 2
- Property Type: Single Family Residence
- Total Rooms: 21
- Status: Active
- Heating: Baseboard, Hot Water, Steam, Oil
- Property Class: Residential
- Style: Colonial
- Year Built: 1870
-
Additional Details
- Appliances: Water Heater, Range, Dishwasher, Microwave, Refrigerator, Washer, Dryer, Plumbed For Ice Maker
- Construction: Frame
- Fireplaces: 2
- Foundation: Stone
- Lot Features: Corner Lot, Level
- Roof: Shingle
- Year Built Details: Approximate
- Zoning: Resa
- Basement: Full, Finished, Interior Entry, Slab
- Exterior Features: Porch, Porch - Enclosed, Deck, Deck - Wood, Pool - Inground, Rain Gutters, Hot Tub/Spa, Storage, Professional Landscaping, Fenced Yard, Outdoor Shower
- Flooring: Tile, Laminate, Hardwood, Flooring - Hardwood, Flooring - Vinyl
- Interior 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
- Road Frontage Type: Public
- SqFt Source: Other
- Year Built Source: Public Records
-
Amenities
- Community Features: Public Transportation, Shopping, Park, Walk/Jog Trails, Medical Facility, Laundromat, Highway Access, House of Worship, Public School, T-Station
- Parking Features: Detached, Storage, Garage Faces Side, Off Street, Driveway, Paved
- Waterfront Features: Beach Front, Ocean, 1 to 2 Mile To Beach, Beach Ownership(Public)
- Covered Parking Spaces: 2
- Pool Features: In Ground
-
Utilities
- Electric: 200+ Amp Service, Generator Connection
- Water Source: Public
- Sewer: Public Sewer
-
Fees / Taxes
- Assessed Value: $1,187,200
- Compensation Based On: Net Sale Price
- Tax Year: 2025
- Buyer Agent Compensation: 2%
- Facilitator Compensation: 1%
- Taxes: $13,688
Similar Listings
Content © 2025 MLS Property Information Network, Inc. The information in this listing was gathered from third party resources including the seller and public records.
Listing information provided courtesy of United Brokers.
MLS Property Information Network, Inc. and its subscribers disclaim any and all representations or warranties as to the accuracy of this information.