FeaturesSkylight, Ceiling Fan(s), Vaulted Ceiling(s), Flooring - Wall to Wall Carpet, Open Floorplan
LevelThird
174 Gilbert St, Mansfield MA 02048
Mansfield, MA 02048
$895,000
Est. $5,484/month
Estimate assumptions
20% down, a 30-year loan at 6.5%, and $200/month estimated insurance.
Includes the supplied property-tax and HOA inputs; missing inputs contribute $0. HOA fees with an unspecified frequency are treated as monthly. PMI and closing costs are excluded.
Adjust the payment calculatorTrack this home for price, status, and open-house alerts.
About this home
STUNNING CONTEMPORARY DESIGN...EXCEPTIONAL CRAFTSMANSHIP COMPLETELY REIMAGINED! Prepare to be captivated by this EXTRAORDINARY, COMPLETELY RENOVATED residence, where SOPHISTICATED MODERN finishes, DRAMATIC architectural details, and THOUGHTFULLY DESIGNED living spaces come together beautifully. Meticulously transformed from top to bottom, this truly special home offers an OPEN CONCEPT FLOOR PLAN, GORGEOUS hardwood floors throughout, and an abundance of NATURAL LIGHT. The CATHEDRAL living room features a STRIKING FIREPLACE and creates an impressive first impression, flowing seamlessly into the SPECTACULAR CHEF'S kitchen. A SHOWPIECE in its own right, the kitchen boasts SLEEK CONTEMPORARY cabinetry, an OVERSIZED ISLAND, TOP-OF-THE-LINE STAINLESS STEEL appliances, a professional VENTED HOOD, and STUNNING modern finishes throughout. A STYLISH dining room or the 1st floor study offers the perfect work-from-home retreat, while a beautifully appointed half bath with a backlit mirror adds another touch of contemporary ELEGANCE. Upstairs, three FABULOUS bedrooms include a LUXURIOUS primary suite featuring a SPA-INSPIRED private bath with DOUBLE VANITIES, an OVERSIZED stone shower, and a GORGEOUS soaking tub. An additional BEAUTIFULLY finished full bath serves the remaining bedrooms. The 3rd floor offers an incredible surprise...a SPRAWLING, OPEN bonus space filled with NATURAL LIGHT from numerous SKYLIGHTS and DISTINCTIVE ARCHITECTURAL WINDOWS. Whether envisioned as a media room, game room, entertaining space, or private retreat, the possibilities are endless! Set on a LARGE, PRIVATE lot, the property also features a detached garage and an additional detached structure offering tremendous versatility. The extensive complete renovation includes NEW plumbing, HVAC, electrical, kitchen, bathrooms, flooring, paint, and so much more...providing the look, feel, and comfort of an entirely new home. Every detail has been thoughtfully considered, every space beautifully executed, and every turn reveals something special. THIS IS CONTEMPORARY LIVING AT ITS FINEST...TRULY ONE OF A KIND!
View in the App
Save this property, schedule tours instantly, and get alerts when the price drops
Scan with phone
BMN Estimate
Get the number an algorithm can't give you
A free agent CMA factors in condition, upgrades, and the street — the things comps alone can't see.
Recently Sold Nearby
Price & Status History
Property Timeline
Listed for Sale
Nov 12, 2026
$895,000
Original listing
Agent: Deborah Piazza
Office: Coldwell Banker Realty - Sharon
| Date | Event | Price | Change | $/sqft | Details |
|---|---|---|---|---|---|
| 11/12/2026 | 🏠 Listed for Sale | $895,000 | - | - | Original listing |
Tax History
| Year | Taxes | Assessment |
|---|---|---|
| 2026 | $9,107 | $695,700 |
Financial Details
Annual Property Tax
$9,107
Tax Year 2026
Assessed Value
$695,700
Facts & Features
1 Car Garage
Central AC
Home Facts
Type
Residential
Style
Single Family Residence
Year Built
1930
Living Area
2,699 sq ft
Lot Size
1.20 acres
Bedrooms
3
Full Baths
2
Half Baths
1
Total Rooms
10
Interior
Heating
Forced Air
Cooling
Central Air
Flooring
Hardwood, Flooring - Hardwood
Appliances
Range, Dishwasher, Microwave, Refrigerator, Range Hood
Fireplace
Living Room
Fireplaces
1
Basement
Partial, Crawl Space, Unfinished
Laundry
None
Features
Recessed Lighting, Study
Exterior
Construction
Frame
Architecture
Contemporary
Roof
Shingle
Features
Porch, Deck - Wood, Storage
Pool
None
Spa
None
Fencing
None
Patio/Porch
Porch, Deck - Wood
Parking
Garage Spaces
1
Has Garage
Yes
Features
Detached, Paved Drive, Off Street, Paved
Total Spaces
6
Utilities
Electric
None
Water
Public
Sewer
Private Sewer
Gas
None
Other
None
Financial
Annual Tax
$9,107
Assessed Value
$695,700
HOA & Community
Fee Includes
None
Amenities
None
Optional Fee Includes
None
MA Disclosures
Lead Paint
Unknown
Seller Disclosures
Full Home Renovation (2025); Brand New Septic (2025); New Plumbing (2025); New Electrical (2025); New Hvac (2025)
Additional Details
Possession
None
Accepted Financing
None
Structure Type
[]
House Color
Blue
Sq Ft Source
Owner
Documents
None
County
Bristol
Property Overview
Property Type
Single Family Residence
Listing Type
For Sale
Year Built
1930
Bedrooms
3
Full Bathrooms
2
Half Bathrooms
1
Living Area
2,699 sq ft
Total Rooms
10
Floor Layout
Interactive room guide
Floor Layout
Finished Area
2,699 sq ft above grade
FeaturesCloset, Flooring - Hardwood, Recessed Lighting
LevelSecond
FeaturesCloset, Flooring - Hardwood, Recessed Lighting
LevelSecond
FeaturesBathroom - Full, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Shower Stall, Bathroom - With Tub, Closet/Cabinets - Custom Built, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Recessed Lighting, Remodeled, Soaking Tub
LevelSecond
FeaturesBathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Recessed Lighting, Remodeled
LevelSecond
FeaturesBathroom - Full, Walk-In Closet(s), Flooring - Hardwood, Recessed Lighting
LevelSecond
FeaturesFlooring - Hardwood, Window(s) - Picture, Dining Area, Pantry, Countertops - Stone/Granite/Solid, Kitchen Island, Cabinets - Upgraded, Deck - Exterior, Exterior Access, Open Floorplan, Recessed Lighting, Remodeled, Slider, Stainless Steel Appliances
LevelMain,First
FeaturesBathroom - Half, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Remodeled
LevelMain,First
FeaturesFlooring - Hardwood, Deck - Exterior, Exterior Access, Open Floorplan, Recessed Lighting, Remodeled, Lighting - Overhead
LevelMain,First
FeaturesCathedral Ceiling(s), Flooring - Hardwood, Window(s) - Picture, Exterior Access, Open Floorplan, Recessed Lighting, Remodeled
LevelMain,First
FeaturesYes
Display Options
Outdoor Areas
Patio & porchPorch, Deck - Wood
Room Markers
KKitchen (1)
BRBedroom (3)
BABathroom (4)
DDining (1)
LLiving (2)
Conceptual diagram based on MLS room data. It is not to scale and is not a substitute for architectural plans or on-site measurements.
Interior Features
Flooring:
Hardwood, Flooring - Hardwood
Appliances:
Range, Dishwasher, Microwave, Refrigerator, Range Hood
Interior Features:
Recessed Lighting, Study
Windows:
Basement:
Partial, Crawl Space, Unfinished
Laundry:
Security:
Construction & Materials
Style:
Contemporary
Year Built:
1930
Structure Type:
Exterior Materials:
Frame
Roof:
Shingle
Foundation:
Concrete Perimeter
Utilities & Systems
Heating:
Forced Air
Cooling:
Central Air
Hot Water:
Water Source:
Public
Sewer:
Private Sewer
Energy Features:
Exterior & Lot
Exterior Features:
Porch, Deck - Wood, Storage
Patio & Porch:
Porch, Deck - Wood
Fencing:
Other Structures:
Lot Features:
Wooded, Level
Road Surface:
Paved
Parking & Garage
Garage Spaces:
1
Total Parking Spaces:
6
Parking Features:
Detached, Paved Drive, Off Street, Paved
Special Features
Fireplaces:
1
Fireplace Type:
Living Room
Community Amenities:
Shopping, Walk/Jog Trails, Conservation Area, Highway Access
Nearby Schools
School information not available for this location.
Monthly Payment Calculator
Monthly Payment
$0
Principal, interest, taxes & insurance
Loan Amount
$0
After down payment
Total Interest
$0
Over life of loan
Total Cost
$0
Including down payment
%
Down: $0
%
Monthly Payment Breakdown
Principal & Interest
$0
Property Tax
$759
Homeowners Insurance
$200
PMI (if <20% down)
$0
Loan Summary
Total of 360 payments
$0
Total principal paid
$0
Total interest paid
$0
Rate Impact
-0.5% Rate
$0/mo
Save $0/mo
Current Rate
$0/mo
+0.5% Rate
$0/mo
Cost $0/mo
Payment Over Time
Year 1
95% Interest
Year 15
50/50
Year 30
95% Principal
* Estimates only. Actual payments may vary. Consult with a lender for accurate figures.
Location
Loading map...
Neighborhood
174 Gilbert St, Mansfield MA 02048
Mansfield, MA 02048
Listing Information
Listing Agent
Deborah Piazza
Listing Office
Coldwell Banker Realty - Sharon
Office Phone
781-784-3313
Agent MLS ID
BB802202
Office MLS ID
AN6233
Listing Data Updated
Nov 12, 2026 1:33 PM EST
Listing information is deemed reliable but not guaranteed. Data provided by MLS Property Information Network, Inc. All information should be independently verified.
Contact Us
Ask about this property — free, no obligation.
Similar Homes for Sale
Comparable Properties
Customize Comparable Search
Finding comparable properties...
Loading market insights for Mansfield.
