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.

310 Old Colchester, Hebron, CT 06231
Save Favorite

Price$499,900

Est. Mortgage: $/month

MLS Number170020807

  • Land
  • Acreage 81.94
  • Waterfront
  • Zoning R-1

Spectacular 81.94 Acre Parcel Offering Great Natural Beauty. Truly A Nature Lovers Paradise! Incredible 3000+/- Feet of Raymond Brook Traverses the Southern Portion of the Property with the Property's Southern Boundary Running Full Length Along the Airline Trail! Gently Rolling Topography with Majority of Acreage Populated with A Variety of Mature Native Tree Growth! The Property Does Have A Gravel Driveway and Overhead Power/Utilities to A Trailer Site Centrally Located on the Property. Suitable for Estate Like Site for a Single Home or Offers Potential for Development as a Single Family Homes Subdivision! Frontage on Two Improved Local Roads- 600+/- Feet Of Road Frontage Along Old Colchester Road with an Additional 50 Foot Frontage Access Point Off Northam Road. Property is Comprised of Three Parcels. The House Trailer on site is not offered as a habitable dwelling and will be subject to Either negotiated removal or conveyed "as is"with no representation for future use by Seller. Please do not enter the Trailer!

{$agent->Name}

CENTURY 21 AllPoints Realty, Hebron
17 Main Street
Hebron CT, 06248
Office: 860-228-9425

Do not fill in this field:

Do not fill in this field:

$
$
%
$/month over payments
Federal 30-year interest rate: 3.94% last updated on Dec 21, 2017
* 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 James Celio of Century 21 AllPoints Realty

Virtual TourSchedule A VisitAsk A QuestionMore Details

52 Smith Farm, Hebron, CT 06231
Save Favorite

Price$409,900

Est. Mortgage: $/month

MLS Number170033783

  • Single Family
  • Acreage 3.63
  • Square Feet 2,666
  • Bedrooms 3
  • Bathroom 3

Quiet country cul-de-sac location is the start of a long list of special features with this Smith Farm Road 2666 square foot 3 BR colonial! Situated on 3.6+ acre lot dotted with field stone wall accents! Area of truly beautiful traditionally styled homes! Inviting tile floored two story foyer entry. First floor features 9' ceilings and window scheme flooding loads of natural light throughout living areas! True country kitchen-cherry cabinet works, maple wood flooring, granite counter tops, large granite top central island cabinet/counter with breakfast bar feature, stainless steel appliances, french doors to rear deck, and daily dining area! Front to back living room with random width maple wood flooring and masonry brick fireplace with gas log insert. Formal dining room with Brazilian redwood flooring! First floor 23'x 23' great room with carpeting over random width maple wood flooring, 2 story cathedral ceiling, dual overhead fan units, tract lighting, paladin window unit, and French Door accessing 600+ square feet of private rear deck! Three second floor bedrooms all with maple flooring and each with OH fan units! MBR suite offers full private bath and walk in closet! Unfinished lower level with ground level walk out French Door unit and three windows offers great potential of additional finished living area! 3.6+ Acre lot, private tree ringed rear yard abutting dedicated open space area! 2 car garage, paved drive, paver walkway, oil heat, central a/c, 2 1/2 baths, & More!

{$agent->Name}

CENTURY 21 AllPoints Realty, Hebron
17 Main Street
Hebron CT, 06248
Office: 860-228-9425

Do not fill in this field:

Do not fill in this field:

$
$
%
$/month over payments
Federal 30-year interest rate: 3.94% last updated on Dec 21, 2017
* 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 James Celio of Century 21 AllPoints Realty

Virtual TourSchedule A VisitAsk A QuestionMore Details

209 Hebron, Andover, CT 06232
Save Favorite

Price$399,900

Est. Mortgage: $/month

MLS NumberG10237345

  • Single Family
  • Acreage 2.22
  • Square Feet 2,914
  • Bedrooms 4
  • Bathroom 3

A truly distinctive country colonial offering beautiful blend of the pure charm of yesteryear and modern conveniences! Loads of character with a long list of very special home features! 2.2 Estate like flat and usable acres with extensive plantings, flower beds, and mature tree growth surround this 2914 SF four bedroom home! A Home Floor Plan made for Entertaining Friends and Family Alike! True country kitchen-totally renovated with newer cabinets, granite counter tops, island counter with breakfast bar, random width pegged oak flooring, field stone fireplace, spacious daily dining area, double wall oven, cook top range, side by side refrigerator, and dishwasher to convey! First floor offers roomy 14x19 formal dining room, formal living room, home office, and large first floor family with fireplace, built in bookshelves, and sliders to 13x18 enclosed screened porch overlooking gunite in-ground heated pool! First Floor Home Office! Master bedroom Suite with adjoining 11x13 Second Home Office or Study plus full bath with double basin sink! Fenced area In-ground gunite pool with extensive pool surround patio area, pool house, and solar heating unit! Landscaped grounds made a little easier to maintain with your own Attached Greenhouse! PLUS 2 stall horse barn with electric fenced grazing area! Paved Drive, Multi Zone Oil Hot Water Baseboard Heat, and Attached Two Car Garage!

