Greater Mansfield CT Real Estate $500k +

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.89% last updated on Jul 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.89% last updated on Jul 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

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 On March 8, 2023 the Town of Mansfield enacted a moratorium on development in the PVRA and DMR zones, the moratorium expires December 8, 2023

Listed by David Mieczynski of National Realty Advisors LLC

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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

80 Bungay Hill Road Woodstock CT 06281

Woodstock, CT80 Bungay Hill Road

Price$2,500,000

Est. Mortgage: $/month

MLS Number 24022911

  • Single Family
  • Square Feet 4,655
  • Bedrooms 3
  • Bathroom 5
  • Year Built 1987

Welcome to this 80 acre Connecticut Estate, tucked into the rolling hills of Woodstock Ct. This exceptional 4,655 sq ft contemporary home offers a unique living experience with its own privately owned public FAA approved commercial grade airport. The property is a pilot's paradise, featuring a spacious hangar that not only accommodates multiple small planes and helicopters but also offers ample room for vehicle storage. The hangar is self-sufficient with its own septic, well, electrical, and heating systems, providing convenience and flexibility as well as a finished lounge area to gather and relax. This property is a rare find, offering a blend of luxury, functionality, and the ultimate in private aviation convenience! Whether you're an avid pilot, car enthusiast, or simply seeking a tranquil retreat, this home promises an unparalleled lifestyle. This residence boasts privacy and scenic New England beauty with stunning views. The contemporary design, built in 1987, features 3 bedrooms and 4 bathrooms, open living space with soaring ceilings, two story fireplace, and a beautiful open center oak staircase. The home's large windows and open layout invite the natural surroundings inside, creating a harmonious living environment. The finished walkout lower level offers beautiful views of the pond and the plush grounds. So many exciting possibilities!

Listed by Cary A. Marcoux of RE/MAX Bell Park Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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

175 Pulpit Rock Road Woodstock CT 06281

Woodstock, CT175 Pulpit Rock Road

Price$2,300,000

Est. Mortgage: $/month

MLS Number 24025933

  • Single Family
  • Square Feet 5,104
  • Bedrooms 4
  • Bathroom 5
  • Year Built 1986

A once-in-a-generation opportunity. Please visit this stunning Georgian estate situated on 55 hilltop acres in desirable Woodstock, CT. Enjoy breathtaking long views all the way to Rhode Island! A few of the exceptional assets offered include an elegant in-law apartment, a large 6 stall horse barn with office, an inviting in-ground pool, and 25 acres of fenced open pasture. As you approach the home up the long, lighted driveway, you will immediately be impressed by the stunning architectural features and fine craftsmanship that characterize this home. "South Hill Farm" exudes a serene sense of historic grace and timelessness. Hallmark features of the 5,100+ sq ft of elegant living space include 10 ft high ceilings, 8 fireplaces, 4.5 baths, a den with classic cherry built-ins, a welcoming center foyer, and wide board flooring. Hand-painted murals of the Woodstock countryside by one of the finest local artists adorn the spacious dining area. You will love the views from the in-ground pool with stone patios, outdoor fireplace, pool house, and gardens perched high above the manicured estate. Above the heated 3-car garage, the newer in-law apartment provides private, unparalleled modern living for your guests. Bring your horses and animals.The picturesque barn connects to 6 paddocks with pastures and includes 6 stalls, tack room, hot/cold running water, spacious hay loft, and an upstairs office. Please visit and retreat from the stress of the city to this exquisite country estate.

Listed by John M. Downs and Johnetta D. Smith of Berkshire Hathaway NE Prop.

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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

216 West Quasset Road Woodstock CT 06281

MLS Number 170603216

  • Single Family
  • Square Feet 6,171
  • Bedrooms 5
  • Bathroom 5
  • Year Built 2005

Wake up to the sunrise view in this spectacular house located 4.3 acres on Quasset Lake in Woodstock CT. This 4,971 plus square foot house has 5 bedrooms, 4 full baths, and a three car attached garage. Expansive views of the lake can be seen from the Master Bedroom, formal and informal Living Rooms, and the full length outside deck which also displays the gardens and fruit trees on the property. Enjoy entertaining guests in the open space kitchen with restaurant grade appliances and granite countertops. Serve your guests in the Formal Dining room which features Brazilian hardwood floors, wainscoting, and tiered tray ceiling. Cozy up in front of the gas fireplace in the formal living room or the wood fueled fireplace in the Den/Informal Living Room before retiring in one of 5 bedrooms. The Master Bedroom has an eastern view which includes a walk in closet, full bath with custom cabinets, double sinks, vanities, along with a bath and steam shower. This Master Bedroom also features a walk-out to the outside deck to enjoy your evenings. A separate laundry room completes the first floor along with an additional guest bathroom. Ascend the grand staircase from the entry hall or from the lower-level living room to the other four bedrooms. The first of four additional bedrooms overlooks the formal gardens in the front of the house and shares a full bath with an adjoining bedroom that overlooks the lake and back yard.

