Refine Search
Sort by
$1,825,000
21 Beds 15 Baths 24197237 MLS
Excellent opportunity to acquire a 16-unit mixed-use investment property strategically positioned along one of New Britain's primary commercial corridors. The property consists of 12 residential units (six 2-bedroom/1-bath units and six 1-bedroom/1-bath units) and four street-level commercial spaces, offering investors a diversified income stream. The commercial component is fully leased to a nail academy (occupying two storefronts), a pizzeria, and a mini market. The nail academy has made substantial tenant improvements, including the installation of commercial HVAC systems, ventilation, and interior build-outs, reflecting a long-term commitment to the property. The residential apartments are separately metered for electricity, with the landlord responsible for heat and hot water. Commercial tenants is responsible for their own utilities (separately metered), reducing operating expenses and enhancing the property's income profile. The asset provides strong in-place cash flow with additional upside through residential rent growth as units turn over. Additional highlights include ample on-site parking, excellent street frontage and visibility, and a high-traffic location. Conveniently located just minutes from Central Connecticut State University (CCSU), Downtown New Britain, CTfastrak, and major highways including Route 9, Route 72, and Interstate 84.

250 North St, New Britain

$790,000
6 Beds 6 Baths 24197135 MLS
This elegant, 6,000-square-foot residence in Hartford's prestigious West End is set on a generous 2/3-acre lot that provides exceptional outdoor space for entertaining, gardening, or simply enjoying your privacy. Almost immediately adjacent to Overlook Park and historic Elizabeth Park, offering trails, basketball & tennis courts, a playground, a baseball diamond, beautiful pubic gardens, and a performance venue. The long circular driveway offers easy access and abundant parking, while the durable stucco exterior and solid mid-life roof present a well-maintained facade. Inside, refined hardwood floors, rich architectural trim, and expansive open rooms create an immediate sense of awe and prestige. The 1st floor consists of a nearly 600-square-foot living room, a serene 300-square-foot sunroom, a formal 320-square-foot dining room, a spacious eat-in kitchen with butler's pantry, a convenient laundry area paired with a powder room, and a private study complete with its own half-bath. The 2nd floor features 5 bedrooms and 3 full baths, highlighted by a luxurious primary suite. The 3rd floor adds a 6th bedroom, a 4th full bath, flexible open space, and extra storage. The dry basement with a finished hobby room further expands the home's versatility. Ideally located with quick access to Routes 84, 44, 91, and 9, plus the amenities of both downtown Hartford and West Hartford just minutes away. This distinguished property invites you to experience its timeless charm firsthand.

856 Prospect Ave, Hartford

$925,000
29 Baths 24197157 MLS
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.

621 Farmington Ave, Hartford

$465,000
6 Baths 24197122 MLS
This West End investment opportunity presents a fire-damaged multi-family building with significant potential for value-add renovation. The property consists of all 1 bed/1 bath units, with 740 SF each, featuring hardwood floors throughout. While the units are currently dated and in need of full updating, the building has several upgrades in place including vinyl replacement windows, a roof approx. 12 years old, and newer gas and water service completed in 2024 by the city.. All utilities are separate and tenant-paid, with gas heat and hot water systems that are believed to be functional, as well as separate electric panels for each unit. The property also includes a six-car detached garage, offering additional parking or potential rental income. This is an excellent opportunity for an investor or developer to restore and modernize a well-located asset with long-term upside.

102 Rowe Ave, Hartford

$465,000
6 Beds 6 Baths 24197117 MLS
This West End investment opportunity presents a fire-damaged multi-family building with significant potential for value-add renovation. The property consists of all 1 bed/1 bath units, with 740 SF each, featuring hardwood floors throughout. While the units are currently dated and in need of full updating, the building has several upgrades in place including vinyl replacement windows, a roof approx. 12 years old, and newer gas and water service completed in 2024 by the city.. All utilities are separate and tenant-paid, with gas heat and hot water systems that are believed to be functional, as well as separate electric panels for each unit. The property also includes a six-car detached garage, offering additional parking or potential rental income. This is an excellent opportunity for an investor or developer to restore and modernize a well-located asset with long-term upside.

