Greater Mansfield CT Real Estate $500k +

450 Brickyard Road Woodstock CT 06281

Woodstock, CT450 Brickyard Road

Price$60,000,000

Est. Mortgage: $/month

MLS Number 170467821

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

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 consist 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 seventy-five 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, Additional Acreage available.

Listed by John F Pizzi of RANDALL,REALTORS-Compass

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

Allen Hill Road Brooklyn CT 06234

MLS Number 170471026

  • Land
  • MLS Status Active
  • Acreage 136.38
  • Subdividable
  • Zoning I-1

For sale, 136.38 acres of prime industrial land. This is one of the largest industrial areas available. Other land uses that may be permissible with a zoning change application to accommodate the need, would be a residential component for a portion of the property, a cannabis cultivation facility was mentioned to have been suitable. This is according to Brooklyn Prior First Selectman. This property is an easy development with little clearing, plenty of buffer space for the surrounding community. You have 2 Access points on the Property, the First is to the west which is the field next to 68 Allen Hill, and the other is to the east between 69 and 63 Fortin Dr. According to the seller, there is public water stubbed to this portion of the property, and there is a public sewer in the road on Fortin Dr, but starting in the house number range of 90, this property lies between 63 and 69. abutting rt 6 Frontage Property is also available. Approximately 1 mile from 395, 25 minutes to Providence, 1 Hr 15 min to Boston, 45 Min To Hartford. 15 acres of this land is Zoned RA which i Allen Hill Rd entrance , the rest of the land is industrial. Please refer to the attached documents. For information on zoning, jump to page 79 for industrial zone regulations. Local demographic information is also attached. as well as wetland maps There is public sewer in the road on Fortin Dr, but starting in the house number range of 90, this property lies between 63 and 69.

Listed by Paul J Manocchio of 1 Worcester Homes

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

40 Merrow Road Tolland CT 06084

Tolland, CT40 Merrow Road

Price$4,500,000

Est. Mortgage: $/month

MLS Number N10196732

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

26 Acres (14 usable) located at four-way interchange on exit 68 of I-84. Excellent visibility with 2,000 feet of frontage on I-84 and 530 feet of frontage on Rt. 195 (Merrow Rd.) This is the UCONN exit. Ideal location for hotel/motel, retail, commercial, or recreation opportunities. Zone: GDD - Gateway Design District. Lease price would be $40,000/Mo NNN.

Listed by Ron Lyman of Lyman Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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 Audette Road Franklin CT 06254

Franklin, CT32 Audette Road

Price$3,000,000

Est. Mortgage: $/month

MLS Number 170497411

  • Single Family
  • Square Feet 2,976
  • Bedrooms 3
  • Bathroom 3
  • Year Built 2001

Hearthstone Farm - Stunning one of a kind post and beam home on over 600 acres! Open concept living with soaring 24' cathedral ceilings. Kitchen features granite counters, stainless steel appliances, and a sunny breakfast room that steps out to a patio overlooking the property. Impressive floor-to-ceiling dual-sided stone fireplace. First floor Master suite w/full bath & whirlpool tub. In-law studio with a full bath & separate entrance. Central Air. 3 Car Garage. New furnace and HW Heater in 2021.

Listed by Dana L Flanagan of NestSeekers International

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

371 North Canterbury Road Canterbury CT 06331

MLS Number 170483796

  • Single Family
  • Square Feet 5,108
  • Year Built 2006
  • Bathroom 4
  • Property Style Contemporary, Tudor

Welcome to Blackwells Brook Farm, a retreat like no other, located in the "Quiet Corner" of Connecticut and on CT's Wine Trail. Upon entering through the stone gates, enjoy the winding driveway with ponds, a vineyard, lush lawns and the mature landscape. The estate is a splendid custom-built French Tudor-styled home nestled into a hill side surrounded by stone walls and rolling hills, making an extraordinary first and lasting impression. Entering the home through the arched doorway and into the welcoming foyer one is embraced with the exceptional craftsmanship and obvious attention to detail. Exquisite features include imported tile and tiger maple flooring with radiant heat throughout the main level. The open floor plan showcases the kitchen of your dreams, equipped with Viking and Sub-Zero appliances, handcrafted cherry cabinets, granite countertops and a butler's kitchen, adding efficiency and a private prep space. There is an easy flow to the house between the living room, glass conservatory, the primary bedroom with en-suite bath and second main level bedroom. The upper floor offers a private guest suite. The fully finished 2000 sq. ft. lower level boasts a recreational haven, including a fourth bedroom/home office, opening to a stone patio and the manicured back yard - perfect for entertaining and recreation.