Listed by Michael L. Deyorio of CR Premier Properties

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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

65 Trumbull Highway Lebanon CT 06249

MLS Number 170517226

  • Land
  • Acreage 168.4
  • MLS Status Active
  • 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.89% last updated on Jul 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

124 Route 87 Columbia CT 06237

Columbia, CT124 Route 87

Price$1,900,000

Est. Mortgage: $/month

MLS Number 24011680

  • Single Family
  • Square Feet 2,803
  • Bedrooms 3
  • Bathroom 4
  • Year Built 1935

Picture yourself living, playing and working at this wonderful property on Columbia Lake with 482' of lake frontage. A great place to enjoy your morning coffee with panoramic views of sunrise and evenings with sun set. Home recently remodeled to reflect the orginal grandeur. Great home for entertaining or just enjoying the lake life. One of the largest properties in the lake. Home features large living room that opens onto the covered porch with steps to stone patio. Master bedroom has porch with panoramic views of the lake. Both fireplaces include gas logs. Basement features a large temp and humidity controled wine cellar with additional cold storage. Large kitchen perfect for entertaining friends and family gatherings.

Listed by David S. Holcroft of RE/MAX Precision Realty

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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

89 Route 169 Woodstock CT 06281

Woodstock, CT89 Route 169

Price$1,900,000

Est. Mortgage: $/month

MLS Number 170532163

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

Ready to live at your own private airport? This quaint 2-bedroom hangar home sits on approx. 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 tie-downs of which Five are grass and five were newly paved in 2020. Aviation enthusiasts 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.89% last updated on Jul 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

12 Webster Lane Columbia CT 06237

Columbia, CT12 Webster Lane

Price$1,895,000

Est. Mortgage: $/month

MLS Number 24024266

  • Single Family
  • Square Feet 3,415
  • Bedrooms 2
  • Bathroom 4
  • Year Built 2015

Custom crafted, beautifully constructed waterfront home on highly sought after Columbia Lake! This spectacular property features a 116 ft lakeside stone wall, private dock and spacious lakefront patio. Elegantly, yet comfortably designed and built by Mike Dion Construction, this home boasts an open floor plan with attention to detail throughout. The impressive architectural detail takes every advantage of lake views. The custom kitchen features Dean cabinetry, large island, high performance appliances, and built-in service area. Kitchen opens to a large dining and living area, with French door to deck. This open floor plan features soaring ceilings, expansive Marvin windows and gorgeous lake views. Enjoy the warmth of the gas fireplace with tile and cabinet surround. First floor primary suite includes a lake view, walk in closet, additional closets with built-ins, full bath with double sink vanity, large shower and radiant heat. Upstairs you will find a large bedroom with ample closets. A stunning open loft area looks out over the first floor and to the lake beyond. Upstairs bonus room may serve as a third bedroom or family room. A full bath with heated floors will delight your guests. Fully finished ground level living space opens to large porch with fully retractable screens, which provide seamless access to the stunning yard and lakefront patios. This quality constructed, tastefully decorated lake front home is distinctive, thoughtful and elegant in its simplicity.

Listed by Pamela L. Horvath and Ben Castonguay of Sentry Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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

133 Sachem Drive Plainfield CT 06374

MLS Number 170615903

  • Land
  • Acreage 56
  • MLS Status Active
  • Other Amenities Waterfront
  • Zoning RA30

Turnkey development opportunity! Start building in the spring. 76 Unit subdivision with tons of work already done. Sewer, water and road already put in giving you a jump start! Comes with all plans and surveys. 6 minutes to Mohegan Sun and close to major highways. Inquire today!

Listed by Kyle Seyboth of Century 21 Limitless

$
$
%
$/month over payments
Federal 30-year interest rate: 6.89% last updated on Jul 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$1,750,000

Est. Mortgage: $/month

MLS Number 170421659

  • Land
  • Acreage 2.25
  • MLS Status Active
  • 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.89% last updated on Jul 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.