Stay tuned for more...
USDAProperties.com is preparing the eligibility details...

 

 

 

$1,499,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
37 Mayapple Rd
Stamford, CT 06903
6 bed 4 bath 4,713 SqFt ($318/SqFt)
1.07 acre lot. Built 1935
Listed 2024-05-10, Taxes $19,245
Ⓧ USDA Ineligible
due to price & location

near Stamford

This historic and elegant English manor

With modern updates, was built in 1935 and designed by famed green architect Frazier Forman Peters. At under 6, 000 sqft, it retains all the charm of the period; 6 fireplaces, slate roof, welcoming foyer w marble floor, fantastic room w/ cathedral beamed ceiling, original hardwood floors, den w/ silk walls and library loft. The strategically designed kitchen has custom oak cabinets w Enkeboll molding, Subzero drawers and fridge, Viking ovens and six burner gas cooktop and Vermont Verde marble countertops. The baronial dining room has a fireplace, leaded windows and wallpaper by Bailey and Griffin! The second floor primary is an oasis w/ fireplace, a private balcony overlooking the pond, His (onyx) and Hers (marble) en-suite baths w/ heated floors, sauna, steam shower, cedar lined closets and air jet tub. There are 3 other big bedrooms and an additional office/den with its own fireplace to complete the second floor. Sitting on over 1 acre, this property blooms w/ pear, dogwood, weeping, cherry trees, & flowers, custom gates, courtyards, waterfall koi pond, wisteria covered patio, IG computerized pool, solar cover, & spa. An attached 1 bedroom guest house over the garage with private entrance is perfect for a nanny or family/friends. It's named the My Fair Lady house as Lerner and Lowe composed the music and lyrics here, so start humming On the Street Where You Live as this home is ideal for family life & entertaining!

Updated plumbing, recessed lighting and electrical, & driveway alarm! Also 2 new central air conditioners, new oil tank, hot H2O tank, & whole house generator!


Presented by Stephen Mele at
Houlihan Lawrence Eastchester.
Listing Agent Photo

Property MLS #24016539 from SMARTMLS

Bedrooms: 6
Bedroom 1 Level: Upper
Bedroom 1 Features: Ceiling Fan, Hardwood Floor

Total Rooms: 10
Den Level: Main
Great Room Level: Main
Office/Study Room Level: Upper
Den Features: Ceiling Fan, Fireplace, Wall/Wall Carpet
Great Room Features: Vaulted Ceiling, Beams, Book Shelves, Fireplace, Hardwood Floor
Office/Study Room Features: Hardwood Floor
Basement Description: Full, Unfinished

Total Bathrooms: 4
Full Bathrooms: 3
1/2 Bathrooms: 1
Primary Bathroom Level: Upper
Primary Bathroom Features: Cedar Closet, Hydro-Tub, Stall Shower, Steam/Sauna, Walk-In Closet, Marble Floor

Auto Garage Door Opener
Central Vacuum
Sauna

Gas Cooktop
Wall Oven
Microwave
Subzero
Dishwasher
Washer
Electric Dryer
Wine Chiller

Cooling Features: Central Air
Heating Features: Heat Fuel Type: Oil, Heat Type: Hot Air
Heating Fuel: Oil
Number of Fireplaces: 6
Water Heaters: Oil, 80 Gallon Tank

Dining Room Features: 9 ft+ Ceilings, Fireplace, Hardwood Floor
Dining Room Level: Main
Kitchen/Dining Combo Features: Bay/Bow Window, Granite Counters, Wet Bar, Wood Stove, Island, Hardwood Floor
Kitchen/Dining Combo Level: Main

Pool Features: Gunite, Heated, Spa, In Ground Pool

Lot Description: Treed, Level Lot, Water View, Open Lot
Lot Size Acres: 1.07
Lot Size Square Feet: 46609

Garage Spaces: 2
Garage Description: Attached Garage

Elementary School: Per Board of Ed
High School: Per Board of Ed

Northeast School is a public elementary school located approximately 3.4 miles away.
directions icon Map directions

Turn Of River School is a public middle school located approximately 5 miles away.
directions icon Map directions

Westhill High School is a public high school located approximately 5.4 miles away.
directions icon Map directions

The Canaan Ridge School is a private elementary school located approximately 1.9 miles away.
directions icon Map directions

Calculated Total Monthly Association Fees: 0

Annual Tax Amount: 22580
Source Listing Status: Active
County: Fairfield
Availability Date: 2024-05-15
Directions: GPS to 37 Mayapple RD but mailbox for house says 1 Mayapple RD
Source Property Type: Single Family For Sale
Source Neighborhood: North Stamford
Zoning: RA1
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$528,090 + $202,840
$730,930
$19,245
2021$528,090 + $202,840
$730,930
$18,982
2020$528,090 + $202,840
$730,930
$18,514
2019$528,090 + $202,840
$730,930
$18,514
2018$528,090 + $202,840
$730,930
$17,871
2017$486,440 + $211,660
$698,100
$17,864
2016$486,440 + $211,660
$698,100
$17,327
2015$486,440 + $211,660
$698,100
$16,852
2013$486,440 + $211,660
$698,100
$15,826
2006$328,720 + $157,990
$486,710
$13,531
2005$328,720 + $157,990
$486,710
$13,579
2004$328,720 + $157,990
$486,710
$12,981
2003$328,720 + $157,990
$486,710
$13,141

Listed 2024-05-10
$1,499,000
SMARTMLS
Listing removed 2023-12-08
$0
SMARTMLS
Listed 2023-07-05
$1,425,000
SMARTMLS
Listing removed 2023-05-05
$0
SMARTMLS
Listing removed 2023-05-05
$0
Greenwich
Listed 2023-03-14
$1,799,000
Greenwich
Listed 2023-03-10
$1,799,000
SMARTMLS
Sold 1988-06-01
$775,000
Public Record

Total Square Feet Living: 4713
Year Built: 1935
Above Grade Finished Area: 4713
Attic: Attic Description: Storage Space, Floored, Access Via Hatch, Attic YN: Y
BelowGradeFinishedArea: 1172
Building Exterior Type: Clapboard, Stone
Construction Materials: Stone
Foundation Details: Block, Concrete
Property Age: 89
House Style: European, Tudor
Total Area Sqft: 5885

Sewer: Septic
Water Source: Private Well
Click Thumbnail Images To View Full Size
unknownhouse_viewhouse_viewunknownyard
house_viewporchporchpoolporch
unknownliving_roomunknownunknownunknown
unknowndining_roomkitchenkitchenkitchen
living_roomunknownunknownbathroombedroom
bedroombathroombathroomunknownliving_room
bathroomunknownbedroombedroomliving_room
bedroomkitchenbathroomlaundry_roomunknown

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.