OPEN SAT, 1PM TO 2:30PM

For sale

$895,000

Est. $5,792/mo —

•

2,699

sq ft

174 Gilbert St, Mansfield, MA 02048

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!

Single-familyProperty Type

1930Year Built

1.2 acresLot Size

$332Price/Sq.Ft.

1 garage spacesParking

Listed by Deb Piazza • Coldwell Banker Realty - Sharon

Listed by • Coldwell Banker Realty - Sharon

Listing updated: Nov 12, 2026 at 01:40pm

Redfin checked: a few seconds ago

•Source:MLS PIN #73601587

Payment calculator

$5,792 per month

Principal and interest$4,884

Property taxes

$759

HOA dues

Home insurance

$149

Utilities

Add

5 minutes to get started. No credit impact.

Affordability tools

See this home in person

Open houses

Saturday, Nov 14

1:00pm - 2:30pm

Nearby open houses (10)

OPEN SAT, 10AM TO 11:30AM
$549,000
4 beds2 baths2,300 sq ft
49 Forest Ave, Seekonk, MA 02771
0.23 acre lot • 4 parking spots • Built 1946
OPEN SAT, 11AM TO 1PM
$435,000
3 beds1 bath1,296 sq ft
153 Woodhaven Rd, Pawtucket, RI 02861
6,500 sq ft lot • Garage • Built 1941
OPEN SAT, 11AM TO 1PM
$280,000
2 beds1 bath960 sq ft
14 Dailey St Unit K, Attleboro, MA 02703
$420 HOA • Parking • Community pool
REDFIN OPEN SAT, 12PM TO 2PM3D & VIDEO TOUR
$1,039,880
4 beds2.5 baths2,454 sq ft
15 Condor Rd, Sharon, MA 02067
0.47 acre lot • 2 garage spots • Built 1978
REDFIN OPEN SAT, 12PM TO 2PM3D & VIDEO TOUR
$1,195,000
4 beds2.5 baths3,025 sq ft
381 Prospect St, Franklin, MA 02038
0.92 acre lot • 3 garage spots • Built 2022
REDFIN OPEN SAT, 2PM TO 3:30PMVIDEO TOUR
$499,000
3 beds1 bath1,080 sq ft
92 England Rd, North Attleboro, MA 02760
0.46 acre lot • 2 parking spots • Built 1934
REDFIN OPEN SAT, 2:30PM TO 4:30PM3D & VIDEO TOUR
$999,000
5 beds2.5 baths2,744 sq ft
8 Dennison Ct, Stoughton, MA 02072
0.63 acre lot • 2 garage spots • Built 1997
OPEN SAT, 2:30PM TO 4PM
$549,888
3 beds2.5 baths1,948 sq ft
133 Cumberland St, Providence, RI 02908
3,200 sq ft lot • 2 parking spots • Built 2023
OPEN SUN, 12PM TO 1:30PM
$739,900
3 beds2 baths1,590 sq ft
Lot 3 Madison Lily Dr, Taunton, MA 02780
0.24 acre lot • 2 garage spots • Built 2026
OPEN SUN, 12PM TO 1PM
$539,900
4 beds2 baths2,841 sq ft
336 Mendon Rd, North Attleboro, MA 02760
0.34 acre lot • 2 garage spots • Built 1969

Around this home

Schools

K - 12
Preschool & daycare

Robinson Elementary School

Public K-2 • Assigned • 3.8mi

Harold L Qualters Middle School

Public 6-8 • Assigned • 3.8mi

7/10

Mansfield High School

Public 9-12 • Assigned • 3.9mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Market insights

174 Gilbert St · $895,000

DAYS ON MARKET

The average home goes pending in 29 days.

SALE-TO-LIST

Most homes are selling 1% below list price.

LIST PRICE

Median sale price in this area is $557,181. (38% lower than this home)

PRICE DROP

25% of homes in this area have had a price drop in the past month.

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Dining

Interior features
Cathedral and vaulted ceilings
Open floor plan
Recessed lighting
Study
Picture windows
Skylight
Ceiling fan
Fireplace in the living room
Partial, unfinished basement with crawl space

Bedrooms
Three bedrooms, all on the second floor
Primary bedroom with walk-in closet

Bathrooms
Two full bathrooms and one half bathroom
One bathroom on the main floor
Primary bathroom
Second-floor full bathroom with double vanity, tiled shower, soaking tub, custom built-in cabinets, and stone countertops
Second-floor full bathroom with tub and shower
Remodeled bathrooms with stone or ceramic tile flooring and stone countertops

Kitchen
Range, dishwasher, microwave, refrigerator, and range hood
Kitchen island
Pantry
Dining area
Upgraded cabinets
Stone countertops
Stainless steel appliances

Flooring
Hardwood flooring
Wall-to-wall carpeting

Heating & cooling
Forced-air heating
Central air conditioning

Sale and tax history for 174 Gilbert St

Sale History
Tax History

Date

Event

Price

MLS PIN #73601587

