45 Walnut Street, Marstons Mills, MA 02648

45 Walnut Street Marstons Mills MA 02648
Owner Information
Owner 1
Kevin P Berry & Pamela J
Owner 2
Owner's Address
45 Walnut Street Marstons Mills, MA 02648
Market Sale Information
Most recent sale date
11/13/2013
Previous sale date
11/13/2013
Transfer document #
27819-0115
Previous transfer document
27819-0094
Grantor
Kevin P Berry
Previous grantor
Pamela J Martin
Most recent sale price
$1.00
Previous sale price
$300,000.00
Site Information
Property ID
149-002
Lot Size
0.46
Use Code
101 - Residential, single family
Zoning
RF
Building Style
Cape Cod
Number of Rooms
7
Stories
1.75
Number of Beds
4
Year Built
1978
Number of full baths
2
Condition
Number of half baths
0
Finished Area
1627
Number of Kitchen
Gross Living Area
2890
Number of Fireplaces
Bsmnt floot
Number of parking
Interior walls
Drywall
Floor type
Pine/Soft Wood
Solar Hot Water
No
Roof Structure
Gable/Hip
Heating type
Hot Water
Roof Cover
Asph/F Gls/Cmp
Heating fuel
Gas
Frame type
Air Condition (%)
Sidings
Wood Shingle
Assessment Information
Fiscal Year
2024
Land Value
$155,900.00
Total value
$527,300.00
Building value
$341,900.00
Estimated tax
$2,755.00
Yard improvement value
$29,500.00
Certified Mass Appraisal
Comparable Properties
  • Total Appraisal
  • Building Appraisal
  • Land Appraisal
  • Last Sale Price
  • Net Living Area
  • Number of Bedrooms
  • Lot Size
  • Year Built
