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: 7.1% last updated on Apr 18, 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: 7.1% last updated on Apr 18, 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

32 Audette Road Franklin CT 06254

MLS Number 170606185

  • Single Family
  • Square Feet 5,314
  • Bedrooms 3
  • Bathroom 3
  • Year Built 2001

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

$
$
%
$/month over payments
Federal 30-year interest rate: 7.1% last updated on Apr 18, 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: 7.1% last updated on Apr 18, 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: 7.1% last updated on Apr 18, 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$2,150,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: 7.1% last updated on Apr 18, 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

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: 7.1% last updated on Apr 18, 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

586 Middletown Road Colchester CT 06415

Colchester, CT586 Middletown Road

Price$1,990,000

Est. Mortgage: $/month

MLS Number 170625161

  • Single Family
  • Square Feet 3,097
  • Bedrooms 4
  • Bathroom 4
  • Year Built 2024

Once in a lifetime opportunity to have your own private estate. Set on 23.9 acres, this 3,097sqft Modern Farmhouse home is destined to be an instant classic. This extraordinary property blends breathtaking natural surroundings with an exquisite, one-of-a-kind barn (see The Black Horse attachment) and a stunning custom home. This special estate epitomizes luxury living where timeless elegance and modern amenities reign supreme. The captivated crisp and clean architectural design has all the right details such as James Hardie siding, black windows, and metal roofing. The carefully selected materials and finishes, coupled with impeccable craftsmanship and detail, add a touch of elegance and sophistication to every room. The heart of this magnificent home is the gourmet chef's kitchen, where no expense is spared. High-end appliances, custom cabinetry, and a generous center island is the perfect space for culinary creations. The open floorplan was thoughtfully designed to flow seamlessly between the kitchen, spacious family room, dining area, and covered porch. The first-floor primary suite is truly remarkable, offering unparalleled comfort and luxury. The home office is discretely positioned to provide an ideal quiet environment. The second-floor features three generously proportioned bedrooms and two elegantly appointed bathrooms. The ultra-energy-efficient geothermal system, high-performance insulation, and green construction practices ensure the utmost comfort and efficiency.

Listed by Jeff Bodeau of William Raveis Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 7.1% last updated on Apr 18, 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: 7.1% last updated on Apr 18, 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

322 Boston Post Road Windham CT 06256

Windham, CT322 Boston Post Road

Price$1,500,000

Est. Mortgage: $/month

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

$
$
%
$/month over payments
Federal 30-year interest rate: 7.1% last updated on Apr 18, 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,500,000

Est. Mortgage: $/month

MLS Number 170421677

  • Land
  • Acreage 2.25
  • MLS Status Active
  • Other Amenities Waterfront
  • Zoning GDD

Also available as land lease $100,000/year NNN Parcel marked restaurant section see attached map. Public Water & Sewer. Traffic Count: 11,200 on Merrow, 101,600 on 84 Also available Hotel site $1,750,000. 10% discount if both are purchased.

Listed by Ron Lyman of Lyman Real Estate

$
$
%
$/month over payments
Federal 30-year interest rate: 7.1% last updated on Apr 18, 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

23 Hayward Avenue Colchester CT 06415

Colchester, CT23 Hayward Avenue

Price$1,350,000

Est. Mortgage: $/month

MLS Number 170545645

  • Multi Family Multi-Family For Sale
  • Square Feet 6,346
  • Acreage 0.29
  • Bedrooms 12
  • Bathroom 9

Rarely available 9 unit multifamily on Colchester town green! Currently offered at a 7% Cap Rate with a 7.6% ROI and tremendous upside! The main building has 7 units and there is a 2 unit cottage in the rear of the property. This investment opportunity boasts a historically low vacancy rate due to increasing demand for apartment rentals in local market. Current ownership has gut-renovated each unit over the past decade, while preserving some of the historical aesthetics, such as hardwood flooring and the original cupola on top of the 3rd floor penthouse apartment. Renovations include new: electrical, plumbing, insulation, roof, sewer line, energy efficient double pane windows, flooring, drywall, fire rated steel doors, wired fire alarm system, and separately metered electric. All apartments feature separate and tenant paid electric electric baseboard heat. The unit mix is (1) efficiency, (3) 1 beds, (2) 2 beds, and a large 2 bedroom penthouse apartment, approximately 1,800 SF. There are (2) 1 bedroom units in the cottage in the rear of the property. Prime downtown location next to the Town Green where community events are held regularly. Amenities can be found all around and include: restaurants, retail shopping, grocery stores, and service businesses. Very easy and convenient access to Route 2 and Route 85. Only 25 minutes to Hartford, Norwich and New London. One of a kind property, call today to schedule a private tour!

Listed by Tyler Egner of Sky Realty Group

$
$
%
$/month over payments
Federal 30-year interest rate: 7.1% last updated on Apr 18, 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.