and narrow your search. If you have fewer than 200 results, you can save your search.

Open Houses

580 Brickyard Road Woodstock CT 06281

Woodstock, CT580 Brickyard Road

Price$29,000,000

Est. Mortgage: $/month

MLS Number 170597460

  • Single Family
  • Square Feet 18,777
  • Bedrooms 9
  • Bathroom 10
  • Year Built 2010

Stunning one of a kind property built to amaze and capture the imagination of the individual who relishes outstanding craftsmanship and superior design. This majestic Castle features a moat, towers rising 126 feet into the sky, 18,777 square feet of delight with nine bedrooms, 7 full baths, 3 half baths, 12 fireplaces, breathtaking entry hall and public spaces that are indeed fit for a King. Bespoke massive kitchen to delight the Queen with the latest kitchen appliances and large stone fireplace overlooking Potter Pond. The wood inlaid floors, doors and woodwork are built with over 25 species of hardwoods imported from around the world. Period architectural doors and stain glass are found throughout the Castle. The walkout lower level consists of approximately an additional 4.500 sq ft of finished space including a common area with fireplace and circular bar. There is a raised stage and auditorium. In-law/maids apartment. Radiant heat keeps the outdoor decks and patios free of snow. Nestled on 375 acres in bucolic Woodstock, CT overlooking 30 acre pond, the Woodstock Castle offers the opportunity of a lifetime to own a dream come true. Additional features: hydro-air heat with radiant heat in the floors, Central Air, Pool, Dock, Back up Generator, State of the Art technology, 800 AMP service, Gated Entry.

Listed by John F. Pizzi of Compass Connecticut,LLC

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

South Road Marlborough CT 06447

Marlborough, CTSouth Road

Price$12,000,000

Est. Mortgage: $/month

MLS Number 170616953

  • Land
  • Acreage 426.5
  • MLS Status Active
  • Other Amenities Golf, Waterfront
  • Zoning R

Only 15 minutes from the home of over 100 insurance companies in Hartford CT ! Now available is a 426 acre parcel of land very close to the town center in Marlborough, Connecticut. Just down the street from the town resident only water front recreation area, as pictured. This quiet country land parcel has town approvals for a golf course/housing project. Complete plans are available. The owners will also consider selling subdivided smaller parcels. The project plans show that the residential component of the project consists of 84 single-family lots (about half of these lots will border the golf course and 12 will be on a ridge with distant scenic views); and 112 town homes targeted, but not restricted to the active adult market with unit sizes starting at 2,500 square feet (most of the town homes will have unobstructed views of the golf course). The residential component of the subject will use about 135 acres with an additional 120 acres allocated to undisturbed open space. The proposed 7,010-yard, par 71, 18-hole, championship golf course designed by the Roger Rulewich Group will encompass about 157 acres. The subject was approved under the Town of Marlborough's Open Space Conservation Area Regulation (OSCAR). Note- signs (4) mark approximate north and southern road locations on South road and Ogden Lord roads.

Listed by Tracy S. Gallagher of Coldwell Banker Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

9 Pettipaug Avenue Old Saybrook CT 06475

MLS Number 24005900

  • Single Family
  • Square Feet 7,465
  • Bedrooms 7
  • Bathroom 6
  • Year Built 1905

Welcome to 9 Pettipaug Avenue, a truly exquisite waterfront property in the charming borough of Fenwick, in Old Saybrook, CT. This stunning residence offers panoramic views of the LI Sound and provides an unparalleled level of luxury and comfort. The property has been completely renovated, making sure to preserve the home's historical beauty. The meticulous design emphasizes its commanding beachfront, fabulous indoor-outdoor family entertainment flow and glorious sunrises and sunsets. The main level offers a large gourmet kitchen with custom cabinets, marble countertops and large island, formal dining room w/fireplace, butler's pantry and a living room with fieldstone fireplace and breathtaking water views. The stunning primary ste. w/balcony has a gas fireplace, custom closets and bath. 6 additional bedrooms, and possible in-law suite all provide luxurious accommodations for family and guests. Outside enjoy quiet moments on the stunning screened in porch, and open air wrap-around covered porch which overlooks the beautiful private beach. The outdoor kitchen is perfect for summer entertaining. Enjoy the famed Fenwick 9-hole golf course, tennis and boating. The Katherine Hepburn Theatre, shopping and fine dining are minutes away. Experience the epitome of waterfront living in this remarkable Old Saybrook estate.

