Greater Mansfield CT Real Estate $500k +

580 Brickyard Road Woodstock CT 06281

Woodstock, CT580 Brickyard Road

Price$50,000,000

Est. Mortgage: $/month

MLS Number 170529304

  • Single Family
  • Square Feet 18,777
  • Bedrooms 9
  • Year Built 2010
  • Property Style Other

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: 6.58% last updated on Nov 23, 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
  • 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.58% last updated on Nov 23, 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

MLS Number 170531845

  • Single Family
  • Square Feet 5,314
  • Property Style Contemporary, Ranch
  • Bedrooms 3
  • Bathroom 3

Unparalleled Beautiful 3 Bedroom 3 Bath Contemporary Ranch sitting on top of over 600 lush acres of land! Open floor plan with towering 24 foot cathedral ceilings and breath taking views for miles!! Gourmet distinguished kitchen equipped with granite countertops, stainless steel appliances, and breakfast nook that leads out to amazing patio. On those cold winter nights curl up to your dual-sided immense floor-to-ceiling hand crafted stone fireplace. Master bedroom suite with full bath and whirlpool tub. Three car garage with separate entrance to overhead in-law studio with full bath. This home also features central air, new furnace, new hot water heater, and the entire outside of the home has been freshly painted. Please schedule your private showing today. There is simply No Comparison!!!

Listed by Jesse Marinak of Coldwell Banker Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 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

89 Route 169 Woodstock CT 06281

Woodstock, CT89 Route 169

Price$2,900,000

Est. Mortgage: $/month

MLS Number 170532163

  • Single Family
  • Square Feet 1,560
  • Bathroom 3
  • Bedrooms 2
  • Year Built 1940

Are you ready to live at your own private airport? This quaint 2-bedroom hangar home sits on approximately 55 acres with a 2200 ft by 40 ft paved and lighted runway. This property includes two additional 40x40 ft single aircraft hangers (one heated), One 30x40 ft hangar with a new concrete floor, one 30x40 ft open hangar and one 60x60 ft 4 bay hangar. This property also includes an FBO/ Aviation learning center w/room for a potential pilot's guest house and a 4,000 gallon above ground fuel tank and pump for 100LL. The home has 1,560 sq ft of living space of which 1,020 is on the main floor with 2 full baths and 540 is a loft/primary bedroom. The attached heated hangar is approx. 3,850 sq ft which will accommodate up to 4 aircraft with additional space for maintenance. The hangar also includes a 1/2 bath & approx. 2,150 sq ft of workshop and cold storage. The home & hangar have a new roof (2019), the home has vinyl siding (2019), septic (2022), & a new well in 2016. The home has propane heat/ hot water, and the hangar heat is oil fired. . The main taxiway, ramp, and fueling area were paved in 2020. There are ten tiedowns of which Five grass and five newly paved in 2020. Aviation enthusiast will enjoy the AMA chartered RC Flyers Model Club with its beautiful 400x40 ft grass runway, pavilion, firepit, & clubhouse. This amazing private airport has huge potential for growth with additional hangars or even a fly in community along with solar potential. - Commercial MLS#170532557

Listed by Ryan Lajoie of Johnston & Associates Real Estate,LLC

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 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

2 Mansfield City Road Mansfield CT 06250

MLS Number 170176105

  • Land
  • Acreage 42
  • MLS Status Active
  • Other Amenities Waterfront
  • Zoning PVRA

41+/- acres on the corner of Mansfield City Road and Pleasant Valley Road, and abutting Eastern Connecticut State University Athletic fields. Nearby retail, downtown Willimantic and just 10 minutes to the University of Connecticut. Conceptual plan for 231 units in 11 buildings with conservation easement and open space for passive recreation. Public Water and Sewer available, nearby bus stop for WRTD. High demand for student housing in the market! Enrollment Undergrad Graduate ECSU 5,832 4,300 1,000 UCONN 32,182 19,241 7,098

Listed by David Mieczynski of National Realty Advisors LLC

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 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

371 North Canterbury Road Canterbury CT 06331

MLS Number 170483796

  • Single Family
  • Square Feet 5,108
  • Bedrooms 4
  • Bathroom 4
  • Year Built 2006

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: 6.58% last updated on Nov 23, 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 170530697

  • Land
  • Acreage 30.87
  • MLS Status Active
  • 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: 6.58% last updated on Nov 23, 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

65 Trumbull Highway Lebanon CT 06249

MLS Number 170517226

  • Land
  • MLS Status Active
  • Acreage 168.4
  • Subdivision Pleasant Valley Farm
  • Zoning RES

One of the most beautiful farms in Connecticut. Ten Mile river runs thru the property plus small brook and 3+/- acre pond large area of cultivated land leased to area farmer, some stonewalls, grass pasture etc. Ideal for Equestrian Estate, working farm, subdivision or High End Adult Housing Development (this would require certain zoning text changes or additions to permit this type of development. The farm is teeming with all sorts of wildlife ideal for very exclusive game club.

Listed by Derek Greene of The Greene Realty Group

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 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
  • Bedrooms 4
  • Bathroom 6
  • 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: 6.58% last updated on Nov 23, 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
  • Bathroom 5
  • Bedrooms 4
  • Year Built 2009

Leaf Peeping at it's BEST! INCREDIBLE VALUE!! This remarkable custom built 6700 sf well-appointed estate is only $280/sq ft (and this excludes the below grade sf of 1000sf)! Mill Rate of only 20.85 is lowest in Tolland & Windham counties. The home was built with great taste and care in 2009. If you are looking for an oasis to create family memories, for an entertainer's dream, potential horse property, 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. 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! 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. 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: 6.58% last updated on Nov 23, 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: 6.58% last updated on Nov 23, 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

22 Lake View Drive Woodstock CT 06281

MLS Number 170525784

  • Single Family
  • Square Feet 3,712
  • Bedrooms 5
  • Bathroom 4
  • Property Style Contemporary

One of a kind waterfront property that is sure to WOW you! This property is unique in many ways! It's situated on 2 building lots, with .83 landscaped acres and 153 ft of your very own private waterfront retreat. You can relax & enjoy the water only steps away from your back door. You can also enjoy the views from the decks, patios, & shaded pergola. This 3,712 sq. ft. home was built with the finest material imported from Belgium, Spain, Holland, & Germany. The top level has a stunning primary suite with water views in every window. The spacious bedroom has a large window with majestic views of the lake, a double walk-in closet, & a state-of-the-art bath with a hydro tub & a large tiled walk-in shower. The suite level also features a large office & bonus room, which is currently being used as another bedroom. The main floor has a formal dining & living room with high ceilings, custom built-ins, and a magnificent two-story stone fireplace. The open kitchen has a wine pantry, granite counters, breakfast bar, & eat-in nook. Bedrooms and full baths are on all 3 levels providing privacy for all guests. The home also includes 4 garage bays, 2 paved driveways, a large workshop, a generator, & an irrigation system. Come and see for yourself & enjoy a vacation every day in this breathtaking home year-round.

Listed by Gloria Townsend of Coldwell Banker Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 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.