Greater Mansfield CT Real Estate $500k +

MLS Number 24056055

• Single Family
• Square Feet 4,752
• Bedrooms 6
• Bathroom 5
• Year Built 1935

If you have been looking for a lake front family compound you are in luck. With over 700' of lake frontage, 2 homes and lots of open space you are ready for those big family events. Set on a strategic point on Columbia lake you have panoramic sun rise and sun set views. Both homes have great views of the lake, the perfect place to enjoy your morning coffee or just relax. Main house has a large temp and humidity controled wine cellar with additional cold storage. This is a must see for anyone wanting to live the lake life on one of CT nicest lakes.

Listed by David S. Holcroft of RE/MAX Precision 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 multifamily housing in the market! Enrollment Undergrad Graduate ECSU 5,832 4,300 1,000 UCONN 32,182 19,241 7,098 New Zoning Regulations allow 10 units per acre

Listed by David Mieczynski of National Realty Advisors LLC

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

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 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

MLS Number 24036313

• Single Family
• Square Feet 4,100
• Bedrooms 3
• Bathroom 3
• Year Built 2005

Bear Hill Estate: An Exemplar of Luxury and Equestrian Splendor in Woodstock, CT. Discover the pinnacle of luxury estate living at Bear Hill Estate, a bespoke 100.2-acre private retreat in the serene Quiet Corner of Woodstock, CT. Secluded behind a private gated driveway, this sophisticated sanctuary offers a harmonious blend of elegance and tranquility. Central to this unparalleled property is a 2,400 sq ft custom log cabin, where opulent tumbled marble flooring and awe-inspiring cathedral ceilings define the grand great room. The gourmet kitchen, a culinary dream, boasts top-of-the-line stainless steel appliances, catering to the most discerning chef. The estate's main level is graced with two lavish bedrooms and a well-appointed office space, streamlined with laundry facilities for modern convenience. Ascend the impressive spiral staircase to a versatile loft area, an ideal space for a third bedroom or a personalized living area. Equestrian enthusiasts will be drawn to the sophisticated 1,600 sq ft horse barn, meticulously designed with five horse stalls, a heated tack room with private lockers, a feed room, and a wash stall. The cabin's integrated one-car garage serves as a practical workshop and storage for farm essentials, while the detached two-car garage, equipped with a wood stove and propane backup system, ensures year-round comfort.

Listed by Melissa Guerrero of William Pitt Sotheby's Int'l

MLS Number 24063349

• Land
• Acreage 30.87
• MLS Status Active
• Other Amenities Waterfront
• Zoning R20

A very unique opportunity in Mansfield, a large piece of land with water, sewer and possibly natural gas access! Two parcels (33.98A.2 & 33.98B.2) totaling 30.87 acres with access to public water, public sewer, walking distance to Eastbrook Mall, Big Y Supermarket, Ledgebrook Office Complex and more. The main parcel is 26.77 acres of raw land with topography that generally rises from the south east to the north west (from the road towards the back) and has frontage on both Conantville/Meadowbrook as well as Puddin Lane to the north (2 connections). While the value is in the land, it does have a 3-car garage with rented apartment above. The second parcel is 4.1 acres in size and adds frontage on Conantville Rd. Survey, Feasibility, Site Analysis and Area Amenities available. Zoning includes both R-20 and R-90 portions, with access to shopping, office space, water & sewer, and just minutes to Windham Hospital, Eastern CT State University & UConn, there are a multitude of possibilities for this piece and with the rental income from the existing properties, holding costs can be offset while plans develop!

Listed by Steven B. Ferrigno of Ferrigno-Storrs,REALTORS LLC

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

MLS Number 24052420

• Land
• Acreage 83.12
• MLS Status Active
• 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 senior 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, visit today for more details and information.

Listed by Elaine AbouAkar of Century 21 AllPoints Realty

MLS Number 24064876

• Land
• Acreage 15.84
• MLS Status Active
• Other Amenities Waterfront
• Zoning GB

15.84 Acres in GB zone. Well & Sewer. Public water is .54 of a mile down the road. 340 feet of frontage 16,700 traffic count. An additional 4.93 acres across the street. Possible uses Hotels, Gas Station, Manufacturing, Retail Restaurants, Taverns. Daycare.

Listed by Ron Lyman of Lyman Real Estate

MLS Number 24002442

• Land
• Acreage 1.15
• MLS Status Active
• Zoning C2

PROPERTY DESCRIPTION 322 Boston Post Rd in North Windham for Sale. This development site is 1.15-acres and is fully approved and permitted for a car wash with 120-foot tunnel, 3 pay stations and 13 vacuums. PROPERTY HIGHLIGHTS Full Approvals and Permits in Place for Car Wash 120-Foot Tunnel Length 21,000 VPD 3 Pay Stations 13 Vacuums Site Plan Site Has Full Due Diligence Permits and AIA Contract That is Assignable Survey, Geotech, and Environmental Report

Listed by James L. McCall of Coldwell Banker Commercial NRT

MLS Number 170621084

• Single Family
• Square Feet 4,800
• Year Built 2004
• Acreage 8.29
• Original listprice $1,799,999

Andover is a quaint, historical New England town just 10 miles outside of Hartford and home to what's currently known as Andover Auto Parts. Such an extraordinary opportunity to grab this prime location and established, turn-key business. The steel-framed, metal building is 4,800 sf with 3 large garage bays, office space and a mezzanine. The property sits on over 8 acres of flat land with on-site parking and includes the abundant inventory of 350+ late model cars and used auto parts for sale. Zoned commercial. City Water and City Sewer. High traffic visibility. The LLC will transfer with the sale and includes both Dealer and Junk Care licenses. Schedule a tour today!

Listed by Simonne E. Corriveau of KW Legacy Partners