Back to Search
Property profile & analytics
OFF-MARKET
Estimated value
$2,155,000
Showrooms
2418 Main St Rocky Hill, CT 06067-2550
Entity Owned
4-yr Hold
~
Est. High Equity
Property ID
US15-0317797
Property summary
AI-generated overview
The Shoppes at Kelson Row, located at 2418 Main St, Rocky Hill, CT 06067, offers 9,400 square feet of Class A retail space in a new building (completed Q4 2024). This prime Downtown Rocky Hill location features three available suites, ideal for retail, restaurant, or medical uses. Individual spaces range from 2,182 to 9,400 contiguous square feet, providing flexibility for various business needs. The building boasts a first-floor layout with ceiling heights up to 16 feet. The property is situated near Garden Street in the vibrant Downtown Rocky Hill submarket, offering excellent visibility and accessibility. This mixed-use development provides a dynamic community environment, attracting both residents and visitors. Lease rates are available upon request. The property is part of a larger development designed to enhance the local landscape and provide a premier shopping and entertainment destination. This is a unique opportunity to establish a presence in a thriving area with high foot traffic and strong community engagement.
Property profile
Verified
Property type
Showrooms
Use group
SHOW ROOM, WAREHOUSE
Year built
1965
Construction
MASONRY/CONCRETE MASONRY UNITS (CMUS)
Total area
225,543 SF
Lot
12.65 ac (551,034 SF)
Zoning code
C
APN
ROCK M:10 L:184
UPID
US15-0317797
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Current use
Occupant on record · Public records
-
Ames Corporate Headquarters Corporate Office
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
$2.03M
CAP Approach
CAP
by Request
Comparable Approach
Comparable
by Request
Blend (final)
Blend
$2.16M
Owner & transaction history
Rocky Hill Gateway LLC · 4 yrs held
Rocky Hill Gateway LLC
since 2022
Last sale
$2.3M
7 recorded transactions
Zoning & alternative use
C · Rocky Hill, CT
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Cap rate
Implied · in-place · derived from last sale + estimated NOI
Implied Cap rate
#1
Implied · in-place · NOI ÷ last sale
In-place · derived from last sale + estimated NOI
Cap rate, NOI & submarket benchmark
Implied cap rate vs Rocky Hill submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Rocky Hill submarket · NOI estimate · typical band, median & reading
Refine your cap rate
8-question underwriting flow
1.
Property current status — Going-In vs Stabilized
2.
Price for denominator — asking / offer / market
3.
Leasing status & lease structure (NNN / Gross)
4.
Tenant risk profile & vacancy assumption
5.
Upload T12 / rent roll / OM (optional)
Refine in 60 seconds, get exact suggested price
T12 upload · Submarket benchmarks · Sensitivity grid
Suggested price · 3 cap rate anchors
Income approach @ 5% / 7% / 9% — aggressive / typical / conservative
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · Implied $/SF per anchor · Sensitivity grid
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · implied $/SF · sensitivity
Value
AI, CAP & Alternative Use estimations · Realmo proprietary blendValue Estimations
Based on Realmo’s proprietary methodology
AI Approach
Method
Estimation
Statistic approach
$2,050,000
ML approach
$2,030,000
CAP Approach
CAP Return
Estimation
6%
by Request
6.5%
by Request
7%
by Request
Blend value · Realmo final
$2.16M
Range $1.94M – $2.37M · ±10% · vs last sale $2.28M (Jun 14 2022)
Last sale anchor
$2.28M
Jun 14 2022
Realmo estimate · informational only.
These numbers are calculated by our models from public records and may not reflect actual market value.
Not an appraisal.
Verify with a licensed appraiser before transacting. Realmo accepts no liability for divergence from real-world outcomes.
View the full estimation — every method, every assumption
Confidence drivers & risk notes · Custom comparable set · Free for first 3 / day
Full estimation methodology
Every method · every assumption · confidence drivers
Price per SF
Sale + rent benchmarks
Subject property
$10 / SF
Submarket sale & rent benchmarks
Median sale $/SF · Asking & closed rent · Submarket vacancy
Submarket sale & rent benchmarks
Median sale $/SF · asking & closed rent · submarket vacancy
Property tax & assessments
Tax year 2023Property tax & assessments
Tax year 2023
Tax billed
$65,119
Tax year 2023
Assessed value
$1,812,880
Assessed 2023
Previous assessed
$1,812,880
+0.0% YoY
Effective rate
3.59%
On assessed value
Assessed land
$1,812,880
Comparables
6 recent transactions · within 1.5 miComparable in this city
6 recent transactions
Comparable in this City
Similar Nearby for Sale
Similar Nearby for Lease
Recent comparable sales
Sale price & price/SF · Sale date & distance · Adjustments & confidence
Recent comparable sales
Sale price & $/SF · sale date & distance · adjustments
Property description
Physical attributes from public recordsBuilding & lot
Public records
Property type
Showrooms
Use group
SHOW ROOM, WAREHOUSE
Status
Off-Market
Year built
1965
Construction
MASONRY/CONCRETE MASONRY UNITS (CMUS)
Heating
FORCED AIR
Cooling
YES
Buildings
1
Stories
4
Units
1
Bathrooms
2
Total area
225,543 SF
Lot
12.65 ac (551,034 SF)
Zoning code
C
APN
ROCK M:10 L:184
UPID
US15-0317797
Jurisdiction
ROCKY HILL
Zoning & alternative use
C · Rocky Hill, CT
Zoning C · permitted uses
C · Rocky Hill, CT
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Rocky Hill. Always verify with local authorities before improvements.
Building & site characteristics
From public records
Year built
1965
Construction
MASONRY/CONCRETE MASONRY UNITS (CMUS)
Heating
FORCED AIR
Cooling
Yes
Stories
4
Buildings
1
Units
1
Bathrooms
2
Lot
12.65 ac
Current owner
From public records · entity-resolved
Rocky Hill Gateway LLC
Entity
Mailing address
2418 MAIN ST STE 1A, ROCKY HILL, CT 06067-2550
Ownership since
2022
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
13 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Dec 28, 2023
—
Rocky Hill Gateway LLC
—
Deed
related
$5,500,000 · Connecticut Housing Finance Authority
Jun 14, 2022
$2,275,000
Rocky Hill Gateway LLC
Mr Rocky LLC
Warranty Deed
$2,275,000 · Bankwell Bank
Oct 20, 2014
—
Mr Rocky LLC
Haven LLC
Quit Claim Deed
related
—
Mar 7, 2001
—
Ames Dept Store INC
—
Deed Of Trust
related
$800,000 · E Capital Corp
Jan 29, 1999
$322,500
Ames Dept Stores
Santilli,ronado
Warranty Deed
—
Jan 22, 1999
$159,000
Ames Dept Store
Dangelo,francis
Warranty Deed
—
Jan 19, 1999
$180,000
Ames Dept Stores
Marchond,robert E
Warranty Deed
—
Jan 6, 1999
—
Ames Dept Store
—
Deed Of Trust
related
$650,000 · Worth Funding INC
Apr 13, 1993
—
Ames Dept Stores INC
—
Deed Of Trust
related
$8,700,000 · Jbi Holding Co
Dec 30, 1992
—
Ames Department Stores
—
Deed Of Trust
related
$839,000,000 · Citibank NA
Dec 29, 1992
—
Ames Dept Stores
—
Deed Of Trust
related
$839,000,000 · Citibank NA
Aug 31, 1992
—
Home Realty
—
Deed Of Trust
related
$180,000 · First National Bank Ct
Nov 18, 1987
$126,000
Ames Dept Stores INC
Unit St Postal Ser
Grant Deed
—
Coming soon
Costs & Benchmarks
Operating expenses, capex projections, utility benchmarks, and submarket comparables — all in one view.
Coming soon
Risks
Flood, climate, environmental, title, and tenant-concentration risk — surfaced with mitigations and source citations.
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
You own 2418 Main St?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
List this address →
Full reports are paid
Unlock the full Property Analytics report
Start free for 7 days — no card required. Full owner contacts, all 4 valuations with methodology, refine flow, comparable adjustments, foot-traffic deep dive, export to PDF / CSV.