102 Rowe Ave, Hartford

$999,900
5 Beds 6 Baths 24196006 MLS
Tucked away at the end of a quiet cul-de-sac in Avon's desirable Avonridge neighborhood, this exceptional home offers the perfect blend of privacy, space & everyday comfort on 1.67 acres surrounded by nature. With 5 bedrooms, 3 full & 2 half baths, & 5,582 square feet, there's room for everyone to spread out. A brand-new roof & automatic generator add peace of mind, while the updated kitchen features granite countertops, a center island with breakfast bar, & a spacious dining area surrounded by windows overlooking the peaceful backyard-ideal for gathering with family & friends. The screened porch with skylights extends your living space outdoors, creating the perfect spot for entertaining, dining, or simply relaxing throughout the warmer months. A first-floor study with custom built-ins offers an ideal work-from-home space or library. The impressive first-floor primary suite (25.7' x 20') is privately located at the rear of the home, providing a quiet retreat with tranquil views. Upstairs, four additional bedrooms offer flexibility for family, guests, hobbies, or additional home office space. Two bedrooms share a Jack-&-Jill bath with separate vanity areas, while another full bath is accessible from both a bedroom & the hallway. Thoughtfully designed for today's lifestyle, this home combines flexible living spaces, sought-after first-floor living, & a peaceful setting just minutes from Avon's shopping, dining, schools & recreation.

33 Saxon Woods, Avon

$785,000
4 Beds 6 Baths 24194588 MLS
This custom-built, Farmhouse-inspired Colonial is stylish, well-appointed, and pristine! Set on a double lot with .76 acres on a quiet dead-end road, this statement-making home in Southington offers 4 bedrooms and 3480+ square feet (not including basement square footage), with multiple options for in-law living. Quality details abound with crown molding, tall ceilings, built-in cabinetry, plentiful Andersen windows, and gorgeous wood flooring. An open floor plan unites the custom cook's kitchen with abundant cherry cabinets, large granite island, walk-in pantry, informal dining area, and large family room showcasing a gas fireplace and custom built-ins. The convenient mudroom, formal dining room, and large office or study round out the main floor. The main staircase leads to 3 bedrooms, including the well-designed master suite with dressing room, walk-in closet, and roomy spa-inspired bathroom with clawfoot tub, and expanded walk-in shower for two with bench seating. An additional bedroom or guest suite over the garage is accessed from a private staircase. The outdoors are designed for relaxation with a private backyard easily accessed through multiple sliders in the 4-season sunroom. Entertain from your patio, and cool off in your in-ground gunite pool with spa and stairs. A handy pool bathroom and outdoor kitchen with grill are just steps away. Don't miss the full finished walk-out basement, oversized 2-car garage, multi-zone HVAC, and much more.

101 Claudia Dr, Southington

$1,580,000
5 Beds 7 Baths 24192146 MLS
The Best of Both Worlds: Luxury, Privacy, and Proximity. Experience the pinnacle of New England elegance in this "Built to Last" solid brick colonial estate. This residence offers the rare luxury of 3.5+ acres of total privacy while remaining just minutes from the vibrant energy of West Hartford Center, the UConn Health Center, and major commuting arteries. Spanning over 6,800 square feet, this turnkey estate is defined by exquisite millwork and master-crafted finishings. The heart of the home is a chef's gourmet kitchen that flows effortlessly into a magnificent 25-foot dining room adorned with stunning coffered ceilings-a space specifically designed for grand-scale entertaining and unforgettable gatherings. The home features a coveted first-floor primary suite; a true retreat equipped with "all the bells and whistles." This unrivaled wing offers the convenience of single-level living without sacrificing the scale of a sprawling luxury manor. With 5 bedrooms, 6.1 bathrooms, and a 3-car garage, there is "space to breathe" for everyone. Enjoy the tranquil, wooded privacy of your own 3.5-acre park and the elite Farmington Valley lifestyle, all while being a stone's throw from West Hartford's world-class dining and shopping. At 215 Old Mountain Rd, you truly can have it all.

