Available Listings

$4,100,000 (USD)
Active

Durham Area Farm

Active

148 &Amp 153 Wallingford Road Durham, CT 06422

Bed
0 Baths
sqft
MLS# 24015202
Virtual Tour
The Greenbacker Brookfield is one of the largest farms now on the Connecticut market with over 400 acres. It has been in operation for over 100 years and is ready now for a new multi-generation family to take the reins or for a progressive investor. There is ample accommodation with 7 houses that have 29 bedrooms for the family to share. (The average size farm in CT is approximately 80 acres). The current owners are using 4 houses and renting 3 other homes. The investor agriculture buyer may also generate rental income from the farm's other rental property; 1. a Two story 35x50 horse barn, 2.a 35x80 stable with 1.5 story horse stalls. 3 a. Barn with double row stalls and indoor riding arena, 4. a 4-bay garage, 5. Dairy barn, and Chicken coops, etc.. These items may also be considered depreciable property (see your tax advisor). Other sources of income from the farm would include renting land for; 1, growing crops (92 acres of cropland leased, currently), 2, Durham Fair parking. 3, pastureland (20 acres of pasture leased, currently), 4, hunt club (land leased currently), 5, equestrian rental (stable & indoor/outdoor riding, currently leased) and for dairy farming. Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more. The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ag
Listing Courtesy of SMART MLS / Listed By: Gary Dobratz, Century 21 Allpoints Realty
$2,800,000 (USD)
Active

Durham Center Area Single Family Home

Active

153 Wallingford Road Durham, CT 06422

15 Bed
8 Baths
10623 sqft
MLS# 24045388
Virtual Tour
This unique farm complex is comprised of an equestrian area for 40 horses +, 5 residential houses and more. It has been in operation for over 100 years and is ready for new multi-generation owners to take the reins or for a progressive investor. There is nearly 280 acres of outstanding land, a pond, pastureland, rolling hills, stalls for 40+ horses and much more. There is, also, an outstanding mix of 5 houses that have 22 bedrooms for the families to share. The current owners are using 2 houses and renting 3 other homes. The investor may generate rental income from the farm's 5 residential homes and 1. a Two story 35x50 horse barn, 2.a 35x80 stable with 1.5 story horse stalls. 3 a Barn with double row stalls, 4. a 4-bay garage, etc.. These items may also be considered depreciable property (see your tax advisor). Other sources of income from the farm would include leases for pasture land and equestrian rental of the stable & indoor/outdoor riding, which is currently leased). Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ago. both parcel MUST be sold together.
Listing Courtesy of SMART MLS / Listed By: Gary Dobratz, Century 21 Allpoints Realty
$1,770,000 (USD)
Active

Downtown Area Commercial

Active

19-29 Main Street Hartford, CT 06106

0 Bed
0 Baths
19500 sqft
MLS# 24175630
Welcome to 25 Main Street, a four-story masonry Class B professional office building in downtown Hartford, sitting directly adjacent to the Hartford Hospital campus and surrounded on three sides by Hartford Hospital-owned property! Capital improvements include replacement roof and windows, roof-mounted HVAC, back-up generator, and a four-stop hydraulic elevator. Four identical ~5,000 SF floor plates, currently 100% vacant and fully adaptable for an incoming owner. The standout feature is the substantial ~98-space gated parking lot - a rare amenity in Downtown Hartford. Ideally suited for hospital-adjacent users: physician groups affiliated with Hartford Hospital or Connecticut Children's, ambulatory care, dental, behavioral health, imaging, rehab, outpatient surgical, or DME providers, all of whom benefit from being right at the campus front door. Hartford Hospital recently announced a nearly $1 billion long-term campus transformation including a new 14-story patient tower, with Connecticut Children's Medical Center just steps away. Downtown Hartford is also in the middle of an active office-to-residential conversion wave, opening the door to exciting possibilities for affordable housing developers. Projects in this corridor have been supported by a variety of programs including CRDA, CHFA, and DOH financing, and federal & state HTC. This is a rare chance to acquire in the shadow of a billion-dollar hospital expansion - don't pass on this uniquely-poised opportunity!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$1,200,000 (USD)
Active

Hamden Area Commercial

Active

2751 Dixwell Avenue Hamden, CT 06518

0 Bed
0 Baths
10375 sqft
MLS# 24175622
Welcome to The Meadowbrook Building, a four-story brick professional office building on Hamden's Dixwell Avenue corridor! Configured as four nearly identical floors of approximately 2,500 SF each, with a restroom and in-suite kitchen on every floor, with individual electric metering and HVAC. 1960's brick construction with a four-stop hydraulic elevator and a ~47-space parking lot. Building systems are in good shape, including replacement double-pane windows, rubber roof, heat pumps on each floor, and a newly installed monitored fire alarm. Currently 50% leased to two long-tenured tenants generating in-place income, with 1st & 4th floors vacant and ready for an incoming owner-occupant. Perfect for an owner-user: a mid-sized professional practice can take possession of one or both floors immediately and let the existing tenants offset a meaningful share of carrying costs. Both floors feature functional and adaptable layouts, and can be reshaped or subdivided to fit the needs of new ownership. A natural fit for law, accounting, financial advisory, insurance, architecture, or consulting practices, along with medical and behavioral health users supported by nearby Quinnipiac University and Yale New Haven Health. Tenants enjoy a quiet setting - Hamden Town Center Park borders three sides of the property - with easy access to I-91, I-95, and the Merritt Parkway. Don't miss the opportunity to own a well-built professional address with income in place!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$780,000 (USD)
Pending

