Greater Mansfield CT Real Estate $500k +

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

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 Ronald Lyman of Lyman Real Estate

MLS Number 170606185

• Single Family
• Square Feet 5,314
• Year Built 2001
• Property Style Contemporary, Ranch
• Bedrooms 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 and Kristen Walsh of Coldwell Banker Realty

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

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

MLS Number 170607706

• Single Family
• Square Feet 4,217
• Bedrooms 4
• Bathroom 4
• Year Built 2002

Retreat from the stress of the city to this luxurious 106 Acre Country Estate located between New York and Boston! Perfectly nestled in Connecticut's Quiet Corner, this exquisite property offers the perfect blend of elegance, privacy, and nature's tranquillity. The home is the result of consummate planning and is the ultimate in quality craftsmanship. Offered to the public for the first time! Follow the long driveway to the hilltop, and you will find this perfectly placed, meticulously built residence. The interior design has beautifully proportioned rooms, rich in architectural detail. Features include high ceilings, built-ins, crown moldings, 3 fireplaces, granite, stained glass, and hardwoods with inlay. Whether for grand entertaining or everyday living, the gracious family room, the spacious chef's gourmet kitchen, formal dining room, and living room provide the ultimate experience in comfort and idyllic living. Oversized glassed windows, French doors, and multitudes of deep open decks allow stunning long views of the open fields and natural beauty. Mechanicals include a generator, heated 3-car garage, radiant heat, a large bonus room, and immense walk-out basement set up for future in-law or expansion. The expansive 106-acre property consists of acres of majestic woods, walking trails, and the ability for possible future development if desired. This property is truly for the discerning buyer searching for the ultimate private preserve. A rare find! Please visit today.

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

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 for the following designations either through a Permitted Site Plan or a Special Permit: Retail, Personal, & Professional Service, Hospitality, Commercial Office, Commercial 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.

MLS Number 170603216

• Single Family
• Square Feet 6,171
• Property Style Colonial
• Year Built 2005
• Bathroom 5

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

MLS Number 170605381

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

Picture yourself living, playing and working at this wonderful property on Columbia Lake. Panoramic views of sunrise and 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

MLS Number 170517226

• Land
• Acreage 168.4
• MLS Status Active
• Subdivision Pleasant Valley Farm
• Subdividable

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

MLS Number 170465560

• Single Family
• Square Feet 3,400
• Bedrooms 4
• Bathroom 6
• Year Built 1999

40 acre Equestrian Estate offers wonderful opportunity for building a business where you live. A well thought out design, it has been built with upscale materials and eco friendly utilities including geo thermal heating and cooling in the residential homes. There facility offers 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 are 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 with bathroom for attendees. The main residence sits a short distance 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. 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.

Listed by Lori A. Vogel of William Raveis Real Estate

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 Ronald Lyman of Lyman Real Estate