Listings for Rosemary Russo

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.

8 Banbury, Farmington, CT 06032
Save Favorite

Price$799,900

Est. Mortgage: $/month

MLS NumberG10195851

  • Single Family
  • Square Feet 4,451
  • Bedrooms 4
  • Bathroom 4
  • Year Built 2012

Welcome to this quintessential, custom NE Col offering exceptional attention to the finest details. Set back from the road in a priv, un-paralleled small enclave offering .78 A of lushly landscpd yard. Exuding grace & elegance thruout w/ superior architectural features w/exceptional lit crown moldings, coffered & tray ceilings, high end finishes, custom hardware & HW Flrs thruout. The open floor plan is perfect for formal entertain or everyday living. The sophisticated décor is neutral w/gracious, high-end lighting, profess window treatmnts, designer finishes & formal hand stenciled powder room w/gorgeous sink. Gather w/friends in the magnificent chefs KIT featuring high end Viking appli, custom cabinetry, lg center granite island, desk area, spacious eatin space & opens to a step down FR. This sophisicated, yet comfortable rm w/an abundance of natural light boasts lovely stone FP & opens to the elegant DR w/old world butlers bar, glass cabinets, wine rack & refrig for easy entertaing access. Set away from the main house is comfortable OFF, currently a billiard rm, w/coffered ceiling, wainscoting & French dr. Sheer opulence exudes in the breathtaking MBRM wing w/double drs entering a truly magical space w/extensive moldings, tray ceiling, custom closet like no other & to die for, luxurious grand mbth incl separate vanities, soaking tub & lg shower. 3 addl ensuite & upper media rm, C/B be 5th bedroom, occupy rest of the upper level. There's no reason to build-just move in.

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Virtual TourSchedule A VisitAsk A QuestionMore Details

30 Bridgehampton, Farmington, CT 06032
Save Favorite

Price$798,000

Est. Mortgage: $/month

MLS NumberG10233810

  • Single Family
  • Square Feet 3,981
  • Bedrooms 4
  • Bathroom 4
  • Year Built 2012

Quality & Elegance exude thruout this 2013 David Stoner built Col. Beautiful & Exquisite architectural details incl extensive wainscoting, triple crown moldings, coffered ceilings & special attention to the finest details. The formal living room boasts an elegant detailed fireplace w/hand carved mantel & is open to the dining room with refined wainscoting & ample windows which radiates natural sunlight making this space perfect for formal entertaining. Enjoy cooking & socializing in the fantastic chef's kitchen w/neutral cabinetry, granite counters, neutral stone backsplash, center island, eat-in space & opens to the dramatic, yet comfortable family room w/coffered ceiling & fireplace w/detailed mantel. Tranquility best describes the home office, set away from the rest of the living area, with custom built-in cherry built-ins. Retreat to luxurious master bedroom suite w/hardwood floors, tray ceiling, full custom bathroom & two walk-in closets. There are three additional bedrooms, all with hardwood floors, walk-in closets and access to private full bathrooms. Second floor Laundry Room. Many upgrades Generac Gas Fired automatic Generator, Hardwood throughout. State of the art surround sound, eat in kitchen crystal light fixture, extensive landscaping. Public Water & sewer. Underground utilities

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

15 Lucy, Simsbury, CT 06070
Save Favorite

Price$764,900

Est. Mortgage: $/month

MLS NumberG10219928

  • Single Family
  • Square Feet 4,072
  • Bedrooms 5
  • Bathroom 6
  • Year Built 1988

stunning Col w/2.32 acrs of meticulously maintained grounds set back from road & offers a serene & private setting. Quality & elegant architectural details incl extensive molding, profes decorating & décor exude thruout this completely renovated home. The impressive 2 story foyer leads to dining, billiard & fam rms. Billiard room (formerly liv rm) radiates “fun” & is a hang-out heaven w/inviting décor, vaulted ceiling, over-sized windows & FP. 2 story fam rm is the focal point boasting flr to ceiling stone FP, built in shelves, full wall of glass French drs, sophisticated wet bar & opens to kit & DR for easy entertaining. Gorgeous remod kit is another perfect spot for gatherings w/its warm décor, high end appliances, butlers bar, built in desk & ample cabinetry many w/lighted glass fronts. The en-suite 1st FL MBR suite is set away from rest of the home for total privacy & offers a newly updated luxurious bath w/separate his/her vanities. Upper level consists of another Master Bedroom Suite w/charming remod bth & 2 add generous bdrms both en-suite w/updated FBTHS & radiant heated flrs. Handsom bonus rm w/rich wood paneling, built-in shelves & large office nook is accessible to FBTH & could couple as 5th bedroom. Back stairway leads to the newly finished mud rm w/built-in seating & egress to outside & garage. LL is perfect for gaming or playroom w/2 large partially finished rms & walk in temperature controlled wine cellar

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Virtual TourSchedule A VisitAsk A QuestionMore Details

