Luxury (over $700k)

MLS Number 170597460

• Single Family
• Square Feet 18,777
• Bedrooms 9
• Property Style Other
• 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 RANDALL,REALTORS-Compass

MLS Number 170586578

• Land
• Acreage 29.31
• MLS Status Active
• Other Amenities Waterfront
• Subdividable

Unbelievable opportunity for purchase and development of twenty-three (23) pristine ACRES of residential (R-40) land in Southington, Connecticut. Access from Welch Road is 90' of frontage. Land gently slopes from the eastern side at 270' to the western side of 220'. Abuts residential properties on West Street (eastern side), North Ridge Court (western side) and Bagno Drive (southern side).

Listed by Michelle A. Meister and Jadwiga H. Karwowski of Realty 3 CT

MLS Number 170555167

• Multi Family Multi-Family For Sale
• Square Feet 74,000
• Acreage 0.22
• Year Built 1968

Rare opportunity to own 68 units on one parcel in the Asylum Hill area of Hartford. This offering consists of 5 adjacent, brick buildings and one building lot. The unit mix is: 1, 4 bedroom townhouse; 22, 3 bedroom townhouses; 19, 2 bedroom ranch style; 11, 1 bedroom ranch style; and, 15 studios. 16 of these units have 2 full bathrooms. Since acquisition, the current owner has remodeled the common areas (new entrance doors on order) and renovated 25+ units with modern finishes. This asset was also gutted to the studs approximately 25 years ago. This property has: secured entry with pass card systems, large fenced in parking lot (recently paved), modern laundry rooms, updated electrical, and an onsite office. Recent mechanical upgrades include: buildings 36 & 46 have new circular pumps, building 40 has new water heaters, and buildings 46 & 48 have 5 year old roofs, and a few of the boilers have been replaced. This asset is located near the Hartford Insurance and St Francis Hospital.

Listed by Lisa Cozzi of Berkshire Hathaway NE Prop.

MLS Number 170554197

• Commercial
• MLS Status Active
• Square Feet 74,000
• Year Built 1968
• Acreage 0.22

Rare opportunity to own 68 units on one parcel in the Asylum Hill area of Hartford. This offering consists of 5 adjacent, brick buildings and one building lot. The unit mix is: 1, 4 bedroom townhouse; 22, 3 bedroom townhouses; 19, 2 bedroom ranch style; 11, 1 bedroom ranch style; and, 15 studios. 16 of these units have 2 full bathrooms. Since acquisition, the current owner has remodeled the common areas (new entrance doors on order) and renovated 25+ units with modern finishes. This asset was also gutted to the studs approximately 25 years ago. This property has: secured entry with pass card systems, large fenced in parking lot (recently paved), modern laundry rooms, updated electrical, and an onsite office. Recent mechanical upgrades include: buildings 36 & 46 have new circular pumps, building 40 has new water heaters, and buildings 46 & 48 have 5 year old roofs, and a few of the boilers have been replaced. This asset is located near the Hartford Insurance and St Francis Hospital.

Listed by Lisa Cozzi of Berkshire Hathaway NE Prop.

MLS Number 170565519

• Land
• Acreage 280
• MLS Status Active
• Waterfront
• Subdividable

This 280 acre property is located in Windsor and East Granby. The property has been farmed for many generations in tobacco and row crops. The property has approximately 90 acres open in fields with Merrimac fine sandy loam and Windsor loamy sand, two of the finest agricultural soils. There are 3,361 feet of frontage along the Farmington River and 1000 feet of frontage along Stone Road in Windsor and 816 feet of frontage along Spoonville Road in East Granby. There are 8 tobacco barns on the properties in various conditions. Most of the land is classified under current use in CT. Current agricultural lease income is $43,050 from April to December from a local farm family. $500/ac for tobacco, $300/ac for vegetables, and $750 per tobacco barn for three barns and $3000/yr for farm workshop with fence enclosure. Annual property tax is $25,974.

Listed by Keith Ross of Landvest,Inc

MLS Number 170515163

• Single Family
• Square Feet 6,740
• Bathroom 5
• Bedrooms 5
• Year Built 2006

Luxurious Country Estate between New York and Boston! Nestled to the North of rural Granby, CT, this luxurious country estate offers the perfect blend of privacy and accessibility. Located just minutes from the town center and close to Bradley International Airport, the estate is also within easy reach of the charming towns of Litchfield County and the scenic Berkshires. Set on over 240 acres of natural beauty, the custom-built home designed by architect Emil Dahlquist and built by local master craftsmen is a haven of luxury and tranquility. Enjoy stunning views from every window, wander through colorful gardens, relax in the gazebo, hike or ride through mature woodland, and accommodate your equine friends in open pastures and run-ins. The impressive barn, complete with an office above, provides ample space for all your outdoor needs. Whether for grand entertaining or everyday living, this magnificent estate provides the ultimate experience in comfort, elegance, and natural beauty. This truly is a special place! Please contact the listing agent for video link, additional details and to book your private tour. *** SHOWINGS STRICTLY BY APPOINTMENT ONLY ***

Listed by Anna Sogliuzzo of Berkshire Hathaway NE Prop.

MLS Number 170447158

• Single Family
• Square Feet 5,000
• Bedrooms 7
• Property Style Victorian
• Bathroom 6

