New Listing
$895,000
 $4,805 est/mo Sourced by Back At You

174 Gilbert St,Mansfield, MA 02048

Mansfield, MA 02048

Share:

Description

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!

Details

MLS #73601587
Listing TypeFor Sale
StyleHouse
Sub-TypeResale
StatusActive
Year1930
Days On Site5
Listing Provided ByColdwell Banker Realty - Sharon | Deborah Piazza

Features

Bed(s)3
Bath(s) 3 Total
SQ Feet2,699
Garage1
BasementY
ZoningRes
Acreage1.20

Interior

Rooms Total10
Cooling Yes / NoYes
CoolingCentral Air
Heating Yes / NoYes
HeatingForced Air
Interior FeaturesRecessed Lighting, Study
AppliancesRange, Dishwasher, Microwave, Refrigerator, Range Hood
Fireplace FeaturesLiving Room
Fireplaces Total1
Fireplace Yes / NoYes
FlooringHardwood, Flooring - Hardwood

Exterior

Exterior FeaturesPorch, Deck - Wood, Storage
RoofShingle
Construction MaterialsFrame
Foundation DetailsConcrete Perimeter
Lot FeaturesWooded, Level

Parking

Garage Yes / NoYes
Attached Garage Yes / NoNo
Parking FeaturesDetached, Paved Drive, Off Street, Paved
Open Parking Yes / NoYes

Utilities

SewerPrivate Sewer

Taxes

Tax Annual Amount9106.71
Tax Assessed Value695700
Tax Year2026

Location

Community FeaturesShopping, Walk/Jog Trails, Conservation Area, Highway Access
Senior Community Yes / NoNo

Area Information

StateMA
CountyBristol
CityMansfield
Zip Code02048
AreaBristol
Listing VS Median (in 02048)
Price:
$895,000
low | high
Med:
$629,800
79.631284916201% of Average
sqft:
2,699
low | high
Med:
2,047
74.157095220452% of Average
$ / sqft:
$332
low | high
Med:
$308
57.217800678469% of Average
On site:
5
low | high
Med:
117
4.273504273504% of Average
Sourced by Back At You

Market Activity 02048

Request a showing

Request a showing

Contact


Additional Information


Showing Information


Submit Form

Required Field
By submitting, you agree to receive promotional texts and/or calls from Andrew Abu Inc at the number provided. Message/data rates may apply. Consent is not a condition of purchase, and you can opt out anytime by replying STOP.
MLS Internet Data Exchange (IDX) information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS Property Information Network.

Contact

Learn More About This Property

StateMA
CountyBristol
CityMansfield
Zip Code02048
AreaBristol
Listing VS Median (in 02048)
Price:
$895,000
low | high
Med:
$629,800
79.631284916201% of Average
sqft:
2,699
low | high
Med:
2,047
74.157095220452% of Average
$ / sqft:
$332
low | high
Med:
$308
57.217800678469% of Average
On site:
5
low | high
Med:
117
4.273504273504% of Average
Sourced by Back At You
Nearby Listings (Within 1/2 mile)
Price: $671K - $1.118M
sqft: 2,000 - 3,000
Nearby Listings Property ImageNearby Listings Details
78 Old Farm Rd Property Photo 1
$699,000
78 Old Farm Rd
Mansfield, MA 02048
Listing Updated: November 16, 2026 at 3:21:29 AM PST