Linna Yuen
Coldwell Banker Realty
(475) 258-8014
51 Total Sales
2 in North Stamford
$915K - $1.4M Price Range
37 Quarry Rd Stamford, CT 06903
North Stamford NeighborhoodEstimated Value: $1,369,317
3
Beds
4
Baths
3,775
Sq Ft
$363/Sq Ft
Est. Value
Highlights
- Concrete Pool
- Open Floorplan
- Attic
- Sub-Zero Refrigerator
- Ranch Style House
- 1 Fireplace
About This Home
As of April 2026Exquisite N Stamford Ranch - A Rare Blend of Elegance & Tranquility. Discover refined living on pristine 1acre oasis in sought-after N Stamford. This meticulously maintained 3-4BR, 4Bath ranch offers an exceptional layout designed for effortless entertaining and serene everyday living. An inviting open floor plan showcases a sunken LR with soaring ceilings and skylights, Plus FR w/bay window & dbl-sided fireplace. The chef's kitchen is a showstopper, featuring a granite island, dbl wall ovens, Sub-Zero refrigerator, 6-burner gas cooktop, & Andersen sliders to a patio w/gorgeous views of backyard & sparkling in-ground pool. The bedroom wing includes a spacious primary suite with dual walk-in closets, luxurious full bath with radiant heat, and pool views. A rare authentic Japanese style Tatami room offers flexible use and tranquility-truly a one-of-a-kind feature. An oversized laundry Rm/pantry, featuring updated full bth w/w-in shower, and attached two-car garage complete the main level. The finished LL expands your living and entertaining space with a newly refreshed rec/play room featuring kitchenette, bar, & blt-ins, plus office & full bth-perfect for guests, hobbies, or a home gym. Impeccably updated w/fresh paint, refinished floors, Toto toilets throughout, generator-ready and city water in street. A rare opportunity to own this special North Stamford gem. Minutes away from Merritt Pkwy, shopping, & everything Stamford & Downtown entertainment district have to offer!
Last Agent to Sell the Property
William Pitt Sotheby's Int'l Brokerage Phone: (203) 253-2613 License #RES.0805744 Listed on: 02/19/2026
Co-Listed By
William Pitt Sotheby's Int'l Brokerage Phone: (203) 253-2613 License #RES.0287320
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 Details
Home Type
- Single Family
Est. Annual Taxes
- $15,124
Year Built
- Built in 1976
Lot Details
- 1 Acre Lot
- Property is zoned RA1
Home Design
- Ranch Style House
- Block Foundation
- Frame Construction
- Asphalt Shingled Roof
- Vertical Siding
Interior Spaces
- Open Floorplan
- Ceiling Fan
- 1 Fireplace
- Home Security System
Kitchen
- Built-In Oven
- Gas Cooktop
- Range Hood
- Sub-Zero Refrigerator
- Dishwasher
- Wine Cooler
Bedrooms and Bathrooms
- 3 Bedrooms
- 4 Full Bathrooms
Laundry
- Laundry Room
- Laundry on main level
- Dryer
- Washer
Attic
- Pull Down Stairs to Attic
- Unfinished Attic
Basement
- Heated Basement
- Basement Fills Entire Space Under The House
- Interior Basement Entry
- Basement Hatchway
- Sump Pump
- Crawl Space
- Basement Storage
Parking
- 2 Car Garage
- Automatic Garage Door Opener
Pool
- Concrete Pool
- In Ground Pool
- Pool Tile
Outdoor Features
- Patio
- Exterior Lighting
- Shed
Schools
- Davenport Ridge Elementary School
- Rippowam Middle School
- Stamford High School
Utilities
- Forced Air Zoned Heating and Cooling System
- Heating System Uses Natural Gas
- Power Generator
- Well
Listing and Financial Details
- Assessor Parcel Number 336106
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Feb 19, 2026
Closed on
Apr 3, 2026
Sold by
Bought by
Seller's Agent
Keiko Martelli
William Pitt Sotheby's Int'l
Buyer's Agent
Sallie Craig
Berkshire Hathaway NE Prop.
List Price
$1,150,000
Sold Price
$1,375,000
Premium/Discount to List
$225,000
19.57%
Views
170
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$5,683
Avg. Annual Appreciation
-1.29%
Purchase Details
Closed on
Oct 17, 2025
Sold by
Bought by
Purchase Details
Closed on
Sep 29, 2014
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in North Stamford, CT
-
Linna Yuen
-
Christopher Reid
Christopher Reid
Coldwell Banker Realty
(475) 265-6047
57 Total Sales
1 in North Stamford
$825,000 Price
-
Susan Janart
Susan Janart
Houlihan Lawrence Inc.
(914) 483-5505
34 Total Sales
5 in North Stamford
$825K - $1.4M Price Range
-
Seamus Costigan
Seamus Costigan
Marr Caruso Realty Group
(475) 258-7673
69 Total Sales
6 in North Stamford
$540K - $951K Price Range
-
Iacovos Spirou
Iacovos Spirou
inSpirou Group
(844) 699-6140
7 Total Sales
1 in North Stamford
$875,000 Price
-
Michael Carey
Michael Carey
Sotheby's International Realty
(475) 234-3788
36 Total Sales
2 in North Stamford
$1.2M - $1.4M Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,375,000 | -- | ||
| -- | -- | ||
| -- | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $100,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 04/08/2026 04/08/26 | Sold | $1,375,000 | +19.6% | $364 / Sq Ft |
| 03/24/2026 03/24/26 | Pending | -- | -- | -- |
| 02/27/2026 02/27/26 | For Sale | $1,150,000 | -- | $305 / Sq Ft |
Source: SmartMLS
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $15,124 | $649,920 | $257,770 | $392,150 |
| 2024 | $14,792 | $649,920 | $257,770 | $392,150 |
| 2023 | $15,897 | $649,920 | $257,770 | $392,150 |
| 2022 | $14,222 | $540,140 | $198,570 | $341,570 |
| 2021 | $14,027 | $540,140 | $198,570 | $341,570 |
| 2020 | $13,682 | $540,140 | $198,570 | $341,570 |
| 2019 | $13,682 | $540,150 | $198,570 | $341,580 |
| 2018 | $13,207 | $540,150 | $198,570 | $341,580 |
| 2017 | $13,227 | $516,870 | $193,520 | $323,350 |
| 2016 | $12,829 | $516,870 | $193,520 | $323,350 |
| 2015 | $12,477 | $516,870 | $193,520 | $323,350 |
| 2014 | $12,048 | $516,870 | $193,520 | $323,350 |
Source: Public Records
Agents Affiliated with this Home
-
Keiko Martelli
Seller's Agent in 2026
Keiko Martelli
William Pitt
(203) 253-2613
9 in this area
19 Total Sales
-
Geri Guzinski
Seller Co-Listing Agent in 2026
Geri Guzinski
William Pitt
(203) 536-2232
24 in this area
83 Total Sales
-
Sallie Craig
Buyer's Agent in 2026
Sallie Craig
Berkshire Hathaway Home Services
(203) 253-0617
3 in this area
41 Total Sales
Map
Source: SmartMLS
MLS Number: 24155308
APN: STAM-000002-000000-006949
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Nearby Homes
- 26 Marva Ln
- 29 Old Logging Rd
- 121 Parry Rd
- 166 Blackwood Ln
- 180 Turn of River Rd Unit 1B
- 180 Turn of River Rd Unit 13A
- 180 Turn of River Rd Unit 10D
- 470 Frogtown Rd Unit Lot 1
- 470 Frogtown Rd Unit Lot 2
- 210 Red Fox Rd
- 32 Arbor Rd
- 19 Skymeadow Dr
- 10 Joan Rd
- 149 Don Bob Rd
- 96 Studio Rd
- 80 Wake Robin Ln
- 48 Driftway Ln
- 95 Intervale Rd Unit 34
- 259 & 253 Frogtown Rd
- 170 Skymeadow Dr
Your Personal Tour Guide
Ask me questions while you tour the home.