Listed by Christine Poppy of Compass Connecticut,LLC

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

872 Stone Road Windsor CT 06095

Windsor, CT872 Stone Road

Price$6,800,000

Est. Mortgage: $/month

Active With Contract

MLS Number 170565519

  • Land
  • Acreage 280
  • MLS Status Under Contract
  • Waterfront
  • Zoning RA

This 280 acre property is located in Windsor and East Granby. The property has been farmed for many generations in tobacco and row crops. The property has approximately 90 acres open in fields with Merrimac fine sandy loam and Windsor loamy sand, two of the finest agricultural soils. There are 3,361 feet of frontage along the Farmington River and 1000 feet of frontage along Stone Road in Windsor and 816 feet of frontage along Spoonville Road in East Granby. There are 8 tobacco barns on the properties in various conditions. Most of the land is classified under current use in CT. Current agricultural lease income is $43,050 from April to December from a local farm family. $500/ac for tobacco, $300/ac for vegetables, and $750 per tobacco barn for three barns and $3000/yr for farm workshop with fence enclosure. Annual property tax is $25,974.

Listed by Keith Ross of Landvest,Inc

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Virtual TourSave FavoriteSchedule TourAsk A QuestionMore Details

1667 Exeter Road Lebanon CT 06249

MLS Number 170601698

  • Commercial
  • MLS Status Active
  • Year Built 1960
  • Square Feet 40,000
  • Acreage 71

Welcome to the Historic Spa at Grand Lake, now known as The Hotel at Grand Lake! Nestled on 71 pristine acres overlooking Lake Williams, this seven building resort property offers an amazing opportunity for a new owner with current rental income in place. The hotel currently offers 55 rooms for guests, with an additional 30 rooms awaiting remodel. This property would make a great conversion to a multifamily project with many amenities. A short walk thru the woods brings you to Brewster Pond, allowing visitors easy access to fishing, kayaking, and paddle boarding. The grounds include an indoor and outdoor pool, large banquet hall, full-sized restaurant-capacity kitchen, and beautiful views of the lake. Also there is an additional restaurant and bakery building. Also included is a 2,700 sq ft contemporary single story 3-bedroom home with open concept layout and a full floor-to-ceiling brick fireplace in great room. The single family home includes a 3-car detached garage. Rooms are currently rented on a weekly basis with approx. 35 of the 55 rooms rented. Gross income currently $40,000 per month for the 35 rooms rented.

Listed by Frank H. Shank of Amodio & Co.

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

32 Huntington Street Hartford CT 06105

MLS Number 24003158

  • Multi Family Multi-Family For Sale
  • Square Feet 12,128
  • Acreage 0.22
  • Bedrooms 120
  • Bathroom 75

Prime Investment Opportunity in Asylum Hill! Welcome to a lucrative venture in the heart of Hartford's vibrant Asylum Hill! Presenting an exceptional chance to own not just one, but 68 units nestled in an unbeatable location, just moments away from key amenities such as bus lines, hospitals, and the bustling Downtown Hartford. This extraordinary property boasts five stunning brick buildings with a diverse unit mix ranging from cozy studios to spacious 4-bedroom townhouses, offering something for everyone. With card-operated laundry facilities in each building, secure gated parking, and a tenant-friendly electric billing setup, managing this investment is a breeze. Several units currently immediately available allow new owners to unleash their vision, whether it's continuing the remodeling journey or handpicking the perfect tenants. Originally gutted to the studs in the 1980s, this property has seen continuous improvement and modernization, making it a solid investment opportunity with endless potential. Don't miss out on this golden opportunity to make your mark in the thriving Hartford real estate market-seize it now and unlock the potential of this remarkable investment gem!

Listed by Lisa Cozzi and Molly Bradbury of Berkshire Hathaway NE Prop.

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Virtual TourSave FavoriteSchedule TourAsk A QuestionMore Details

