Start of property details
Property Details
Welcome to this remarkable William Gordon custom built 5 bed, 4 full+2 half bath home, centrally located in the desirable Village of WestClay. Beyond the expansive covered front porch and into the foyer that features a barrel ceiling, you'll immediately feel the seamless traditional yet modern design. The front sitting room is a welcome respite to take in views of the beautiful outdoor courtyard that features a heated gunite pool with auto cover, separate jacuzzi, custom landscaping and a freshly painted / sealed patio. Just past the oversized office and updated powder room is the spacious great room with gas fireplace, and newly built-in entertainment center. The open space flows into a chef's kitchen finished with SS appliances, new dishwasher, granite counters, new light fixtures, an oversized center island and premium 6 burner 48" Wolf Range. The double entry butler's pantry is filled with ample storage and a new stackable washer / dryer for added convenience. Enjoy a meal while taking in the views of the pool from the bright window filled dining nook. Hardwood floors span both the main and upper levels and have been refinished with a beautiful modern ebony and ivory stain. At the rear of the house you will find the mudroom with lockers, a 2nd powder bath perfect for pool guests and a spacious 3-car garage complete with new epoxy flooring. Upstairs the Primary Suite features a balcony with Pella slider, a spa like bathroom has separate back to back vanities, a whirlpool tub, large separate shower and custom walk in closet. Bedrooms 2 and 3 are connected by a Jack-n-Jill bathroom, Bedroom 4 has an en suite bathroom. Main laundry room is located upstairs for added convenience. The lower level is ideal for entertaining and is equipped with a theater-ready setup, wired for audio, features new LVP flooring, a 5th bedroom, full bathroom, bar area with sink, and 2 large storage rooms or if built out, a flex space. With over $300K+ of upgrades, this home is truly a treasure!
Property Highlights
Location
Property Details
Building
Community
Local Schools
Interior Features
Bedrooms and Bathrooms
Rooms and Basement
Area and Spaces
Appliances
Interior Features
Heating and Cooling
Building Details
Construction
Materials
Taxes
HOA
Heating, Cooling & Utilities
Utilities
Lot
Exterior Features
Parking
Homeowner's Association
Pool Features
Payment Calculator
Property History
Similar Properties
{"property_id":"in210_21975205","AboveGradeFinishedArea":null,"AccessibilityFeatures":null,"Appliances":"Dishwasher, Dryer, Disposal, Gas Water Heater, Humidifier, Microwave, Gas Oven, Refrigerator, Free-Standing Freezer, Washer, Water Heater, Water Softener Owned","ArchitecturalStyle":"Italianate","AssociationAmenities":"Basketball Court, Fitness Center, Meeting Room, Park, Party Room, Playground, Pool, Tennis Court(s), Trail(s)","AssociationFee":"564.00","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Association Home Owners, Clubhouse, ParkPlayground, Tennis Court(s), Walking Trails","AssociationYN":"1","AttributionContact":"[email protected]","Basement":"Ceiling - 9+ feet, Daylight\/Lookout Windows, Egress Window(s), Storage Space","BasementYN":"1","BathroomsFull":"4","BathroomsHalf":"2","BathroomsOneQuarter":null,"BathroomsThreeQuarter":null,"BelowGradeFinishedArea":"1247","BuilderModel":null,"BuilderName":null,"BuyerOfficeName":null,"CapRate":null,"CityRegion":null,"CommunityFeatures":null,"ComplexName":null,"ConstructionMaterials":"Brick, Cement Siding","Contingency":null,"Cooling":"Central Electric","CountyOrParish":"Hamilton","CoveredSpaces":null,"DevelopmentName":null,"DevelopmentStatus":null,"DirectionFaces":"North","DoorFeatures":null,"Electric":null,"ElementarySchool":null,"Exclusions":null,"ExteriorFeatures":"Balcony, Lighting, Smart Light(s), Smart Lock(s), Tennis Community","Fencing":"Fence Complete, Gate, Wrought Iron","FireplaceFeatures":"Gas Log, Great Room","FireplaceYN":null,"FireplacesTotal":"1","Flooring":null,"FoundationDetails":"Poured Concrete","GarageSpaces":null,"GreenBuildingVerificationType":null,"GreenEnergyEfficient":null,"GreenEnergyGeneration":null,"GreenIndoorAirQuality":null,"GreenLocation":null,"GreenSustainability":null,"GreenWaterConservation":null,"Heating":"Forced Air, Gas","HighSchool":null,"HorseAmenities":"None","HorseYN":null,"Inclusions":null,"IndoorFeatures":null,"InteriorFeatures":"Raised Ceiling(s), Center Island, Entrance Foyer, Paddle Fan, Hardwood Floors, Eat-in Kitchen, Network Ready, Pantry, Programmable Thermostat, Walk-in Closet(s), Window Bay Bow","InternetAddressDisplayYN":null,"LaundryFeatures":"Main Level, Upper Level","Levels":"Two","ListingTerms":null,"LivingArea":null,"LotFeatures":"Curbs, Sidewalks, Street Lights","LotSizeArea":null,"LotSizeSquareFeet":"11761.00","MainLevelBedrooms":"0","MiddleOrJuniorSchool":"Creekside Middle School","Model":null,"NewConstructionYN":"0","NumberOfUnitsTotal":null,"OtherParking":null,"Ownership":null,"ParkingFeatures":"Alley Access, Attached, Concrete, Garage Door Opener, Rear\/Side Entry","ParkingTotal":null,"PatioAndPorchFeatures":"Covered Porch, Deck UP, Open Patio","PoolFeatures":"Heated, In Ground, Outdoor Pool, Pool Cover, Waterfall","PoolYN":null,"PoolPrivateYN":"1","PropertyCondition":"Updated\/Remodeled","PropertySubType":"Single Family Residence","public_remarks":"Welcome to this remarkable William Gordon custom built 5 bed, 4 full+2 half bath home, centrally located in the desirable Village of WestClay. Beyond the expansive covered front porch and into the foyer that features a barrel ceiling, you'll immediately feel the seamless traditional yet modern design. The front sitting room is a welcome respite to take in views of the beautiful outdoor courtyard that features a heated gunite pool w\/auto cover, separate jacuzzi, custom landscaping and a freshly painted\/sealed patio. Just past the oversized office and updated powder room is the spacious great room w\/gas fireplace, and newly built-in entertainment center. The open space flows into a chef's kitchen finished with SS appliances, new dishwasher, granite counters, new light fixtures, an oversized center island and premium 6 burner 48\" Wolf Range. The double entry butler's pantry is filled with ample storage and a new stackable washer\/dryer for added convenience. Enjoy a meal while taking in the views of the pool from the bright window filled dining nook. Hardwood floors span both the main and upper levels and have been refinished with a beautiful modern ebony and ivory stain. At the rear of the house you will find the mudroom with lockers, a 2nd powder bath perfect for pool guests and a spacious 3-car garage complete with new epoxy flooring. Upstairs the Primary Suite features a balcony with Pella slider, a spa like bathroom has separate back to back vanities, a whirlpool tub, large separate shower and custom walk in closet. Bedrooms 2 & 3 are connected by a Jack-n-Jill bathroom, Bedroom 4 has an en suite bathroom. Main laundry room is located upstairs for added convenience. The lower level is ideal for entertaining and is equipped with a theater-ready setup, wired for audio, features new LVP flooring, a 5th bedroom, full bathroom, bar area with sink, and 2 large storage rooms or if built out, a flex space. With over $300K+ of upgrades, this home is truly a treasure!","Roof":null,"RoomsTotal":"11","SchoolDistrict":"Carmel Clay Schools","SecurityFeatures":null,"SeniorCommunityYN":null,"Sewer":null,"SpaFeatures":"Above Ground, Heated","SpaYN":"1","SpecialListingConditions":null,"StandardStatus":null,"StateRegion":null,"Stories":null,"StructureType":null,"TaxAnnualAmount":null,"Utilities":null,"View":null,"ViewYN":"0","VirtualTourURLUnbranded":"https:\/\/real.vision\/2037-stanhope-street?o=u","WalkScore":null,"WaterBodyName":null,"WaterSource":"Municipal\/City","WaterfrontFeatures":null,"WaterfrontYN":"0","WindowFeatures":null,"YearBuilt":"2005","Zoning":null,"ZoningDescription":null,"headline_txt":null,"description_txt":null,"seller_office_id":null,"property_uid":"MBR21975205","listing_status":"active","mls_status":"Active","mls_id":"in210","listing_num":"21975205","acreage":null,"acres":"0.27","address":null,"address_direction":null,"address_flg":"1","address_num":"2037","agent_id":"44487","area":"2910 - Hamilton - Clay","baths_total":"6.00","bedrooms_total":"5","car_spaces":"3","city":"Carmel","coseller_id":null,"coagent_id":null,"days_on_market":"7","finished_sqft_total":"5119","geocode_address":"2037 Stanhope Street","geocode_status":null,"lat":"39.970436","lon":"-86.200801","office_id":"EXPL04","office_name":"eXp Realty, LLC","orig_price":"1450000","photo_count":"89","previous_price":null,"price":"1450000","prop_img":"\/listing\/photos\/in210\/21975205-0.jpeg","property_type":"Residential","sqft_total":"5431","state":"IN","street_type":"Street","street_name":"Stanhope","sub_area":"The Village of Westclay","unit":null,"zip_code":"46032","listing_dt":"2024-04-25","undercontract_dt":null,"openhouse_dt":null,"price_change_dt":null,"seller_id":null,"sold_dt":null,"sold_price":null,"webapi_update_dt":"2024-05-01 19:06:09","update_dt":"2024-05-01 19:10:58","create_dt":"2024-04-25 15:12:44","marketing_headline_txt":null,"use_marketing_description_txt":null,"marketing_description_txt":null,"showcase_layout":null,"mortgage_calculator":null,"property_history":null,"marketing_account_id":null}