46 Meadow, Avon, CT 06001
Save Favorite

Price$759,900

Est. Mortgage: $/month

MLS NumberG10235537

  • Single Family
  • Square Feet 4,340
  • Bedrooms 4
  • Bathroom 7
  • Year Built 1992

Fantastic location for the New England style colonial set on over 1 acre in the heart of Avon convenient to everywhere. Beautiful details thru out including extensive moldings, wainscoting, two story family room with floor to ceiling windows, 4 FP's, updated kitchen with new stainless appliances, newly finished hardwood floors, new carpet in family room. All generous and gracious rooms great for entertaining or every day living. 1st fl library w/cherry built-ins. Upper level boast 4 brms plus media room and back stairs to mud room. Master suite w/FP, Walk in Closet & full bath with remodeled Shower. Full walk out lower level great for in-law or au-pair w/full bath. New 50 Yr arch. shingle roof. DON'T MISS OUT!!!!!

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

178 Orchard, West Hartford, CT 06117
Save Favorite

Price$699,000

Est. Mortgage: $/month

MLS NumberG10208643

  • Single Family
  • Square Feet 4,266
  • Bedrooms 4
  • Bathroom 5
  • Year Built 1969

Truly unique one of a kind home set on over an acre west of mountain road at the end of the cul-de-sac. Custom designed contemporary with dramatic architecture details including archways, soaring ceiling, spectacular doors, stained hardwood floors & open floor plan perfect for entertaining or everyday living. Enjoy nature at its best...each room has sliders to private decks and patios. First floor master wing w/dressing room, full bath, steam shower & cedar walled tub room. Separate wing with 2 bedrooms (one with lofted area) & full bath. Finished walk out in lower level with additional bedroom, full bath and natural wood paneled walls & ceiling game room also w/slider to private patio...additional 1,134 sq. ft. Automatic propane generator

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Virtual TourSchedule A VisitAsk A QuestionMore Details

Pending26 Schoolhouse, West Hartford, CT 06110
Save Favorite

Price$284,000

Est. Mortgage: $/month

MLS NumberG10215140

  • Condo
  • Bedrooms 2
  • Bathroom 2
  • Square Feet 1,065
  • Year Built 2013

Great opportunity to live at quaker green in this almost new condo. Convenient location & close to center & bbsq. 3rd floor unit with balcony overlooking grounds. Kitchen with ss/appliances, breakfast bar & granite. Mbrm set away from rest of unit with w/i closet & full bath w/glass enclousure. Bright and sunny open floor plan. Oversized attached garage a7 (key & fob in unit for garage and club house and exercise room). Great club house w/social, billiard & exercise. Inground pool. Don't miss out.

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Virtual TourSchedule A VisitAsk A QuestionMore Details

40 Applewood, Avon, CT 06001
Save Favorite

Price$174,900

Est. Mortgage: $/month

MLS NumberG10218509

  • Condo
  • Bedrooms 3
  • Bathroom 3
  • Square Feet 1,650
  • Year Built 1976

Bring your decorating ideas. Spacious 3 bedroom 2.1 bath town home with private setting on the 18th green. Dramatic cathedral ceiling formal living room with fireplace. Formal dining room, eat in kitchen with sliders to over sized deck and views of the golf course. Master bedroom suite has a dressing room and full bath. 1 car attached garage. Priced to sell for that buyer looking to make it their own.

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

9012 Waterville, Farmington, CT 06032
Save Favorite

Price$124,900

Est. Mortgage: $/month

MLS NumberG10221941

  • Land
  • Acreage 2.19

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

Pending9014 Waterville, Farmington, CT 06032
Save Favorite

Price$124,900

Est. Mortgage: $/month

MLS NumberG10221945

  • Land
  • Acreage 2.1

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

