5 Saint Andrews Rd, Bloomfield, CT 06002

Off market apr 2016 for $278K

$542,667

•

6,303

sq ft

5 Saint Andrews Rd, Bloomfield, CT 06002

About this home

Live and work in this mid-century modern 3 bedroom converted commercial building space. The home offers many unique industrial features including a 55X40 work studio, an extra large lower level basement that's ideal for storage or workshop. The home sits on 3.4 secluded, wooded acres and is set back from the road. Fully applianced updated eat-in kitchen, large common area, multiple offices and work spaces. Town allows owner occupant to operate a business.

Single-familyProperty Type

1957Year Built

3.4 acresLot Size

$86Est. Price/Sq.Ft.

Listed by Tony Opalenik • William Raveis Real Estate

Bought with Non Member • SmartMLS II, Inc.

Source:Smart MLS #G10073183

Redfin Estimate

$542,667

$265K since sold in April 2016$9,000 since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 9.9% higher than the average sale price ($494K) of 6 comparable homes.

SOLD JUL 30, 2026
$405,000
A
3 beds2.5 baths2,754 sq ft
2 Barn Hill Rd, Bloomfield, CT 06002
SOLD SEP 4, 2026
$554,000
B
3 beds2 baths2,106 sq ft
201 S Main St, East Granby, CT 06026
SOLD SEP 21, 2026
$475,000
C
3 beds2.5 baths3,126 sq ft
10 Penwood Rd, Bloomfield, CT 06002
SOLD SEP 4, 2026
$480,000
D
3 beds2.5 baths2,380 sq ft
11 Concord Dr, East Granby, CT 06026
SOLD AUG 20, 2026
$500,000
E
3 beds2 baths1,680 sq ft
207 S Main St, East Granby, CT 06026
SOLD AUG 24, 2026
$550,000
F
3 beds2.5 baths1,956 sq ft
11 Lexington Dr, East Granby, CT 06026

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$337,433

Est. take-home

List your home with Redfin and save $5,427

Rent

$2,860/mo

Redfin rental estimate

List your home for rent

Market trends in 06002, CT

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

102.9%

2.9% MoM

Median sale price

$375K

$35K MoM

Avg. days on market

45d

10 days MoM

Recently sold homes

12 MoM

New listings for sale

$399,500
4 beds2.5 baths1,365 sq ft
29 Crestview Dr, Bloomfield, CT 06002
$643,000
5 beds2 baths2,300 sq ft
9 Loeffler Rd, Bloomfield, CT 06002
OPEN NOV 16, 1PM TO 3PM
$699,900
4 beds4.5 baths2,705 sq ft
12 Penwood Rd, Bloomfield, CT 06002
$299,000
4 beds1.5 baths1,999 sq ft
6 Livingstone Rd, Bloomfield, CT 06002
$260,000
3 beds1 bath1,950 sq ft
5 Mayfair Ct, Bloomfield, CT 06002
$360,000
3 beds2 baths1,888 sq ft
28 Diana Dr, Bloomfield, CT 06002
3D WALKTHROUGH
$475,000
3 beds2.5 baths2,568 sq ft
1 Butternut Dr, Bloomfield, CT 06002
See all

Provided by Redfin

Sale history for 5 Saint Andrews Rd

Year

Property tax

Land + Additions

Assessment*

2025

$9,384 (+26.0%)

$59,780 + $190,450

$250,230

2024

$7,449 (+1.8%)

$46,690 + $143,150

$189,840

2023

$7,315 (+6.9%)

$46,690 + $143,150

$189,840

2022

$6,840 (−2.2%)

$46,690 + $143,150

$189,840

2021

$6,992 (+1.6%)

$46,690 + $143,150

$189,840

2020

$6,884 (−6.2%)

$46,690 + $143,150

$189,840

2019

$7,339 (−8.9%)

$46,690 + $143,150

$189,840

2018

$8,056 (+0.1%)

$46,900 + $161,700

$208,600

2017

$8,044 (−22.1%)

$46,900 + $161,700

$208,600

2016

$10,326 (−13.4%)

$54,250 + $220,010

$274,260

2014

$11,926 (+2.3%)

$65,940 + $267,750

$333,690

2011

$11,659

$65,940 + $267,750

$333,690

Tax history for 5 Saint Andrews Rd

Year

Property tax

Land + Additions

Assessment*

2025

$9,384 (+26.0%)

$59,780 + $190,450

$250,230

2024

$7,449 (+1.8%)

$46,690 + $143,150

$189,840

2023

$7,315 (+6.9%)

$46,690 + $143,150

$189,840

2022

$6,840 (−2.2%)

$46,690 + $143,150

$189,840

2021

$6,992 (+1.6%)

$46,690 + $143,150

$189,840