279 Granville Road Granby CT 06060

MLS Number 170515163

  • Single Family
  • Square Feet 6,740
  • Bedrooms 5
  • Bathroom 5
  • Year Built 2006

Luxurious Country Estate between New York and Boston! Nestled to the North of rural Granby, CT, this luxurious country estate offers the perfect blend of privacy and accessibility. Located just minutes from the town center and close to Bradley International Airport, the estate is also within easy reach of the charming towns of Litchfield County and the scenic Berkshires. Set on over 240 acres of natural beauty, the custom-built home designed by architect Emil Dahlquist and built by local master craftsmen is a haven of luxury and tranquility. Enjoy stunning views from every window, wander through colorful gardens, relax in the gazebo, hike or ride through mature woodland, and accommodate your equine friends in open pastures and run-ins. The impressive barn, complete with an office above, provides ample space for all your outdoor needs. Whether for grand entertaining or everyday living, this magnificent estate provides the ultimate experience in comfort, elegance, and natural beauty. This truly is a special place! Please contact the listing agent for video link, additional details and to book your private tour. *** SHOWINGS STRICTLY BY APPOINTMENT ONLY ***

Listed by Anna Sogliuzzo of Berkshire Hathaway NE Prop.

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Virtual TourSave FavoriteSchedule TourAsk A QuestionMore Details

520 Bailey Hill Road Killingly CT 06241

MLS Number L10060067

  • Land
  • Acreage 644.16
  • MLS Status Active
  • Subdivision Tri-Lakes,LLC
  • Waterfront