Address 45 Walnut Street Photo Plan Map Proximity Last Sold Price Net Living Area Stories Sale Price/sft $0.00 Style Cape Cod Age 1978 Rooms 7 Bedrooms 4 Full baths 2 Half baths 0 Gross Living Area 2890 Heating Fuel Gas Detached Garage Lot Size 0.46 Roof Cover Asph/F Gls/Cmp AEM Value - Building $341,900.00 AEM Value - Land $155,900.00 AEM Value - Other $29,500.00 AEM Value - Total $527,300.00
A) 80 Walnut Street 0.1 7/18/2024 $615,000 1,507 1.5 $408.10 Cape Cod 1970 6 3 2 0 2776 Gas 0.5 Asph/F Gls/Cmp $312,800 $157,200 $21,700 $491,700
B) 140 Bridle Path 0.1 3/26/2024 $535,000 1,554 2 $344.27 Bungalow 1978 7 3 1 1 2512 Gas 0.5 Asph/F Gls/Cmp $256,400 $157,200 $32,200 $445,800
C) 929 Old Falmouth Road 0.1 6/3/2024 $67,500 1,431 1.5 $47.17 Cape Cod 1970 6 4 2 0 2931 Gas 0.91 Asph/F Gls/Cmp $300,200 $174,900 $33,000 $508,100
D) 120 Walnut Street 0.2 7/15/2024 $480,000 1,824 2 $263.16 Antique 1972 6 3 2 0 3392 Oil 0.49 Asph/F Gls/Cmp $344,100 $156,800 $38,300 $539,200
E) 436 Nye Road 0.4 7/2/2024 $404,000 1,674 1 $241.34 Ranch 1976 6 2 2 0 3276 Gas 0.35 Asph/F Gls/Cmp $360,300 $152,200 $40,300 $552,800
F) 16 Hadrada Lane 0.5 5/24/2024 $610,000 1,320 1 $462.12 Ranch 1976 5 2 2 0 3200 Gas 0.35 Asph/F Gls/Cmp $297,400 $152,200 $44,200 $493,800
G) 156 Sheaffer Road 0.6 4/4/2024 $635,000 1,704 1 $372.65 Ranch 1972 8 3 1 1 3600 Gas 0.34 Asph/F Gls/Cmp $377,900 $151,900 $48,200 $578,000
H) 58 Liberty Lane 0.7 3/21/2024 $620,000 1,712 1.75 $362.15 Cape Cod 1991 8 3 2 0 3684 Gas 0.43 Asph/F Gls/Cmp $360,200 $178,100 $37,200 $575,500
I) 59 Liberty Lane 0.7 6/10/2024 $750,000 1,346 1.75 $557.21 Cape Cod 1991 6 3 2 0 3620 Gas 0.41 Asph/F Gls/Cmp $353,800 $177,300 $54,000 $585,100
J) 775 Lumbert Mill Road 0.7 9/4/2024 $580,000 1,256 1 $461.78 Ranch 1984 5 3 2 0 3579 Electric 0.45 Asph/F Gls/Cmp $296,200 $155,500 $63,100 $514,800
K) 41 Ensign Road 0.7 9/9/2024 $650,000 1,556 1 $417.74 Ranch 1982 6 3 1 1 4172 Gas 0.35 Asph/F Gls/Cmp $368,800 $152,200 $89,800 $610,800
L) 315 Prince Hinckley Road 0.8 3/22/2024 $605,000 1,680 1 $360.12 Ranch 1980 6 2 2 0 3992 Electric 0.52 Asph/F Gls/Cmp $365,800 $158,800 $57,100 $581,700
M) 326 Prince Hinckley Road 0.9 8/30/2024 $640,000 1,640 1 $390.24 Ranch 1984 6 3 2 0 3780 Gas 0.35 Asph/F Gls/Cmp $428,500 $152,200 $61,000 $641,700
N) 38 Prince Hinckley Road 0.9 4/10/2024 $849,000 1,798 1.75 $472.19 Cape Cod 1976 6 3 2 1 4576 Gas 0.35 Asph/F Gls/Cmp $358,400 $152,200 $68,700 $579,300
O) 6 Stage Coach Road 0.9 6/21/2024 $720,000 1,756 2 $410.02 Colonial 1973 8 4 2 0 3004 Gas 0.38 Asph/F Gls/Cmp $324,300 $153,200 $38,700 $516,200
P) 24 Micah Hamlin Road 0.9 7/18/2024 $699,900 1,952 1 $358.56 Ranch 1986 7 3 2 1 4664 Gas 0.35 Asph/F Gls/Cmp $493,500 $152,200 $77,700 $723,400
Q) 145 Braley Jenkins Road 0.9 8/9/2024 $610,000 1,589 1.75 $383.89 Cape Cod 1987 6 3 2 0 3448 Gas 0.8 Asph/F Gls/Cmp $351,400 $173,100 $44,300 $568,800
R) 131 Seth Parker Road 0.9 6/14/2024 $740,000 1,540 1 $480.52 Ranch 1988 7 3 2 0 4080 Gas 0.35 Asph/F Gls/Cmp $374,600 $152,200 $71,200 $598,000
S) 645 Lumbert Mill Road 0.9 8/2/2024 $612,500 1,267 1.75 $483.43 Cape Cod 1985 6 3 2 0 3120 Gas 0.62 Asph/F Gls/Cmp $295,500 $157,100 $39,600 $492,200
T) 34 Eben Smith Road 0.9 4/3/2024 $595,000 1,614 1 $368.65 Ranch 1980 6 2 2 0 3914 Gas 0.35 Asph/F Gls/Cmp $375,300 $152,200 $58,100 $585,600
U) 117 Lakeside Drive 0.9 7/24/2024 $585,000 1,426 1.5 $410.24 Cape Cod 1990 6 3 2 0 2832 Gas 0.29 Asph/F Gls/Cmp $311,300 $150,300 $30,500 $492,100
V) 538 Lumbert Mill Road 1.0 7/31/2024 $670,000 1,462 1.75 $458.28 Cape Cod 1979 5 2 3 0 3176 Gas 0.81 Asph/F Gls/Cmp $317,100 $199,200 $46,900 $563,200
# Address Last Sold Sale Price Dist(m) Style LA (sq ft) Lot(ac) BR F-HB
@ 45 Walnut Street 11/13/2013 $1 0 Cape Cod 1,627 0.46 4 2-0 -
  Criteria
