Listings for James Celio

Use the map tools below to view real estate available in a specific area. You can use the Draw tool or Radius tool to define a custom search area, or use the Region Search tool to narrow down results by state, county, and town.

Interested in some of these properties? Contact our team to set up a showing or learn more about real estate in this area.

48 Chesterfield Road Hebron CT 06231
Save Favorite

Price$599,900

Est. Mortgage: $/month

MLS Number170529843

  • Single Family
  • Square Feet 4,233
  • Bedrooms 5
  • Bathroom 3
  • Year Built 1993

Beautifully Planned & Appointed American Double Wing Colonial Offering an Array of Special Home Features. LOCATION PLUS SETTING-Country Neighborhood, 2.48 Acre Treed Lot, & Quiet Permanent Cul-de-sac Street! This 10 Rooms-5 BR-3 Full Bath Home Offers 3316 SF of Primary Living Areas Including Potential Extended Family or Au Pair Quarters PLUS Additional 917 SF of Finished LL Area! Country Kitchen w/Horseshoe Cabinets, Granite Counter Space, Daily Dining Area, Appliances Includes Double Wall Oven, & Sliders to Private 12'x 20' Rear Deck! 13' x 15' Formal Dining Room w/HW Floors, Crown Moulding, & Chair Rail Accents! HW Floored Formal Living Room Features 1 of 2 Masonry Fireplaces w/Supplement Heat Pellet Stove Insert! First Floor Family Room Offers Full Wall Floor to Ceiling Fieldstone Fireplace & HW Floors! 2nd Floor Plan Arranged w/Suite Primary BR- Walk-In Closet, Private Full Bath Tile Floor, Double Sink Basins, Jet Tub, & Shower Stall! Balance of Main 2nd Floor Offers 3 BR's All w/HW Floors & Additional Full Bath! Separate Interior Accessed “Bonus Room” Suitable for Extended Family Living Arrangements! Special Features Include 30 Solar Panel System Cost Saving Fixed Price Power Purchase Agreement! PLUS-2 Car Attached Garage-Detached Single Bay Garage w/Attached Screened Porch, Whole House Generator, Brick-Paver Walkways, Landscaped Grounds, Paved Driveway, Warm Air Furnace, & Central A/C! EZ Commute to Hartford, Manchester, Willimantic, Norwich, UCONN, OR ECSU Campus!

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 2022
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Listed by Century 21 AllPoints Realty

Virtual TourSchedule TourAsk A QuestionMore Details

108-106 Colts Pond Road Ashford CT 06278
Save Favorite

Price$599,900

Est. Mortgage: $/month

MLS Number170535213

  • Single Family
  • Square Feet 768
  • Bedrooms 2
  • Bathroom 2
  • Year Built 1988

This Listing (170535213) is One of Two Created to Present Full Information for The Country Estate Property Located at 106-108 Colts Pond Road in Ashford CT. In Addition to A Beautiful Rural Country 14.09 Acre Setting of A Mix of Treed and Cleared Acreage, Fruit Trees, Garden Areas, New England Stonewalls Plus A Private Pond, This Property's Centerpiece is A Circa 1785 Center Chimney Cape Cod "Main House" Offering 2885 SF of Living Area Consisting of 10 Rooms, Featuring 5 Working Fireplaces, and a Blended List of Special Antique and Modern Updated Home Features(See MLS #170535210)! In Addition to the "Main House" This Property Features a Detached 2 Car Garage with Finished Second Floor Two Room Studio Space (Floor Plan Provided in Listing Photos). PLUS, Detached 40'x 24' Two Story Barn with a 5 Room 2 Bedroom Second Floor Apartment Suitable as Caretaker Quarters, Guest Quarters, or Extended Family Living Arrangement! (Floor Plan Provided in Listing Photos). Situated in Rural Eastern Connecticut Community of Ashford Offering a Mid-Point Location to Either Boston or New York this Property is Abutted on 80% of Its Boundaries by Land Held in Conservation Trust!

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 2022
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Listed by Century 21 AllPoints Realty

Virtual TourSchedule TourAsk A QuestionMore Details

106-108 Colts Pond Road Ashford CT 06278
Save Favorite

Price$599,900

