Hang on a second...
USDAProperties.com is coming up with an answer for you...

 

 

 

$1,550,000   Price Analysis
USDAProperties Agent Contact Page  Agent Details  share icon     map icon  QR
174 E Hunting Ridge Rd
Stamford, CT 06903
5 bed 5 bath 5,184 SqFt ($298/SqFt)
1.0 acre lot. Built 2006
Listed 2024-04-29, Taxes $22,269
Ⓧ USDA Ineligible
due to price & location

near Stamford

Welcome to The Hampton House'' This North Stamford classic Connecticut house is less than hour from NYC and boasts 5 bedrooms

* Sale Pending *

4.5 baths with 5, 184 square feet but the true show piece is the inviting covered outdoor space that creates an extension of the home for pure relaxation, entertainment and refuge! Dine Alfresco or enjoy a fire, watch the big game with your outdoor TV with infrared heat lamps all while overlooking the large private and green property. This gracious home was constructed from the ground up in 2006 and 2015. Step into your gracious foyer with separate first floor office space, generous family room with wood burning fireplace attached to classic gourmet white kitchen with open floor plan with breakfast nook.

Featuring a pretty Bertazzoni Italian Range, additional double oven, prep sink and farm sink. Multiple sets of french doors lead to the exterior for seamless indoor/outdoor space. Enter into the entertaining space with a built in humidor and wine cellar scullery, to the dining room with a dual sided fire gas fireplace shared the lounge/living room. Retreat upstairs to vaulted ceilings in the primary bedroom with additional gas fireplace, large walk-in closet and ensuite spa bathroom. Four additional large guest rooms 2 of which have en suite bathrooms and a secnd floor laundry room with sink. With a open hallway, acting as a separate wing for added privacy.


Presented by Holly Giordano at
William Pitt Sotheby's International Realty.


Property MLS #24013709 from SMARTMLS

Bedrooms: 5
Primary Bedroom Dimensions: 20 x 17
Bedroom 1 Dimensions: 10 x 14
Bedroom 2 Dimensions: 13 x 11
Bedroom 3 Dimensions: 13 x 11
Bedroom 4 Dimensions: 13 x 11
Primary Bedroom Level: Upper
Bedroom 1 Level: Upper
Bedroom 2 Level: Upper
Bedroom 3 Level: Upper
Bedroom 4 Level: Upper
Primary Bedroom Features: 9 ft+ Ceilings, Vaulted Ceiling, Gas Log Fireplace, Full Bath, Walk-In Closet, Hardwood Floor
Bedroom 1 Features: Full Bath, Walk-In Closet, Hardwood Floor
Bedroom 2 Features: Full Bath, Walk-In Closet, Hardwood Floor
Bedroom 3 Features: Walk-In Closet, Hardwood Floor
Bedroom 4 Features: Walk-In Closet, Hardwood Floor

Total Rooms: 12
Other: 19 x 15, Other: 12 x 15
Family Room Dimensions: 20 x 16
Game/Recreation Room Dimensions: 20 x 27
Living Room Dimensions: 14 x 19
Office/Study Room Dimensions: 12 x 16
Family Room Level: Main
Game/Recreation Room Level: Lower
Living Room Level: Main
Office/Study Room Level: Main
Family Room Features: 9 ft+ Ceilings, Fireplace, Patio/Terrace, Hardwood Floor
Game/Recreation Room Features: Wall/Wall Carpet
Living Room Features: Bay/Bow Window, 9 ft+ Ceilings, Gas Log Fireplace, Hardwood Floor
Office/Study Room Features: 9 ft+ Ceilings, Balcony/Deck, Hardwood Floor
Basement Description: Full, Heated, Storage, Fully Finished, Cooled

Total Bathrooms: 5
Full Bathrooms: 4
1/2 Bathrooms: 1

Audio System
Auto Garage Door Opener
Cable - Pre-wired
Central Vacuum
Open Floor Plan

Gas Cooktop
Oven/Range
Wall Oven
Microwave
Refrigerator
Freezer
Dishwasher
Washer
Dryer
Wine Chiller
Laundry Features: Location: 2 floor 6x9 Room with Sink, Upper Level

Cooling Features: Central Air
Heating Features: Heat Fuel Type: Oil, Heat Type: Hot Air
Heating Fuel: Oil
Number of Fireplaces: 4
Water Heaters: Electric, 50 Gallon Tank