Nov 12, 2026

Listed

$895,000

$332/sq ft

MLS PIN #73096282

Jul 11, 2023

Sold

$305,000

$113/sq ft

Jun 18, 2023

Contingent

—

Jun 14, 2023

Relisted

—

Jun 10, 2023

Listing Removed

—

Apr 18, 2023

Contingent

—

Apr 8, 2023

Listed

$325,000

$120/sq ft

+35

Back On Market after Buyer failed to obtain funding. Investors, Contractors, Flippers, or Builders TAKE NOTICE. This charming 2 bedroom 1 full bath bungalow is an ideal candidate for a full gut rehab or tear down and build your dream home! Situated on a 1.2-acre lot, this property has three structures: the single-family bungalow-style home, a one-car garage, and an oversized workshop/barn/garage. The possibilities here are ENDLESS - the large barn/workshop is ideal for artists, musicians, hobbyists, tinkers, mechanics, etc. Conveniently located within close proximity to highways, MBTA, and shopping. Buyer & Buyer agent to verify all information prior to making an offer. Will not qualify for FHA financing. No Title V - Buyer Responsibility (currently a cesspool). Cash buyer preferred. Showings by appointment only.

Year

Property tax

Land + Additions

Assessment*

2023

$5,305 (+2.3%)

$255,700 + $120,800

$376,500

2022

$5,188 (+3.2%)

$237,000 + $105,000

$342,000

2021

$5,029 (+5.1%)

$207,200 + $120,200

$327,400

2020

$4,786 (+18.4%)

$197,400 + $114,200

$311,600

2019

$4,041 (+0.5%)

$164,700 + $100,800

$265,500

2018

$4,019 (+7.5%)

$157,300 + $100,800

$258,100

2017

$3,740 (+3.6%)

$153,000 + $96,000

$249,000

2016

$3,609 (+3.2%)

$145,500 + $88,700

$234,200

2015

$3,498 (−4.8%)

$145,500 + $80,200

$225,700

2014

$3,674 (+13.1%)

$145,500 + $87,500

$233,000

2013

$3,248 (+4.2%)

$145,500 + $72,600

$218,100

2012

$3,117 (−0.1%)

$145,500 + $72,600

$218,100

2011

$3,121 (−12.2%)

$145,500 + $72,600

$218,100

2010

$3,555 (−0.3%)

$190,000 + $76,700

$266,700

2009

$3,566

$202,200 + $94,700

$296,900

Public record

Beds

Baths

Stories

Lot width

—

Lot depth

—

Lot size

1.2 Acres

Year renovated

—

Finished Sq. Ft.

972

Unfinished Sq. Ft.

—

Total Sq. Ft.

972

Year built

1930

Style

Single Family Residential

County

Bristol County

APN

2856523

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 19, 2023.

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

5/10 Heat Factor

7 days above 97° expected this year, 15 days in 30 years

6/10 Wind Factor

64% chance of strong winds in next 30 years

2/10 Air Factor

1 unhealthy days expected this year, 2 days in 30 years

Provided by First Street

Historical weather

Mansfield, MA • 02048

Average low and high temperatures (°F)

34°

18°

37°

19°

51°

31°

60°

39°

69°

49°

81°

58°

84°

63°

79°

56°

74°

53°

62°

44°

52°

33°

39°

23°

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

96/ 100

Exceptional sunlight

Sunscore

This home ranks in the top 19% for direct sun exposure in Mansfield. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

9.2 hrs

5.8 hrs

JuneDecember

Provided by Shadowmap

Redfin Estimate for 174 Gilbert St

$893,725

$1,275 under list price of $895K

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $770K to $950K.

SOLD OCT 9, 2026
$950,000 Last sold price
4 beds2.5 baths2,016 sq ft
7 Southpark Ln, Mansfield, MA 02048
$139/sq ft
smaller lot
60 years newer
SOLD OCT 9, 2026
$940,000 Last sold price
4 beds2.5 baths2,390 sq ft
31 Nelson Way, Mansfield, MA 02048
$61/sq ft
smaller lot
59 years newer
SOLD SEP 28, 2026
$920,000 Last sold price
5 beds3.5 baths3,118 sq ft
4 Kybren Cir, Mansfield, MA 02048
$37/sq ft
smaller lot
71 years newer
SOLD JUL 17, 2026
$838,000 Last sold price
4 beds2.5 baths2,640 sq ft
10 Strawstone Ln, Norton, MA 02766
$15/sq ft
smaller lot
61 years newer
SOLD JUN 30, 2026
$820,000 Last sold price
4 beds2.5 baths2,880 sq ft
11 Antone Dr, Norton, MA 02766
$47/sq ft
smaller lot
65 years newer
SOLD JUL 17, 2026
$770,000 Last sold price
4 beds2 baths2,276 sq ft
238 N Worcester St, Norton, MA 02766
$6/sq ft
30 years newer

Rental earnings

Est. $1,549 per month, based on comparable rentals

Tour for free, no strings attached

