Greater Mansfield CT Real Estate $500k +

MLS Number 24069977

• Commercial
• MLS Status Active
• Year Built 1987
• Bathroom 5
• Square Feet 33,778

Exceptional investment opportunity at 303 Merrow Road, Tolland, CT. This 34,000-square-foot Class B office space is newly primed for conversion into a self-storage facility, thanks to recently approved zoning amendments and a strong market outlook. With the groundwork already in place, this property represents a unique opportunity to capitalize on the growing demand for self-storage in the Tolland area. Property Overview * Location: Strategically located just off Route 195, the property is only 1 mile from I-84 and 5.5 miles from the UConn Storrs campus. This highly accessible location connects to a wide customer base, including residents, businesses, and schools. * Zoning Flexibility: Newly approved zoning opens up a range of potential uses, making this property highly versatile. Options include self-storage, retail, personal and professional services, hospitality, mixed-use development, and more. * Development Potential: A Pre-Development Self-Storage Site & Market Feasibility Study conducted by Self Storage 101 has provided a detailed analysis of this opportunity. The study proposes a combination of drive-up, non-climate-controlled units on the open land and climate-controlled, interior-access units within the existing building. The included OM provides further information on these findings and recommendations.

Listed by Mark Riesbeck of Berkshire Hathaway NE Prop.

MLS Number 24162452

• Single Family
• Square Feet 6,015
• Bedrooms 4
• Bathroom 8
• Year Built 2016

Custom Catarino-built French Country residence, located on a cul-de-sac in an enclave of fine homes, seamlessly blends rustic charm with modern elegance. Situated high on a knoll to capture unparalleled views of Hartford skyline and the ridges beyond, this 5022 sq ft home, built in 2016, offers a multitude of warm, welcoming spaces, each designed to perfection. The Kitchen and Great Room create an immediate impact - literally take your breath away - with extraordinary architectural design that offer both scale and comfort. A stove hood crafted from natural stone anchors the space, complemented by beams of reclaimed wood overhead, a massive center island with seating for six, and a windowed sitting alcove that calls you to relax with a morning coffee. In the two-story Great Room, oversized custom Andersen windows flood the space with natural light, while a stone gas fireplace adds warmth and a striking focal point. Vibrant sunsets transform the dining room many evenings, casting the space in warm light and color. Working from home is a pleasure in the dedicated office with bump-out bay windows, coffered ceiling, and gas fireplace. A fabulous first floor flex space with attached accessible bath is perfect for guests, playroom or library. On the second level is a magnificent primary bedroom with stunning barrel ceiling, sitting room, French doors opening to sweeping vistas, and a sumptuous ensuite bath with soaking tub, heated floors, and deluxe shower. Three additional

Listed by Michelle C. Collins of Berkshire Hathaway NE Prop.

MLS Number 24180508

• Single Family
• Square Feet 3,723
• Bedrooms 4
• Bathroom 4
• Year Built 1989

Extraordinary Waterfront Estate. Set on an exceptional 5.5-acre private lot with 265 feet of shoreline frontage, this completely rebuilt luxury residence offers a rare opportunity to own one of Woodstock's premier lakefront properties. Arrive via a long, newly paved private driveway that winds through a tranquil setting before revealing this stunning waterfront retreat. Offering 3,971 square feet, 4 bedrooms, and 4 bathrooms, the home was rebuilt from the ground up with next level quality and craftsmanship. Designed for both elegant entertaining and everyday enjoyment, the layout includes a formal dining room, spacious family room, custom mudroom, and a beautiful living room with propane fireplace overlooking Quasset Lake. The showpiece kitchen is truly one-of-a-kind, featuring handcrafted cabinetry by a New York artisan cabinet maker, thick quartzite countertops, premium built-in appliances, and a dramatic tray ceiling with custom white oak detailing. Luxury finishes continue throughout with veneer plaster walls, custom white oak vanities, a professionally designed primary closet, handmade laundry room cabinetry, and architectural flangeless LED lighting seamlessly integrated into the wood ceilings. Built with 2x6 construction, engineered floor systems, 2x12 roof rafters, red cedar siding and trim, central air, all-new heating and cooling systems, underground 400-amp service, and an automatic whole-house generator. Step outside and embrace the ultimate lake lifestyle.

Listed by Skyla Gagnon of RE/MAX Bell Park Realty

MLS Number 24019658

• Commercial
• MLS Status Active
• Year Built 1971
• Bathroom 1
• Square Feet 12,808

Successful auto body/auto repair shop with affluent customer base for sale, including real estate. Includes used car license. Well maintained 6 bay building with inside parking for 15+ vehicles on large lot with lots of parking. Located on a busy primary road. Strong & consistent profitability illustrated by very clear financial records which can be available to a qualified person. The seller is retiring after 20 years in business. This is a fine opportunity to secure a stable financial future. Stock photo. DO NOT VISIT THE SITE AND SPEAK WITH EMPLOYEES.

Listed by Gary Pruitt of Century 21 Classic Homes

MLS Number 24163520

• Commercial
• MLS Status Active
• Year Built 1985
• Bathroom 1
• Square Feet 2,850