{$agent->Name}

CENTURY 21 AllPoints Realty, Hebron
17 Main Street
Hebron CT, 06248
Office: 860-228-9425

Do not fill in this field:

Do not fill in this field:

$
$
%
$/month over payments
Federal 30-year interest rate: 3.94% last updated on Dec 21, 2017
* 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 James Celio of Century 21 AllPoints Realty

Virtual TourSchedule A VisitAsk A QuestionMore Details

Pending42 Chittenden, Hebron, CT 06248
Save Favorite

Price$350,000

Est. Mortgage: $/month

MLS Number170021006

  • Single Family
  • Acreage 2.88
  • Square Feet 2,200
  • Bedrooms 4
  • Bathroom 3

New Price! Rurally situated Just Completed Colonial offers IMMEDIATE OCCUPANCY! OPEN FOR YOUR INSPECTION! FULLY COMPLETED! 2.88 Acre Lot set on Low Traffic Local Dead End Street with Private yet not Remote Feel! Located in the South End of Hebron with EZ Commuter Location via CT RT 2 to Hartford, Norwich, New London as well as UCONN, or ECSU! 2200 SF Two Story Colonial Home Floor Plan with Fully Finished Second Floor Bonus Room! Kitchen Features Granite Counter Tops, Custom Cabinetworks with Peninsula Cabinet and Counter! Hardwood Floors throughout the Entire First Floor Plan offers Country Styled Kitchen with Stainless Steel Appliances. Daily Kitchen Dining Area, Front to Back Fireplaced Living Room, and Formal Dining Room! Second Floor Features Front to Back MBR with Private Bath and Walk In Closet, 3 or 4 Bedrooms Layout, Two Full Baths, and Laundry Room! Finished Bonus Room/Bedroom accented with Two Front "Eye" Dormers" Offers Great Living Area! Attached Two Car Garage, Propane Fired Hot Water Boiler Heat, Fully Installed Central A/C, $2500 Appliance Allowance, and Paved Driveway! ½ Mile to Exit 16 Route 2 and Hartford-Norwich New London Commute Lane! Site Plan, Building Spec's and Blueprints Available to View! CT New Home Contractor #0000490

{$agent->Name}

CENTURY 21 AllPoints Realty, Hebron
17 Main Street
Hebron CT, 06248
Office: 860-228-9425

Do not fill in this field:

Do not fill in this field:

$
$
%
$/month over payments
Federal 30-year interest rate: 3.94% last updated on Dec 21, 2017
* 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 James Celio of Century 21 AllPoints Realty

Schedule A VisitAsk A QuestionMore Details

247 Martin, Hebron, CT 06248
Save Favorite

Price$349,900

Est. Mortgage: $/month

MLS Number170020993

  • Single Family
  • Acreage 1.16
  • Square Feet 2,200
  • Bedrooms 4
  • Bathroom 3

Great Country Location in Gilead Area of Hebron! Great Commuter Location 1 Mile to Glastobury Town Line! 90 Days to Completion! Still Time to Make Modifications to Your Liking! Builder has Similar Home Completed Home 42 Chittenden Road Hebron which Offers Great Look at a Finished Home Details! Serves as "Model Home" for Buyer Walk Through! Country Setting 1.16 Acre Lot! Located in the North End of Hebron within 1 Mile of Two Public Golf Courses offering EZ Commuter Location to Hartford, Manchester, UCONN or ECSU! 2200 SF Two Story Colonial Home Floor Plan with Finished Second Floor Bonus Room! Kitchen Features Granite Counter Tops with Buyer selection from Custom Cabinet Samples and Your Choice of Hardwood or Tile Flooring Samples! Well thought out First Floor Plan offers Daily Kitchen Dining Area, Front to Back Fireplaced Living Room, and Formal Dining Room with Hardwood Floors! Second Floor Features Front to Back MBR with Private Bath and Walk In Closet, Second Floor Laundry Space with Total of Three Bedrooms and Two Full Baths! Second Floor Bonus Room offers 392 SF of Finished Living Area accented with Two Front "Eye" Dormers" Offers Great Living Area! Attached Two Car Garage, Propane Fired Hot Water Baseboard Heat, Fully installed Central A/C! Site Plan, Building Spec's and Blueprints Available to View! CT New Home Contractor #0000490

{$agent->Name}

CENTURY 21 AllPoints Realty, Hebron
17 Main Street
Hebron CT, 06248
Office: 860-228-9425

Do not fill in this field:

Do not fill in this field:

$
$
%
$/month over payments
Federal 30-year interest rate: 3.94% last updated on Dec 21, 2017
* 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 James Celio of Century 21 AllPoints Realty

Schedule A VisitAsk A QuestionMore Details

Information contained in this Smart MLS listing has been compiled from various sources, all of which may not be completely accurate. Smart MLS makes no warranty or representation as to the accuracy of listing information. All information that influences a decision to purchase a listed property should be independently verified by the purchaser. Copyright 2017 Smart MLS, Inc. All rights reserved.