Greater Mansfield CT Real Estate $500k +

MLS Number 24197162

• Multi Family Multi-Family For Sale
• Square Feet 23,064
• Acreage 0.6
• Bedrooms 3
• Bathroom 2

Exceptional redevelopment opportunity in Hartford's desirable West End. This 23,064 SF, two-story office building presents outstanding potential for an office-to-multifamily conversion. The property was previously approved for a 29-unit apartment conversion, providing a significant head start for developers. The approved unit mix consisted of 27 one-bedroom apartments with projected rents of approximately $1,300 per month and 2 two-bedroom apartments with projected rents of approximately $1,500 per month. Situated on approximately 0.60 acres with ample off-street parking (roughly 30+ spaces), the property is ideally positioned for investors seeking to capitalize on Hartford's continued demand for quality rental housing. Redevelopment opportunities of this scale and location are increasingly difficult to find, making this an exceptional value-add development opportunity. The property offers a substantial footprint, flexible floor plan, and a prominent location along Farmington Avenue with convenient access to Downtown Hartford, West Hartford Center, major highways, public transportation, hospitals, and major employers. One or more of this property's owners is a Real Estate Licensee.

Listed by Amanda R. Faroni-Sheehan of Oxford Realty

MLS Number 24210193

• Multi Family Multi-Family For Sale
• Square Feet 4,524
• Acreage 0.14
• Bedrooms 9
• Bathroom 8

TAX ABATED BUILDING AMAZING OPPORTUNITY in Hartford's Frog Hollow neighborhood! This completely renovated property features a total of 7 Units, 6- 1 Bedroom and 1- 3 Bedroom. 7 off-street parking spaces with a private driveway. With approximately 5,000 square feet, 9 bedrooms, 8 bathrooms, natural gas heat, a full basement, this property will provide great income potential. Conveniently located near shopping, public transportation, schools, and major highways.

Listed by Shay Hugo Vaezzadeh of Oxford Realty

MLS Number 24183501

• Single Family
• Square Feet 2,000
• Bedrooms 4
• Bathroom 3
• Year Built 2026

Discover an exceptional To Be Built opportunity at 0 Shennecossett Road, where coastal convenience, modern design, and everyday luxury come together on a prime corner lot moments from the beach and Shennecossett Golf Course. This 2,000 sq. ft. modern farmhouse is thoughtfully designed with 4 bedrooms, 3 bathrooms, a 2-car garage, a covered front porch, and a rear deck - perfect for relaxed mornings, effortless entertaining, and enjoying the best of the shoreline lifestyle. White oak hardwood flooring runs throughout the entire home, giving a modern yet warm and inviting feel that ties every space together, while tile flooring in all three full bathrooms adds a polished, spa-like touch. The flexible first-floor layout features two bedrooms, both with ensuite bathrooms, offering an ideal setup for guest accommodations or multigenerational living. Upstairs, two additional bedrooms and a full bathroom create a separate space for family, guests, work-from-home needs, or quiet relaxation. The unfinished basement offers even more room to grow, with potential for a home office, gym, media space, or future recreation area. Close to Pfizer, Electric Boat, beaches, shopping, dining, and just minutes from Mystic, this is what Groton shoreline living is all about. To Be Built by Caulkins Homes, an experienced local design and build company with nearly 40 years of experience. First rendering - custom options available.

Listed by Heather M. Caulkins of William Pitt Sotheby's Int'l

MLS Number 24212552

• Single Family
• Square Feet 3,664
• Bedrooms 4
• Bathroom 4
• Year Built 2007

Meticulously maintained Colonial located on a cul-de-sac in Bolton, built in 2007, offering 4 bedrooms, 3.5 bathrooms and 3,664 square feet on 1.09 acres. Hardwood floors, crown molding and wainscoting complement the interior. A front entry with sidelights welcomes you into a spacious, bright foyer. The kitchen features cherry cabinetry, stainless steel appliances and hardwood flooring, and opens to a generous family room with a stone fireplace. Two staircases provide access to the second floor, where the primary suite includes two spacious closets and a bathroom with a whirlpool tub, separate shower, cherry vanity cabinetry and double sinks. Three additional bedrooms, a Jack-and-Jill bathroom, a convenient second-floor laundry room and a separate nook offering library or storage space complete the second floor. The finished third floor provides approximately 600 additional square feet for recreation, a home office or other flexible use. This space is not included in the stated 3,664 square feet. Outside, a spacious, low-maintenance Trex deck overlooks the expansive, private, park-like yard with an irrigation system. An oversized 5-car garage provides ample room for vehicles, storage and hobbies.

Listed by Theodore Branon of Better Homes and Gardens Real Estate Executive Real Estate

MLS Number 24187035

• Land
• Acreage 17.1
• MLS Status Active
• Other Amenities Waterfront, Dock
• Waterfront

Rare mixed-use farm/commercial opportunity in Andover! This offering combines 11 Bunker Hill Rd with a second Route 6 parcel for a total of 17.1 acres with direct Route 6 access, two large parking areas, and land that mostly abuts the Hop River. The existing 4,565 gross SF building offers a flexible setup with offices, garage/warehouse space, approximately 15' ceiling height, truck dock, cleared work areas, pavilion/patio space, and established tree farm acreage. Ideal for an owner-user, agricultural operator, nursery/landscape business, farm-to-retail concept, contractor, storage/distribution user, agritourism venture, event-forward farm operation, or investor seeking a rare combination of visibility, acreage, existing improvements, and rural New England character. Current land use is 037: Mixed Use-Primary Commercial & Agriculture, supporting the property's blend of business and farm utility. Potential uses may include farming, nursery/tree farm operations, wayside farm stand, retail, office, agricultural sales, contractor/business operations, agritourism, or other mixed-use concepts-subject to buyer due diligence, zoning, wetlands, inland watercourse, and Town approvals. Land, buildings, parking, cleared areas, pavilion, patio, and tree farm are being offered together as one unique Andover opportunity.