Est. Mortgage: $/month

MLS Number170535210

  • Single Family
  • Square Feet 2,885
  • Bedrooms 4
  • Bathroom 3
  • Year Built 1785

Rural Eastern Connecticut Country Estate Property Nestled on 14+ Beautiful Farmland Acres. This Private Tranquil Setting Offers A Mix of Both Open Pasture and Mature Native Species Tree Growth Acres Accented by Classic New England Fieldstone Wall Fences, Private Pond, Garden Areas, Fruit Trees, and Guaranteed Privacy with Open Space Conservation-Trust Lands along 80% of Estate Property Boundaries. "THE PINKHAM ESTATE" features a Circa 1785 Center Chimney Cape Cod Main Residence, Detached Two Car Garage with Second Floor Two Room Artist Studio/Home Office Space, and 24'x 40' Two Story Barn with Second Floor Two Bedroom "Caretaker's Quarters-Suitable as Guest Quarters or For Extended Family Living Use! The Main House Features an Abundance of 1785 Era Charm and Character with Antique Features Lovingly Preserved While Combined with Thoughtful Appropriately Designed Additional Living Areas Added! The Main Home Consists of 2885 SF of Living Area Over a 10 Room-3/4 BR-2.5 Bath Floor Plan Accented by Spacious Country Kitchen, Central Formal Dining Room, 5 Working Fireplaces, Wide-board Flooring, Open Beamed Ceiling-PLUS Open Front and Back Porches AND a Fully Screened Summer Porch! Central Heat Oil-Fired and Propane Fired Warm Air Systems, Supplemental Wood Stove/Propane Gas Log Heating Units , Central A/C and Whole House Auto Generator System! More Detailed Information and Photos for the Garage/Studio and Barn/Caretaker Quarters can be viewed on MLS#170535213!

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 2022
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Listed by Century 21 AllPoints Realty

Virtual TourSchedule TourAsk A QuestionMore Details

107 Main Street Hebron CT 06248
Save Favorite

Price$549,900

MLS Number170513477

  • Commercial
  • MLS Status Active
  • Year Built 1970
  • Square Feet 3,744
  • Acreage 0.88

Located in the Heart of Hebron Main Street Business Zone with excellent visibility and Traffic count on "Main Street" Rt 66. 3744 SF single level building with 3 rental units. Past and current usage as General and Professional Office Space. Excellent on site parking in both the rear and front of the building. Served by Public Water and Sewer with Natural Gas now available to the site! Great Pedestrian connections to all of the Hebron Main Streeet Business area! Shown by appointment. Route 66 billboard location!

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 2022
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Listed by Century 21 AllPoints Realty

Virtual TourSchedule TourAsk A QuestionMore Details

John Horton Boulevard Hebron CT 06231
Save Favorite

Price$549,900

Est. Mortgage: $/month

MLS Number170342842

  • Land
  • Acreage 34.79
  • MLS Status Active
  • Zoning Village Green
  • Subdividable

Hebron Village Green Multi Use Zoned Properties. This Offering Consists of Two Separate Parcels. 25.31 Acres Parcel with Conceptual Development Plan as the New Town Green Area and a Second 9.48 Parcel Suitable for Condominium or Apartment Development of up to 44 Units. These Parcels are Part of an Approved Mixed Use Zoned Site Combining General Business, Retail, Commercial, and Diversified Residential Uses! 1100 Ft John Horton Boulevard is an Accepted Town Road with Final Course of Paving and come with Natural Gas, Public Sewer, Public Water, And Underground Electrical/Cable/Communication Utilities Installed and Available for Connection. Town approved Master Concept Plan of Development with Army Corp of Engineers Approved! Long list of Resources and Reference Materials on this Fantastic Development Opportunity! Unbelievable Value - Currently John Horton Boulevard is the Location for Colebrook Village at Hebron a Fully Completed Assisted Living Facility offering 114 Residential Units.

$
$
%
$/month over payments
Federal 30-year interest rate: 6.58% last updated on Nov 23, 2022
* All Figures are estimates. Check with your bank or proposed mortgage company for actual interest rates.
This product uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Listed by Century 21 AllPoints Realty

Virtual TourSchedule TourAsk A QuestionMore Details

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