Listed by Jay Kelly of William Raveis Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

312 Merrow Road Tolland CT 06084

Tolland, CT312 Merrow Road

Price$2,499,000

Est. Mortgage: $/month

MLS Number 170345734

  • Land
  • MLS Status Active
  • Acreage 30.87
  • Zoning NCZ-R

Commercially Zoned Land for Sale with almost 1,000 feet of road frontage and traffic counts in excess of 9,400 cars per day this 30 Acre lot located in close proximity to the on and off ramps of I-84 and six miles from the University of Connecticut. This prime location makes it the ideal location for a multitude of uses including investment, innovator, corporation or developer, office building, laboratory, research, technology or computer-based facility. Route 195 is the primary entrance route to UCONN. This property is part of the Tolland Technology Campus Zone (TCZ) with sewers available on street. The property can used used for the following designations either through a Permitted Site Plan or a Special Permit: Retail, Personal, & Professional Service, Hospitality, Commercial Office, Commecial Laboratory & R&D, Residential & Mixed Use Development, Institutional, Public & Recreational, Agriculture & Natural Resources. Conveniently located close to highways, shopping and dining.

Listed by Mark Riesbeck of Berkshire Hathaway NE Prop.

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

71 Child Road Woodstock CT 06281

MLS Number 170464403

  • Single Family
  • Square Feet 7,684
  • Bedrooms 4
  • Property Style European
  • Bathroom 5

If you are looking for an oasis to create family memories, for an entertainer's dream, or your private escape into paradise, 71 Child Rd, Woodstock, CT, is your kind of home. This 11-acre estate, surrounded by spectacular northeastern Connecticut countryside is a rare find. The sprawling 7,700 sq.ft residence was built with great taste and care in 2009. Its Western Red Cedar exterior, large porches, & superior architectural details, many of which were curated from around the world or hand-made, make it both rustic & refined. Its kitchen is worthy for any chef, & it offers lovely gathering spots for family & friends. Relax or entertain around the Rumford field stone fireplace, or on the outdoor bluestone patio, or inground pool. Details, such as reclaimed marble from a Spanish monastery in the entrance and custom rustic walnut bookshelves in the library, exude character & elegance. Features like radiant heat & top-of-the-line appliances ensure modern luxury comforts! The large Primary Bedroom Suite on the 2nd flr offers views of the Valley & boasts a large, covered loggia, a steam shower, extra large dressing room & a jacuzzi. The basement features an exercise room & is set up to accommodate an endless pool. While the residence currently has 4 bedrooms, the unfinished attic space above the 3-car heated garage may be finished off for an apartment. PLEASE NO DRIVEBYS. Schedule your showing! A must-see in-person to understand and appreciate all that this home truly offers!

Listed by Lisa P Rollins and Anne Marie Straka of Page Taft - Compass

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

859 Beaumont Highway Lebanon CT 06249

MLS Number 170465560

  • Single Family
  • Square Feet 3,400
  • Bathroom 6
  • Property Style Cape Cod, Ranch
  • Year Built 1999

Carbery Fields sits on 40 acres and offers wonderful opportunity for the equestrian. A well thought out design, it has been built with upscale materials and eco friendly utilities. Reproducing this today would cost well over 4 million dollars. There are currently 24 stalls, 16 stalls in the main barn and 8 in the owners barn. The 60 meter x 20 meter indoor arena is spectacular. There is individual tack lockers, heated bridle room, managers office, heated grain room with bath, Inside and outside wash stalls, and a commercial kitchen for events, For your clients there is spectator seating and a heated lounge/viewing room with bathroom. Outside is a 30 meter by 70 meter arena with ring side seating and a judges gazebo. Ample trailer parking for clinics and shows. The main residence sits away from the facility with the 8 stall barn for personal use. The house design is a reproduction center chimney Cape with beautiful woodwork, 3 bedrooms on the main level, a guest bedroom in the upper level. Cathedral ceilings in the great room, kitchen with commercial grade appliances. There is a 3 car heated garage with a 2 bedroom apartment above. Both houses have geothermal heating and AC. The second residence is a 2 bdrm 2 bath ranch, guest/ trainers house. For the working student/groom or staff there is a 1 bdrm apartment that overlooks the indoor arena. There is just so much to offer with this property, please see attached documents for floorplans, and list of all features.