Beautiful property with spectacular views of the Connecticut River and Long Island Sound. This 1875 Victorian home includes 124 acres of land. Steeped in folklore, this home and the expansive land surrounding it was originally purchased in 1926 as farmland, which provided the gravel to fill in Boston's Inner Harbor and helped supply water to old steam engines. Now, nearly a century later and cradled between Route 9 and I-95, it is a "Developer's Dream".....either commercial or residential. The many unique features this property offer's include views of the CT. River and a 20 acre lake with a beach and restrooms. Additional adjacent land also available. Extensive due diligence completed by seller's.

Listed by Matthew Merritt of William Pitt Sotheby's Int'l

MLS Number 170447223

• Land
• MLS Status Active
• Acreage 124.08
• Waterfront
• Zoning AA-1

124+ Acres! Beautiful property with spectacular view of the Connecticut River and Long Island Sound. This expansive land was originally purchased in 1926 as farmland, which provided the gravel to fill in Boston's Inner Harbor and helped supply water to old steam engines. Now, nearly a century later and cradled between Rt. 9 and I-95, it is a "Developers Dream".....either commercial or residential. The many unique features of the property include stunning views and a 20 acre lake with a beach and restrooms. Additional adjacent land also available. Extensive due diligence completed by seller's. Copies of survey's and original deed available. Seller's main interest is to be sold to a developer. Owner's would consider delaying closing until permits are approved. Town of Old Saybrook and DEEP are willing to assist buyer in developing the property.

Listed by Matthew Merritt of William Pitt Sotheby's Int'l

MLS Number L10060067

• Land
• MLS Status Active
• Acreage 645.17
• Subdivision Tri-Lakes,LLC
• Waterfront

HIDDEN 50 ACRE LAKE ON 645 ACRE WILDERNESS TRACT including 3 smaller ponds, 2 streams in Connecticut's quiet Northeast corner. Absolute peace, quiet and security with no public access. Located on 2 paved town roads with 3 separate means of ingress/egress, the property boasts an extensive network of miles of drivable gravel roads allowing easy viewing and direct access to hidden lakes and interior. With 9,000' of direst water frontage, the lake affords numerous building sites some with sunrise/sunset views along with private boating, swimming and fishing. For the nature lover, this is heaven on earth. Abundant wildlife provides excellent hunting as well. No traffic noise. Star gazing is unparalleled. For the developer, the entire tract is approved for 135 cluster lots (30 ready immediately). Zoning regulations allow and recorded engineering data show the feasibility for various other uses including family compound, large estate lots, recreational, corporate headquarters, etc. A monolith tower in a remote corner not visible from a vast majority of the property provides strong cell service (lessee is responsible for annual real estate taxes of $3,378 of the total $9,221). Seller options: 245+/- acres with 15 acre pond $2,500,000 or 400+/- acres with big lake and 2 smaller ponds $4,500,000. Distance to Providence 23 miles, Hartford 50 miles, Boston 65 miles, New York City 155 miles. Several major airports are within one hour's drive. (Owner is a licensed CT RE broker).

Listed by J. Thomas Mettling of J. Thomas Mettling

MLS Number 170580217

• Single Family
• Square Feet 5,552
• Bedrooms 4
• Bathroom 6
• Year Built 1964

Views abound! This beautiful waterfront home sits on 3 ? acres with 263ft of waterfront on the Connecticut River with a dock. This white brick and stone architecturally designed contemporary offers the ultimate in luxury with an open floor plan that flows seamlessly. The formal living room with a floor to ceiling bay window brings in light and views, and a beautifully carved white marble fireplace completes the room. A bright spacious open kitchen and breakfast room has skylights and a Palladium window. A large island with high end appliances makes this kitchen a chef's delight! The family room with fireplace is off the kitchen and the sunroom too, with a dramatic high hexagonal ceiling. The first floor primary suite has a bay window overlooking the river and has five closets. The white marble bath has radiant heated floors, beautifully carved twin basins and a Jacuzzi and walk-in shower. A guest bedroom and Library completes the first floor. Most rooms have moldings, 9' ceilings and/or tray ceilings and take advantage of the fabulous views. Stairs with a brass balustrade lead to the second floor two ensuite bedrooms one with a fireplace, a walk-in closet. A path from the house leads past flower gardens and over the expansive manicured lawn to the dockside stone patio, an ideal area for entertaining and to enjoy the stunning 180 degree river views. A two car garage completes this impeccably maintained, beautiful and unique property.

Listed by Colette Harron of William Pitt Sotheby's Int'l

MLS Number 170555942

• Commercial
• MLS Status Active
• Square Feet 20,261
• Year Built 1963
• Acreage 3.63

2 buildings 62-68 Merrow Rd 14,561 SF Acres: 2.13 Heating: Oil Public Water & Sewer Frontage: 195 Ft. Zone: TVA Taxes: $36,521.48 Traffic Count: 6,200 Year Built: 1964 70 Merrow Rd 5,700 SF 2 Stories 4 Units Acres: 1.5 Heating: Elec Public Water & Sewer Frontage: 495 Ft. Zone: TVA Taxes: $18,187.58 Traffic Count: 6,200 Year Built: 1963

Listed by Peter Walsh of Lyman Real Estate

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 Ronald Lyman of Lyman Real Estate