215 Old Mountain Rd, Farmington

$1,500,000
9 Baths 24192556 MLS
Exceptional Mixed-Use Investment Opportunity in the heart of Windsor! Discover the perfect blend of commercial and residential income at 66 Poquonock Avenue. Ideally located steps from the vibrant Windsor Center, this well maintained mixed-use property offers outstanding versatility and long-term investment potential. The property features over 1,500 square feet of commercial office space, ideal for professional offices, medical, retail, or service orientated businesses. Complementing the commercial space are the 7 potential income producing residential rental units, creating multiple revenue streams and strong cash flow potential. Situated on a generous lot with ample off street parking for tenants, customers, and employees, this property offers exceptional convenience in a highly desirable, walkable location. Enjoy easy access to restaurants, shops, the Windsor Train Station, Parks, and community events, while remaining just minutes from I-91, Bradley International Airport, and Hartford. Whether your an investor seeking a stable income-producing asset or an owner occupant looking to operate your business while benefiting from residential rental income, this is a rare opportunity to own a premier mixed-use property in one of Windsor's most desirable locations.

66 Poquonock Ave, Windsor

$849,900
12 Beds 6 Baths 24193299 MLS
Discover an exceptional income-producing investment at 1585 Park Street, Hartford, Connecticut. This well-positioned mixed-use property features 8 total units, including 2 commercial storefronts and 6 residential apartments, offering investors the stability of diversified rental income in a highly visible location. Situated along the busy Park Street corridor, this property benefits from strong vehicle and pedestrian traffic, making it an attractive location for retail, office, or service-oriented businesses. The residential units provide consistent rental demand in one of Hartford's established neighborhoods. Property Highlights: Mixed-use building with 2 commercial units 6 residential apartments Multiple income streams from commercial and residential tenants High-visibility Park Street location Excellent investment or portfolio addition Convenient access to downtown Hartford, public transportation, major highways, shopping, dining, and neighborhood amenities Whether you're looking to expand your investment portfolio or acquire a value-add mixed-use asset with long-term upside, 1585 Park Street presents an outstanding opportunity in Hartford's active commercial corridor. Contact us today for additional financial information, current rent roll, expenses, and to schedule a private tour.

1585 Park St, Hartford

$595,000
6 Beds 6 Baths 24192695 MLS
Rare Bristol Triplex Opportunity! This three-unit townhouse-style triplex is an outstanding opportunity for both investors and owner-occupants looking to build wealth. Each spacious unit features 2 bedrooms, 1.5 bathrooms, a functional townhouse layout, and its own private garage with abundant storage space/laundry in the lower level-a feature tenants love and one that sets this property apart. Separate entrances and generous living space make these units highly desirable in today's rental market. Conveniently located on King Street, you'll enjoy quick access to Route 72, Route 6, shopping, restaurants, schools, and everyday amenities, making this an ideal location for tenants and commuters. Whether you're expanding your investment portfolio or looking to live in one unit while generating rental income from the others, this is an opportunity. Townhouse-style triplexes with garages are in high demand and rarely available. Schedule your private showing today and see why this property stands out from the rest - EZ to show!

489 King St, Bristol

$1,850,000
4 Beds 7 Baths 24192652 MLS
A brick estate truly like no other. Tucked at the end of a quiet cul-de-sac, the circular drive and newly extended stone walkway (2023) lead to the columned entry of your dreams. Step inside to your two story polished stone foyer with sweeping curved staircase that makes the first of many unforgettable impressions. Nearly 10,000 sq ft of finished living space unfolds across three levels, all served by a private elevator. Every turn reveals craftsmanship rarely seen: a dramatic two-story library with fireplace, floor-to-ceiling built-ins and an oval book loft floating above; a handsome office; a formal dining room with butler's pantry. The great room takes your breath away with it's soaring coffered ceiling, floor-to-ceiling stone fireplace, and a Palladian-crowned wall of glass framing to the resort grounds. The gourmet kitchen was built to perform: custom wood cabinetry, granite, an oversized island, Sub-Zero refrigerator and freezer, professional appliances, and a sunlit breakfast room. Every chef's wish of a true walk-in pantry with a Sub-Zero back-stock refrigerator, abundant storage, and main-level laundry. A sun-drenched flex room stands ready as a second office, playroom, or lounge. Upstairs, retreat to a primary suite with fireplace, private sitting room, spa bath, jet tub and fitted dressing rooms, joined by three spacious ensuite-style bedrooms and a second laundry room with storage.