50 ACRE SECLUDED LAKE ON 644 ACRE WILDERNESS TRACT including 3 smaller ponds, 2 streams in Connecticut's quiet Northeast corner. Absolute peace, quiet and security with no public access. With 9,000' of direct water frontage, the lake affords numerous building sites some with sunrise/sunset views along with private boating, swimming and fishing. For the nature lover, this is heaven on earth with abundant wildlife, no traffic noise, unparalleled star gazing. Miles of gravel roads provide vehicular access to the interior hidden lake and ponds. For the developer, the entire tract is approved for 135 cluster lots (30 lots in Phase 1 completely engineered). Zoning regulations allow and recorded engineering data show the feasibility for various other uses including family compound, large estate lots, recreational, corporate headquarters, etc. A monolith tower in a remote corner not visible from a vast majority of the property provides strong cell service (lessee is responsible for annual real estate taxes of $3,378 of the total $9,221). Seller options: 244+/- acres with 15 acre pond $2,500,000 (Listing # 170604362) or 400+/- acres with big lake and 2 smaller ponds $4,500,000 (Listing # 170604053). Distance to Providence 20 miles, Foxwoods Casino 30 mi, Hartford 45 miles, Boston 55 miles, New York City 145 miles. Several major airports are within one hour's drive. Local airstrips are also available for small planes.

Listed by J. Thomas Mettling of J. Thomas Mettling

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

200 South Main Street East Windsor CT 06088

MLS Number 170608049

  • Commercial
  • MLS Status Active
  • Year Built 1950
  • Square Feet 13,861
  • Acreage 6.46

An exciting opportunity awaits all potential investors! We are thrilled to present a prime commercial property that offers unparalleled visibility and convenient access to major highways. With seven rentals that generate a monthly income of $32,600.00 and long-term leases, four car dealer licenses, this property is truly a goldmine. Moreover, the current owner has held onto this gem for over 35 years, and there's an extensive tenant waitlist eagerly awaiting their chance. The property is inclusive of 200 S Main Street, 202 S. Mian Street and a 3 third parcel with extra land to tie it all together. Tons of parking. On the commercial side the building has been restored with metal roofs, siding, windows and doors and garage doors. There is tons of parking and 2 more building are approved as of 2020 which would increase the gross monthly to 40,000K. We have a detailed appraisal available upon request.

Listed by Gregory E. Heineman of Trend 2000 Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

273 Asylum Street Hartford CT 06103

MLS Number 24006565

  • Commercial
  • MLS Status Active
  • Year Built 1920
  • Square Feet 35,277
  • Acreage 0.3

Welcome to an unparalleled opportunity in the heart of downtown Hartford-an exceptional chance to spearhead the development of a residential haven in an enviable location! Embraced by the city's vibrant pulse, this former high school site stands primed for transformation, boasting approved plans for a residential complex featuring 50 units. Among these are 22 studios, 11 studio pluses offering enhanced living space, and 17 one-bedroom apartments. With the City of Hartford's seal of approval, this canvas of possibility awaits the visionary buyer seeking to redefine urban living. Commanding impressive market rents of $1,400 for studios and $1,700 for one-bedroom dwellings, the potential for lucrative returns is undeniable. Furthermore, there is opportunity to include a small parking area nearby with the purchase. Situated at the center of downtown's bustling landscape, this property offers unrivaled proximity to iconic landmarks and entertainment venues. Just a stone's throw away from the XL Center and a mere two blocks from Bushnell Park and City Place, residents will revel in a lifestyle of convenience and excitement. Immerse yourself in the cultural tapestry of the city with TheaterWorks mere steps away, while an array of esteemed dining establishments and nightlife hotspots beckon within walking distance, including Black Eyed Sally's, Agave, and Max Downtown.

Listed by Lisa Cozzi and Chantal Lallier of Berkshire Hathaway NE Prop.

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

40 Merrow Road Tolland CT 06084

Tolland, CT40 Merrow Road

Price$4,500,000

Est. Mortgage: $/month

MLS Number N10196732

  • Land
  • Acreage 26
  • MLS Status Active
  • Zoning Commercial

Proposed Hotel, Restaurant, Multi Family, and Retail Site. On 26+ acres zone TVA-GD Public water & sewer available. Merrow Rd Frontage: 530Ft., I-84 Frontage 1,960. Traffic count: 77,700 (on 84) 14,500 (on Merrow Rd /195)

Listed by Ron Lyman of Lyman Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

Bailey Hill Road And Ledge Road Road Killingly CT 06241

MLS Number 170604053

  • Land
  • Acreage 400
  • MLS Status Active
  • Waterfront
  • Zoning RD

Secluded 50 acre pristine SPECTACLE LAKE and two 8 acre ponds on 400 acre wilderness tract in quiet Northeast corner of Connecticut on Rhode Island border. One of the few privately owned large lakes without public access in the State of CT, Spectacle Lake boasts 9,000' of wooded shoreline affording numerous homesites some with sunrise-sunset views. Boating, fishing and swimming are all yours in an exclusive, private, quiet and serene environment. Teeming with abundant wildlife, this property is a nature lover's paradise. Extensive engineering, wetlands identification, soils testing and environmental studies show the feasibility of large scale cluster development, large estate sites and multiple other uses under rural zoning. Several miles of gravel roads throughout the property allow vehicular access to the interior lake, ponds and forest. This parcel is the Southerly portion of 644 acres listed at $5.9M (see MLS L10060067). The Northerly 244 acres are listed separately at $2.5M (See MLS 170604362). Distance to: Providence 20 mi, Foxwoods Casino 30 mi, Hartford 50 mi, Boston 60 mi, NYC 150 mi. Several major airports are within 1 hour's driving time. A few smaller airstrips are within 1/2 hr. (Owner is a CT licensed real estate broker).

Listed by J. Thomas Mettling of J. Thomas Mettling

$
$
%
$/month over payments
Federal 30-year interest rate: 6.88% last updated on Apr 11, 2024
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Save FavoriteSchedule TourAsk A QuestionMore Details

The data relating to real estate for sale on this website appears in part through the SmartMLS Internet Data Exchange program, a voluntary cooperative exchange of property listing data between licensed real estate brokerage firms, and is provided by SmartMLS through a licensing agreement. Listing information is from various brokers who participate in the SmartMLS IDX program and not all listings may be visible on the site. The property information being provided on or through the website is for the personal, non-commercial use of consumers and such information may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Some properties which appear for sale on the website may no longer be available because they are for instance, under contract, sold or are no longer being offered for sale. Property information displayed is deemed reliable but is not guaranteed. Copyright 2024 SmartMLS, Inc.