x
Showing 1 of 0
X
Save

249 Hewlett Court
Creve Coeur MO 63141 US

$949,000

Active Under Contract Listing ID 24005943
bed icon
5 bed
bath icon
5.00 Bath (4 Full Bath , 1 Half Bath)
lot icon
Lot: 1.04 Acres
home icon
Single Family Residence

$949,000

Active Under Contract Listing ID 24005943
Save

249 Hewlett Court Nestled on over 1 acre of meticulously landscaped grounds, this magnificent 2-story brick home exudes elegance at every turn offering unparalleled blend of comfort, style, & functionality. 3700 + sq ft. Main level features a spacious & inviting layout, highlighted by a stunning custom kitchen complete w high-end appliances, granite countertops, & a large center island, perfect for entertaining guests or enjoying casual dinners. 5 generously sized bedrms, 4 full & 1 half baths. The primary suite is a true retreat, offering a peaceful sanctuary w its luxurious en-suite, sitting area & walk in closet. LL has a cozy family rm, an additional bedrm, rec area, wet bar & is a walk out. Outdoor enthusiasts will delight in the backyard retreat, complete w a sparkling pool. Lovingly maintained by its original owner, who has spared no expense in ensuring its upkeep & longevity.-inspections available. Upgrades include a new roof, HVAC systems, & professionally finished garage flr.

Collapse all

Property Features

  • Facts
  • Lot Size: 1.04 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 4
  • 1/2 Bathrooms: 1
  • Cooling System: Ceiling Fan(s), Zoned A/C
  • Heating Fuels: Fireplace, Forced Air, Humidifier, Zoned
  • Additional Features
  • Fireplace

School Information

  • School
  • Mason Ridge Elem.(Elementary)
  • Central Middle(MiddleSchool)
  • Parkway Central High(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 949000
  • unparsedaddress: 249 Hewlett Court
  • postalcity: Creve Coeur
  • stateorprovince: MO
  • country: US
  • postalcode: 63141
  • bathroomsfull: 4
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 1.04
  • lotsizeunits: Acres
  • lotsizearea: 1.04
  • livingarea: 3707
  • livingareaunits: Square Feet
  • latitude: 38.650543
  • longitude: -90.458625
  • listagentfullname: Stephanie Connell
  • listagentemail: SConnell@janetmcafee.com
  • listagentkey: 3yd-MARISMO-sconnell
  • listagentmlsid: sconnell
  • listagentpreferredphone: 18889914800
  • listagentofficephone: 18889914800
  • listofficekey: 3yd-MARISMO-MCFE01
  • listofficemlsid: MCFE01
  • disclaimer: Copyright © 2024 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MARISMO
  • yearbuilt: 1976
  • listingcontractdate: 2024-04-11
  • listagenturl: http://www.stephanieconnellstlhomes.com
  • countyorparish: St Louis
  • parcelnumber: 18O-12-0312
  • elementaryschool: Mason Ridge Elem.
  • highschool: Parkway Central High
  • elementaryschooldistrict: Parkway C-2
  • middleorjuniorschooldistrict: Parkway C-2
  • highschooldistrict: Parkway C-2
  • appliances: Dishwasher, Microwave, Oven - Double, Oven - Gas, Range, Refrigerator, Warming Drawer, Washer
  • cooling: Ceiling Fan(s), Zoned A/C
  • constructionmaterials: Brick, Stone
  • heating: Fireplace, Forced Air, Humidifier, Zoned
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 2
  • parkingfeatures: Garage, Garage - Attached, Off Street
  • waterfrontyn: False
  • interiorfeatures: Built-in Bookcases, Center Hall Plan, Some Carpeting, Walk-in Closets, Some Wood Floors, Private Inground Pool, Underground Util
  • architecturalstyle: New Traditional
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Bonus Room, Den, Dining Room, Family Room, Kitchen, Library, Living Room, Office
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -90.458625, 38.650543
  • customfields: {"AlternatePrices":[], "ListPriceCurrencyType":"USD", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/249-Hewlett-Ct_Creve-Coeur_MO_63141_M80287-62055?f=listhub&s=MARISMO&m=24005943&c=rexren", "LeadRoutingEmail":"mikeadkins@janetmcafee.com", "BrokerName":"Janet McAfee Inc.", "ListingTitle":"Residential, Traditional - Creve Coeur, MO", "ListOfficeBrokerMlsId":"884600927", "ListOfficeEmail":"jhorlacher@janetmcafee.com", "ListOfficeAddress1":"9889 Clayton Rd", "ListOfficeAddress2":null, "ListOfficeCity":"Saint Louis", "ListOfficePostalCode":"63124-1603", "ListOfficeStateOrProvince":"MO", "ListOfficeCountry":"US", "BuilderPhone":null, "BuilderFax":null, "BuilderEmail":null, "UnparsedAddress":null, "UnitNumber":null, "City":null, "StateOrProvince":null, "PostalCode":null, "Country":null, "ListBrokerageName":"Janet McAfee Inc.", "ListBrokeragePhone":"1-888-991-4800", "ListBrokerageEmail":"info@janetmcafee.com", "ListBrokerageWebsiteUrl":"http://www.janetmcafee.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MARISMO/c5ababc320d4a9cf0120d4e564f40066/20090424164521298.jpeg", "ListBrokerageUnparsedAddress":"9889 Clayton Road", "ListBrokerageUnitNumber":null, "ListBrokerageCity":"Ladue", "ListBrokerageStateOrProvince":"MO", "ListBrokeragePostalCode":"63124", "ListBrokerageCountry":"US", "RoomCount":13, "GeocodeOptions":null, "MLSModificationTimestamp":"2024-04-15T08:09:34Z", "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseValue":275, "ExpenseFrequency":"Annually"}], "Neighborhoods":[{"Name":"Parkway Central", "Description":null}], "Taxes":[{"TaxYear":"2023", "TaxAnnualAmount":9978, "TaxDescription":null}]}
Listing Changed: 4/15/2024 2:48:17 PM GMT
Source Updated Date: 5/10/2024 6:45:42 AM GMT

Courtesy of: Stephanie Connell, Janet McAfee Inc., SConnell@janetmcafee.com

Copyright © 2024 MARIS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

}