A 80 Walnut Street 7/18/2024 $615,000 0.1 Cape Cod 1,507 0.5 3 2-0
B 140 Bridle Path 3/26/2024 $535,000 0.1 Bungalow 1,554 0.5 3 1-1
C 929 Old Falmouth Road 6/3/2024 $67,500 0.1 Cape Cod 1,431 0.91 4 2-0
D 120 Walnut Street 7/15/2024 $480,000 0.2 Antique 1,824 0.49 3 2-0
E 436 Nye Road 7/2/2024 $404,000 0.4 Ranch 1,674 0.35 2 2-0
F 16 Hadrada Lane 5/24/2024 $610,000 0.5 Ranch 1,320 0.35 2 2-0
G 156 Sheaffer Road 4/4/2024 $635,000 0.6 Ranch 1,704 0.34 3 1-1
H 58 Liberty Lane 3/21/2024 $620,000 0.7 Cape Cod 1,712 0.43 3 2-0
I 59 Liberty Lane 6/10/2024 $750,000 0.7 Cape Cod 1,346 0.41 3 2-0
J 775 Lumbert Mill Road 9/4/2024 $580,000 0.7 Ranch 1,256 0.45 3 2-0
K 41 Ensign Road 9/9/2024 $650,000 0.7 Ranch 1,556 0.35 3 1-1
L 315 Prince Hinckley Road 3/22/2024 $605,000 0.8 Ranch 1,680 0.52 2 2-0
M 326 Prince Hinckley Road 8/30/2024 $640,000 0.9 Ranch 1,640 0.35 3 2-0
N 38 Prince Hinckley Road 4/10/2024 $849,000 0.9 Cape Cod 1,798 0.35 3 2-1
O 6 Stage Coach Road 6/21/2024 $720,000 0.9 Colonial 1,756 0.38 4 2-0
P 24 Micah Hamlin Road 7/18/2024 $699,900 0.9 Ranch 1,952 0.35 3 2-1
Q 145 Braley Jenkins Road 8/9/2024 $610,000 0.9 Cape Cod 1,589 0.8 3 2-0
R 131 Seth Parker Road 6/14/2024 $740,000 0.9 Ranch 1,540 0.35 3 2-0
S 645 Lumbert Mill Road 8/2/2024 $612,500 0.9 Cape Cod 1,267 0.62 3 2-0
T 34 Eben Smith Road 4/3/2024 $595,000 0.9 Ranch 1,614 0.35 2 2-0
U 117 Lakeside Drive 7/24/2024 $585,000 0.9 Cape Cod 1,426 0.29 3 2-0
V 538 Lumbert Mill Road 7/31/2024 $670,000 1.0 Cape Cod 1,462 0.81 2 3-0
Averages 93 days $603,314 0.66 --- 1,573 0.47 --- ---  

Estimation of Market Value - $597,945

As of today, 09/17/2024, the estimated market value of 45 Walnut Street, Marstons Mills considering the above 22 comparable properties is $597,945.

 

In estimating the current market value, RealtyInSite follows the sales comparison (market) approach which is an approach based on the principles of supply and demand (principle of change) and the principle of substitution. The principle of substitution assumes that a prudent person will pay no more for a property than it would cost to purchase a comparable substitute property.

 

Comparable sales data are applied to arrive at an estimate of value. By default, comparable properties are those properties located within 1 mile of the subject property that have sold within the last 6 months and have a similar size of living area. The table shown above lists the comparable properties that were considered. Note that which properties are considered comparables can be adjusted by varying the selection criteria or deleting non-representative properties.

Neighboring Properties
  • Total Appraisal
  • Building Appraisal
  • Land Appraisal
  • Last Sale Price
  • Net Living Area
  • Number of Bedrooms
  • Lot Size
  • Year Built
# Address Last Sold Sale Price Dist(m) Style LA (sq ft) Lot(ac) BR F-HB
@ 45 Walnut Street 11/13/2013 $1 0 Cape Cod 1,627 0.46 4 2-0 -
  Criteria