55 Hunters Rdg, Rocky Hill

$799,000
5 Beds 6 Baths 24191505 MLS
Some homes simply give you more space. This one gives you the freedom to live the way you want today while already being ready for tomorrow. Built in 2019 and expanded in 2022, this home offers 9 foot ceilings, hardwood floors throughout, abundant natural light, and a custom kitchen with soft close cabinetry, pull out drawers, granite countertops, a large island, and double pantry storage. The open layout flows from the kitchen to the living room with a gas fireplace and out to the deck, creating inviting spaces for everyday living and entertaining. Upstairs, the primary suite features a walk in closet and beautifully finished bath with custom tile, granite countertops, and double sinks, while a first floor room beside a full bath offers the flexibility of a guest bedroom, home office, or playroom. Also on the main level is a private in law suite, thoughtfully designed as its own living space and connected through the attached garage. Complete with its own kitchen, living room, oversized bedroom, laundry, full bath, half bath, private deck, and handicap accessible design, it offers exceptional flexibility for extended family, aging parents, long term guests, or whatever life may bring. A partially finished lower level adds flexible space. With everything seven years old or newer, public utilities, and a sought after neighborhood within walking distance to parks and schools, this is more than a move in ready home. It is designed to grow with you.

649 Nevers Rd, South Windsor

$7,200,000
5 Beds 8 Baths 24191237 MLS
The wait is over-the Grand Dame of South Glastonbury is now available. Perched atop one of Connecticut's most breathtaking settings, this extraordinary custom French chateau commands sweeping views stretching to Massachusetts, along with spectacular sunsets over the Hartford skyline.A true labor of love, this remarkable estate reflects more than 13 years spent sourcing the finest materials and architectural inspirations from the grand estates of France and Newport, Rhode Island. Inside, every detail has been thoughtfully curated to capture the authenticity and elegance of a classic French chateau. Eight custom fireplaces imported from Europe, exquisite chandeliers inspired by Versailles, hand-crafted Habersham cabinetry, and premium Miele appliances define the stunning chef's kitchen. Each room offers its own distinct character, showcasing exceptional craftsmanship through intricate millwork, hand carved limestone fireplaces, Brazilian walnut and marble flooring, ornate medallions, solid mahogany doors, custom wrought iron, and a magnificent circular marble staircase. Step into a world of timeless elegance, where uncompromising quality and artistry are evident at every turn. Every room enjoys breathtaking views, from the spectacular primary suite to the attached guest house. Enter the primary retreat through its dramatic rotunda, leading to extraordinary custom closets, a luxurious spa bath, and a bedroom featuring a private balcony and a stunning marble-and-brass fireplace.

105 Crystal Ridge Rd, Glastonbury

$1,395,000
5 Beds 8 Baths 24189885 MLS
Welcome to 45 Longview, an elegant Federal style home built by master builder Ray Carnelli as his last work. This home is set on over 3 private acres at the top of a cul-de-sac in one of Avon's premier neighborhoods. Surrounded by mature trees, stone walls, and town-owned farmland, this property offers exceptional privacy and a truly estate-like setting. A two-story foyer with curved staircase introduces beautifully crafted bedrooms with rich millwork. The center island kitchen and sunlit breakfast area open to a striking two-story family room with brick accent wall, built-ins, and a raised hearth fireplace. French doors lead to an enclosed porch overlooking the patio and expansive grounds-home to a remarkable 300-year-old oak tree with daily sunsets as the backdrop. The first floor also includes a handsome library, laundry room, two half baths, and access to the three-car garage. Upstairs, the primary suite offers a fireplace, sitting area, and spa like bath. Three additional ensuite bedrooms complete the second level. A private third floor suite with full bath and walk in attic provides ideal guest or au pair space. The finished Lower Level features a spacious game room with wet bar and full bath-perfect for entertaining while offering flexible space that can also serve as a private guest suite, au pair quarters, home gym, or media room. Rails to Trails, recreation, major routes, shopping, and upscale dining, this home delivers refined living with exceptional convenience.

