$794,900
OPEN HOUSE 9/21 $30K PRICE DROP

2318 Terrapin Trail College Station, TX 77845

Estimated payment $4,474/month

Total Views 7,813
5 Beds
3.5 Baths
3,265 Sq Ft
$243 Price per Sq Ft

Highlights

  • Traditional Architecture
  • Cathedral Ceiling
  • Quartz Countertops
  • Forest Ridge Elementary School Rated A
  • Mud Room
  • Walk-In Pantry

About This Home

Step inside and prepare to be wow'd! This brand new construction by Rafter 12 Custom Homes marries timeless sophistication with elegant modern touches. The house features five bedrooms with three of those being downstairs, and three and a half bathrooms. The living room boasts a gorgeous stone fireplace from floor to ceiling that carries into the chef's dream kitchen, showcasing a large island with ample seating and a butler's pantry for all your extra appliances or more food prep space when entertaining. The laundry room runs off the master closet, into the mudroom and to the garage. Large master suite features a raised cathedral ceiling with a custom wood beam and lots of natural sunlight. The bathroom offers pure relaxation with a walk-in shower featuring two dual shower heads and a soaking tub, all behind glass. Not to mention the large closet with his and her built-in drawers. Up the gorgeous, modern stairs, you'll find two additional bedrooms and a full bath with an unfinished extra space that has been floored for additional attic/flex space or can be finished out for another bedroom if needed.
Schedule a showing today!

Listing Agent

Katie Stogner

RE/MAX 2020 License #0698710 Listed on: 12/02/2024

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,866

Year Built

  • Built in 2025

Lot Details

  • 9,831 Sq Ft Lot
  • Wood Fence

Parking

  • 2 Car Attached Garage

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Shingle Roof
  • Stone

Interior Spaces

  • 3,265 Sq Ft Home
  • 2-Story Property
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Mud Room
  • Fire and Smoke Detector

Kitchen

  • Walk-In Pantry
  • Butlers Pantry
  • Gas Range
  • Recirculated Exhaust Fan
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Soaking Tub

Laundry

  • Laundry Room
  • Washer Hookup

Eco-Friendly Details

  • ENERGY STAR Qualified Appliances
  • Energy-Efficient Windows with Low Emissivity
  • Energy-Efficient HVAC
  • Energy-Efficient Lighting

Utilities

  • Central Heating and Cooling System
  • Heating System Uses Gas
  • Tankless Water Heater

Listing and Financial Details

  • Legal Lot and Block 6 / 26
  • Assessor Parcel Number 450497

Community Details

Overview

  • Property has a Home Owners Association
  • Association fees include common area maintenance, management
  • Built by Rafter 12 Custom Homes
  • Greens Prairie Reserve Subdivision
  • On-Site Maintenance

Security

  • Resident Manager or Management On Site

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,866

Year Built

Built in 2025

Lot Details

0

Parking

2

Listing Details

  • Architectural Style: Traditional
  • Directions: From HWY 6 heading south towards Houston, exit William D. Fitch and take a right at the light. Take a left at Arrington Road and then a right into the neighborhood. Continue straight to the round-a-bout and take the second exit towards Oldham Oaks Ave. Right onto Coral River Road and a right on Legendary Drive. Turn left on Terrapin Trail. House will be on the left.
  • Garage Yn: Yes
  • Efficiency: Appliances, HVAC, Lighting, Windows
  • Unit Levels: Two
  • Lot Size Acres: 0.2257
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Subdivision Name: Greens Prairie Reserve
  • Year Built: 2025
  • Special Features: NewHome

Interior Features

  • Accessibility Features: None
  • Appliances: Dishwasher, Disposal, Gas Range, Microwave, Water Heater, ENERGY STAR Qualified Appliances, TanklessWater Heater
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Interior Amenities: High Ceilings, Quartz Counters, Butler's Pantry, Ceiling Fan(s), Kitchen Exhaust Fan, Kitchen Island, Walk-In Pantry
  • Living Area: 3265.0
  • Window Features: Low-Emissivity Windows

Exterior Features

  • Builder Name: Rafter 12 Custom Homes
  • Construction Type: Brick, Stone
  • Fencing: Wood
  • Foundation Details: Slab
  • Roof: Shingle

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2.0
  • Garage Spaces: 2.0
  • Parking Features: Attached, Garage

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Electric
  • Cooling Y N: Yes
  • Heating: Central, Electric, Gas
  • Heating Yn: Yes
  • Laundry Features: Washer Hookup
  • Security: Smoke Detector(s)
  • Sewer: Public Sewer
  • Utilities: Sewer Available, Water Available
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Maintenance Grounds, Management
  • Association Fee Frequency: Annually
  • Association: Yes
  • Senior Community: No

Fee Information

  • Association Fee Includes: Common Area Maintenance, Association Management

Schools

  • Junior High Dist: College Station

Lot Info

  • Lot Size Sq Ft: 9831.0
  • Parcel #: 450497

Tax Info

  • Tax Block: 26
  • Tax Lot: 6

Map

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

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 $2,866 $692,319 $168,897 $523,422
2024 -- $150,414 $150,414 --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/16/2025 07/16/25 Price Changed $794,900 -0.5% $243 / Sq Ft
07/16/2025 07/16/25 Price Changed $799,000 -1.3% $245 / Sq Ft
06/24/2025 06/24/25 Price Changed $809,900 -1.8% $248 / Sq Ft
05/19/2025 05/19/25 For Sale $824,900 0.0% $253 / Sq Ft
05/14/2025 05/14/25 Pending -- -- --
12/02/2024 12/02/24 For Sale $824,900 -- $253 / Sq Ft
Source: Bryan-College Station Regional Multiple Listing Service

Purchase History

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

Mortgage History

Date Status Loan Amount Loan Type
Closed $596,000 Construction
Closed $118,750 Construction
Source: Public Records

Source: Bryan-College Station Regional Multiple Listing Service

MLS Number: 24014888

Bryan-College Station Regional Multiple Listing Service

APN: 450497