554 Strawberry Hill Road, Hyannis, MA 02601

554 Strawberry Hill Road Hyannis MA 02601
Owner Information
Owner 1
Erik Trojian
Owner 2
Geline Midouin
Owner's Address
Pending Verification ,
Market Sale Information
Most recent sale date
8/12/2024
Previous sale date
9/2/2003
Transfer document #
D1507539-1
Previous transfer document
C170412-
Grantor
Richard Arneson
Previous grantor
Mary S Booth
Most recent sale price
$624,000.00
Previous sale price
$240,000.00
Site Information
Property ID
249-164
Lot Size
0.37
Use Code
101 - Residential, single family
Zoning
RB
Building Style
Cape Cod
Number of Rooms
8
Stories
1.75
Number of Beds
3
Year Built
1978
Number of full baths
2
Condition
Number of half baths
1
Finished Area
2270
Number of Kitchen
Gross Living Area
5122
Number of Fireplaces
Bsmnt floot
Number of parking
Interior walls
Drywall
Floor type
Hardwood
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
$152,900.00
Total value
$628,700.00
Building value
$425,000.00
Estimated tax
$4,347.00
Yard improvement value
$50,800.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 554 Strawberry Hill Road Photo Plan Map Proximity Last Sold Price Net Living Area Stories Sale Price/sft $274.89 Style Cape Cod Age 1978 Rooms 8 Bedrooms 3 Full baths 2 Half baths 1 Gross Living Area 5122 Heating Fuel Gas Detached Garage Lot Size 0.37 Roof Cover Asph/F Gls/Cmp AEM Value - Building $425,000.00 AEM Value - Land $152,900.00 AEM Value - Other $50,800.00 AEM Value - Total $628,700.00
A) 141 Pond View Drive 0.3 10/18/2024 $995,000 1,795 1.75 $554.32 Cape Cod 1976 6 3 2 0 3742 Oil 0.47 Asph/F Gls/Cmp $365,400 $265,500 $51,700 $682,600
B) 77 Headwaters Road 0.3 11/8/2024 $637,000 2,079 1 $306.40 Cape Cod 1964 8 4 3 0 4676 Oil 0.52 Asph/F Gls/Cmp $394,100 $222,300 $54,000 $670,400
C) 163 Pond View Drive 0.4 7/8/2024 $950,000 1,922 1 $494.28 Ranch 1953 7 3 3 0 3954 Gas 0.53 Asph/F Gls/Cmp $411,900 $271,300 $65,900 $749,100
D) 130 Sachem Drive 0.7 10/4/2024 $695,000 2,064 1 $336.72 Ranch 1970 10 4 3 0 5789 Gas 0.48 Asph/F Gls/Cmp $504,000 $180,000 $106,300 $790,300
E) 154 Longview Drive 0.8 7/16/2024 $675,000 2,008 2 $336.16 Colonial 1966 7 3 2 1 3056 Gas 0.56 Asph/F Gls/Cmp $351,100 $162,100 $27,800 $541,000
F) 48 Sea Marsh Road 0.9 9/6/2024 $1,475,000 2,248 1.5 $656.14 Cape Cod 1981 7 3 2 1 4384 Gas 1 Asph/F Gls/Cmp $469,600 $299,800 $39,700 $809,100
G) 35 Angus Way 0.9 9/12/2024 $1,265,000 2,782 1.75 $454.71 Cape Cod 1962 9 3 3 1 7360 Gas 0.45 Asph/F Gls/Cmp $587,300 $217,700 $61,000 $866,000
# Address Last Sold Sale Price Dist(m) Style LA (sq ft) Lot(ac) BR F-HB
@ 554 Strawberry Hill Road 8/12/2024 $624,000 0 Cape Cod 2,270 0.37 3 2-1 -
  Criteria