45 Longview Rd, Avon

$899,000
7 Baths 24189807 MLS
Welcome to 24 Park Terrace, Hartford-a fantastic opportunity for both owner-occupants and savvy investors! This well-maintained multi-family property offers spacious living areas, generously sized bedrooms, functional layouts, and abundant natural light throughout. Whether you're looking to live in one unit while generating rental income from the others or expand your investment portfolio, this property offers excellent income-producing potential. Ideally located in Hartford's desirable Frog Hollow neighborhood, you'll enjoy convenient access to Interstates 84 and 91, making commuting throughout Connecticut a breeze. The property is just minutes from Downtown Hartford, Hartford Hospital, Trinity College, and popular destinations including Bushnell Park, with nearby shopping, restaurants, cafes, and everyday conveniences along Park Street, Farmington Avenue, and Main Street. Don't miss this exceptional opportunity to own a versatile property in a prime location with strong investment potential. Schedule your private showing today!

24 Park Ter, Hartford

$1,975,000
6 Beds 8 Baths 24189420 MLS
Perfectly positioned alongside the Hartford Golf Club, 82 Ledyard Road is a remarkable custom-built residence that seamlessly blends luxury, comfort, and versatility. Thoughtfully designed with exceptional craftsmanship and timeless appeal, this expansive home offers a flexible floor plan tailored to today's modern lifestyle. Elegant living spaces unfold throughout the home, anchored by a dramatic family room that serves as the heart of the residence. Bathed in natural light and designed for effortless entertaining. The kitchen, dining room and living room have direct access to one of the decks that overlooks the golf course, creating exceptional spaces for al fresco dining, morning coffee, or evening gatherings. The chef's kitchen is equally impressive, featuring abundant workspace and storage, a generous dining area, and seamless connectivity to the family room through a gracious wet bar and coffee bar. A rare offering, the home provides the convenience of one-level living while accommodating a variety of lifestyle needs. The main level has a luxurious primary suite featuring a spacious walk-in closet, steam shower, jacuzzi tub, and a private sitting room with views of the golf course. The main level also has a handsome home office, an expansive sunroom, and two powder rooms. The second floor offers four generously sized bedrooms, including two with en-suite baths and two connected by a Jack-and-Jill bath.

82 Ledyard Rd, West Hartford

$1,500,000
12 Baths 24188750 MLS
Exceptional opportunity to acquire a 13-unit mixed-use portfolio with 8.5% CAP rate, consisting of two solid brick assets totaling 13 units (12 residential + 1 commercial) across two buildings. Combined square footage of approximately 13,979 SF with a strong unit mix and in-place cash flow, plus additional upside potential. 38 Redding Street is a 6-unit multifamily located in the South End, offering six 2.5-bedroom, 1-bath units with 5,643 SF. Units feature hardwood floors throughout with some kitchen and bath updates. Utilities are separately metered and tenant-paid. No on-site laundry; on-street parking. 89 Barbour Street is a mixed-use property comprised of six 3-bedroom, 1-bath apartments and one adjacent commercial space (400 SF), totaling 7,936 SF. The property is 100% occupied, delivering stable, in-place income. Residential units offer hardwood flooring, some kitchen and bath updates, and laundry hookups within each unit. Separate, tenant-paid utilities. On-street parking. Together, the portfolio offers a balanced mix of stabilized income and upside through lease optimization and continued improvements. Ideal for investors seeking scale, strong unit layouts, and diversified income in established rental locations.

89-93 Barbour St, Hartford

