Back on Mkt! Spectacular Executive Home on Golf Course Lot in Cy-Fair ISD. Located in sought after Gated-Keystone Fairway in Stone Gate. Features 4 Bdrms+Study, 3 1/2 Baths, Gameroom & Media Room. Stunning Entryway w/ Dramatic Rotunda Staircase. Soaring Ceilings in Living Rm w/ Wall of Windows for Gorgeous View. Island Kitchen w/ Granite Counters. Master Bath-double sinks, sep shower & tub. 3 Car Garage w/ Auto Iron Gate. Water Softener System. Rezoned to Cy-Ranch HS for 2017-18 school yr.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Permits
Beds
4
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
9,600 Sq. Ft.
Year renovated
2005
Sq. Ft.
4,162
Year built
2005
Style
Single Family Residential
County
Harris County
APN
1231320010006
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 10, 2026.
Jun 9, 2005 • Final
Development
Construct a new single-family home as a standalone structure.
New construction
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking & Garage
Garage: Attached/Detached
Auto Driveway Gate, Auto Garage Door Opener, Driveway Gate, Porte-Cochere
# of Garage Spaces: 3
Interior
Bathroom Information
# of Baths (1/2): 1
# of Baths (Full): 3
Master Bath Features: Double Sinks, Master Bath with Separate Shower, Whirlpool Tub
Bedroom Information
2 Master Bedrooms, Master Bedroom on 1st Floor
Interior Features
Room Count: 13
1 Living Area, Breakfast Room, Formal Dining, Gameroom Up, Media, Study/Library, Utility Room in House
Equipment
Electric Oven
Gas Cooktop
Laundry Information
Laundry Location: Utility Room in House
Washer Connections
Fireplace Information
# of Fireplaces: 1
Gaslog Fireplace
Heating & Cooling Information
Heating System: Central Gas
Cooling System: Central Electric
Other Interior Features
Countertops: Granite
Floors: Carpet, Laminate, Terrazo, Tile
Room 1 Information
Dimensions: 12 x 13
Room Type: Bedroom
Room 2 Information
Dimensions: 12 x 16
Room Type: Bedroom
Room 3 Information
Dimensions: 20 x 14
Room Type: Master Bedroom
Location: 1st Floor
Room 4 Information
Dimensions: 12 x 18
Room Type: Master Bedroom
Room 5 Information
Dimensions: 15 x 18
Room Type: Living Room
Room 6 Information
Dimensions: 17 x 10
Room Type: Media Room
Room 7 Information
Dimensions: 14 x 15
Room Type: Kitchen
Room 8 Information
Dimensions: 13 x 14
Room Type: Dining Room
Features: Formal
Room 9 Information
Dimensions: 20 x 14
Room Type: Game Room
Location: 2nd Floor
Room 10 Information
Dimensions: 9 x 14
Room Type: Breakfast
Room 11 Information
Room Type: Utility
Location: In House
Room 12 Information
Dimensions: 11 x 14
Room Type: Study/Library
Room 13 Information
Room Type: Master Bath
Features: Double Sinks, Master Bath + Separate Shower, Whirlpool/Tub
Exterior
Building Information
Siding: Brick & Wood
Roof: Composition
Foundation: Slab
Defects: No Known Defects
Water & Sewer Information
Public Sewer, Water District
Other Exterior Features
Has Public Pool Area
Exterior: Controlled Subdivision Access, Covered Patio/Deck, Sprinkler System
Property Information
Management Company: Sterling Mgmt
Golf Course: Houston National Golf Club
Master Planned Community
Exemptions: Homestead,,,,,,,,,,,
Full Ownership
Lot Information
Section Num: 17
Legal Lot Description: LT 6 BLK 1 STONE GATE SEC 17
Lot Description: On Golf Course
Financial
Tax Information
Tax ID #: 123-132-001-0006
Tax Amount: $9,102
Tax Year: 2015
Total Tax Rate (%): 2.7583
Financial Information
Financing Available: Cash Sale, Conventional, FHA
Location
Homeowners Association Information
Mandatory HOA
Has Other Fee(s)
Other Fee Amount: $200
Annual Maintenance: Mandatory
Other Mandatory Fee(s): Transfer
Maintenance Fee Amount: $1,100
Maintenance Fee Pay Schedule: Annually
School Information
School District: Cypress-Fairbanks
School Elementary: BIRKES ELEMENTARY SCHOOL
School Middle: SPILLANE MIDDLE SCHOOL
School High: CY-FAIR HIGH SCHOOL
Location Information
Area: Hwy 6 North
Community: Stone Gate
Directions: Take Hwy 290 West, Exit Barker-Cypress and go left, Turn left on Queenstown, Take a right on Houston National Blvd, Go left through gate on Keystone Fairway Dr, right on Opal Ridge Dr, Home is on your Right
MLS Map Page and Grid: 367Y
Public facts
Beds: 4
Baths: 3.5
Sq. Ft.: 4,162
Stories: 2.0
Lot Size: 9,600 square feet
Style: Single Family Residential
Year Built: 2005
Year Renovated: 2005
County: Harris County
APN: 1231320010006
Home facts updated by county records on Sep 9, 2026
Other
Listing Information
Exclusive Right to Sell/Lease
Listing Office & Agent Information
TREC License Number: 0241362
Around this home
Schools
Birkes Elementary School
Public PreK-5 • Assigned • 1.5mi
9/10
Spillane Middle School
Public 6-8 • Assigned • 3.0mi
10/10
Cypress Falls High School
Public 9-12 • Assigned • 2.4mi
5/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
3/10 Flood Factor
Estimated 10-14% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
9/10 Heat Factor
7 days above 110° expected this year, 23 days in 30 years
9/10 Wind Factor
99% chance of strong winds in next 30 years
2/10 Air Factor
2 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Houston, TX • 77095
Average low and high temperatures (°F)
61
43
72
51
80
59
82
65
87
70
91
76
93
76
94
76
92
72
88
66
78
58
69
51
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.4 hours in
June and 4.7 hours in December, which is comparable to the
U.S. average for solar exposure.
9.4 hrs
4.7 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$513,000 – $621,000
Reach more buyers when you sell with Redfin. Save up to $5,397 in fees.3 minutes to get started.