A 141 Pond View Drive 10/18/2024 $995,000 0.3 Cape Cod 1,795 0.47 3 2-0
B 77 Headwaters Road 11/8/2024 $637,000 0.3 Cape Cod 2,079 0.52 4 3-0
C 163 Pond View Drive 7/8/2024 $950,000 0.4 Ranch 1,922 0.53 3 3-0
D 130 Sachem Drive 10/4/2024 $695,000 0.7 Ranch 2,064 0.48 4 3-0
E 154 Longview Drive 7/16/2024 $675,000 0.8 Colonial 2,008 0.56 3 2-1
F 48 Sea Marsh Road 9/6/2024 $1,475,000 0.9 Cape Cod 2,248 1 3 2-1
G 35 Angus Way 9/12/2024 $1,265,000 0.9 Cape Cod 2,782 0.45 3 3-1
Averages 76 days $956,000 0.63 --- 2,128 0.57 --- ---  

Estimation of Market Value - $921,618

As of today, 11/25/2024, the estimated market value of 554 Strawberry Hill Road, Hyannis considering the above 7 comparable properties is $921,618.

 

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
@ 554 Strawberry Hill Road 8/12/2024 $624,000 0 Cape Cod 2,270 0.37 3 2-1 -
  Criteria
A 576 Strawberry Hill Road 12/20/2018 $270,000 0.0 Ranch 896 0.3 2 1-0
B 552 Strawberry Hill Road 5/6/2010 $1 0.0 Cape Cod 1,990 0.27 3 2-1
C 550 Strawberry Hill Road 12/14/2012 $246,000 0.0 Cape Cod 1,310 0.25 3 2-0
D 586 Strawberry Hill Road 10/19/2018 $1,265,000 0.0 Office Bldg 6,085 0.37 0 0-
E 571 Strawberry Hill Road 10/2/2015 $215,000 0.0 Ranch 1,008 0.23 2 1-0
F 94 Seagate Lane 12/14/2005 $389,000 0.0 Cape Cod 1,663 0.3 4 2-0
G 855 West Main Street Unit 1 8/23/2002 $150,000 0.0 Condominium 1,152 0 2 1-1
H 855 West Main Street Unit 2 11/15/1994 $49,000 0.0 Condominium 1,152 0 2 1-1
I 855 West Main Street Unit 3 11/17/2006 $172,000 0.0 Condominium 896 0 2 1-0
J 855 West Main Street Unit 4 3/2/2007 $0 0.0 Condominium 896 0 2 1-0
K 855 West Main Street Unit 5 5/30/2018 $1 0.0 Condominium 896 0 2 1-0
L 855 West Main Street Unit 6 8/7/2017 $158,750 0.0 Condominium 896 0 2 1-0
M 855 West Main Street Unit 7 8/7/2023 $226,000 0.0 Condominium 600 0 1 1-0
N 855 West Main Street Unit 8 12/16/2022 $240,000 0.0 Condominium 600 0 1 1-0
O 855 West Main Street Unit 9 3/31/2009 $120,000 0.0 Condominium 600 0 1 1-0
P 855 West Main Street Unit 10 6/10/2020 $1 0.0 Condominium 600 0 1 1-0
Q 855 West Main Street Unit 11 7/28/2011 $1 0.0 Condominium 1,040 0 2 1-1
R 855 West Main Street Unit 12 4/14/2017 $177,000 0.0 Condominium 1,040 0 2 1-1
S 855 West Main Street Unit 13 3/31/2008 $144,500 0.0 Condominium 840 0 2 1-0
T 855 West Main Street Unit 14 11/16/2015 $121,500 0.0 Condominium 840 0 2 1-0
U 855 West Main Street Unit 15 8/15/2023 $284,000 0.0 Condominium 840 0 2 1-0
V 855 West Main Street Unit 16 12/17/2019 $175,000 0.0 Condominium 840 0 2 1-0
W 855 West Main Street Unit 17 5/23/2002 $150,700 0.0 Condominium 1,152 0 2 1-1
X 855 West Main Street Unit 18 3/7/2019 $185,000 0.0 Condominium 1,152 0 2 1-1
Y 855 West Main Street Unit 19 11/5/2001 $89,950 0.0 Condominium 532 0 1 1-0
Z 855 West Main Street Unit 20 10/25/2018 $117,500 0.0 Condominium 532 0 2 1-0
- 855 West Main Street Unit 21 11/9/2018 $136,000 0.0 Condominium 532 0 1 1-0
- 855 West Main Street Unit 22 12/7/2020 $1 0.0 Condominium 532 0 1 1-0
- 563 Strawberry Hill Road 6/24/2011 $140,000 0.0 Ranch 1,648 0.24 3 2-0
- 581 Strawberry Hill Road 3/14/2002 $0 0.0 Ranch 832 0.23 2 1-0
- 546 Strawberry Hill Road 10/27/2017 $307,700 0.0 Cape Cod 1,030 0.23 2 1-0
- 591 Strawberry Hill Road 7/25/2016 $285,000 0.1 Ranch 1,576 0.23 3 2-0
- 549 Strawberry Hill Road 6/20/2013 $0 0.1 Ranch 756 0.43 2 1-0
- 104 Seagate Lane 5/24/2018 $370,000 0.1 Raised Ranch 1,044 0.23 3 2-0
- 825 West Main Street Unit 1 8/28/2014 $160,000 0.1 Condominium 1,054 0 2 1-1
- 825 West Main Street Unit 2 1/29/2013 $1 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 3 6/25/2015 $88,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 4 8/26/2024 $290,400 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 5 3/26/2012 $1 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 6 3/12/2015 $137,500 0.1 Condominium 1,054 0 2 1-1
- 825 West Main Street Unit 7 9/18/2020 $224,900 0.1 Condominium 1,054 0 2 1-1
- 825 West Main Street Unit 8 10/1/2004 $190,000 0.1 Condominium 1,054 0 2 1-1
- 825 West Main Street Unit 9 5/15/1984 $49,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 10 9/9/2016 $83,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 11 4/24/2014 $93,500 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 12 7/25/2002 $1 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 12A 4/14/2006 $189,500 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 14 6/3/2016 $1 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 15 12/29/2015 $117,500 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 16 2/5/2020 $1 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 17 1/16/2009 $0 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 18 3/1/2013 $79,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 19 11/29/2007 $1 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 20 1/15/2009 $94,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 21 9/28/2022 $282,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 22 8/18/2017 $142,000 0.1 Condominium 868 0 2 1-1
- 825 West Main Street Unit 23 12/20/2022 $295,000 0.1 Condominium 837 0 2 1-1
- 825 West Main Street Unit 24 1/19/2018 $155,000 0.1 Condominium 868 0 2 1-1
- 68 Kennesaw Avenue 4/5/2002 $190,000 0.1 Ranch 1,344 0.49 3 1-1
- 889 West Main Street 10/19/2018 $1,265,000 0.1 Office Bldg 6,545 0.7 0 0-
- 536 Strawberry Hill Road 5/16/2024 $485,000 0.1 Ranch 1,065 0.19 2 1-0
- 82 Kennesaw Avenue 11/21/1986 $84,000 0.1 Ranch 1,864 0.49 3 3-0
- 85 Seagate Lane 10/21/2002 $250,000 0.1 Cape Cod 1,192 0.23 3 2-0
- 601 Strawberry Hill Road 6/15/2017 $237,000 0.1 Ranch 1,464 0.28 4 1-1
- 537 Strawberry Hill Road 10/25/2017 $1 0.1 Ranch 948 0.27 2 1-0
- 114 Seagate Lane 12/23/2014 $100 0.1 Ranch 1,428 0.24 2 2-0
- 52 Kennesaw Avenue 7/1/2009 $203,000 0.1 Ranch 988 0.46 3 1-0
- 107 Seagate Lane 3/21/2017 $1 0.1 Colonial 2,106 0.23 3 3-0
- 98 Kennesaw Avenue 12/19/1960 $0 0.1 Ranch 1,802 0.59 4 2-0
- 57 Seagate Lane 9/12/2005 $347,000 0.1 Cape Cod 1,469 0.25 3 2-0
- 0 Strawberry Hill Road 10/25/2017 $1 0.1 Vacant Land 0.17 -
- 34 Bee Lane 5/8/2024 $540,000 0.1 Raised Ranch 804 0.3 2 2-0
- 815 West Main Street 6/15/1987 $250,000 0.1 Ret/Rest/Apt 4,640 0.29 0 2-
- 80 Childs Street 6/15/2012 $1 0.1 Modern/Contemp 2,024 0.45 3 2-0
- 47 Seagate Lane 7/25/2002 $0 0.1 Cape Cod 1,346 0.23 3 2-0
- 617 Strawberry Hill Road 5/16/2016 $100 0.1 Ranch 1,512 0.53 3 1-1
- 124 Seagate Lane 11/1/2011 $175,000 0.1 Raised Ranch 1,104 0.24 2 2-0
- 64 Childs Street 9/7/2022 $685,000 0.1 Cape Cod 2,203 0.45 4 3-0
- 119 Seagate Lane 5/23/2016 $350,000 0.1 Cape Cod 1,663 0.23 4 2-0
- 94 Childs Street 9/12/2014 $80,000 0.1 Cape Cod 3,032 0.45 4 3-0
- 523 Strawberry Hill Road 11/9/2020 $1 0.1 Ranch 876 0.46 2 1-0
- 830 West Main Street 8/8/2013 $1 0.1 Garage/Office 12,449 3.38 0 0-
- 801 West Main Street 9/15/1985 $150,000 0.1 Office Bldg 4,894 0.28 0 0-
- 35 Bee Lane 8/31/2016 $355,000 0.1 Ranch 2,000 0.22 3 2-0
- 48 Childs Street 2/22/2018 $297,000 0.1 Ranch 1,560 0.45 2 2-0
- 37 Seagate Lane 3/5/2020 $1 0.1 Antique 1,632 0.23 3 2-0
- 24 Bee Lane 6/15/1992 $82,500 0.1 Cape Cod 1,152 0.21 3 1-0
- 114 Childs Street 10/18/2023 $645,000 0.1 Cape Cod 1,907 0.45 3 2-0
- 136 Seagate Lane 2/3/2016 $100 0.1 Cape Cod 1,373 0.24 3 2-0
- 127 Seagate Lane 7/6/1999 $133,000 0.1 Cape Cod 1,346 0.23 3 1-1
- 905 West Main Street 12/12/2019 $306,000 0.1 Ranch 880 0.53 2 1-0
- 9 Pleasant Park Avenue Unit 1A 5/1/2017 $145,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1B 10/12/2017 $1 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1C 10/26/2018 $169,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1D 8/1/2001 $130,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1E 2/27/2012 $92,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1F 12/20/2004 $0 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1G 9/30/1998 $58,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1H 6/1/2017 $155,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 1I 12/31/2010 $1 0.1 Condominium 1,204 0 2 2-0
- 9 Pleasant Park Avenue Unit 2A 5/9/1997 $69,000 0.1 Condominium 1,204 0 2 2-0
- 9 Pleasant Park Avenue Unit 2B 4/1/2016 $1 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 2C 7/20/2015 $145,500 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 2D 10/16/2009 $125,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 2E 3/1/2001 $87,500 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 2F 12/2/2013 $115,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 2G 12/28/1998 $69,000 0.1 Condominium 982 0 2 2-0
- 9 Pleasant Park Avenue Unit 2H 4/26/2017 $140,000 0.1 Condominium 982 0 2 1-1
- 9 Pleasant Park Avenue Unit 2I 11/17/2009 $1 0.1 Condominium 982 0 2 2-0
- 38 Seagate Lane Unit A 8/30/2013 $93,000 0.1 Condominium 880 0 1 1-1
- 42 Seagate Lane Unit B 11/13/2012 $113,900 0.1 Condominium 880 0 2 1-1
- 46 Seagate Lane Unit C 9/15/1992 $46,240 0.1 Condominium 880 0 1 1-1
- 25 Bee Lane 5/8/2013 $1 0.1 Raised Ranch 1,620 0.23 4 3-0
- 71 Childs Street 6/6/2017 $408,000 0.1 Ranch 1,560 0.48 2 2-0
- 25 Seagate Lane 5/9/2017 $0 0.1 Cape Cod 1,586 0.23 3 2-0
- 795 West Main Street 4/21/2020 $1 0.1 Finan Inst. 2,530 0.19 4 2-12
- 89 Childs Street 6/29/2020 $352,000 0.1 Ranch 1,440 0.48 3 1-0
- 14 Bee Lane 4/27/2017 $1 0.1 Ranch 1,050 0.24 1 1-0
- 34 Childs Street 10/26/2018 $340,000 0.1 Ranch 1,025 0.46 3 1-0
Averages 4676 days $158,133 0.07 --- 1,359 0.17 --- ---  
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
249-164 554 Strawberry Hill Road