34 Schoolhouse, West Hartford, CT 06110
Save Favorite

Rental Price$2,300

MLS NumberG10225717

  • Rental
  • Square Feet 948
  • Bedrooms 2
  • Bathroom 2
  • Year Built 2015

Gorgeous end unit in popular Quaker Green community. This unit has it all. Custom built ins, crown molding, granite, custom paint colors and so much more. Anyone would want to live in this bright sunny professionally decorated unit. Enjoy maintenance free living in this elevator building. This wonderful community also offers a heated pool, full fitness center, social and billiard rooms. One car garage with a parking place behind the garage. Minutes to West Hartford Center and Blue Back Square. Convenient to hospitals and restaurants. This property is for sale as well G10219258

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

25 Stanley, West Hartford, CT 06107
Save Favorite

Rental Price$2,175

MLS NumberG10233403

  • Rental
  • Square Feet 1,425
  • Bedrooms 2
  • Bathroom 2
  • Year Built 1981

Location! Location! Location! Seldom available - one block to west hartford center! 2 bedroom, 2 full bath, loft style unit. Kitchen with granite and ss. Dining/living room with wood burning fireplace, sliders to deck. Washer and dryer in unit. Garage available for $75 month. Enjoy being close to restaurants, shops and all that west hartford center has to offer!!

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

25 Stanley, West Hartford, CT 06107
Save Favorite

Rental Price$2,175

MLS NumberG10234289

  • Rental
  • Square Feet 1,425
  • Bedrooms 2
  • Bathroom 2
  • Year Built 1981

Location! Location! Location! Seldom available - one block to west hartford center! 2 bedroom, 2 full bath, loft style unit. Kitchen with granite and ss. Dining/living room with wood burning fireplace, sliders to deck. Washer and dryer in unit. Garage available for $75 month. Enjoy being close to restaurants, shops and all that west hartford center has to offer!!

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

25 Stanley, West Hartford, CT 06107
Save Favorite

Rental Price$2,175

MLS NumberG10234291

  • Rental
  • Square Feet 1,425
  • Bedrooms 2
  • Bathroom 2
  • Year Built 1981

Location! Location! Location! Seldom available - one block to west hartford center! 2 bedroom, 2 full bath, loft style unit. Kitchen with granite and ss. Dining/living room with wood burning fireplace, sliders to deck. Washer and dryer in unit. Garage available for $75 month. Enjoy being close to restaurants, shops and all that west hartford center has to offer!!

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

114 Huckleberry Hill, Avon, CT 06001
Save Favorite

Rental Price$1,595

MLS NumberG10197683

  • Rental
  • Square Feet 1,000
  • Bedrooms 2
  • Bathroom 2
  • Year Built 1927

This ONE-PLUS Bedroom is light filled and roomy! Converted from an old schoolhouse, all 6 units in the building have large windows allowing plenty of light and hardwood in the living room. Large bedroom with pocket doors to second bedroom/office/den. Unit has granite and stainless in updated kitchen, washer/dryer, lots of closet space, and comes with your own garage. Pets may be accepted with one time pet fee of $250. Security Deposit. Tenant pays all utilities. Lease 1 yr. Other units available. Close to 17acr Countryside Park for fishing, hiking and picnics. Call NOW!!

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

Schedule A VisitAsk A QuestionMore Details

114 Huckleberry Hill, Avon, CT 06001
Save Favorite

Rental Price$1,495

MLS NumberG10197698

  • Rental
  • Square Feet 1,000
  • Bedrooms 2
  • Bathroom 2
  • Year Built 1927

This ONE-PLUS Bedroom is light filled and roomy! Converted from an old schoolhouse, all units in the building have large windows and hardwood in the living room. Large bedroom with pocket doors to smaller bedroom/office/den. Unit has large living/dining area, kitchen, washer/dryer, lots of closet space, and comes with your own garage. Pets may be accepted with a one time fee of $250. Credit check, Security Deposit. Tenant pays all utilities. Lease 1 yr. Other units available. Close to 17acr Countryside Park for fishing, hiking and picnics. CALL NOW!!

CENTURY 21 AllPoints Realty, Windsor
70 Poquonock Avenue
Windsor CT, 06095
Office: 860-688-4911

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 Jul 27, 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 Rosemary Russo of Century 21 AllPoints Rlty

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.