Listed by Robert F. Rosa of Berkshire Hathaway NE Prop.

MLS Number 24186987

• Commercial
• MLS Status Active
• Year Built 1957
• Square Feet 4,565
• Acreage 15.5

Rare mixed-use farm/commercial opportunity in Andover! This offering combines 11 Bunker Hill Rd with a second Route 6 parcel for a total of 17.1 acres with direct Route 6 access, two large parking areas, and land that mostly abuts the Hop River. The existing 4,565 gross SF building offers a flexible setup with offices, garage/warehouse space, approximately 15' ceiling height, truck dock, cleared work areas, pavilion/patio space, and established tree farm acreage. Ideal for an owner-user, agricultural operator, nursery/landscape business, farm-to-retail concept, contractor, storage/distribution user, agritourism venture, event-forward farm operation, or investor seeking a rare combination of visibility, acreage, existing improvements, and rural New England character. Current land use is 037: Mixed Use-Primary Commercial & Agriculture, supporting the property's blend of business and farm utility. Potential uses may include farming, nursery/tree farm operations, wayside farm stand, retail, office, agricultural sales, contractor/business operations, agritourism, or other mixed-use concepts-subject to buyer due diligence, zoning, wetlands, inland watercourse, and Town approvals. Land, buildings, parking, cleared areas, pavilion, patio, and tree farm are being offered together as one unique Andover opportunity.

Listed by Robert F. Rosa of Berkshire Hathaway NE Prop.

MLS Number 24207605

• Single Family
• Square Feet 3,753
• Bedrooms 4
• Bathroom 4
• Year Built 2003

Welcome to 10 Arden Dr., a 2003 custom-built home with 3,753 sqft of well-designed spaces, stunning details, thoughtful storage, a flexible floor plan, an inground pool and outdoor living spaces, all set on 2.93 private acres set back from the street. From the circular driveway, to the grand foyer with curved staircase & curved walls, with chandelier and decorative mouldings, to the refinished oak floors, central air, central vac, 4 bedrooms, 3 full and 1 half bath, to the new roof & skylights in 2024, soaring ceilings, and the oversized windows flooding the house with natural light, there is so much to love. 1st floor rooms include an office, sun room, living room, family room, media room, dining room, spacious kitchen with island, pantry, breakfast area, kitchen office nook, laundry room, and half bath. 2nd floor has the primary suite, another bedroom with ensuite bath, 2 more bedrooms, and shared bath with double sinks. 3 of the bedrooms have new carpeting installed in 2025, the primary has hardwood floors. There's even a laundry chute & a pulldown attic for storage. Quality details like 2x6 construction, a turret feature, 10ft ceilings in the basement for future living space, a walkout instead of bulkhead, 3-car garage with hot & cold water, dual 330 gallon fuel tanks, driveway lights, security system, irrigation system, covered brick porch and patio installed in 2024 add incredible value that you don't get with new construction. This custom build has it all!

Listed by Lynn P. Minnick of Carl Guild & Associates

MLS Number 24214232

• Single Family
• Square Feet 5,102
• Bedrooms 4
• Bathroom 5
• Year Built 2000

Prepare to be captivated by this stunning, stately brick Colonial, perfectly situated on a beautifully landscaped lot surrounded by mature trees and natural beauty. This exceptional residence offers 5 bedrooms and 4.5 bathrooms, blending timeless elegance with everyday comfort and privacy. Each spacious bedroom features its own ensuite bathroom, providing the ultimate convenience for family and guests alike. The versatile fifth room can easily serve as a private home office, guest suite, or an additional oversized bedroom to fit your lifestyle. From its classic curb appeal to its thoughtfully designed interior, this home is truly one of a kind. Step outside to your own private backyard, where a beautifully finished stone patio and spacious deck create the perfect setting for relaxing or entertaining. Surrounded by mature trees, the expansive yard offers exceptional privacy and plenty of room to add the pool of your dreams, making this outdoor space full of endless possibilities.

Listed by Amy P. Rio of Better Homes and Gardens Real Estate Executive Real Estate

MLS Number 24196261

• Single Family
• Square Feet 3,745
• Bedrooms 3
• Bathroom 3
• Year Built 1977

This extraordinary custom residence seamlessly blends timeless elegance with relaxed sophistication. Originally a log cabin and thoughtfully reimagined into a luxurious estate, the home showcases exceptional craftsmanship, distinctive architectural details, and premium finishes throughout. A stunning wraparound porch with rich mahogany flooring and beadboard ceilings creates an inviting first impression, while the oversized carriage-style two-car garage provides generous space for vehicles and additional storage. Step inside to a dramatic two-story foyer featuring soaring ceilings, travertine flooring, and an elegant marble medallion inlay. Every room reflects meticulous attention to detail, from shadowbox accents, bullnose archways, and custom niches to hand-painted walls and a beautifully frescoed foyer ceiling. The great room is anchored by a floor-to-ceiling stone fireplace, custom handcrafted built-in entertainment center, and striking cherry inlay hardwood flooring that adds warmth and character. French doors on either side of the fireplace fill the space with natural light and provide seamless access to the outdoor entertaining areas. Andersen windows and designer lighting enhance the home's bright, welcoming atmosphere. Designed for both everyday living and entertaining, the chef's kitchen features terra-cotta tile flooring , an oversized center island, handcrafted cabinetry, extra-thick granite countertops, tumbled marble backsplash.

Listed by Thomas Simjian of Keller Williams Coastal