NOT LISTED FOR SALE

501 The Mews Rocky Hill, CT 06067

Estimated Value: $385,000 - $419,761

2 Beds
2.5 Baths
2,292 Sq Ft
$177/Sq Ft Est. Value

Last Sold August 16, 2024

Last sale price $400,000 $175 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,040/month

7 Days on Market

Highlights

  • Property is near public transit
  • Attic
  • End Unit
  • Albert D. Griswold Middle School Rated A
  • 1 Fireplace
  • Public Transportation

About This Home

As of August 2024

Come and experience this stunning end unit townhouse at Rolling Greens! This freshly painted and updated home features 2 bedrooms and 2.5 bathrooms, boasting an open floor plan with high ceiling and captivating Golf Course Views. The kitchen has been beautifully upgraded with customized cabinets (2023), quartz countertops (2023), and new stainless steel appliances including a gas stove and microwave (2023) with additional countertop and cabinet space. Upstairs, two spacious bedrooms with attached bathroooms, while a large size loft with 2 skyview windows overlooks the cathedral foyer ideal for a cozy sitting area or office space. The full finished walk-out basement adds 756 sqft of additional living space (included in total sqft) and provides ample storage. Recent updates include a newer roof (2019) and a private Trex deck (2021), perfect for outdoor enjoyment with easy access to a large lawn common area. Located conveniently close to shopping, restaurants, and with easy access to main highways, this townhouse offers both luxury and convenience. Don't miss out on this opportunity!

Last Agent to Sell the Property

Deepak Sharma

Executive Real Estate Inc. License #RES.0799012 Listed on: 07/16/2024

Executive Real Estate Inc.

Co-Listed By

Rachna Sharma

Executive Real Estate Inc. License #RES.0812987

Last Buyer's Agent

Himanshu Singh

Singh Realty License #REB.0795564

Townhouse Details

Home Type

  • Townhome

Est. Annual Taxes

  • $5,911

Year Built

  • Built in 1990

Lot Details

  • End Unit

HOA Fees

  • $395 Monthly HOA Fees

Parking

  • 1 Car Garage

Home Design

  • Concrete Siding
  • Vinyl Siding

Interior Spaces

  • 1 Fireplace
  • Walkup Attic

Kitchen

  • Gas Range
  • Microwave
  • Dishwasher

Bedrooms and Bathrooms

  • 2 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Location

  • Property is near public transit
  • Property is near shops
  • Property is near a golf course

Schools

  • West Hill Elementary School
  • Rocky Hill High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • 60+ Gallon Tank

Listing and Financial Details

  • Assessor Parcel Number 2255614

Community Details

Overview

  • Association fees include grounds maintenance, snow removal, water, sewer, property management, road maintenance
  • 100 Units
  • Property managed by Rolling Greens Condo Asso

Amenities

  • Public Transportation

Pet Policy

  • Pets Allowed

Townhouse Details

Home Type

Townhome

Est. Annual Taxes

$5,911

Year Built

Built in 1990

Lot Details

0

HOA Fees

$395 per month

Listing Details

  • Neighborhood: N/A
  • Property Type: Condo/Co-Op For Sale
  • Style: Townhouse
  • Sq Ft Est Heated Above Grade: 1536
  • Sq Ft Est Heated Below Grade: 756
  • Total Sq Ft: 2292
  • Year Built: 1990
  • New Construction: No/Resale
  • Nearby Amenities: Golf Course, Medical Facilities, Public Pool, Public Transportation, Shopping/Mall, Tennis Courts
  • Remarks Public Addendum: HIGHEST AND BEST DUE - MONDAY 7/22 AT 8:00PM
  • Property Sub Type: Condominium
  • Direct Waterfront: No
  • End Unit: Yes
  • Home Warranty Offered: No
  • Special Assessment Details: $142.79
  • Directions: Cold Spring Rd Turn left onto Century Hills Dr Turn right to The Mews
  • Financing Used: Conventional Fixed
  • Spec Assoc Asses: Yes
  • Street Type: Mews
  • Special Features: None

Interior Features

  • Total Bedrooms: 2
  • Total Bathrooms: 3
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Fireplaces: 1
  • Attic Description: Walk-up
  • Basement Description: Full, Fully Finished, Full With Walk-Out
  • Appliances: Gas Range, Microwave, Refrigerator, Dishwasher, Washer, Dryer
  • Laundry Room Info: Main Level
  • Attic: Yes

