Great opportunity for rarely available multi-family duplex in Berlin. Very well maintained. Perfect for investor or owner-occupy. Each side offers 2 bedrooms and one full bath. Separate private driveways for each unit. Natural gas heating and hot water. Newer appliances. Single car garage. Close to all major highways and shopping. WON'T LAST!!! Please note: House is marked 248-250 Fairview Drive for postal purposes only. Entire property is 248 Fairview Drive on tax records.
- MLS# 170152469
- Date Listed01/04/2019
- Bedrooms 4
- Bathrooms 2 Full baths
- Lot Size 0.14 acres (6,098 sq. ft)
- Sewer Public Sewer
- Property Type Duplex
- County Hartford
- Year Built 1942
- Water Public
- Square Feet 1,632 sq. ft
- Price Per Sq. Ft $151.96
Interior Features
- Appliances Gas Water Heater
- Cooling None
- Heating Natural Gas, Forced Air
Exterior / Lot Features
- Roof Asphalt
- Lot Size Acres 0.14
- Lot Size SQFT 6,098.40
- Lot Features Corner Lot
Directions
Porters Pass to Fairview Drive
Financial Considerations
- Tax Amount $4,316
- Terms Cash, Conventional, FHA, VA Loan
Nearby Schools
Source: School Digger
Public • PK - 5 • Serves this home
1.33 mi
Distance
Catherine M. Mcgee Middle School
Public • 6 - 8 • Serves this home
1.33 mi
Distance
Public • 9 - 12 • Serves this home
1.36 mi
Distance
Public • PK - 5 • Serves this home
1.33 mi
Distance
Roosevelt Early Learning Center
Public • PK - PK
3.73 mi
Distance
Public • PK - 4
3.91 mi
Distance
Public • PK - 4
5.84 mi
Distance
Public • PK - 5
6.22 mi
Distance
Public • PK - 5
7.12 mi
Distance
Public • PK - 5
7.17 mi
Distance
Academy Of Aerospace & Engineering Elementary
Public • PK - 5
7.21 mi
Distance
Public • PK - 2
7.3 mi
Distance
Public • PK - 12
7.92 mi
Distance
Catherine M. Mcgee Middle School
Public • 6 - 8 • Serves this home
1.33 mi
Distance
Public • 7 - 12
2.02 mi
Distance
House Of Arts Letters And Science (hals) Academy
Public • 6 - 8
3.73 mi
Distance
Public • 5 - 8
4.19 mi
Distance
Public • 6 - 8
4.88 mi
Distance
Academy Of Science And Innovation
Public • 6 - 12
6.22 mi
Distance
Public • 6 - 8
7.19 mi
Distance
Public • 6 - 8
7.19 mi
Distance
Public • 3 - 5
7.3 mi
Distance
Public • 6 - 6
7.77 mi
Distance
Public • 9 - 12 • Serves this home
1.36 mi
Distance
Public • 9 - 12
2.49 mi
Distance
Public • 10 - 13
4.51 mi
Distance
Public • 9 - 12
6.83 mi
Distance
E. C. Goodwin Technical High School
Public • 9 - 12
7.01 mi
Distance
Public • 9 - 12
7.54 mi
Distance
Public • 9 - 12
7.77 mi
Distance
Private • 03 - 12
2.74 mi
Distance
Private • 01 - 12
3.08 mi
Distance
Private • PK - 12
4.87 mi
Distance
Private • 03 - 12
7.23 mi
Distance
Mountain Laurel Sudbury School
Private • UG - UG
7.24 mi
Distance
Sales & Tax History
Source: Public Records
| Street Address | Beds | Baths | Sold Date | List Price |
|---|---|---|---|---|
| 577 Maple Hill Avenue | 3 | 1 | Oct 24, 2025 | $349,900 |
| 81 Club Drive | 3 | 3 | Oct 22, 2025 | $679,900 |
| 461 Maple Hill Avenue | 3 | 2 | Oct 15, 2025 | $449,900 |
| 291 East Street | 3 | 2 | Oct 15, 2025 | $260,000 |
| 124 Cedarwood Drive | 4 | 4 | Oct 15, 2025 | $475,000 |
| 64 Frederick Street | 3 | 2 | Oct 15, 2025 | $299,900 |
| 255 Church Street | 3 | 2 | Oct 15, 2025 | $349,900 |
| 66 Fawn Drive | 3 | 2 | Oct 15, 2025 | $439,900 |
| 184 Clark Street | 3 | 2 | Nov 21, 2025 | $244,900 |
| 37 Sage Drive | 3 | 3 | Oct 15, 2025 | $449,500 |
Population & Environment
Source: Sperling's Best Places
| Zip | City | County | National | |
|---|---|---|---|---|
| Population | 19,287 | 20,699 | 913,900 | 335,858,263 |
| Population Density | 762 | 786 | 1,243 | 95 |
| People per Household | 2.5 | 2.5 | 2.5 | 2.6 |
| Median Age | 48.4 | 48.7 | 42 | 39.1 |
| Median Income | $104,389 | $102,787 | $77,593 | $66,222 |
| Average Income | $49,733 | $49,278 | $41,527 | $35,475 |
| Cost of Living Index | 113 | 113 | 103 | 100 |
| Zip | City | County | National | |
|---|---|---|---|---|
| January Avg. High Temp | 20.3°F | 20.3°F | 16.3°F | 22.6°F |
| July Avg. High Temp | 84.2°F | 84.2°F | 83.8°F | 86.2°F |
| Annual Precipitation | 51.6" | 52.15" | 56.93" | 38" |
55/100
Somewhat Walkable
Walk Score ®
43/100
Bikable
Bike Score ®
Overview
Some errands can be accomplished on foot. It is possible to get on a bus. Minimal bike infrastructure.Walkability averages in the surrounding area
The average walkability score in the surrounding area is Walk Score: 23/100, Transit Score: 7/100, Bike Score: 24/100.
Property Change History
Points of Interest near 248 Fairview Drive, Berlin, CT 06037
898 ft
Distance
0.2 mi
Distance
0.2 mi
Distance
0.22 mi
Distance
0.22 mi
Distance
0.22 mi
Distance
0.23 mi
Distance
0.24 mi
Distance
0.24 mi
Distance
0.24 mi
Distance
0.25 mi
Distance
898 ft
Distance
0.2 mi
Distance
0.22 mi
Distance
0.24 mi
Distance
0.24 mi
Distance
0.25 mi
Distance
898 ft
Distance
0.22 mi
Distance
0.24 mi
Distance
0.24 mi
Distance
0.24 mi
Distance
0.23 mi
Distance
0.25 mi
Distance
475 ft
Distance
0.23 mi
Distance
0.25 mi
Distance
898 ft
Distance
0.24 mi
Distance
0.23 mi
Distance
0.23 mi
Distance
0.2 mi
Distance
0.23 mi
Distance
0.24 mi
Distance
Nearby Properties
-
$279,900 Active3 bds • 3 ba • 1,725 sqft
235 High Street APT C, New Britain, CT 06051
introducing this 3 bed, 2.5 bath 1388 sq ft condo that features NO HOA! Detached 2 car garage sits behind the units. Walk into your front entrance and you're greeted by your hardwood floor living room. The kitchen features all new appliances adjacent...Listing by: Mike Robinson - Century 21 AllPoints Realty -
$285,000 Active4 bds • 1 ba • 1,554 sqft
1403 Stanley Street, New Britain, CT 06053
Step into a home full of charm and character! This inviting 4-bedroom, 1-bathroom gem offers the perfect blend of comfort and versatility, with rooms that can adapt to your needs-whether it's a cozy office, creative space, or more. Picture yourself s...Listing by: Lisa Elsinger - ERA Treanor Real Estate -
$239,900 Active Under Contract3 bds • 3 ba • 1,832 sqft
27 Chestnut Court 27, Cromwell, CT 06416
Rarely available End-unit Townhouse, updated & move-in ready! This beautifully updated end-unit townhouse offers a spacious and functional layout with plenty of natural light. The kitchen features granite countertops, tile flooring, a stylish backspl...Listing by: Annie Gura - Coldwell Banker Premier Real Estate -
$275,000 Active2 bds • 2 ba • 1,758 sqft
8 Mohawk Court, Cromwell, CT 06416
This 2 bedroom townhouse is stunning. Everything is updated and immaculate! When entering you immediately feel how welcoming and inviting it is. The remodeled white kitchen is beautiful and has stainless steel appliances, a gas stove, and very large...Listing by: Donna-jean Dargie - Eagle Eye Realty PLLC -
$269,999 Active3 bds • 1 ba • 1,395 sqft
35 Morse Street, Meriden, CT 06450
Welcome to 35 Morse Street, a charming Meriden home tucked into a quiet neighborhood that balances comfort, convenience, and classic New England living. Step inside to a warm, inviting layout where natural light fills each room. The living area off...Listing by: Alan Stewart Jr - ASJ Realty Partners -
$225,000 Active Under Contract2 bds • 3 ba • 1,782 sqft
543 South Farms Terrace 543, Southington, CT 06489
Welcome to this 2 Bedroom, 2.5 Bath Townhouse in beautiful Spring Lake Village, an active 55+ community. Enjoy the comfortable, open floor plan with Living Room and Dining Room boasting vaulted ceilings with beams, skylights, wood burning fireplace a...Listing by: Philip Giampietro - Coldwell Banker Realty -
$272,000 Active Under Contract2 bds • 2 ba • 1,458 sqft
68 Mattabasset Drive 68, Meriden, CT 06450
Welcome home to Mattabasset - where everyday living feels a little more relaxed. This beautifully cared-for condo offers the perfect blend of comfort, style, and low-maintenance living. The spacious living room opens to a private deck overlooking a p...Listing by: Debbie Huscher - Real Broker CT, LLC -
$264,900 Active Under Contract2 bds • 2 ba • 1,440 sqft
16 Brookside Drive, Southington, CT 06489
Welcome to this charming 2-bedroom, 2-bathroom ranch-style mobile home located on a corner lot in the desirable Sun Communities 55+ community. This home is move-in ready, has been freshly painted, and features new flooring throughout most of the home...Listing by: Joey McVety - mygoodagent -
$225,000 Active Under Contract3 bds • 1 ba • 1,474 sqft
11 Fairwood Farms Drive, West Hartford, CT 06107
Nestled in one of West Hartford's most desirable neighborhoods, this 3-bedroom brick ranch offers timeless charm and endless potential. Step inside to find hardwood floors throughout, a sun-filled living room with fireplace, and sliders leading to a...Listing by: David Pilon - KW Legacy Partners -
$259,900 Active3 bds • 1 ba • 1,522 sqft
55 Hanmer Street, East Hartford, CT 06114
Welcome home to this classic New England-style property filled with charm, character, and incredible potential. Enter through the traditional formal entryway and enjoy a warm, functional layout featuring an inviting eat-in kitchen, a formal dining ro...Listing by: Robert Rosa - Berkshire Hathaway NE Prop. -
$279,999 Active4 bds • 2 ba • 1,415 sqft
10 Silver Street, Middletown, CT 06457
Be Home for the Holidays! A fresh new chapter begins at 10 Silver Street, where a brand-new kitchen renovation transforms the heart of this Middletown home. The modern, new design features crisp white cabinetry, soft-close drawers, granite counters w...Listing by: Sacha Armstrong - William Pitt Sotheby's International Realty -
$229,900 Active Under Contract2 bds • 2 ba • 1,414 sqft
90 Kane Street APT D10, West Hartford, CT 06119
For Sale - $229,900 Spacious 2-Bedroom Penthouse with Loft, Balcony, Roof Deck & Separate standing Garage Prime West Hartford Location Discover a rare opportunity to own a sun-filled 2-bedroom, 2-bathroom Penthouse in a secure, well-maintained gate...Listing by: Ilya Tsvok - Partnership Realty -
$229,900 Active Under Contract3 bds • 2 ba • 1,414 sqft
100 Kane Street APT D10, West Hartford, CT 06119
A property like this rarely becomes available. Here is you chance!Listing by: Rick McCullough - R.A. McCullough Homes, LLC -
$279,900 Active Under Contract2 bds • 3 ba • 1,449 sqft
753 Long Hill Road A, Middletown, CT 06457
Beautifully Located End-Unit Condo in the Desirable Long Hill Road Community! This 2-bedroom, 2.5-bath condo with a 1-car garage offers both convenience and comfort. Enjoy a spacious open layout with a kitchen featuring bar seating that flows seamles...Listing by: Tracy Cooley - Berkshire Hathaway NE Prop. -
$275,000 Active2 bds • 3 ba • 1,408 sqft
1325 Farmington Avenue APT 2, Bristol, CT 06010
This inviting two-bedroom, one-and-a-half-bath condo offers comfort and convenience in a desirable location. Enjoy a cozy living room with a fireplace, perfect for relaxing evenings, and a private deck ideal for outdoor dining or morning coffee. The...Listing by: Brittany Russell - Tier 1 Real Estate -
$270,000 Active4 bds • 2 ba • 1,630 sqft
376 Deercliff Road, Avon, CT 06001
This is a AS-IS, 2.22-acre lot in Avon with endless potential. Located at 376 Deercliff Road, this property was previously home to a 4-bedroom, 2-bath residence with over 1,600 square feet. The structure has been fully gutted, with the roof and chimn...Listing by: Alexander King - Lock and Key Realty, Inc -
$240,000 Active3 bds • 1 ba • 1,462 sqft
18 Lincoln Street, East Hartford, CT 06108
Welcome Home to East Hartford's! Tucked away on a quiet cul-de-sac, this charming Cape Cod offers 3 spacious bedrooms and 1 full bathroom-perfect for comfortable and functional living. Step inside to find gleaming tile flooring that will bring warmth...Listing by: Eli Joseph - eXp Realty -
$259,000 Active3 bds • 2 ba • 1,503 sqft
41 Bissell Street, East Hartford, CT 06108
Whether you're an investor or an owner-occupant, this versatile two-family home offers solid potential in a central location. The first-floor unit features 2 bedrooms and 1 full bath, while the second-floor unit offers a cozy 1 bedroom, 1 bath setup-...Listing by: Meagan Albert - Tier 1 Real Estate -
$250,000 Active3 bds • 2 ba • 1,715 sqft
27 Olmsted Street, East Hartford, CT 06108
Endless Potential in this Classic Colonial - Investor & DIY Opportunity This spacious 1890 Colonial offers 3 generously sized bedrooms, 1.5 bathrooms, and over 1,700 sq ft of living space-all ready for your updates and vision. Whether you're an inve...Listing by: Krystal Bariffe - Tier 1 Real Estate -
$279,900 Active3 bds • 2 ba • 1,746 sqft
75 Cleveland Avenue, Hartford, CT 06120
Welcome to 75 Cleveland Ave in Hartford, a beautifully renovated colonial-style home combining classic charm with modern updates. This spacious residence offers 3 bedrooms, 2 full baths, and over 1,700 sq ft of comfortable living space. Step inside t...Listing by: Mahadeo Ajodhi - Vylla Home (CT) LLC
Similar Priced Comparison
-
$250,000 Activebds • 2 ba • 1908 sqft
363 New Britain Road A
- Home larger by 276 sqft
- Lot smaller by 6,099 sqft
- Newer by 48 years
Listing by: Nadia Kachwaha - KW Legacy Partners -
$299,900 Active Under Contract3 bds • 2 ba • 1314 sqft
31 Glendale Avenue
- Home smaller by 318 sqft
- Lot larger by 3,050 sqft
- Newer by 13 years
Listing by: Amy Bartolucci - Coldwell Banker Realty -
$254,900 Active Under Contract3 bds • 1 ba • 1196 sqft
28 Kulper Road
- Home smaller by 436 sqft
- Lot larger by 872 sqft
- Newer by 17 years
Listing by: Patrick Garrett - Complete Real Estate -
$225,000 Active Under Contract3 bds • 1 ba • 1355 sqft
27 Konstin Place
- Home smaller by 277 sqft
- Lot larger by 1,307 sqft
- Older by 17 years
Listing by: Evan Berman - William Raveis Real Estate -
$299,999 Active Under Contract6 bds • 2 ba • 1752 sqft
44 Brook Street
- Home larger by 120 sqft
- Lot larger by 4,356 sqft
- Older by 18 years
Listing by: Eric Pierce - ERIS, LLC -
$259,900 Active Under Contract3 bds • 2 ba • 1280 sqft
270 Maple Street
- Home smaller by 352 sqft
- Lot larger by 2,614 sqft
- Older by 62 years
Listing by: Brian Barbosa Barbosa - Legacy Private Client Group -
$229,000 Active Under Contract2 bds • 1 ba • 1004 sqft
83 Henry Street
- Home smaller by 628 sqft
- Lot larger by 7,406 sqft
- Newer by 6 years
Listing by: Richard Dale - Realty ONE Group Connect -
$224,900 Active2 bds • 1 ba • 896 sqft
66 Henry Street
- Home smaller by 736 sqft
- Lot larger by 1,307 sqft
- Newer by 10 years
Listing by: Robert Rosa - Berkshire Hathaway NE Prop. -
$199,900 Activebds • 0 ba • sqft
Slope South Drive
- Home smaller by 1,632 sqft
- Lot larger by 537,531 sqft
- Unknown year built
Listing by: Frank Fonteyn - Prestige Realty Group -
$299,000 Active3 bds • 2 ba • 1410 sqft
11 George Street
- Home smaller by 222 sqft
- Lot larger by 436 sqft
- Newer by 64 years
Listing by: Nancy Newman - LPT Realty -
New$289,000 Active3 bds • 2 ba • 1312 sqft
385 Columbus Boulevard
- Home smaller by 320 sqft
- Lot larger by 2,178 sqft
- Older by 72 years
Listing by: Shari Jones - Coldwell Banker Realty -
$189,000 Activebds • 0 ba • sqft
212 Church Street
- Home smaller by 1,632 sqft
- Lot larger by 33,542 sqft
- Unknown year built
Listing by: Donald Pac - Century 21 North East -
$310,000 Active3 bds • 1 ba • 1454 sqft
488 Church Street
- Home smaller by 178 sqft
- Same size
- Older by 37 years
Listing by: Cindi Carranza Estrada - eRealty Advisors, Inc. -
$299,800 Active6 bds • 3 ba • 2210 sqft
11 Dwight Court
- Home larger by 578 sqft
- Lot smaller by 436 sqft
- Older by 42 years
Listing by: Michael Truong - eXp Realty -
$240,000 Active Under Contract2 bds • 1 ba • 1190 sqft
19 Sunny Brook Drive
- Home smaller by 442 sqft
- Same size
- Newer by 42 years
Listing by: Jody Viola - The Joseph J. Gustin Company -
$219,990 Active Under Contract2 bds • 2 ba • 768 sqft
151 Smalley Street
- Home smaller by 864 sqft
- Lot smaller by 1,743 sqft
- Newer by 17 years
Listing by: Kostas Travisano - Sailpoint Property Group -
$299,900 Active Under Contract3 bds • 1 ba • 1096 sqft
11 Eleanor Place
- Home smaller by 536 sqft
- Lot smaller by 1,307 sqft
- Older by 92 years
Listing by: Roger Veilleux - William Raveis Real Estate -
$305,000 Active4 bds • 2 ba • 1783 sqft
66 Lincoln Street
- Home larger by 151 sqft
- Lot larger by 5,663 sqft
- Older by 42 years
Listing by: Diana Paccha - eXp Realty -
$190,000 Active Under Contract2 bds • 1 ba • 768 sqft
21 7th Street
- Home smaller by 864 sqft
- Lot smaller by 2,614 sqft
- Newer by 12 years
Listing by: Kathleen Freeman - Berkshire Hathaway NE Prop. -
$275,000 Activebds • 0 ba • sqft
2950 Berlin Turnpike
- Home smaller by 1,632 sqft
- Lot larger by 241,323 sqft
- Unknown year built
Listing by: Brittany Skorupski-Williams - Parker Benjamin Real Estate Se
Nearby Locations
Communities
- South Meriden Homes For Sale
- Tracy Homes For Sale
- Griswoldville Homes For Sale
- Wells Quarter Homes For Sale
- Southwest Homes For Sale
- Behind The Rocks Homes For Sale
- Dutch Point Colony Homes For Sale
- SoDo Homes For Sale
- Roland Heights Homes For Sale
- Css Con Homes For Sale
- Blue Hills Homes For Sale
- Bucks Hill Homes For Sale
- Ardmore in Burnt Hills Homes For Sale
- Northeast Homes For Sale
- Town Center Homes For Sale
- Beecher Heights Homes For Sale
- Augerville Homes For Sale
- Greystone Homes For Sale
- Miracle Mile Homes For Sale
- Spring Glen Homes For Sale
Nearby Zips
- 06037 Homes For Sale
- 06052 Homes For Sale
- 06451 Homes For Sale
- 06450 Homes For Sale
- 06051 Homes For Sale
- 06489 Homes For Sale
- 06053 Homes For Sale
- 06062 Homes For Sale
- 06111 Homes For Sale
- 06032 Homes For Sale
- 06410 Homes For Sale
- 06416 Homes For Sale
- 06492 Homes For Sale
- 06110 Homes For Sale
- 06067 Homes For Sale
- 06457 Homes For Sale
- 06107 Homes For Sale
- 06010 Homes For Sale
- 06109 Homes For Sale
- 06085 Homes For Sale
Nearby Cities
- Berlin, CT Homes for Sale
- Kensington, CT Homes for Sale
- Meriden, CT Homes for Sale
- New Britain, CT Homes for Sale
- Southington, CT Homes for Sale
- Plainville, CT Homes for Sale
- Newington, CT Homes for Sale
- Farmington, CT Homes for Sale
- Cheshire, CT Homes for Sale
- Cromwell, CT Homes for Sale
- Wallingford, CT Homes for Sale
- Rocky Hill, CT Homes for Sale
- Wallingford Center, CT Homes for Sale
- Middletown, CT Homes for Sale
- Bristol, CT Homes for Sale
- Wethersfield, CT Homes for Sale
- West Hartford, CT Homes for Sale
- Wolcott, CT Homes for Sale
- Durham, CT Homes for Sale
- Avon, CT Homes for Sale
Similar Searches
- Berlin Land for Sale
- Berlin New Homes for Sale
- Berlin Single Story Homes for Sale
- Berlin Homes with Pools for Sale
- Berlin Cheap Homes for Sale
- Berlin Luxury Homes for Sale
- Berlin Condos for Sale
- Berlin Town Homes for Sale
- Berlin Commercial for Sale
- Berlin Open Houses for Sale
- Berlin Two Car Garage Homes for Sale
- Berlin Large Lots for Sale
- National Listings
- National Home Values
- Properties in CT
- Home Values in CT
- Other properties in Hartford, CT
- Other properties in 06037, CT
- Home Values in Berlin, CT
Frequently Asked Questions for 248 Fairview Drive
Source: Realty.com
248 Fairview Drive, Berlin, CT 06037 is a Duplex, Residential Income property listed for $248,000 The property is 1632 sq. ft with 4 bedrooms and 2 bathrooms
Realty.com has 11 photos of 248 Fairview Drive.
Our records indicate that 248 Fairview Drive was built in 1942.
The full address for this home is 248 Fairview Drive, Berlin, CT 06037.
248 Fairview Drive has been listed on Realty.com since Fri January 04, 2019
Some errands can be accomplished on foot. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 23/100, Transit Score: 7/100, Bike Score: 24/100.
There are 3 schools assigned to this home. Check out the schools near 248 Fairview Drive. Emma Hart Willard School (Grades: PK - 5), Catherine M. Mcgee Middle School (Grades: 6 - 8), Berlin High School (Grades: 9 - 12)
Listing provided courtesy of:
Re/max Precision Realty
(tel: 860-808-2000)
Listing agent:
Michael Gashgorian
(tel: 860-808-2000)
(#GASHGORM)
This content last refreshed on 2025-11-30 01:47:39. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 248 Fairview Drive, Berlin, CT 06037 : MLS# 170152469