Greater Mansfield CT Real Estate $500k +

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

MLS Number 24041876

• Single Family
• Square Feet 4,694
• Bedrooms 5
• Bathroom 6
• Year Built 1972

Welcome to your dream lakefront property! This breathtaking 5-bedroom, 6-bathroom lake house resort has unparalleled luxury and privacy on the pristine Columbia Lake. Spanning 4,416 square feet, this exquisite estate boasts the only private beach frontage on the entire lake, with over 300 feet of direct lake access. In addition to the main residence, the property features a brand new, state-of-the-art barn/ 2 car garage. One of the garages is equipped with a loft and a full basement, providing ample space for storage, a workshop, or additional living quarters. View Listing Video: https://www.dropbox.com/scl/fi/m2q0qpo9e0w4qscxc0ssv/47-Sleepy-Hollow-Video-Cinematic.mp4?rlkey=usljx89w7344o0hawx4g7a088&e=1&st=znga5zq9&dl=0

Listed by Annmarie A. Fortier of Coldwell Banker Realty

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

• Multi Family Multi-Family For Sale
• Square Feet 11,052
• Acreage 0.44
• Bedrooms 29
• Bathroom 17

NEW TO THE MARKET...MONEY MAKING PORTFOLIO iin Windham with 16 UNITS & 6-1 Bay Detached garages consisting of 4 Buildings w/4 units per building within less than .5 miles from each other, with the possibility of adding an additional 3 units to make a total of 19 units with over 11,000 sqft for all buildings. Tenants pay heat, Hot water & electricity. LOW expenses for the owner with LOTS OF PROFIT left over and the potential to bring the profit to approx 25k a month & 300k a year or higher. Combination of leased and month to month tenants in place...ALL UNITS ARE FULLY RENTED. Buildings consist of 146 Chapman- has the 6 bay garage, large parking in the back w .44 ac, possible 5th unit, 403 pleasant st- large parking lot in the back w.25 ac, possible.5th unit,(featured picture), 36 Taylor Ct- has its own driveway for parking w/ .20 ac lot, possible 5th unit, sits privately & 20 Spruce st has .10ac Amazing opportunity to buy in BULK and have all your units close by. City Water & CITY Sewer. If your looking for a smaller portfolio thats no problem, seller will combine pleasant & Taylor for 8 units total for 799k and Chapman & Spruce for 8 units total at 799k. All properties have separate deeds and lots. Acreage, taxes, year built on this listing is for only pleasant st. Also will be listed as 2- 8 units for sale separately. Some info inputted will vary & may reflect all or individual properties. Specifics upon request. Close to ESCU, Hartford, Boston & all major routes

Listed by Irene Adams of Signature Properties of NewEng

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