A 33 Walnut Street 6/20/2024 $560,000 0.0 Ranch 1,088 0.46 3 1-0
B 57 Walnut Street 1/9/1980 $0 0.0 Cape Cod 1,899 0.46 5 2-0
C 152 Timber Lane 9/17/1998 $124,900 0.0 Bungalow 1,576 0.46 3 2-0
D 867 Old Falmouth Road 2/22/1999 $65,000 0.0 Cape Cod 2,016 0.5 4 2-0
E 136 Timber Lane 9/23/2022 $473,000 0.0 Cape Cod 1,544 0.46 3 2-0
F 170 Timber Lane 9/11/1991 $121,900 0.0 Cape Cod 1,321 0.46 3 1-1
G 71 Walnut Street 4/19/2019 $420,000 0.0 Ranch 1,676 0.46 3 3-0
H 19 Walnut Street 2/5/2010 $220,000 0.0 Conventional 810 0.48 3 2-0
I 60 Walnut Street 3/4/1985 $42,000 0.0 Cape Cod 1,027 0.5 2 1-0
J 153 Timber Lane 10/7/2014 $1 0.1 Cape Cod 1,412 0.46 3 2-0
K 139 Timber Lane 10/19/2009 $296,850 0.1 Cape Cod 1,246 0.47 3 2-0
L 885 Old Falmouth Road 1/30/2013 $202,000 0.1 Ranch 1,008 0.5 2 1-1
M 169 Timber Lane 5/10/2016 $100 0.1 Bungalow 1,248 0.46 2 1-1
N 116 Timber Lane 3/2/2000 $1 0.1 Cape Cod 1,497 0.46 3 2-0
O 81 Walnut Street 10/16/2002 $1 0.1 Ranch 1,662 0.46 3 2-0
P 831 Old Falmouth Road 6/26/2018 $0 0.1 Ranch 1,914 0.46 4 3-0
Q 188 Timber Lane 10/22/2014 $100 0.1 Colonial 2,672 0.47 3 3-0
R 80 Walnut Street 7/18/2024 $615,000 0.1 Cape Cod 1,507 0.5 3 2-0
S 121 Timber Lane 10/25/2005 $295,000 0.1 Ranch 1,852 0.47 3 3-0
T 850 Old Falmouth Road 9/17/2010 $200,000 0.1 Ranch 1,645 1.03 3 2-1
U 10 Amelia Way 7/24/1997 $187,500 0.1 Ranch 1,500 1 2 2-0
V 901 Old Falmouth Road 8/30/1996 $109,000 0.1 Cape Cod 1,604 0.46 3 2-0
W 185 Timber Lane 4/22/2014 $1 0.1 Cape Cod 1,514 0.46 3 2-1
X 128 Bridle Path 12/11/2009 $270,000 0.1 Cape Cod 1,404 0.5 3 2-0
Y 140 Bridle Path 3/26/2024 $535,000 0.1 Bungalow 1,554 0.5 3 1-1
Z 92 Walnut Street 7/24/2014 $0 0.1 Vacant Land 0.4 -
- 114 Bridle Path 7/2/2020 $359,000 0.1 Colonial 1,344 0.51 3 1-1
- 10 Fairhaven Lane 6/12/2003 $395,000 0.1 Cape Cod 1,848 1.01 3 2-0
- 0 Old Falmouth Road 6/30/2020 $475,000 0.1 Vacant Land 0.03 -
- 152 Bridle Path 11/13/2017 $326,585 0.1 Bungalow 1,509 0.5 2 1-1
- 98 Timber Lane 8/10/1984 $98,500 0.1 Cape Cod 2,434 0.46 4 2-1
- 97 Walnut Street 3/6/2019 $0 0.1 Ranch 1,662 0.46 3 2-0
- 102 Bridle Path 2/21/1986 $18,500 0.1 Colonial 1,344 0.55 3 1-1
- 105 Timber Lane 6/24/2005 $388,900 0.1 Cape Cod 1,951 0.46 4 2-0
- 811 Old Falmouth Road 7/26/2023 $150,000 0.1 Cape Cod 1,832 0.47 3 2-1
- 204 Timber Lane 2/17/1988 $59,000 0.1 Ranch 1,556 0.47 3 2-0
- 913 Old Falmouth Road 6/6/2014 $1 0.1 Colonial 1,534 0.47 3 2-0
- 164 Bridle Path 5/2/2012 $0 0.1 Bungalow 1,892 0.51 3 2-0
- 201 Timber Lane 2/15/2018 $1 0.1 Ranch 1,038 0.46 2 1-0
- 102 Walnut Street 10/13/2006 $331,000 0.1 Cape Cod 1,163 0.46 3 1-0
- 90 Bridle Path 4/20/1993 $120,000 0.1 Colonial 1,716 0.59 3 1-1
- 11 Fairhaven Lane 8/28/2017 $360,200 0.1 Cape Cod 1,373 0.47 3 2-0
- 178 Bridle Path 3/15/2017 $1 0.1 Bungalow 1,872 0.52 3 1-1
Averages 5891 days $181,838 0.08 --- 1,495 0.5 --- ---  
DISCLAIMER: The information in this report was collected from the concerned Assessors Office and Registry of Deeds.  Compu-Links disclaims any and all representations or warranties as to the accuracy of this information
149-002 45 Walnut Street