{
"@context": "https://schema.org",
"@graph": [
{
"@type": "RealEstateAgent",
"@id": "https://theshermanteam.nexthomefoundations.com/#realestateagent",
"name": "The Sherman Team",
"alternateName": "The Sherman Team at NextHome Foundations",
"description": "We’re Josh & Bonnie — a mother-son real estate team with 9 years of experience helping people buy and sell homes across Northern Colorado, including Greeley, Weld County, and the surrounding communities. We were both born and raised here, and we’ve built our business around honesty, education, and helping people make confident decisions in every market.",
"url": "https://theshermanteam.nexthomefoundations.com",
"logo": {
"@type": "ImageObject",
"url": "https://theshermanteam.nexthomefoundations.com/wp-content/uploads/sites/215/2024/05/NHF-Logo.png"
},
"image": {
"@type": "ImageObject",
"url": "https://photos.zillowstatic.com/fp/7bbf1db81609b9f891c52db320acdeaf-h_l.jpg"
},
"telephone": "+1-970-301-8239",
"email": "bonniesherman1961@hotmail.com",
"priceRange": "$$",
"address": {
"@type": "PostalAddress",
"streetAddress": "5754 W 11th Street #201",
"addressLocality": "Greeley",
"addressRegion": "CO",
"postalCode": "80634",
"addressCountry": "US"
},
"geo": {
"@type": "GeoCoordinates",
"latitude": 40.112383,
"longitude": -104.519583
},
"hasMap": "https://maps.app.goo.gl/7q8J8t7n2XkYb9hN7",
"areaServed": [
{
"@type": "City",
"name": "Greeley"
},
{
"@type": "City",
"name": "Windsor"
},
{
"@type": "City",
"name": "Eaton"
},
{
"@type": "City",
"name": "Ault"
},
{
"@type": "City",
"name": "Severance"
},
{
"@type": "City",
"name": "Fort Collins"
},
{
"@type": "AdministrativeArea",
"name": "Weld County"
},
{
"@type": "AdministrativeArea",
"name": "Northern Colorado"
}
],
"contactPoint": {
"@type": "ContactPoint",
"telephone": "+1-970-301-8239",
"email": "bonniesherman1961@hotmail.com",
"contactType": "sales",
"areaServed": "US",
"availableLanguage": "English"
},
"parentOrganization": {
"@type": "RealEstateAgent",
"name": "NextHome Foundations",
"url": "https://nexthomefoundations.com",
"address": {
"@type": "PostalAddress",
"streetAddress": "5754 W 11th Street #201",
"addressLocality": "Greeley",
"addressRegion": "CO",
"postalCode": "80634",
"addressCountry": "US"
}
},
"employee": [
{
"@id": "https://theshermanteam.nexthomefoundations.com/#bonnie-sherman"
},
{
"@id": "https://theshermanteam.nexthomefoundations.com/#josh-sherman"
}
],
"sameAs": [
"https://www.facebook.com/shermanteam721",
"https://www.instagram.com/the_sherman_team/",
"https://www.tiktok.com/@teamsherman",
"https://www.youtube.com/@theshermanteamco",
"https://g.co/kgs/8kQFv6",
"https://shorturl.at/Re0Xl",
"https://www.zillow.com/profile/bonniesherman1961",
"https://reach150.com/m/review/105273/nexthome-foundations-real-estate-josh-sherman-greeley-co",
"https://www.nexthome.com/agent/CO/Greeley/Bonnie-Sherman/21542/"
]
},
{
"@type": "Person",
"@id": "https://theshermanteam.nexthomefoundations.com/#bonnie-sherman",
"name": "Bonnie Sherman",
"jobTitle": "Broker Associate",
"description": "Bonnie Sherman is a Broker Associate with The Sherman Team at NextHome Foundations serving Northern Colorado.",
"url": "https://www.nexthome.com/agent/CO/Greeley/Bonnie-Sherman/21542/",
"image": {
"@type": "ImageObject",
"url": "https://photos.zillowstatic.com/fp/7bbf1db81609b9f891c52db320acdeaf-h_l.jpg"
},
"telephone": "+1-970-301-8239",
"email": "bonniesherman1961@hotmail.com",
"worksFor": {
"@id": "https://theshermanteam.nexthomefoundations.com/#realestateagent"
},
"parentOrganization": {
"@type": "RealEstateAgent",
"name": "NextHome Foundations",
"url": "https://nexthomefoundations.com"
},
"knowsLanguage": "English",
"hasCredential": {
"@type": "EducationalOccupationalCredential",
"credentialCategory": "Real Estate License",
"identifier": "FA100027540"
},
"areaServed": [
{
"@type": "City",
"name": "Greeley"
},
{
"@type": "City",
"name": "Windsor"
},
{
"@type": "City",
"name": "Eaton"
},
{
"@type": "City",
"name": "Ault"
},
{
"@type": "City",
"name": "Severance"
},
{
"@type": "City",
"name": "Fort Collins"
},
{
"@type": "AdministrativeArea",
"name": "Weld County"
},
{
"@type": "AdministrativeArea",
"name": "Northern Colorado"
}
],
"sameAs": [
"https://www.facebook.com/theshermanteam",
"https://www.instagram.com/the_sherman_team",
"https://www.tiktok.com/@teamsherman",
"https://www.youtube.com/@theshermanteamco",
"https://www.zillow.com/profile/bonniesherman1961",
"https://www.nexthome.com/agent/CO/Greeley/Bonnie-Sherman/21542/"
]
},
{
"@type": "Person",
"@id": "https://theshermanteam.nexthomefoundations.com/#josh-sherman",
"name": "Josh Sherman",
"jobTitle": "Broker Associate",
"description": "Josh Sherman is a Broker Associate with The Sherman Team at NextHome Foundations serving Northern Colorado.",
"url": "https://theshermanteam.nexthomefoundations.com",
"image": {
"@type": "ImageObject",
"url": "https://photos.zillowstatic.com/fp/7bbf1db81609b9f891c52db320acdeaf-h_l.jpg"
},
"telephone": "+1-970-301-8239",
"worksFor": {
"@id": "https://theshermanteam.nexthomefoundations.com/#realestateagent"
},
"parentOrganization": {
"@type": "RealEstateAgent",
"name": "NextHome Foundations",
"url": "https://nexthomefoundations.com"
},
"knowsLanguage": "English",
"hasCredential": {
"@type": "EducationalOccupationalCredential",
"credentialCategory": "Real Estate License",
"identifier": "FA100074934"
},
"areaServed": [
{
"@type": "City",
"name": "Greeley"
},
{
"@type": "City",
"name": "Windsor"
},
{
"@type": "City",
"name": "Eaton"
},
{
"@type": "City",
"name": "Ault"
},
{
"@type": "City",
"name": "Severance"
},
{
"@type": "City",
"name": "Fort Collins"
},
{
"@type": "AdministrativeArea",
"name": "Weld County"
},
{
"@type": "AdministrativeArea",
"name": "Northern Colorado"
}
],
"sameAs": [
"https://www.facebook.com/shermanteam721",
"https://www.instagram.com/the_sherman_team",
"https://www.tiktok.com/@teamsherman",
"https://www.youtube.com/@theshermanteamco"
]
}
]
}
Open House Sun, Sep 27th 11:00 AM - 02:00 PM - Price Reduction - New Construction - Eco Friendly
Address
24734 E Kettle Ct, Aurora, CO
Property Attributes
MLS# 6237423
Type Single Family
Listing Status
Active
County ARAPAHOE
City Aurora
Area Metro Denver
Neighborhood Guilford Estates
Zip 80016
Style Single Family Residence
Year Built 2025
Taxes $ 5721
Price $ 852,800
Bedrooms 5
Full Bathrooms 4
Half Bathrooms 0
Sqr Footage 3907
Lot Size 0.24 Acres
Data Source:
Information and Real Estate Services (IRES)
Property Description
**Contact builder today about Special Financing for this home when using Builder's preferred lender - terms and conditions apply.** AVAILABLE NOW with private backyard that backs to forested open space in Guilford Estates at Whispering Pines, a new community with only 28 homesites.This brand-new 2,771 square feet, 5 Bedroom, 4 bath home features an oversized 3 car garage with tandem space for additional storage as well as an unfinished full basement on a spacious homesite that backs to open space and is AVAILABLE NOW! This Lennar home comes with a high level of designer finishes and energy-efficient features at no extra cost to you. Beautiful upgrades and finishes throughout including luxury vinyl plank flooring, stainless steel appliances, extended covered deck and more. Close to dining, shopping, entertainment and other amenities.
Elementary School
Middle School
High School
Black Forest Hills Elementary School
Fox Ridge Middle School
Cherokee Trail High School
Price History
7/3/2026
Listed $899,900
7/3/2026
2$889,900
8/31/2026
1$889,800
9/18/2026
1$882,800
9/22/2026
4$852,800
General Features
Living Area
2771
Sewer
Public Sewer
Heating
Forced Air,Electronic Air Filter
Cooling
Central Air
Utilities
Natural Gas Available,Electricity Available,Cable Available
Roof
Composition
Appliances
Dishwasher,Refrigerator,Microwave,Disposal,Fire Alarm
HOA Fee
231
Garage Spaces
3
Association Fee Includes
Trash
Patio/Porch Features
Patio,Deck
Construction Materials
Frame,Composition,Other
Exclusions
N/A
Year Built
2025
Levels
Two
Property Subtype
Single Family Residence
Tax Year
2025
Community Features
Clubhouse,Tennis Court(s),Pool
Assoc Fee Paid Per
Monthly
County
Arapahoe
New Construction
Yes
Property Type
Residential
HOA
Yes
Energy Efficient
Windows,Thermostat
Subdivision Name
Guilford Estates
Full Baths
4
Status
Active
High School
Cherokee Trail
City
Aurora
Association Name
Guilford Estates
High School District
Cherry Creek 5
MLS Area
Metro Denver
Elementary School
Black Forest Hills
Property Attached Y/N
No
Tax Annual Amount
5721
Middle/Junior High School
Fox Ridge
MLS Area Minor
Metro22/SSE
Virtual Tour
https://www.lennar.com/new-homes/colorado/denver/aurora/guilford-estates-at-whispering-pines/the-grand-collection/stonehaven/virtual-tour
Builder Name
Lennar
Standard Status
Active
Expected Active Date
2026-07-03
AttributionContact
robyn.asbury@comcast.net,303-246-7866
Interior Features
Interior Amenities
Eat-in Kitchen,Open Floorplan,Pantry,Walk-In Closet(s),Kitchen Island
Basement
Unfinished,Slab
Fireplace Features
Great Room,One
Above Grade Finished Area
2771
Total Bedrooms
5
LivingAreaSource
Plans
Total Baths
4
Exterior Features
Exterior Amenities
Sprinkler System,Tandem Garage
Fencing
Partial
Parking Features
Attached
Lot Features
Cul-De-Sac,Abuts Public Open Space,Paved,Gutters
Water Source
Public
Lot Size Area
10457
Lot Size Acres
0.24
Waterfront Y/N
No
Builder Model
Stonehaven/ FH
Amenities
Foreclosure
Views
Short Sale
New Construction
Adult 55+
Lease To Own
No HOA Fees
Furnished
Primary On Main
Air Conditioning
Seller Finance
Green
Fixer Upper
Horse
Golf
Fireplace
Deck
Garage
Basement
Pool
Property vs Single Family Average in 80016
Visits
Data Provided by Inside Real Estate®
Listed By
RE/MAX Professionals;
Just change these settings to update the prices across the entire website. If you need help figuring out your numbers our Home Loan Provider is more than happy to help explain things.
setmonths
30 Year
15 Year
setpayment
0% Down
3.5% Down
5% Down
10% Down
15% Down
20% Down
25% Down
30% Down
50% Down
setrate
2.5%
2.75%
3%
3.25%
3.5%
3.75%
4%
4.25%
4.5%
4.75%
5%
5.25%
5.5%
5.75%
6%
6.25%
6.5%
6.75%
Success
We have sent an email to . Check your email and click the link to verify your information and view sold listing data on our website. Thank you.
Note: If you don't see an email in your inbox, check your spam folder.
Sent to wrong email? Click to enter a different email address
Resend the verification email
An account was created for the previously used email. Updating your email here will update that account.