2020

$6,884 (−6.2%)

$46,690 + $143,150

$189,840

2019

$7,339 (−8.9%)

$46,690 + $143,150

$189,840

2018

$8,056 (+0.1%)

$46,900 + $161,700

$208,600

2017

$8,044 (−22.1%)

$46,900 + $161,700

$208,600

2016

$10,326 (−13.4%)

$54,250 + $220,010

$274,260

2014

$11,926 (+2.3%)

$65,940 + $267,750

$333,690

2011

$11,659

$65,940 + $267,750

$333,690

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

1.5

Stories

Lot width

—

Lot depth

—

Lot size

3.4 Acres

Year renovated

—

Sq. Ft.

3,993

Year built

1957

Style

Single Family Residential

County

Hartford County

APN

2212950

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 10, 2026.

Property details

Parking

Garage Information
Garage & Parking: Parking Lot

Interior

Interior Information
Total Rooms: 6
Laundry Room Location: Lower Level
Interior Features: Cable - Available
In-Law Apartment: No
Fireplaces Total: 3
Appliances Included: Dishwasher, Electric Range, Electric Cooktop, Refrigerator

Bathroom Information
# of Baths (Full): 2
# of Baths (Half): 1

Bedroom Information
Beds Total: 3

Room Information
Basement Description: Full, Partially Finished, Unfinished

Exterior

Exterior Features
Exterior Siding: Brick

Lot Information
Lot Description: Secluded, Treed

Building Information
Color: Brick

Property Information
Property Type: Single Family For Sale
Driveway Type: Gravel

Financial

Assessments Information
Assessed Value: $333,690

Rental Information
Lease Purchase YN: No

Utilities

Utility Information
Water Source: Public Water Connected
Sewage System: Septic
Hot Water Description: Electric
Heat Type: Radiator
Heat Fuel Type: Oil
Fuel Tank Location: In Ground
Energy Features: Thermopane Windows

Location

School Information
High School: Boe
Elementary School: Boe

Location Information
State: Connecticut
Directions: Rte 189 to tarriffville to st. Andrews
County: Hartford

Public facts

Beds: 3
Baths: 1.5
Sq. Ft.: 3,993
Stories: 1.0
Lot Size: 3.4 acres
Style: Single Family Residential
Year Built: 1957
Year Renovated: —
County: Hartford County
APN: 2212950

Home facts updated by county records on Jul 10, 2026

Other

Documents & Disclosures
Supplement Count Public: 2

Around this home

Schools

K - 12
Preschool & daycare

Laurel School

Public PreK-2 • Assigned • 4.3mi

Carmen Arace Middle School

Public 7-8 • Assigned • 5.2mi

3/10

Bloomfield High School

Public 9-12 • Assigned • 4.8mi

4/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Historical weather

Bloomfield, CT • 06002

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9 hours in June and 4.4 hours in December, placing it below the U.S. average for solar exposure.

9 hrs

4.4 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$516,000 – $625,000

Reach more buyers when you sell with Redfin. Save up to $5,427 in fees. 3 minutes to get started.

Get a free, detailed breakdown of how we calculated your estimate.

Nearby similar homes

$334,900

4 beds2 baths2,076 sq ft

16 Griffin Rd S, Bloomfield, CT 06002

1.5 acres • Remodeled • Functional layout

$499,900

4 beds2.5 baths2,120 sq ft

15 Butternut Dr, Bloomfield, CT 06002

Fireplace • Spacious yard • Updated throughout

NEW CONSTRUCTION

$549,900

3 beds2.5 baths1,480 sq ft

Lot 2 Cambridge Ct, Simsbury, CT 06070

Open-concept layout • Granite countertops • Peninsula island

$699,000

4 beds2.5 baths2,184 sq ft

5 Sanctuary Dr, Simsbury, CT 06070

New kitchen • Custom cabinetry • Pantry storage

$450,000

3 beds2 baths2,370 sq ft

34 Hoskins Rd, Bloomfield, CT 06002

Main level garage • Remodeled kitchen • Granite counters

NEW CONSTRUCTION

$589,000

3 beds2.5 baths1,742 sq ft

69 Cambridge Ct, Simsbury, CT 06070

Open-concept living • Custom finishes • Granite countertops

New listings for sale in 06002

$399,500

4 beds2.5 baths1,365 sq ft

29 Crestview Dr, Bloomfield, CT 06002

Spacious lot • Dedicated office • Remodeled kitchen

$643,000

5 beds2 baths2,300 sq ft

9 Loeffler Rd, Bloomfield, CT 06002

Private lot • Hardwood flooring • Multiple fireplaces

OPEN NOV 16, 1PM TO 3PM

$699,900

4 beds4.5 baths2,705 sq ft

