NOT LISTED FOR SALE

1509 Red Rose Trail Celina, TX 75009

Estimated Value: $722,000 - $759,000

5 Beds
4 Baths
3,584 Sq Ft
$208/Sq Ft Est. Value

Last Sold March 12, 2020

Current estimated payment $5,099/month

51 Days on Market

Highlights

  • New Construction
  • Vaulted Ceiling
  • Wood Flooring
  • Lorene Rogers Middle School Rated A
  • Traditional Architecture
  • Community Pool

About This Home

As of March 2020

Nestled in picturesque Celina, Lilyana’s convenient location is just 10 miles north of Frisco and the $5 Billion Mile, which includes The Star and Frisco Station. Its proximity to Legacy Business Park and Legacy West makes it a short drive to shopping, dining and numerous sports and entertainment venues. Currently, estimated at 11,000, the City of Celina’s population has nearly doubled since 2010. This pace makes Celina one of the fastest growing cities in the Dallas – Fort Worth Metroplex. Celina is positioned geographically, demographically and economically to quickly become a leader in the North Texas metropolitan community. THIS HOME IS MOVE-IN READY!!

Last Agent to Sell the Property

Wendell Miller

Wendell Miller Realty License #0362134 Listed on: 12/31/2019

Last Buyer's Agent

Tierny Jordan

eXp Realty LLC License #0564785

eXp Realty LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $12,978

Year Built

  • Built in 2019 | New Construction

Lot Details

  • 7,187 Sq Ft Lot
  • Lot Dimensions are 60x120
  • Wood Fence
  • Landscaped
  • Interior Lot
  • Irregular Lot
  • Sprinkler System
  • Few Trees

HOA Fees

  • $58 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Front Facing Garage

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Composition Roof
  • Concrete Siding
  • Stone Siding

Interior Spaces

  • 3,584 Sq Ft Home
  • 2-Story Property
  • Sound System
  • Vaulted Ceiling
  • Ceiling Fan
  • Decorative Lighting
  • Heatilator
  • Gas Log Fireplace
  • Metal Fireplace
  • ENERGY STAR Qualified Windows
  • Window Treatments

Kitchen

  • Double Oven
  • Electric Oven
  • Gas Cooktop
  • Microwave
  • Plumbed For Ice Maker
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • 4 Full Bathrooms

Home Security

  • Burglar Security System
  • Smart Home
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient HVAC
  • Energy-Efficient Insulation
  • Rain or Freeze Sensor
  • Energy-Efficient Thermostat
  • Enhanced Air Filtration

Outdoor Features

  • Covered Patio or Porch
  • Rain Gutters

Schools

  • Cynthia A Cockrell Elementary School
  • Lorene Rogers Middle School
  • Prosper High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Vented Exhaust Fan
  • Heating System Uses Natural Gas
  • Cable TV Available

Listing and Financial Details

  • Legal Lot and Block 5 / D
  • Assessor Parcel Number R-11220-00B-0100-1

Community Details

Overview

  • Association fees include full use of facilities, maintenance structure, management fees
  • First Residential Svc HOA, Phone Number (214) 451-5405
  • Lilyana 60'S Subdivision
  • Mandatory home owners association
  • Greenbelt

Recreation

  • Community Pool
  • Park
  • Jogging Path

Home Details

Home Type

Single Family

Est. Annual Taxes

$12,978

Year Built

Built in 2019 | New Construction

Lot Details

0

HOA Fees

$58 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structural Style: Single Detached
  • Unit Levels: Two
  • Security: Burglar, Carbon Monoxide Detector(s), Security System, Smoke Detector(s)
  • Year Built Details: New Construction - Complete
  • Multi Parcel I D Y N: No
  • Municipal Utility District Y N: No
  • Will Subdivide: No
  • Accessibility Features Yn: No
  • Ratio Current Price By Building: 115.79241
  • Special Features: None
  • Year Built: 2019

Interior Features

  • Square Footage: 3584.00
  • Windows: Window Coverings
  • Fireplace Features: Gas Logs, Gas Starter, Heatilator, Metal
  • Interior Amenities: Cable TV Available, Decorative Lighting, Smart Home System, Sound System Wiring, Vaulted Ceiling(s)
  • Flooring: Carpet, Ceramic Tile, Wood
  • Appliances: Dishwasher, Disposal, Double Oven, Electric Oven, Gas Cooktop, Microwave, Plumbed for Ice Maker, Vented Exhaust Fan
  • Fireplaces: 1
  • Number Of Dining Areas: 2
  • Number Of Living Areas: 3
  • Room Count: 12

Beds/Baths

  • Full Bathrooms: 4
  • Total Bedrooms: 5

Exterior Features

  • Pool: No
  • Foundation: Slab
  • Community Features: Community Pool, Greenbelt, Jogging Path/Bike Path, Other, Park
  • Fencing: Wood
  • Roof: Composition
  • Soil Type: Unknown
  • Construction Materials: Brick, Concrete, Fiber Cement, Rock/Stone
  • Exterior Features: Covered Patio/Porch, Rain Gutters
  • Patio And Porch Features: Covered