Listed by Lori A Vogel of William Raveis Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

40 Merrow Road Tolland CT 06084

Tolland, CT40 Merrow Road

Price$1,750,000

Est. Mortgage: $/month

MLS Number 170421659

  • Land
  • MLS Status Active
  • Acreage 2.25
  • Other Amenities Waterfront
  • Zoning GDD

Also available Restaurant site $1,500,000. 10% discount if both are purchased. Parcel marked hotel section see attached map. Public Water & Sewer. Traffic Count: 11,200 on Merrow . 101,600 on 84

Listed by Ron Lyman of Lyman Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

Tolland Stage Road Tolland CT 06084

Tolland, CTTolland Stage Road

Price$1,550,000

Est. Mortgage: $/month

MLS Number 170474647

  • Land
  • MLS Status Active
  • Acreage 83.12
  • Other Amenities Waterfront
  • Zoning RDD

Exceptional Opportunity!! Incredible potential to fully develop over 80 acres of raw land with easy access to interstate 84. Fantastic possibility awaits you on this large level lot zoned Residential Design District which encourages a flexible site design that covers many options from single family homes to village type cluster housing. Expand your options with special permit uses which include elderly housing, assisted living facility, a private school, nonprofit club or take advantage of the natural landscape for a sporting club, campground or resort, just to name a few. (See Section 5.1 - 5.2 attached for more details) Use your imagination, so many options available for an investor or real estate developer. Ideally located with 1,200 feet of frontage on Tolland Stage Road/Route 74 and additional access on Buff Cap Road only minutes to local amenities and attractions, easy commute to Boston in under 90 minutes. Some wetlands which enhance the beauty of the property. This parcel of land is a true gem, call today for more details and information.

Listed by Elaine Abouakar and Arek Wtulich of CENTURY 21 AllPoints Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

Tolland Stage Road Tolland CT 06084

Tolland, CTTolland Stage Road

Price$1,550,000

Est. Mortgage: $/month

MLS Number 170492638

  • Land
  • MLS Status Active
  • Acreage 83.12
  • Other Amenities Waterfront
  • Subdividable

Exceptional Opportunity!! Incredible potential to fully develop over 80 acres of raw land with easy access to interstate 84. Fantastic possibility awaits you on this large level lot zoned Residential Design District which encourages a flexible site design that covers many options from single family homes to village type cluster housing. Expand your options with special permit uses which include elderly housing, assisted living facility, a private school, nonprofit club or take advantage of the natural landscape for a sporting club, campground or resort, just to name a few. (See Section 5.1 - 5.2 attached for more details) Use your imagination, so many options available for an investor or real estate developer. Ideally located with 1,200 feet of frontage on Tolland Stage Road/Route 74 and additional access on Buff Cap Road only minutes to local amenities and attractions, easy commute to Boston in under 90 minutes. Some wetlands which enhance the beauty of the property. This parcel of land is a true gem, call today for more details and information.

Listed by Elaine Abouakar and Arek Wtulich of CENTURY 21 AllPoints Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

40 Merrow Road Tolland CT 06084

Tolland, CT40 Merrow Road

Price$1,500,000

Est. Mortgage: $/month

MLS Number 170421677

  • Land
  • MLS Status Active
  • Acreage 2.25
  • Other Amenities Waterfront
  • Zoning GDD

Also available as land lease $100,000/year NNN Parcel marked restaurant section see attached map. Public Water & Sewer. Traffic Count: 11,200 on Merrow, 101,600 on 84 Also available Hotel site $1,750,000. 10% discount if both are purchased.

Listed by Ron Lyman of Lyman Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 5.7% last updated on Jun 30, 2022
* 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

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 2022 SmartMLS, Inc.