12 Penwood Rd, Bloomfield, CT 06002

1.09 acres • Borders simsbury • Mature trees

$299,000

4 beds1.5 baths1,999 sq ft

6 Livingstone Rd, Bloomfield, CT 06002

0.38 acre lot • 2 garage spots • Built 1952

$260,000

3 beds1 bath1,950 sq ft

5 Mayfair Ct, Bloomfield, CT 06002

Newer windows • Heating system • Electrical

$360,000

3 beds2 baths1,888 sq ft

28 Diana Dr, Bloomfield, CT 06002

Quiet street • Cul de sac • Large backyard

3D WALKTHROUGH

$475,000

3 beds2.5 baths2,568 sq ft

1 Butternut Dr, Bloomfield, CT 06002

Newer vinyl siding • Generous backyard • Lovely gardens

Home values near 5 Saint Andrews Rd

Data from public records.

Address	Redfin Estimate
74 Tariffville Rd, Bloomfield, CT 4 Beds \| 2.5 Baths \| 2165 Sq. Ft.	$499,280
23 Hoskins Rd, Bloomfield, CT 2 Beds \| 1.5 Baths \| 1624 Sq. Ft.	$403,456
26 Hoskins Rd, Bloomfield, CT 3 Beds \| 3 Baths \| 1722 Sq. Ft.	$449,971
75 Tariffville Rd, Bloomfield, CT 3 Beds \| 3.5 Baths \| 4570 Sq. Ft.	$701,934
74 Tariffville Rd, Bloomfield, CT 4 Beds \| 2.5 Baths \| 2165 Sq. Ft.	$428,437
16 Hoskins Rd, Bloomfield, CT 2 Beds \| 1 Baths \| 1144 Sq. Ft.	$295,995
74 Tariffville Rd, Bloomfield, CT 4 Beds \| 2.5 Baths \| 2165 Sq. Ft.	$476,686

Address	Redfin Estimate
68 Tariffville Rd, Bloomfield, CT 3 Beds \| 2.5 Baths \| 1604 Sq. Ft.	$504,779
22 Hoskins Rd, Bloomfield, CT 3 Beds \| 1 Baths \| 1584 Sq. Ft.	$331,871
27 Hoskins Rd, Bloomfield, CT 4 Beds \| 2.5 Baths \| 3245 Sq. Ft.	$557,502
52 Tariffville Rd, Bloomfield, CT 3 Beds \| 1.5 Baths \| 1688 Sq. Ft.	$370,396
27 Hoskins Rd, Bloomfield, CT 4 Beds \| 2.5 Baths \| 3245 Sq. Ft.	$586,012
28 Hoskins Rd, Bloomfield, CT 3 Beds \| 2 Baths \| 2126 Sq. Ft.	$425,807
52 Tariffville Rd, Bloomfield, CT 3 Beds \| 2 Baths \| 1688 Sq. Ft.	$369,086

Address	Redfin Estimate
16 Hoskins Rd, Bloomfield, CT 2 Beds \| 1 Baths \| 1144 Sq. Ft.	$262,402
24 Hoskins Rd, Bloomfield, CT 3 Beds \| 2 Baths \| 2160 Sq. Ft.	$398,239
76 Tariffville Rd, Bloomfield, CT 3 Beds \| 2 Baths \| 2058 Sq. Ft.	$460,654
0 Hoskins Rd, Bloomfield, CT - Beds \| - Baths \| - Sq. Ft.	$221,576
23 Hoskins Rd, Bloomfield, CT 2 Beds \| 1.5 Baths \| 1624 Sq. Ft.	$381,817
22 Hoskins Rd, Bloomfield, CT 3 Beds \| 1 Baths \| 1584 Sq. Ft.	$308,477
75 Tariffville Rd, Bloomfield, CT 3 Beds \| 3.5 Baths \| 4570 Sq. Ft.	$711,800

Property information provided by Smart MLS when last listed in 2015. This data may not match . 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.

Houses for rent in Hartford County	Agents near me	Westport, CT homes for sale	Hartford County Housing Market
Houses for sale near me	Greenwich, CT homes for sale	New Haven, CT homes for sale
Land for sale near me	Stamford, CT homes for sale	Milford, CT homes for sale
Open Houses near me	West Hartford, CT homes for sale	Hartford County Property Records
Condos for sale near me	Norwalk, CT homes for sale	CT New Listings

Worcester County homes for sale
Fairfield County homes for sale
Suffolk County homes for sale

West Hartford homes for sale
Newington homes for sale
Hartford homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 06002, CT

Sale history for 5 Saint Andrews Rd

Tax history for 5 Saint Andrews Rd

Public record

Property details

Around this home

Schools

Lifestyle

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 06002

Home values near 5 Saint Andrews Rd

More real estate resources