$800,000
19 Beds 6 Baths 24188741 MLS
Mixed-use investment opportunity offering a 10% CAP rate. The property consists of (6) spacious 3-bedroom, 1-bath apartments, each averaging 1,320 square feet, plus one adjacent commercial grocery space with roughly 400 SF. The property is 100% occupied, providing immediate, stable cash flow. Residential units feature hardwood flooring, laundry hookups, and select kitchen and bathroom updates. All utilities are separately metered and tenant-paid, helping minimize operating expenses. The commercial space provides diversified income while offering long-term investment potential. Located in Hartford's North End with convenient access to Downtown Hartford, Saint Francis Hospital, parks, public transportation, shopping, schools, and major highways. An outstanding opportunity for investors seeking a stabilized asset with strong unit layouts, diversified income, and future upside through continued rent growth and operational improvements.

89-93 Barbour St, Hartford

$700,000
12 Beds 6 Baths 24188713 MLS
38 Redding Street is a 6-unit multifamily located in the South End with 8% CAP rate, offering (6) 2.5-bedroom, 1-bath units with roughly 940 SF each. the property is 100% occupied. Units feature hardwood floors throughout with some kitchen and bath updates. Utilities are separately metered and tenant-paid (gas heat and hot water). No on-site laundry and mostly on-street parking. There is a private, paved driveway with tandem parking for a couple cars. Conveniently located in the south end, walking distance to Colt Park, near Downtown Hartford, Hartford Hospital, major highways, public transportation, shopping, and neighborhood amenities, this is an excellent start or addition to any investment portfolio.

38-40 Redding St, Hartford

$1,295,000
7 Beds 6 Baths 24183805 MLS
Truly exceptional brick & slate Tudor home that has been lovingly and meticulously cared for by its current owners for the past 24 years. Built in 1927 for aviator and engineer, Frederick Rentschler, co-founder of Pratt & Whitney Aircraft, this property retains much of its original beauty and character, while seamlessly integrating many modern conveniences. Details such as elegant moldings, wainscoting, paneled walls, chestnut and pine floors, and leaded glass windows are common throughout much of home. While modern touches, such as updated kitchen and baths, along with central air, don't deter from the home's charm. The original wood-paneled foyer greets guests and leads to the gracious living room with wood burning fireplace and French doors that lead to a spacious bluestone terrace for easy outdoor living and entertaining. Also off the foyer is a wonderful wood paneled library with fireplace and views over the back yard and pool. Off the library is a charming sunroom with stone floor and access to the outdoor terraces. The home's gracious dining room is the perfect space for family gatherings, dinner parties or hosting holiday get togethers. The butler's pantry connects the dining room and the updated kitchen with its center island, granite counters and newer stainless steel appliances. The kitchen has a cozy breakfast nook and sliders leading to an outdoor dining terrace. There is also a mudroom and access to the oversized 2 car garage next to the kitchen for convenience.

1844 Albany Ave, West Hartford

$1,599,900
4 Beds 6 Baths 24175441 MLS
Exceptional brick colonial w/estate-like privacy, grand architectural scale, & refined craftsmanship just moments from Glastonbury Center. Privately set at end of tree-lined drive on 6.29 acres bordering town-owned preserve. Sited along cul-de-sac of distinguished homes, the property encompasses over 7,200sf of elegant living space. Impressive front approach w/motor courtyard, extended paved parking, & oversized attached 3-car garage. Immediately captivating w/elevated millwork, soaring 2-story foyer, and dramatic front-to-back center hall finished w/radiant heated tile floors. Beautifully proportioned formal living spaces include front living room w/hardwood floor & paneled walls, & a gracious dining room w/adjoining butler's pantry. The expansive chef's kitchen features large center island w/breakfast bar, gas cooktop, wall ovens, abundant cabinetry, pantry, & exceptional eat-in dining area w/French doors opening to rear patio. The 2-story great room is breathtaking in scale & detail w/built-in bookcases & cabinets, striking gas fireplace w/exquisite mantel detail, & inlay hardwood floor. The main level is complete w/spacious mudroom w/direct access to garage, powder room, 2nd back staircase, & dedicated laundry room w/sink & access to pool patio for effortless indoor/outdoor living. The upper level continues w/soaring ceilings & 4 generously sized bedroom suites, each complete w/walk-in closets, & ensuite full bathrooms. ***CONTINUED***

