Featured Connecticut Listings

MLS Number 170517226

• Land
• MLS Status Active
• Acreage 168.4
• Subdivision Pleasant Valley Farm
• Subdividable

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

MLS Number 170585265

• Single Family
• Square Feet 6,250
• Property Style Contemporary, Chalet
• Year Built 1978
• Bedrooms 7

This Modern Post & Beam Masterpiece was built for your year round Privacy & Enjoyment. After a Hot or Cold long day out, Stress Dissolves Away as your Private Driveway leads you up to your Paradise Retreat on the Side of Avon Mountain! Imagine watching the Holiday Snow falling across the Farmington?Valley from these Toasty Warm View Rooms! Yes this Mansion is Loaded with AMAZING VIEWS Up to the NY Mountain Lines. Some rooms with 30 foot tall beamed Cathedral Ceilings and Large Fireplaces. The Two Story Primary Bedroom Suite has a Huge Custom Rain Shower, Jetted Bath, Walk In Closet and a Personal Laundry Room built in to it. A large bright eat-in kitchen and an island that opens to the wrap around deck will have you wanting to be home often! Use the Dining Room & Library Formally or create your own use of these HUGE Rooms. The Ground Level offers 4 seasons of Fun and Relaxation with a Billiard Room, Media Room, Exercise Areas, a Full Bath and Glass doors that lead you out to the HUGE In-ground Pool. From Top to bottom this 7 Level Mansion offers over 6000 sq feet of Luxury Living with Amazingly Low Maintenance and Costs! This location has all of the Bells & Whistles like Speed Chargers for your Electric Vehicles, a New Roof with a 50 year Warranty & New Energy Efficient Windows! If full throttle entertainment or comfort is your style, then you will enjoying your New Private Avon Mountain Compound!

Listed by Derek Greene of The Greene Realty Group

MLS Number 170550339

• Commercial
• MLS Status Active
• Square Feet 3,500
• Year Built 1941
• Acreage 34

4.4 acres in Meriden zoned R-R "Residential", 14.6 acres in Middletown zoned IOP "Interstate Office Park" and 15.0 acres in Middlefield zoned PO "Planned Office" the property has 273 ft. of frontage on Preston Ave that is used as the primary entrance, 448 ft. of non-accessible frontage along I-91 and also a 50 ft. wide "Right of Way" that is not currently used at the southern end of the property from Preston Ave. The property consists level and rolling terrain mostly cleared agricultural fields, woodland and some inland wetland areas. The property is improved with an updated 3500 sq. ft. 8 room dwelling, 2 fireplaces, 3 stop elevator, 2 car garage plus a separate detached 3 car barn w/stairway to a loft and shed. Property is agent-owned.

Listed by Derek Greene of The Greene Realty Group

MLS Number 170550336

• Land
• Acreage 34
• MLS Status Active
• Zoning RES,IOP & PO
• Subdividable

4.4 acres in Meriden zoned R-R "Residential", 14.6 acres in Middletown zoned IOP "Interstate Office Park" and 15.0 acres in Middlefield zoned PO "Planned Office" the property has 273 ft. of frontage on Preston Ave that is used as the primary entrance, 448 ft. of non-accessible frontage along I-91 and also a 50 ft. wide "Right of Way" that is not currently used at the southern end of the property from Preston Ave. The property consists level and rolling terrain mostly cleared agricultural fields, woodland and some inland wetland areas. The property is improved with an updated 3500 sq. ft. 8 room dwelling, 2 fireplaces, 3 stop elevator, 2 car garage plus a separate detached 3 car barn w/stairway to a loft and shed. Property is agent-owned.

Listed by Derek Greene of The Greene Realty Group

MLS Number 170485345

• Single Family
• Square Feet 2,941
• Property Style Farm House, Other
• Bathroom 3
• Bedrooms 4

This renovated gem is in the bucolic Painter Hill district of Roxbury near Washington CT. The photos don't do it justice! This is a must see property full of character, privacy and seasonal views! All of the needed updates are done! Imagine entering the home through a sunlit vestibule. To the right there is an impeccable entertaining room with a lofty barn wood trussed cathedral ceiling. To the left is a ideal daily living layout with an open dining, living room and fully renovated gourmet kitchen well appointed with new Dacor appliances and quartz countertops. The second floor Primary suite is luxurious with a cathedral ceiling, walk in closets and new bath with large soaking tub and walk in shower. Relax on a large West facing renovated brick terrace with captivating seasonal views. The first floor has a versatile layout with three flex rooms, which could accommodate a first floor bedroom suite, separate offices and a gym, or suit to your use. The large one car garage is detached. Town approvals exist for a future two car attached garage and tree clearing for a possible pool area. We have estimates for the pool and the garage.

Listed by Derek Greene of The Greene Realty Group

MLS Number 170479452

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

Beautiful 100+ acre farm in prime section of upper bracket homes, ideal for future subdivision, equestrian estate or private family compound or preserve, 40 to 50% under crop management with remainder wooded with multiple hidden fields, terrain is level sloping with manmade farm pond, approx. 900 feet frontage and legal R.O.W. between 2 farm houses plus add'l. 45 feet on White Plain Road at the eastern end of property. 60% =/- is bordered by stone wall and contains abundant wildlife. This farm must be seen to be fully appreciated. Current taxes have PA-490 exemption.

Listed by Derek Greene of The Greene Realty Group

MLS Number 170552162

• Single Family
• Square Feet 4,951
• Year Built 1975
• Property Style Colonial
• Bathroom 8

Custom Soraghan Kitchen. Marble counter tops. 5-8 bedrooms.7.5 Baths. Majority of house built in 2004. Remarkably spacious with tons of closets. Private, level and huge yard. Majority newer construction. Perfect location to get in and out of town. Private, quiet neighborhood. Quality crown molding, built-ins. Coveted chef's kitchen featuring Sub-Zero refrigerator, 6 burner Wolfe cook top, vent and double ovens, warming drawer, compactor, immense main island plus food prep island w/ additional sink. Two additional bedrooms w/ private entrances. Fully finished basement with four huge step and custom cabinetry. Bathrooms on all floors all with antique glass surrounds and tumbled marble. Jacuzzi tub, fixtures. Imported sinks. Large Pantry. Real Cherry floors throughout. Large rooms. Two fireplaces. Large, comfortable deck with great private views. Oversized, heated garage w/ custom wood doors SUV w ski boxes attached. Central air. Baseboard heat w/gas boiler. Thermal pane windows and glass sliding doors.150 Ga. hot water heater. Town water. Massive attic storage. Multiple skylights w rain sensors. Cedar shake exterior. 3/4" hand split shakes for great insulation and low maintenance. Oversized driveway. Stunning Brownstone walls. Flowering Pear trees and Holly Berry bushes. Plenty of room for home offices. Spread out, relax and make this your next home.

Listed by Derek Greene of The Greene Realty Group