Location! Right off the I-95 on/off Ramp, You will find an Exceptional Commercial Property. Located at the end of a cul-de-sac, in an Industrial park setting. This property is 10.48 Acres and has a 2,850 sq. ft. pre-fab metal building, with 450 sq. ft of office space, including a bathroom, a 2,400 sq. ft warehouse with a mezzanine and 2 large loading docks at grade level, offering many possibilities. Most recently, it operated as a Pipe Company warehouse/office and a material yard. Currently there are 2 acres completely fenced in, with a locking gate and plenty of room to expand. With easy highway access, there's many possibilities, subject to approvals.

Listed by Colleen E. Block of Barile Realty Group

MLS Number 24164443

• Land
• Acreage 1.18
• MLS Status Active
• Waterfront
• Zoning RA-40

Set on a gentle promontory, this rare waterfront property features 1.18 acres of level, cleared land on one of Stonington's most picturesque streets. The property offers a superior high vantage building site anchored by original stone walls and mature trees, complete with a two-story barn and Brazilian walnut dock. With 372 feet of direct frontage on the protected waters of Quiambaug Cove, the site provides a direct gateway to the deep waters of Fishers Island Sound. Ideally located a short walk from Wehpittituck Farm, the property sits perfectly between the close-by amenities of Stonington Borough and downtown Mystic. This site represents an exceptional opportunity to own a prime waterfront property in one of the region's most sought-after locations.

Listed by Thomas Switz and Jackson Switz of Switz Real Estate Associates

MLS Number 24168789

• Condo
• Bedrooms 2
• Bathroom 3
• Square Feet 2,128
• Year Built 2026

Welcome to Center Park Place, where sophisticated living meets unparalleled access in the heart of West Hartford Center. Positioned as the area's most prestigious new development, these incredible condominiums offer a lifestyle of luxury, with gourmet dining, upscale shopping, and cultural experiences just a short walk away. Residences feature hardwood floors, high ceilings, European-style cabinetry, walk-in closets, and a premium appliance suite featuring Sub-Zero, Wolf, and Bosch. Many units come complete with outdoor space as well! Curated amenities elevate everyday living, including a stunning rooftop oasis with comfortable lounge areas and city views. For relaxation and rejuvenation, you can enjoy a heated outdoor pool and luxurious lounge area, or maintain your wellness routine in a state-of-the-art fitness facility with the latest equipment. The building also offers dedicated amenities and convenience with lobby concierge, communal lounge areas with fire pits, a private residence lounge with a kitchen, and secure parking provided. Unit 612 is a one-of-a-kind layout, a stunning triple-exposure corner penthouse with a massive wrap-around terrace which spans the entire eastern and southern sides of the residence. This luxurious home features 2 bedrooms plus a den, 2.5 baths, high ceilings and dramatic large windows, allowing for maximum light and views. Don't miss the chance to own in one of the hottest new property in New England!

Listed by Catherine A. McCahill of William Pitt Sotheby's Int'l

MLS Number 24164433

• Land
• Acreage 0.94
• MLS Status Active
• Waterfront
• Zoning RA-40

An exceptional waterfront lot offering the rare opportunity to own almost 1 acre of level coastal property in prime Stonington. Historic stone walls and mature trees frame sweeping views of the serene waterfront of Quiambaug Cove. 225 feet of frontage on the cove provides access to the deep waters of Fishers Island Sound. Equally positioned between the vibrant, close by amenities of downtown Mystic and Stonington Borough, and a short walk down the street from Wehpittituck Farm. Offering nearly 260 feet in depth, the parcel sits on one of Stonington's most scenic roads. This site offers the rare chance to own prime waterfront property in one of the region's most sought-after locations.

Listed by Thomas Switz and Jackson Switz of Switz Real Estate Associates

MLS Number 24176769

• Single Family
• Square Feet 2,899
• Bedrooms 6
• Bathroom 3
• Year Built 1937

Perched in an exceptional waterfront setting with sweeping panoramic views from the Mystic River to Fisher's Island Sound, this timeless coastal residence offers a rare blend of elegance, comfort, and versatility. Beautifully maintained and thoughtfully updated, the home captures ever-changing water views from nearly every room while offering the ease of one-floor living with expansive space for guests, entertaining, or multi-generational living. The sun-filled living room features a fireplace w/ custom paneling and built-ins, while oversized sliders open to an expansive stone terrace overlooking the water, marshlands, and the village of Noank beyond. The formal dining room shares the same breathtaking 180-degree views. The kitchen is appointed w/ granite countertops, custom cherry cabinetry, a Viking range, wine cooler, and abundant natural light. The first-floor primary suite offers a peaceful retreat with updated marble flooring and shower. Upstairs, six additional flexible rooms provide ideal space for guests, offices, or playrooms, along with two full baths and a dedicated laundry room. Set high above the shoreline, the property also includes a picturesque lower yard and a classic boathouse w/ electricity, perfect for storage, workshop, or studio use. A tranquil salt pond enhances the natural beauty, while owned marsh frontage provides direct access to 19 feet of waterfront. An extraordinary coastal offering combining privacy, timeless character, and unforgettable views.

Listed by Jon Arruda of William Pitt Sotheby's Int'l