Dining Room Dimensions: 15 x 14
Dining Room Features: 9 ft+ Ceilings, Gas Log Fireplace, French Doors, Patio/Terrace, Hardwood Floor
Dining Room Level: Main
Kitchen/Dining Combo Dimensions: 21 x 26
Kitchen/Dining Combo Features: Remodeled, 9 ft+ Ceilings, Breakfast Nook, Granite Counters, Island, Hardwood Floor
Kitchen/Dining Combo Level: Main

Beach Rights
Water Community

Lot Description: Professionally Landscaped
Lot Size Acres: 1.0
Lot Size Square Feet: 43560

Garage Spaces: 2
Garage Description: Attached Garage

Golf Course
Library
Medical Facilities
Park
Private School(s)
Shopping/Mall
Stables/Riding

Elementary School: Northeast
High School: Westhill

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

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

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

Villa Maria Education Center is a private elementary, middle and high school located approximately 1 miles away.
directions icon Map directions

Calculated Total Monthly Association Fees: 0

Annual Tax Amount: 24827
Source Listing Status: Under Contract
County: Fairfield
Availability Date: 2024-05-01
Directions: Long Ridge Road to Rock Rimmon to East Hunting Ridge Road
Source Property Type: Single Family For Sale
Source Neighborhood: North Stamford
Postal Code Plus 4: 2314
Zoning: RA1
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$652,250 + $193,520
$845,770
$22,269
2021$652,250 + $193,520
$845,770
$21,965
2020$652,250 + $193,520
$845,770
$21,423
2019$652,250 + $193,520
$845,770
$21,423
2018$652,250 + $193,520
$845,770
$20,679
2017$626,140 + $201,940
$828,080
$21,191
2016$626,140 + $201,940
$828,080
$20,553
2015$576,550 + $201,940
$778,490
$18,793
2013$576,550 + $201,940
$778,490
$17,648
2006$101,090 + $157,500
$258,590
$7,189
2005$101,090 + $157,500
$258,590
$7,215
2004$101,090 + $157,500
$258,590
$6,897
2003$95,630 + $157,500
$253,130
$6,835

Listed 2024-04-29
$1,550,000
SMARTMLS
Sold 2021-08-24
$1,417,500
SMARTMLS
Listing removed 2021-08-07
$0
Greenwich
Listed 2021-06-15
$1,435,000
Greenwich
Listing removed 2018-06-28
$1,399,000
SMARTMLS
Listing removed 2018-06-28
$7,200
SMARTMLS
Listed 2018-04-03
$1,399,000
SMARTMLS
Listed for rent 2018-04-03
$7,200
SMARTMLS
Listing removed 2017-05-15
$6,900
Greenwich
Listing removed 2017-05-10
$6,900
SMARTMLS
Price Changed for rent 2017-04-12
$6,900
Greenwich
Price Changed for rent 2017-04-12
$6,900
SMARTMLS
Price Changed for rent 2017-03-23
$7,900
SMARTMLS
Price Changed for rent 2017-03-23
$7,900
Greenwich
Listed for rent 2017-03-22
$8,200
Greenwich
Listed for rent 2017-03-06
$8,200
SMARTMLS
Sold 2007-06-01
$1,760,000
Public Record
Sold 2006-01-30
$728,000
Public Record
Sold 2002-12-17
$592,500
Public Record
Sold 1994-07-15
$307,500
Public Record
Sold 1989-09-01
$330,000
Public Record

Total Square Feet Living: 5184
Year Built: 2006
Above Grade Finished Area: 5184
Attic: Attic Description: Pull-Down Stairs, Attic YN: Y
Building Exterior Type: Shake
Construction Materials: Frame
Foundation Details: Concrete
Property Age: 18
House Style: Colonial
Total Area Sqft: 5184

Sewer: Septic
Water Source: Private Well

Green Energy Efficient: Generator, Programmable Thermostat
Click Thumbnail Images To View Full Size
house_viewhouse_viewunknownliving_roomliving_room
living_roomliving_roomunknownliving_roomkitchen
kitchenkitchenkitchenkitchenkitchen
dining_roomdining_roomkitchenunknowndining_room
dining_roomliving_roomliving_roomliving_roomliving_room
living_roomliving_roombathroombathroomunknown
laundry_roomunknownbathroomunknownunknown
unknownhouse_viewporchunknownunknown

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.