76 Sturgeon River Rd, Glastonbury

$999,900
6 Beds 8 Baths 24183232 MLS
Nestled privately off Main Street, this exceptional custom Colonial offers over-the-top craftsmanship, timeless elegance, and remarkable versatility with 6-7 bedrooms, 6 full baths, and 2 half baths. Designed for both grand entertaining and comfortable everyday living, the home features two primary suites, creating excellent potential as an in-law suite or multigenerational living. A dramatic marble foyer welcomes you into an interior rich with architectural detail, including stately columns, graceful archways, crown molding, and gleaming hardwood floors. The formal living room and private office each feature a fireplace, while the elegant dining room provides the perfect setting for special gatherings. At the heart of the home, the impressive family room boasts soaring ceilings, floor-to-ceiling windows, and a stunning fireplace that fills the space with natural light and warmth. The spacious eat-in kitchen is appointed with custom cabinetry, granite countertops, and abundant workspace for cooking and entertaining. Step outside to a beautiful patio framed by a stone wall and overlooking the expansive grounds, offering a peaceful retreat with room to relax, play, or entertain. Additional highlights include a 3-car attached garage, multiple living areas, and a highly convenient location close to shopping, dining, schools and parks. A rare opportunity to own a truly distinguished residence that combines luxury, functionality, and privacy.

1742 Main St, South Windsor

$1,349,000
5 Beds 7 Baths 24186282 MLS
Welcome to luxury living at its finest in one of Avon's most desirable neighborhoods. This custom residence makes a stunning first impression with a grand two-story foyer highlighted by a dramatic curved staircase, exquisite millwork, and timeless architectural details throughout. The gourmet kitchen is a chef's dream, featuring beautiful cherry cabinetry, granite countertops, premium appliances, and seamless flow into the inviting family room. Anchored by a striking coffered ceiling, fireplace, and wet bar, this impressive gathering space is ideal for entertaining and everyday enjoyment. Just off the kitchen are a spacious mudroom, walk-in pantry, and laundry room, providing convenience and organization. Elegant formal living and dining rooms offer refined spaces for hosting guests. The luxurious primary suite serves as a private retreat featuring a tray ceiling, two-sided fireplace, spacious sitting room, walk-in closets, and a spa-inspired bath. The incredible finished lower level delivers an unmatched lifestyle experience with a second full kitchen, full bath, fitness room, sauna, media room, and office. Outside, enjoy your own resort-like oasis featuring a sparkling saltwater pool, expansive patio areas, and beautifully landscaped grounds. Additional highlights include a four-car garage and Tesla solar system for enhanced energy efficiency. Combining craftsmanship and exceptional amenities this remarkable Avon residence offers the best in modern living!

130 Northington Dr, Avon

$999,900
12 Beds 6 Baths 24184669 MLS
Rare opportunity - MUST SEE to appreciate! This one has it all - income, condition, stability AND upside. Excellent opportunity to acquire a impeccably maintained 6-unit multifamily property consisting of two buildings on one parcel in New Britain. The property is in excellent condition and has benefited from numerous capital improvements, making it an attractive investment for both seasoned and first-time multifamily investors. Tan building has extensive updates, including a new roof, siding, windows, and gas lines, while the brick building also features a newer roof, heating system and updated electrical service. Additional improvements include a chimney updates completed in 2021, newer hot water heaters, and fire code compliance upgrades throughout both properties. All units feature large sq. ft., with high ceilings, separate heat and electric, helping to minimize owner expenses and maximize operating efficiency. Income approximately $9000. per month. See income/expense disclosure. Plus a 5 bay garage in rear may add additional income. With strong rental demand, quality building systems, and pride of ownership evident throughout, this turnkey asset offers investors a rare combination of stability, condition, and upside - tremendous opportunity to increase income stream between bringing rents to market and renting out the garage spaces. Whether you're looking to expand your portfolio or complete a 1031 exchange, 445-451 Columbus Boulevard is a solid opportunity.

445 Columbus Blvd, New Britain

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 2026 SmartMLS, Inc.