Garage/Parking

  • Cooling System: Ceiling Fan(s), Central Air, Electric, Zoned
  • Garage Spaces: 2
  • Total Covered Spaces: 2
  • Parking Features: Garage Faces Front
  • Attached Garage YN: Yes
  • GarageYN: Yes

Utilities

  • Heating: Central, Natural Gas, Zoned
  • Utilities: City Sewer, City Water, Concrete, Curbs, Sidewalk

Condo/Co-op/Association

  • HOA Fee Includes: Full Use of Facilities, Maintenance Structure, Management Fees
  • Association Fee: 700
  • Association Fee Frequency: Annually
  • Association Type: Mandatory
  • Hoa Management Company: First Residential Svc
  • HOA Management Company: 214-451-5405

Schools

  • School District: Prosper ISD
  • Elementary School: Cynthia A Cockrell
  • Middle School: Lorene Rogers
  • High School: Prosper
  • School District: Prosper ISD
  • Elementary School: Cynthia A Cockrell
  • High School: Prosper

Lot Info

  • PropertyAttachedYN: No
  • Lot Size: Less Than .5 Acre (not Zero)
  • Lot Features: Few Trees, Interior Lot, Irregular Lot, Landscaped, Sprinkler System, Subdivision
  • Lot Size Units: Acres
  • Lot Size Area: 0.1650
  • Lot Size: 60x120
  • Parcel Number: R-11220-00B-0100-1
  • Lot Size Acres: 0.1650
  • Lot Size Sq Ft: 7187.4000

Green Features

  • Efficiency: Appliances, Enhanced Air Filtration, ET Irrigation Control, HVAC, Insulation, Rain / Freeze Sensors, Thermostat, Windows
  • Energy Saving Features: High Efficiency Water Heater
  • Smart Home Features Appor Pass Y: Yes
  • Green Verification Count: 2

Building Info

  • Year Built: 2019

Tax Info

  • TaxBlock: D
  • Tax Lot: 5

MLS Schools

  • MiddleOrJuniorSchool: Lorene Rogers
  • Middle School Name: Lorene Rogers
  • Elementary School Name: Cynthia A Cockrell
  • High School Name: Prosper

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 31, 2019
Closed on
Mar 12, 2020
Sold by
Lennar Homes Of Texas Sales And Mktg Ltd
Bought by
Williams Shawn Berkley and Williams Veronica Renee
Seller's Agent
Wendell Miller
Wendell Miller Realty
Buyer's Agent
Tierny Jordan
eXp Realty LLC
List Price
$434,527
Current Estimated Value
$726,579

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.67%
Original Mortgage
$407,483
Outstanding Balance
$364,096
Interest Rate
3.4%
Mortgage Type
FHA
Estimated Equity
$353,133
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Williams Shawn Berkley -- Cal
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Williams Shawn Berkley $407,483
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/12/2020 03/12/20 Sold -- -- --
02/20/2020 02/20/20 Pending -- -- --
12/31/2019 12/31/19 For Sale $434,527 -- $121 / Sq Ft
Source: North Texas Real Estate Information Systems (NTREIS)

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2023 $12,978 $566,282 $160,000 $555,904
2022 $11,899 $514,802 $130,000 $516,392
2021 $11,020 $468,002 $95,000 $373,002
2019 $2,010 $78,000 $78,000 $0
2018 $2,044 $79,000 $79,000 $0
2017 $1,475 $57,000 $57,000 $0
Source: Public Records

Agents Affiliated with this Home

  • W

    Seller's Agent in 2020

    Wendell Miller

    Wendell Miller Realty

  • T

    Buyer's Agent in 2020

    Tierny Jordan

    eXp Realty LLC

    (214) 414-2811

    1 in this area

    140 Total Sales

    Section Image
See All Agents

Map

Source: North Texas Real Estate Information Systems (NTREIS)

MLS Number: 14251216

North Texas Real Estate Information Systems (NTREIS)

APN: R-11220-00B-0100-1

Texas Collin County Celina 75009

1509 Red Rose Trail, Celina, TX

This home is located at 1509 Red Rose Trail, Celina, TX 75009 since 31 December 2019 and is currently estimated at $744,199, approximately $207 per square foot. This property was built in 2019. 1509 Red Rose Trail is a home located in Collin County with nearby schools including Lorene Rogers Middle School and Whispering Farms Montessori Academy.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

North Texas Real Estate Information Systems (NTREIS) Listing information provided in part by the North Texas Real Estate Information Systems, Inc, for personal, non-commercial use by viewers of this site and may not be reproduced or redistributed. All information is deemed reliable but not guaranteed. Copyright © NTREIS 2025. All rights reserved

Nearby Homes