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
$579,999 (USD)
Pending

Moodus Area Single Family Home

Pending

154 Falls Road East Haddam, CT 06469

3 Bed
3 Baths
1165 sqft
MLS# 24083525
Beautiful direct waterfront home on Moodus Lake. Fully renovated 1925 Farmhouse with a bright open concept & layout. The stunning "Cooks Kitchen" with panoramic view of the lake, includes state of art appliances including double wall convection ovens & air fryer, large center island with gas cooktop, Microwave drawer, open beam cathedral ceiling and Breakfast Nook with slider to a large deck facing the lake. The living room has a gas fireplace and 9 foot sliders out to the deck with stunning views of the lake and waterfall. There is also a first floor bedroom, a full bath and Dining Room plus a study area just off the main Foyer. The second floor has the Primary Bedroom with walk-in closet, stunning full bath and views of the lake. There is also a third bedroom and an additional half bath as well. The front of the house features a beautiful stone wall, landscaping and a brick walkway. The back yard slopes gently down to the water with lots of grassy area to host friends and family for summer get togethers. Just a short 11 minute drive to The Goodspeed Opera House plus local eateries including the Gelston House Restaurant right on the Connecticut River. It is also just a short drive to Route 9 for access to many other shoreline communities and activities. This Moodus Lake location also includes a Town Beach with playground and two boat launches. New Well and new 4 bedroom capable septic system.
Listing Courtesy of SMART MLS / Listed By: Peter Allam, Century 21 Allpoints Realty
$315,000 (USD)
Pending

East Meriden Area Single Family Home

Pending

65 Glenview Road Meriden, CT 06450

4 Bed
2 Baths
2140 sqft
MLS# 24172752
Opportunity knocks! This unique home is ready for a complete transformation, but the potential is undeniable-truly a hidden gem waiting to be brought back to life. Situated on a beautiful lot on the east side of Meriden, near the Wallingford line, this property offers both location & character. As you arrive, you'll notice its distinctive raised ranch-meets-split-level design with a contemporary flair. Step inside to the main living area & be immediately impressed by soaring vaulted ceilings & a stunning floor-to-ceiling stone fireplace that anchors the space. Natural sunlight pours in, creating a bright & inviting atmosphere. On either side of the fireplace, two separate staircases-each with just a few steps-lead to the dining room on one side & the kitchen on the other, adding a truly unique architectural touch. The kitchen & dining room both overlook the living area, enhancing the open feel. Sliders off the dining room lead to a deck, perfect for enjoying the outdoors. Down the hallway, you'll find a full bath, two additional bedrooms & a spacious primary suite complete with its own full bath & private slider to a balcony. Hardwood floors run through most of the home, adding warmth & timeless appeal. The lower level offers even more space, featuring a laundry room already plumbed for an add'l bathroom. A cozy den with a wood-burning stove & sliders leading out to a patio & the backyard. An additional level includes a 4th bedroom, offering flexibility for guests, home -
Listing Courtesy of SMART MLS / Listed By: Linda Conchado, Century 21 Allpoints Realty