Greater Mansfield CT Real Estate $500k +

MLS Number 170597460

• Single Family
• Square Feet 18,777
• Bedrooms 9
• Property Style Other
• 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 RANDALL,REALTORS-Compass

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 170582801

• Land
• Acreage 602.63
• MLS Status Active
• Subdividable Unknown
• Zoning R080

Welcome to your own personal "Yellow Stone Like Paradise" Over 600 lush acres of land!! Currently a working farm with so much room for whatever your dreams desire!!! Property also features a beautiful 3 Bedroom 3 Bath Contemporary Ranch with an 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

MLS Number 170531845

• Single Family
• Square Feet 5,314
• Property Style Contemporary, Ranch
• Bathroom 3
• 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 of Coldwell Banker Realty

MLS Number 170176105

• Land
• MLS Status Active
• Acreage 42
• 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
• Property Style Ranch, Other
• Bathroom 3
• Bedrooms 2

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 170554493

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

Approved lot available for development. These well located 67 acres of pristine and raw land with 396 ft of road frontage offers lots of privacy. Fantastic opportunity to build 18+ homes in a great location. Close to schools, shopping, library, park and recreation. Minutes away from Staffordville Lake and about 1hr 40 min to Boston. Could be used as CAMPGROUND as well!!!

Listed by Beata Zapadka of Vision Real Estate

MLS Number 170560805

• Single Family
• Square Feet 5,108
• Bedrooms 4
• Property Style French, Tudor
• 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 James Kelly of William Raveis Real Estate

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 170465560

• Single Family
• Square Feet 3,400
• Bedrooms 4
• Property Style Cape Cod, Ranch
• Bathroom 6

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 170517226

• Land
• MLS Status Active
• Acreage 168.4
• 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 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