Exterior Features

  • Exterior Siding: Vinyl Siding
  • Waterfront Description: Not Applicable
  • Swimming Pool: No
  • Construction Description: Concrete

Garage/Parking

  • Garages Number: 1
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Natural Gas, 65 Gallon Tank
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Condo/Co-op/Association

  • Association Fee Includes: Grounds Maintenance, Snow Removal, Water, Sewer, Property Management, Road Maintenance
  • HOA Fees: 395
  • HOA Fee Frequency: Monthly
  • Property Management Type: Professional-Off Site
  • Property Manager Name: Rachael Fazzino
  • Property Mgt Company Name: Rolling Greens Condo Asso
  • Property Mgt Phone: (860) 728-9759
  • Total Number of Units In Complex: Rolling Greens

Lot Info

  • Lot Description: Level Lot
  • Zoning: R-20
  • Parcel #: 2255614

Rental Info

  • Pets Allowed Info: Dogs and Cats
  • Pets Allowed: Yes

Multi Family

  • Total Number Of Units: 100

Tax Info

  • Tax Year: July 2024-June 2025
  • Property Tax: 5911

MLS Schools

  • Elementary School: West Hill
  • High School: Rocky Hill

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 16, 2024
Closed on
Aug 16, 2024
Sold by
Munnanoory Kiran
Bought by
Khichi Shailendra S and Singh Namrata
Seller's Agent
Deepak Sharma
Executive Real Estate Inc.
Buyer's Agent
Himanshu Singh
Singh Realty
List Price
$364,900
Sold Price
$400,000
Premium/Discount to List
$35,100
9.62%
Views
32
Current Estimated Value
$405,190

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$5,190
Avg. Annual Appreciation
1.00%
Original Mortgage
$380,000
Outstanding Balance
$374,691
Interest Rate
5.75%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$30,499

Purchase Details

Listed on
Jul 18, 2017
Closed on
Oct 3, 2017
Sold by
Gupta Ranu and Gupta Mahendra K
Bought by
Munnanoory Kiran
Seller's Agent
Deepak Sharma
Executive Real Estate Inc.
Buyer's Agent
Maryann Doody
Calcagni Real Estate
List Price
$249,900
Sold Price
$241,500
Premium/Discount to List
-$8,400
-3.36%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.61%
Original Mortgage
$174,400
Interest Rate
3.89%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 28, 2015
Sold by
Leonard James D and Leonard Nancy V
Bought by
Gupta Mahendra K and Gupta Ranu

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$146,250
Interest Rate
3.99%

Purchase Details

Closed on
Feb 23, 2012
Sold by
Soupel Angeline B and Beres Joan
Bought by
Leonard James D and Leonard Nancy
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Khichi Shailendra S $400,000 None Available
Khichi Shailendra S $400,000 None Available
Munnanoory Kiran $241,500 --
Munnanoory Kiran $241,500 --
Munnanoory Kiran $241,500 --
Gupta Mahendra K $195,000 --
Gupta Mahendra K $195,000 --
Gupta Mahendra K $195,000 --
Leonard James D -- --
Leonard James D -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Khichi Shailendra S $380,000
Closed Khichi Shailendra S $380,000
Previous Owner Munnanoory Kiran $174,400
Previous Owner Gupta Mahendra K $146,250
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/16/2024 08/16/24 Sold $400,000 +9.6% $175 / Sq Ft
07/23/2024 07/23/24 Pending -- -- --
07/16/2024 07/16/24 For Sale $364,900 +51.1% $159 / Sq Ft
10/02/2017 10/02/17 Sold $241,500 -3.4% $106 / Sq Ft View Prior Sale
09/14/2017 09/14/17 Pending -- -- --
07/18/2017 07/18/17 For Sale $249,900 -- $109 / Sq Ft
Source: SmartMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $6,128 $202,650 $0 $202,650
2024 $5,911 $202,650 $0 $202,650
2023 $5,532 $154,000 $0 $154,000
2022 $5,316 $154,000 $0 $154,000
2021 $5,251 $154,000 $0 $154,000
2020 $5,174 $154,000 $0 $154,000
2019 $5,005 $154,000 $0 $154,000
2018 $4,736 $146,160 $0 $146,160
2017 $4,619 $146,160 $0 $146,160
2016 $4,531 $146,160 $0 $146,160
2015 $4,341 $146,160 $0 $146,160
2014 $4,341 $146,160 $0 $146,160
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24032758

SmartMLS

APN: ROCK-000019-000000-000016-000113