$2,100,000
$300K PRICE DROP

5009 Trumpeter Swan Dr College Station, TX 77845

Estimated payment $13,455/month

Total Views 3,182
6 Beds
7 Baths
6,439 Sq Ft
$326 Price per Sq Ft

Highlights

  • Media Room
  • In Ground Pool
  • Wooded Lot
  • Pebble Creek Elementary School Rated A
  • Maid or Guest Quarters
  • Traditional Architecture

About This Home

Welcome to the pinnacle of luxury living! This stunning property offers everything you could dream of in a home. The expansive Main House features 5 spacious bedrooms & 4 bathrooms, perfect for family & guests. High-end finishes grace every room, from the elegant formal dining room to the inviting breakfast nook. The gourmet kitchen is perfect for everything from casual meals to grand feasts. This home combines function & luxury with a dedicated office, mudroom, game room, wet bars, Texas attic & built-in storage. Outside, discover two guest houses. Guest House #1 offers a bedroom, bathroom, kitchenette, living room & formal dining area. Guest House #2 is a cozy studio with a walk-in closet, kitchenette & half bath. The outdoor living space is ideal for entertaining with a sparkling pool, hot tub & ample grounds. The oversized driveway provides space for guests, while the 5 car garage includes an air-conditioned gym, half bath & laundry room. This is not just a home, it’s a lifestyle.

Listing Agent

Laura Lea Smith

Coldwell Banker Apex, REALTORS LLC License #0675779 Listed on: 05/21/2025

Coldwell Banker Apex, REALTORS LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $28,907

Year Built

  • Built in 2015

Lot Details

  • 1.39 Acre Lot
  • Wooded Lot

Parking

  • 5 Car Garage

Home Design

  • Traditional Architecture
  • Slab Foundation

Interior Spaces

  • 6,439 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Dry Bar
  • Crown Molding
  • High Ceiling
  • 2 Fireplaces
  • Wood Burning Fireplace
  • Gas Log Fireplace
  • Window Treatments
  • Formal Entry
  • Family Room Off Kitchen
  • Living Room
  • Breakfast Room
  • Dining Room
  • Media Room
  • Home Office
  • Game Room
  • Utility Room
  • Washer Hookup

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Double Oven
  • Electric Oven
  • Gas Cooktop
  • Microwave
  • Ice Maker
  • Dishwasher
  • Kitchen Island
  • Pots and Pans Drawers
  • Self-Closing Cabinet Doors
  • Disposal
  • Pot Filler

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Maid or Guest Quarters
  • Double Vanity
  • Single Vanity
  • Hydromassage or Jetted Bathtub
  • Separate Shower

Home Security

  • Security System Owned
  • Fire and Smoke Detector

Pool

  • In Ground Pool
  • Spa

Schools

  • Southwood Valley Elementary School
  • A & M Consolidated Middle School
  • A & M Consolidated High School

Utilities

  • Central Heating and Cooling System
  • Heating System Uses Gas
  • Septic Tank

Community Details

  • Built by Flagship Custom Homes
  • Bird Pond Estates Ph 1 Subdivision

Home Details

Home Type

Single Family

Est. Annual Taxes

$28,907

Year Built

Built in 2015

Lot Details

0

Parking

5

Listing Details

  • Prop. Type: Farm
  • Building Stories: 2
  • Year Built: 2015
  • Lot Size Acres: 1.39
  • Road Surface Type: Asphalt
  • Subdivision Name: Bird Pond Estates Ph 1
  • Architectural Style: Traditional
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Structure Type: House
  • UniversalParcelId: urn:reso:upi:2.0:US:48041:345326
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Double Oven, Dishwasher, Electric Oven, Gas Cooktop, Disposal, Ice Maker, Microwave, Refrigerator
  • Private Spa: Yes
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Total Bedrooms: 6
  • Fireplace Features: Gas, Gas Log, Wood Burning
  • Fireplaces: 2
  • Fireplace: Yes
  • Flooring: Carpet, Tile, Wood
  • Interior Amenities: Wet Bar, Breakfast Bar, Crown Molding, Dry Bar, Dual Sinks, Double Vanity, Entrance Foyer, High Ceilings, Hot Tub/Spa, Jetted Tub, Kitchen Island, Kitchen/Family Room Combo, Pots & Pan Drawers, Pantry, Pot Filler, Self-closing Cabinet Doors, Separate Shower, Vanity, Walk-In Pantry, Window Treatments
  • Living Area: 6439.0
  • Dining Room Type: Breakfast Room/Nook, Dining Room, Family Room, Game Room, Guest Quarters, Living Room, Media Room, Office, Utility Room
  • Window Features: Window Coverings

Exterior Features

  • Builder Name: Flagship Custom Homes
  • Disclosures: Seller Disclosure
  • Lot Features: Wooded
  • Pool Features: In Ground
  • Pool Private: Yes
  • Foundation Details: Slab

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 5.0
  • Parking Features: Attached, Detached, Garage, Oversized

Utilities

  • Laundry Features: Washer Hookup
  • Security: Prewired, Security System Owned, Smoke Detector(s)
  • Cooling: Central Air, Electric
  • Cooling Y N: Yes
  • Heating: Central, Gas
  • Heating Yn: Yes
  • Sewer: Septic Tank

Schools

  • Elementary School: SOUTHWOOD VALLEY ELEMENTARY SCHOOL
  • Junior High Dist: 153 - College Station
  • High School: A & M CONSOLIDATED HIGH SCHOOL
  • Middle Or Junior School: A & M CONSOLIDATED MIDDLE SCHOOL

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 28907.0

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

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
2025 $30,591 $1,855,579 -- --
2024 $30,591 $1,686,890 -- --
2023 $30,591 $1,533,536 $0 $0
2022 $29,724 $1,394,124 $0 $0
2021 $28,625 $1,267,385 $77,502 $1,189,883
2020 $29,061 $1,279,595 $77,502 $1,202,093
2019 $29,826 $1,262,276 $77,500 $1,184,776
2018 $31,535 $1,373,800 $69,030 $1,304,770
2017 $28,343 $1,204,300 $69,030 $1,135,270
2016 $29,114 $1,237,070 $72,660 $1,164,410
2015 $1,796 $72,660 $72,660 $0
2014 $1,796 $77,500 $77,500 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/02/2025 12/02/25 Price Changed $2,100,000 0.0% $326 / Sq Ft
12/02/2025 12/02/25 For Sale $2,100,000 0.0% $326 / Sq Ft
10/13/2025 10/13/25 For Sale $2,100,000 -4.5% $326 / Sq Ft
10/07/2025 10/07/25 Off Market -- -- --
07/16/2025 07/16/25 Price Changed $2,199,900 -8.3% $342 / Sq Ft
05/21/2025 05/21/25 For Sale $2,399,999 -- $373 / Sq Ft
Source: Houston Association of REALTORS®

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- Lawyers Title Co
Warranty Deed -- Lawyers Title Co
Source: Public Records

Source: Houston Association of REALTORS®

MLS Number: 38156959

Houston Association of REALTORS®

APN: 345326