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) 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
C) 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
D) 26 Mountwood Road 0.2 10/30/2024 $525,000 1,616 1 $324.88 Ranch 1978 7 3 1 1 3232 Gas 0.45 Asph/F Gls/Cmp $352,600 $155,500 $37,400 $545,500
E) 436 Nye Road 0.4 11/5/2024 $510,000 1,674 1 $304.66 Ranch 1976 6 2 2 0 3276 Gas 0.35 Asph/F Gls/Cmp $360,300 $152,200 $40,300 $552,800
F) 173 Nottingham Drive 0.6 9/30/2024 $550,000 1,360 1 $404.41 Ranch 1972 6 3 1 0 2880 Gas 0.34 Asph/F Gls/Cmp $297,100 $151,900 $32,400 $481,400
G) 143 Nottingham Drive 0.7 11/8/2024 $618,000 1,584 1 $390.15 Ranch 1972 6 3 1 1 3024 Gas 0.34 Asph/F Gls/Cmp $336,000 $151,900 $37,700 $525,600
H) 113 Ansel Howland Road 0.7 10/15/2024 $600,000 1,760 1 $340.91 Ranch 1983 7 3 2 0 4176 Gas 0.41 Asph/F Gls/Cmp $384,500 $154,200 $68,800 $607,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) 63 Elijah Childs Lane 0.7 10/22/2024 $650,000 1,436 1 $452.65 Ranch 1981 7 3 2 0 3480 Gas 0.34 Asph/F Gls/Cmp $375,600 $151,900 $47,200 $574,700
L) 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
M) 8 Filly Way 0.7 11/1/2024 $705,000 1,909 1.5 $369.30 Cape Cod 1988 6 3 2 0 4390 Gas 0.43 Asph/F Gls/Cmp $417,100 $178,100 $47,300 $642,500
N) 117 Prince Hinckley Road 0.8 10/1/2024 $590,000 1,548 1 $381.14 Ranch 1978 7 3 2 0 3968 Oil 0.35 Asph/F Gls/Cmp $394,300 $152,200 $56,700 $603,200
O) 34 Elijah Childs Lane 0.8 10/30/2024 $600,000 1,316 1 $455.93 Ranch 1981 6 2 2 0 3376 Gas 0.57 Asph/F Gls/Cmp $318,300 $162,900 $47,000 $528,200
P) 58 Oak Street 0.8 10/22/2024 $500,000 1,641 2 $304.69 Conventional 1945 6 3 2 0 3292 Gas 0.38 Asph/F Gls/Cmp $328,800 $153,200 $59,100 $541,100
Q) 16 Washington Bursley Way 0.8 11/14/2024 $650,000 1,476 1 $440.38 Ranch 1977 7 3 2 0 3734 Gas 0.35 Asph/F Gls/Cmp $344,900 $152,200 $61,100 $558,200
R) 316 Prince Hinckley Road 0.9 9/23/2024 $605,000 1,958 1 $308.99 Ranch 1979 6 3 2 1 4498 Oil 0.35 Asph/F Gls/Cmp $477,000 $152,200 $59,400 $688,600
S) 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
T) 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
U) 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
V) 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
W) 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
X) 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
Y) 635 Lumbert Mill Road 0.9 10/18/2024 $692,000 1,616 1 $428.22 Ranch 1979 5 3 2 0 4168 Gas 0.76 Asph/F Gls/Cmp $350,100 $172,400 $56,300 $578,800
Z) 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
-) 129 Chuckles Way 1.0 10/16/2024 $730,000 1,920 1.75 $380.21 Cape Cod 1990 8 3 3 0 4416 Gas 0.46 Asph/F Gls/Cmp $394,700 $155,900 $55,600 $606,200
-) 56 Outpost Lane 1.0 10/18/2024 $390,000 1,504 1 $259.31 Ranch 1974 7 3 2 0 3996 Oil 0.38 Asph/F Gls/Cmp $326,200 $153,200 $57,800 $537,200
-) 940 Old Stage Road 1.0 11/8/2024 $460,000 1,344 2 $342.26 Colonial 1996 6 3 1 1 2664 Gas 1.23 Asph/F Gls/Cmp $310,800 $179,600 $39,800 $530,200
-) 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 929 Old Falmouth Road 6/3/2024 $67,500 0.1 Cape Cod 1,431 0.91 4 2-0
C 120 Walnut Street 7/15/2024 $480,000 0.2 Antique 1,824 0.49 3 2-0
D 26 Mountwood Road 10/30/2024 $525,000 0.2 Ranch 1,616 0.45 3 1-1
E 436 Nye Road 11/5/2024 $510,000 0.4 Ranch 1,674 0.35 2 2-0
F 173 Nottingham Drive 9/30/2024 $550,000 0.6 Ranch 1,360 0.34 3 1-0
G 143 Nottingham Drive 11/8/2024 $618,000 0.7 Ranch 1,584 0.34 3 1-1
H 113 Ansel Howland Road 10/15/2024 $600,000 0.7 Ranch 1,760 0.41 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 63 Elijah Childs Lane 10/22/2024 $650,000 0.7 Ranch 1,436 0.34 3 2-0
L 41 Ensign Road 9/9/2024 $650,000 0.7 Ranch 1,556 0.35 3 1-1
M 8 Filly Way 11/1/2024 $705,000 0.7 Cape Cod 1,909 0.43 3 2-0
N 117 Prince Hinckley Road 10/1/2024 $590,000 0.8 Ranch 1,548 0.35 3 2-0
O 34 Elijah Childs Lane 10/30/2024 $600,000 0.8 Ranch 1,316 0.57 2 2-0
P 58 Oak Street 10/22/2024 $500,000 0.8 Conventional 1,641 0.38 3 2-0
Q 16 Washington Bursley Way 11/14/2024 $650,000 0.8 Ranch 1,476 0.35 3 2-0
R 316 Prince Hinckley Road 9/23/2024 $605,000 0.9 Ranch 1,958 0.35 3 2-1
S 326 Prince Hinckley Road 8/30/2024 $640,000 0.9 Ranch 1,640 0.35 3 2-0
T 6 Stage Coach Road 6/21/2024 $720,000 0.9 Colonial 1,756 0.38 4 2-0
U 24 Micah Hamlin Road 7/18/2024 $699,900 0.9 Ranch 1,952 0.35 3 2-1
V 145 Braley Jenkins Road 8/9/2024 $610,000 0.9 Cape Cod 1,589 0.8 3 2-0
W 131 Seth Parker Road 6/14/2024 $740,000 0.9 Ranch 1,540 0.35 3 2-0
X 645 Lumbert Mill Road 8/2/2024 $612,500 0.9 Cape Cod 1,267 0.62 3 2-0
Y 635 Lumbert Mill Road 10/18/2024 $692,000 0.9 Ranch 1,616 0.76 3 2-0
Z 117 Lakeside Drive 7/24/2024 $585,000 0.9 Cape Cod 1,426 0.29 3 2-0
- 129 Chuckles Way 10/16/2024 $730,000 1.0 Cape Cod 1,920 0.46 3 3-0
- 56 Outpost Lane 10/18/2024 $390,000 1.0 Ranch 1,504 0.38 3 2-0
- 940 Old Stage Road 11/8/2024 $460,000 1.0 Colonial 1,344 1.23 3 1-1
- 538 Lumbert Mill Road 7/31/2024 $670,000 1.0 Cape Cod 1,462 0.81 2 3-0
Averages 77 days $593,163 0.73 --- 1,574 0.48 --- ---  

Estimation of Market Value - $583,448

As of today, 11/25/2024, the estimated market value of 45 Walnut Street, Marstons Mills considering the above 30 comparable properties is $583,448.

 

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,432 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 5960 days $181,838 0.08 --- 1,501 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