Cheshire Area Single Family Home

Pending

75 Hearthstone Drive Cheshire, CT 06410

4 Bed
4 Baths
2640 sqft
MLS# 24185536
**HIGHEST & BEST BY TUES, 6/30 4:00 pm. Location, Location, Location! Welcome to one of Cheshire's most sought-after neighborhoods. Nestled on a beautifully maintained 1 acre lot bordering the Broad Brook Reservoir, commonly known as the Cheshire Reservoir, this exceptional Colonial borders 422 acres of preserved open space, providing a peaceful and picturesque setting right in your own backyard. Professionally landscaped grounds feature lush mature gardens, stone walls & incredible curb appeal. Step inside to discover a thoughtfully designed floor plan with room for everyone. The spacious primary bedroom suite offers a walk-in closet & private full bath complete with a double-sized walk-in shower. Three additional bedrooms and another full bath complete the upper level. The main floor features a formal living room with new carpeting (2024), a private study/home office & a bright, inviting kitchen with center island, cooktop, wall oven, dining area & stainless steel appliances including a refrigerator (2022) and dishwasher (2021). The formal dining room is perfect for hosting holiday gatherings, while the remodeled half bath (2023) adds convenience for guests. The stunning front-to-back family room is the heart of the home, featuring soaring cathedral ceilings, floor-to-ceiling fireplace & direct access to the two-car garage. French doors lead to a beautiful four-season sunroom drenched in natural sunlight, creating the perfect space to relax year-round. (More below)
Listing Courtesy of SMART MLS / Listed By: Linda Conchado, Century 21 Allpoints Realty
$599,900 (USD)
Active

East Hampton Area Single Family Home

Active

11 Brookside Court East Hampton, CT 06424

5 Bed
4 Baths
2688 sqft
MLS# 24189321
Move right into this beautifully remodeled Colonial featuring a legal, attached ranch-style in-law apartment-perfect for multigenerational living or easily converted into one expansive single-family home.The main home offers a stunning chef's kitchen with granite countertops, stainless steel appliances, abundant cabinetry, attractive hardware, and a large center island. The kitchen opens to a spacious dining room overlooking the scenic backyard. A welcoming living room with a bow window and fireplace, plus a half bath, complete the main level.Upstairs are three spacious bedrooms, including a large primary with sitting area, and a beautifully remodeled oversized Jack-and-Jill bath. The lower level includes a partially finished family room and laundry area.The 1,120-square-foot in-law apartment features a large living room with a bow window, an eat-in kitchen with pantry and ample cabinet space, a dining area with sliders to a private deck, a primary bedroom with full bath, and a second spacious bedroom.Major updates include a five-zone Crown boiler with Aero hot water heater, a 3-year-old 50-year roof with transferable warranty, and a new well pump.Set at the end of a quiet cul-de-sac on 2.3 private acres surrounded by conservation land, this meticulously maintained home offers exceptional privacy, flexibility, and pride of ownership. A truly turnkey property ready for its next owners.
Listing Courtesy of SMART MLS / Listed By: Pam "Pamela" Savejs, Century 21 Allpoints Realty
$429,000 (USD)
Active

Norwich Area Multi-Family Home

Active

45 Dunham Street Norwich, CT 06360

4 Bed
3 Baths
2209 sqft
MLS# 24189532
Excellent opportunity to own a fully occupied two-family property offering immediate cash flow and long-term investment potential. Currently generating $3,900 per month in rental income, with one unit rented for $1,900/month and the other for $2,000/month, this property is a solid addition to any investment portfolio. Each unit features 2 bedrooms, with one offering 1 full bathroom and the other 1.5 bathrooms, providing comfortable and functional living spaces for tenants. With approximately 2,209 square feet of living space, this well-maintained multifamily offers plenty of room while delivering consistent rental income. Additional features include a detached garage ideal for storage, a large driveway providing ample off-street parking, and the convenience of public water and public sewer. Conveniently located near shopping, restaurants, major employers, entertainment, and easy highway access, this property is well-positioned in an area with strong rental demand. Whether you're looking to expand your investment portfolio or purchase your first income-producing property, 45 Dunham Street offers the opportunity to own a turnkey multifamily with reliable rental income from day one. Don't miss your chance to add this excellent investment to your portfolio. Agent related.
Listing Courtesy of SMART MLS / Listed By: Nicolas Rubino, Century 21 Allpoints Realty