Step into your own resort-style oasis! This backyard retreat is just the start, designed for year-round enjoyment! Relax in the sparkling pool and spa with water feature, unwind by the fire pit, or entertain at the bar and covered patio. The beautifully manicured landscaping and lush turf create a truly stunning outdoor experience. No detail was overlooked in updating this 3-bedroom, 3-bath, home, from the spa-inspired master bath and hand-scraped wood floors to the iron spindles, upgraded appliances and striking stone façade. Dynamic floor plan is complete with a private study and game room. Living in Light Farms feels like a vacation in itself! You'll enjoy: front yard maintenance included, a modern fitness center, courts for basketball, volleyball, tennis, and pickle ball, a refreshing community pool, scenic trails for walking and biking, and a vibrant lineup of community sponsored events. Embrace everyday luxury living!
Sold
Price Unknown
405 Forefront Ave, Celina, TX 75009
3beds
2,711sqft
Single Family Residence
Built in 2017
8,015.04 Square Feet Lot
$589,800 Zestimate®
$--/sqft
$3,689 Estimated rent
Home value
$589,800
$554,000 - $625,000
$3,689/mo
Zestimate® history
Owner options
List your home for rent
$3,689/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,689/mo
Rent Zestimate®
Refinance and save
$125/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$125/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Hand-scraped wood floorsPrivate studyGame roomLush turfBar and covered patioIron spindlesBeautifully manicured landscaping
Zillow last checked:
Listing updated:
Listed by:
Treci Torbett 0621464 214-280-7780,
Fathom Realty, LLC 888-455-6040,
Todd Engels 0682285 214-930-8350,
Fathom Realty
Bought with:
Aimee Hendrix
EXP REALTY
Source: NTREIS,MLS#: 20724797
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Dual Sinks, Walk-In Closet(s)
- Level: First
- Dimensions: 17 x 15
Bedroom
- Features: Ceiling Fan(s), Walk-In Closet(s)
- Level: First
- Dimensions: 13 x 12
Bedroom
- Features: Ceiling Fan(s), Walk-In Closet(s)
- Dimensions: 12 x 12
Dining room
- Level: First
- Dimensions: 17 x 11
Game room
- Level: Second
- Dimensions: 16 x 18
Kitchen
- Features: Breakfast Bar, Built-in Features, Eat-in Kitchen, Granite Counters, Kitchen Island, Walk-In Pantry
- Level: First
- Dimensions: 15 x 17
Living room
- Level: First
- Dimensions: 16 x 17
Office
- Level: First
- Dimensions: 20 x 11
Utility room
- Features: Utility Room
- Level: First
- Dimensions: 11 x 6
Heating
- Central, Fireplace(s)
Cooling
- Central Air, Ceiling Fan(s), Electric
Appliances
- Included: Some Gas Appliances, Dishwasher, Electric Oven, Gas Cooktop, Disposal, Gas Water Heater, Microwave, Plumbed For Gas
- Laundry: Washer Hookup, Electric Dryer Hookup, Laundry in Utility Room
Features
- Decorative/Designer Lighting Fixtures, Eat-in Kitchen, Granite Counters, High Speed Internet, Kitchen Island, Open Floorplan, Cable TV, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Ceramic Tile, Wood
- Windows: Shutters, Window Coverings
- Has basement: No
- Number of fireplaces: 2
- Fireplace features: Electric, Family Room, Gas Log, Outside, Wood Burning
Interior area
- Total interior livable area: 2,711 sqft
Property
Parking
- Total spaces: 2
- Parking features: Covered, Door-Single, Driveway, Garage Faces Front, Garage, Garage Door Opener, Inside Entrance, Lighted, On Site
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Front Porch, Patio
- Exterior features: Fire Pit
- Pool features: Cabana, Gunite, Heated, In Ground, Outdoor Pool, Pool, Pool Sweep, Pool/Spa Combo, Water Feature, Community
- Fencing: Stone,Wood
Lot
- Size: 8,015 sqft
- Features: Back Yard, Interior Lot, Lawn, Subdivision, Sprinkler System, Few Trees
Details
- Additional structures: Cabana
- Parcel number: R1115000G00701
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional,Detached
- Property subtype: Single Family Residence
Materials
- Foundation: Slab
- Roof: Shingle
Condition
- Year built: 2017
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Available, Natural Gas Available, Sewer Available, Separate Meters, Water Available, Cable Available
Green energy
- Energy efficient items: Appliances, HVAC, Insulation, Rain/Freeze Sensors
Community & neighborhood
Security
- Security features: Prewired, Security System, Fire Alarm, Smoke Detector(s), Wireless
Community
- Community features: Clubhouse, Fitness Center, Fishing, Fenced Yard, Other, Playground, Park, Pool, Restaurant, Tennis Court(s), Trails/Paths, Community Mailbox, Curbs, Sidewalks
Location
- Region: Celina
- Subdivision: Light Farms The Sage Neighborhood Ph 2
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $125 monthly
- Amenities included: Maintenance Front Yard
- Services included: All Facilities, Association Management, Maintenance Grounds
- Association name: Light Farms Community Association
- Association phone: 214-292-3484
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan
Price history
| Date | Event | Price |
|---|---|---|
| 6/23/2025 | Sold | -- |
Source: NTREIS #20724797 Report a problem | ||
| 5/27/2025 | Pending sale | $639,900$236/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 5/19/2025 | Contingent | $639,900$236/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 5/16/2025 | Price change | $639,900-1.5%$236/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 5/9/2025 | Price change | $649,900-0.8%$240/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 5/2/2025 | Price change | $654,900-0.8%$242/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 4/25/2025 | Price change | $659,900-0.6%$243/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 4/16/2025 | Price change | $664,000-0.7%$245/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 4/11/2025 | Price change | $669,000-1.5%$247/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 4/3/2025 | Price change | $679,000-0.1%$250/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 3/21/2025 | Price change | $680,000-0.3%$251/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 3/12/2025 | Price change | $682,000-1.4%$252/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 3/6/2025 | Price change | $692,000-0.3%$255/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 2/28/2025 | Price change | $694,000-0.1%$256/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 2/14/2025 | Price change | $695,000-0.6%$256/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 2/7/2025 | Price change | $699,000-0.1%$258/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 1/22/2025 | Price change | $699,900-2.8%$258/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 1/16/2025 | Price change | $719,900-0.7%$266/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 12/5/2024 | Price change | $724,900-1.4%$267/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 10/25/2024 | Price change | $734,900-0.7%$271/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 10/10/2024 | Price change | $739,900-0.5%$273/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 10/4/2024 | Price change | $743,900-0.3%$274/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 9/30/2024 | Listed for sale | $745,900$275/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 9/21/2024 | Listing removed | $745,900$275/sqft |
Source: NTREIS #20724797 Report a problem | ||
| 9/13/2024 | Listed for sale | $745,900$275/sqft |
Source: NTREIS #20724797 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $6,441 +1.5% | $573,289 +10% |
| 2024 | $6,344 +12.4% | $521,172 +10% |
| 2023 | $5,645 -14.4% | $473,793 +10% |
| 2022 | $6,598 +12.4% | $430,721 +17.4% |
| 2021 | $5,870 -1.9% | $366,753 +0.2% |
| 2020 | $5,984 -12.3% | $366,047 -2.1% |
| 2019 | $6,823 -6% | $373,938 -0.4% |
| 2018 | $7,257 | $375,607 +364.6% |
| 2017 | -- | $80,850 |
Find assessor info on the county website
Neighborhood: 75009
Nearby schools
GreatSchools rating
- 8/10Light Farms Elementary SchoolGrades: PK-5Distance: 0.7 mi
- 9/10Reynolds Middle SchoolGrades: 6-8Distance: 1.9 mi
- 7/10Prosper High SchoolGrades: 9-12Distance: 0.9 mi
Schools provided by the listing agent
- Elementary: Light Farms
- Middle: Reynolds
- High: Prosper
- District: Prosper ISD
Source: NTREIS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$589,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$589,800
- Texas
- Collin County
- Celina
- 75009
- 405 Forefront Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Celina Topics
