
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$1,750,000
Listing Price4beds
4baths
3,638sqft
78,408sqft lot
342 Mayapple Rd, Stamford, CT 06903
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
A Vintage Jewel Reimagined for Modern Living! Step into the embrace of timeless elegance when you enter this distinguished Colonial tucked away on a lush, landscaped 1.8 acres in coveted N. Stamford. This stunner weaves the sophistication of arched doorways, built-ins, & cozy fireplaces w/contemporary comfort at every turn. The distinguished living room w/fp & French doors is a beautiful space to welcome guests. You will love the impressive one-of-a-kind family room w/huge fp, vaulted ceiling, & french doors. The style continues into the formal dining rm that opens to a space perfect for your barware. You will instantly feel the warmth of the well-appointed eat-in-kitchen equipped w/luxury appliances by GE Monogram, Thermador & double dishwasher drawers by Fisher & Paykel. Upstairs you will find the primary bedroom w/a primary bathroom that will take your breath away! Its like walking into your own personal spa! Both the primary bedroom and primary bathroom are toasty w/radiant floor heating. 3 additional bedrooms and a hall bathroom complete the upper level. The lower level is used as a gym, however, you can make it whatever you love. Vacation at home in the backyard adorned w/multiple patios, mature trees, stunning plantings and lots of privacy. Theres even room for a pool! This gorgeous home offers rare character and presence-a perfect canvas for buyers seeking a home w/personality, space to roam, & room to grow. Welcome to the next chapter in this homes enduring story.
Interior Details
3638
4
4
Has Heating:
Yes
Heating Type:
Forced Air With Air Conditioning
Has Cooling:
Yes
Cooling Type:
N/A
Has Fuel:
Yes
Fuel Type:
Oil
Has Basement:
No
Basement Type:
Partial
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
78408
No
No
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
0
N/A
N/A
N/A
N/A
N/A
N/A
N/A
Construction Details
Colonial
Wood Siding
N/A
Gable
Tile
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2020
$15,040
$211,910
$381,850
--%
$593,760
2019
$15,040
$211,910
$381,850
--%
$593,760
2018
$14,517
$211,910
$381,850
--%
$593,760
2017
$14,743
$221,130
$354,980
--%
$576,110
2016
$14,299
$221,130
$354,980
--%
$576,110
2014
$13,429
$221,130
$354,980
--%
$576,110
2011
$13,060
$221,130
$354,980
--%
$576,110
Average Home Price in 06903
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$1,468,088
$1,468,088
5 Beds
4 Baths
3,677 Sqft
75,359 Lot (sqft)
Sold 10/06/2026
$1,524,078
$1,524,078
4 Beds
3.5 Baths
3,887 Sqft
44,431 Lot (sqft)
Sold 09/29/2026
$1,650,000
$1,650,000
5 Beds
4.5 Baths
3,990 Sqft
84,071 Lot (sqft)
Sold 10/05/2026
$1,750,000
$1,750,000
4 Beds
4 Baths
3,638 Sqft
78,408 Lot (sqft)
Sold 10/05/2026
$1,165,000
$1,165,000
3 Beds
3 Baths
3,500 Sqft
43,560 Lot (sqft)
Sold 09/29/2026