Make a winning offer with the help of a local agent

Ask a question

(617) 849-9610

Early Access listings

EARLY ACCESSCOMPASS COMING SOON

$845,000

3 beds2 baths1,940 sq ft

63-65 Charles St #63, Newton, MA 02466

EARLY ACCESSCOMPASS COMING SOON

Contact for price

2 beds1 bath1,466 sq ft

32 Sherborn St, Arlington, MA 02474

EARLY ACCESSCOLDWELL BANKER REALTY COMING SOON

Contact for price

5 beds3 baths4,357 sq ft

5 Westview Farm Rd, Dracut, MA 01826

EARLY ACCESSCOMPASS COMING SOON

$1,695,000

2 beds3 baths2,351 sq ft

25 Channel Center St #610, Boston, MA 02210

EARLY ACCESSCOMPASS COMING SOON

$1,050,000

2 beds1 bath902 sq ft

120 Mountfort St #406, Boston, MA 02215

EARLY ACCESSCOMPASS COMING SOON

$1,799,000

6 beds5 baths2,741 sq ft

544 Nantasket Ave, Hull, MA 02045

Nearby similar homes

NEW 14 HRS AGO

$1,175,000

4 beds2.5 baths2,847 sq ft

51 Cobb St, Mansfield, MA 02048

New construction • End of cul de sac • Close to train

$625,000

3 beds2 baths1,852 sq ft

35 Mc Keon Dr, North Attleboro, MA 02760

Patio • Small pond • Upper deck

OPEN SUN, 11AM TO 12:30PM

$910,000

3 beds3 baths2,396 sq ft

42 Treasure Island Rd, Plainville, MA 02762

Lakefront paradise • Waterfront property • Oversized dock

$739,000

4 beds1.5 baths1,944 sq ft

273 W Main St, Norton, MA 02766

Flexible layout • Excellent visibility • Convenient access

$350,000

Land— sq ft

Lot 1B Dean St, Mansfield, MA 02048

Listed 36 days

$699,000

4 beds1.5 baths2,333 sq ft

343 Central St, Foxboro, MA 02035

Expansive grounds • Private retreat • Substantial lot

New listings for sale in 02048

COMING SOON

$749,900

4 beds2 baths1,808 sq ft

798 Ware St, Mansfield, MA 02048

Lovely garden area • Storage shed • Attached greenhouse

OPEN SAT, 1PM TO 2:30PM3D WALKTHROUGH

$895,000

3 beds2.5 baths2,699 sq ft

174 Gilbert St, Mansfield, MA 02048

Completely renovated • Natural light • 1.2 acre lot

OPEN SAT, 11AM TO 1PM3D WALKTHROUGH

$499,000

3 beds1.5 baths1,800 sq ft

101 N Main St Unit A103, Mansfield, MA 02048

Downtown mansfield • Commuter rail • Bike trail

OPEN SAT, 11AM TO 1PM

$649,900

3 beds2 baths2,876 sq ft

111 Park St, Mansfield, MA 02048

Attached breezeway • Newer windows • On demand hw

$699,000

2 beds3 baths2,332 sq ft

139 Grove, Mansfield, MA 02048

Finished basement • Horse stable • Secluded backyard

OPEN SUN, 11:30AM TO 1:30PM

$519,900

2 beds2 baths1,371 sq ft

631 East St Unit D103, Mansfield, MA 02048

First-floor • End unit • Prime location

OPEN SUN, 9AM TO 10:30AM

$499,900

2 beds2 baths1,266 sq ft

631 East St Unit D203, Mansfield, MA 02048

Private balcony • In-unit elevator • Landscaped grounds

OPEN SAT, 12PM TO 2PM

$339,900

2 beds1 bath890 sq ft

150 Rumford Ave #106, Mansfield, MA 02048

Inground pool • $418 HOA • 2 parking spots

Details provided by MLS PIN and may not match the public record. Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

Redfin Brokerage Licenses

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

02766 homes for sale
02703 homes for sale
02035 homes for sale
02356 homes for sale
02048 homes for sale

Houses for rent in Mansfield	Agents near me	Quincy, MA homes for sale	Mansfield Housing Market
Houses for sale near me	Boston, MA homes for sale	Brookline, MA homes for sale
Land for sale near me	Newton, MA homes for sale	Arlington, MA homes for sale
Open Houses near me	Cambridge, MA homes for sale	Mansfield Property Records
Condos for sale near me	Lexington, MA homes for sale	MA New Listings

Boston homes for sale
Newton homes for sale
Quincy homes for sale

Central North Attleboro homes for sale
North Attleboro City homes for sale

About this home

Payment calculator

Affordability tools

See this home in person

Nearby open houses (10)

Around this home

Schools

Lifestyle

Market insights

Property details

Sale and tax history for 174 Gilbert St

Public record

Climate risks

Historical weather

Sun exposure

Redfin Estimate for 174 Gilbert St

Early Access listings

Nearby similar homes

New listings for sale in 02048

More real estate resources