Luxury Home with Guest
5009 Trumpeter Swan Drive College Station, TX 77845
For Sale
$2,199,900
Spacious main house plus two guest houses and premium amenities.
Property Size6,439 SF
Price / SF$341.65
Days on Market430
Property Features for 5009 Trumpeter Swan Drive
General Information
- Standard status
- Active
- Size
- 6,439 SF
Building Details
- Year Built
- 2015
Listing Agency:
COLDWELL BANKER APEX, REALTORS LLC
(979) 218-2315
Listed By:
LAURA LEA SMITH · License #0675779
Source:
Corcoran
Added: May 22, 2025
Changed: Mar 16
Last Checked: Mar 16 at 9:09AM
Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of COLDWELL BANKER APEX, REALTORS LLC
Investment Insights
Based on property information with market context.
This property features a main house with 5 bedrooms and 4 bathrooms, designed with high-end finishes throughout. The main house includes a formal dining room, breakfast nook, gourmet kitchen, dedicated office, mudroom, game room, wet bars, Texas attic, and built-in storage. Additionally, the property includes two guest houses. Guest House #1 offers a bedroom, bathroom, kitchenette, living room, and formal dining area. Guest House #2 is a studio with a walk-in closet, kitchenette, and half bath. The outdoor area is equipped for entertaining, featuring a pool, hot tub, and ample grounds. The property also includes an oversized driveway and a 5-car garage with an air-conditioned gym, half bath, and laundry room. The property size is 6439 square feet.
Key Highlights
- Main house with 5 bedrooms and 4 bathrooms featuring high‑end finishes throughout.
- Two separate guest houses offering additional living space and privacy.
- Outdoor living area with pool and hot tub, perfect for entertaining.
Financial Insights For Apartment 5plus
Simulate Cap Rate and NOI
NOI Build-Up
- Vacancy
- income lost from leasable area expected to sit empty during the year — subtracted from gross rent.
- EGI (Effective Gross Income)
- gross rent minus vacancy losses — the realistic income before paying operating costs.
- OpEx (Operating Expenses)
- recurring costs to operate the property (property tax, insurance, utilities, maintenance, management) — excludes financing and capital improvements.
- NOI (Net Operating Income)
- income a property generates after operating costs but before financing and taxes.
| Component | $ | $/SF |
|---|---|---|
| Gross rent | $118.2k | $18.36 |
| − Vacancy | −$5.9k | −$0.92 |
| EGI | $112.3k | $17.44 |
| − OpEx | −$50.5k | −$7.85 |
| NOI | $61.8k | $9.59 |
6,439 SF · lease $18.36/SF/yr · vacancy 5.00% · expense 45.00%
Alternative Uses
Best Use
Apartment 5plus
$882.4K
$772.1K – $1.03M
NOI $61,770 @ 7.0% cap · market cap 2.81%
Second Best
—
—
no second resolved use
Theoretical Best
Office A
$1.59M
$1.39M – $1.85M
NOI $110,988 @ 7.0% cap · market cap 5.05%
Zoning and permitted uses should be independently verified with local authorities.
Property Analytics
Property Profile
Location Intelligence
Current Use by Public Records
Single family properties
FAQs
What type of property is this?
Single family property - Spacious main house plus two guest houses and premium amenities.
Where is this single family property located?
The property is located at 5009 Trumpeter Swan Drive College Station, TX.
What is the asking price?
The asking price for this property is $2,199,900.
What are key features of this property?
This property features: Main house with **5 bedrooms and 4 bathrooms featuring high‑end finishes throughout.**; Two separate guest houses offering additional living space and privacy.; **Outdoor living area with pool and hot tub, perfect for entertaining.**
