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.

Hebron, CT 06248
Save Favorite

Price$599,999

Est. Mortgage: $/month

MLS NumberG10238420

  • Land
  • Acreage 53
  • Subdivision Lakewood Estates
  • Zoning Residential
  • Subdividable

LAKEWOOD ESTATES is a Fully Approved 32 Lot OPEN SPACE Single Family Home Subdivision located in Hebron CT. An Environmentally Conscious Greenway Preservation Plan of Development Which Nestles 32 Single Family Home Sites Ranging from .7 Acres to 3.3 Acres Spread Across 53+ High and Dry Development Acres! This Primary Development Area is Surrounded by a Total of An Additional 71 Acres of Naturally Preserved and Dedicated Open Space Land Tract Areas! The Plan of Development Calls for Construction of Two Permanent Cul-de-sac Roads To Be Served By Under Ground Utilities, Public Sewers, and Individual Water Wells! Build Out of Lakewood Estates is Based on a Developer Friendly Multi-Phased Construction Plan of Development! Documents available include Complete Fully Approved Subdivision Plan, Full Road and Utility Engineering, Conditions of Approval, Delineated Recorded Open Space and Wetland Areas. Bonding Estimates/Requirements are Also Available. At Under Acquisition Cost of UNDER $19,000 PER APPROVED BUILDING LOT this Opportunity Deserves Serious Investigation! Hebron Location Offers EZ commute to Hartford's Capital Region Area, Manchester, Willimantic, Norwich-New London Employment Centers As Well as the Campus' of UCONN and ECSU!

{$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.92% last updated on Nov 2, 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

84 Long Hill, Andover, CT 06232
Save Favorite

Price$550,000

Est. Mortgage: $/month

MLS Number170018457

  • Single Family
  • Acreage 73.72
  • Square Feet 1,740
  • Bedrooms 4
  • Bathroom 2

Rare Opportunity-First Time Offered in the Open Real Estate Market Place in Literally Generations! "The Talbot Farm" a 77+ Acre Country Farm with Pastoral Hill Top Setting with Sweeping Panoramic Views! Circa 1774 Two Story Colonial Home with 1740 Square Feet of Living Area! Country Kitchen with Dining Area Featuring Built In Cupboards, Fireplaced Family Room with Hardwood Floors and Built in Book Shelving, Hardwood Floored & Fireplaced Living Room, 4 Bedrooms- 2 On Main Level and Two On Second Floor, 2 Full Baths-One on Main Level and One on Second Floor, First Floor Laundry Room, and Large L-Shaped Rear Screened Porch with Beautiful Pasture/Woodland Views! Mid 1950's Built Full Sized Post and Beam Barn in Superb Condition with Full Lower Level Walk Out Double Sliding Door Access! Rolling 77 Acres Comprised of Some Open Pasture/Grazing Ground (Estimate 5-6 Acres), Winding Brook and Stream Traverses Full Length of the Property North to South with Majority of the Site Treed with Variety of Native Tree Growth! Recent Full A-2 Boundary Survey Available! Primary Mechanical Systems of the Residence Have been Upgraded within the Past 10 Years - Boiler 2007, Electrical Service 2017, Well Pump 2009, New Residence Roof 2016, Barn Roof 2010, Exterior Barn and House Painted 2013 and 2016 Respectively! Great Location with EZ Commute to Hartford, Manchester, and Willimantic Employment Areas as Well as UCONN and ECSU!

{$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.92% last updated on Nov 2, 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

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.92% last updated on Nov 2, 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.92% last updated on Nov 2, 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

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

To Be Built Similar to Photo With Front Load Garage! Builder has Similar Home Nearing Completion at 42 Chittenden Road Hebron that can Serve as "Model Home" for Buyer Walk Through! Country Setting 1.16 Acre Lot in Gilead Section of Hebron! Still Time to Tweak Floor Plan and Select Finish Details to Your Liking!! 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.92% last updated on Nov 2, 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.