Title Page Background
DEBUG FN args: Array ( [0] => 2156 [1] => [2] => [3] => agent ) BEFORE: Site: 2156 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2156 Igate: njhud LocID: 2156 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2156 AND i.igate IN ('okhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2156 [1] => [2] => [3] => lender ) BEFORE: Site: 2156 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2156 Igate: njhud LocID: 2156 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2156 AND i.igate IN ('okhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2156 [1] => [2] => [3] => other ) BEFORE: Site: 2156 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2156 Igate: njhud LocID: 2156 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2156 AND i.igate IN ('okhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

Fairwater By Castlerock Communities 1319 Pleasant Springs
Montgomery, TX 77316

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $337,990
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2099 Square Feet
Agency: CR TX Houston
Agency Phone:

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Property Condition: New Construction

Neighborhood/Schools

Elementary School/District: Keenan Elementary School/Montgomery ISD
Middle/Junior High School/District: /Montgomery ISD
High School/District: Lake Creek High School/Montgomery ISD
Subvidision Name: Fairwater

Description/Comments


Lot Size: 0 sqft
Property Type: Other-Other
Year Built: --
Notes: The uniquely-designed Hemingway floor plan is ideal for any lifestyle.. Upon entering, the quaint foyer area greets you with your second and third bedrooms, each with walk-in closets, while your walk-in utility room and secondary full bathroom rest just beside the two bedrooms. Also at the front of the home is access to your two-car garage. If you desire more space to hold tools, supplies, or an extra car - opt for a two-and a half car garage or a three-car garage instead! Work from home in peace, or have a space for the kids to finish their homework in your private study room with a convenient powder bathroom residing just outside of the study. Next, the flow of this attractive layout will lead you directly to your spacious kitchen area that completely opens up to your welcoming dining area and family room. The unique floor plan that the Hemingway offers makes this the perfect home for quality time spent with family and friends. No matter the occasion or the gathering size, rest assured no one will miss out on the fun. Add an extra flair to your family room by opting for a stylish fireplace. Your kitchen boasts fabulous included features such as sleek granite countertops, designer light fixtures, birch cabinets, a kitchen island, and an oversized walk-in pantry! For those that love backyard barbecues with friends or neighbors, the Hemingway comes with the option for a spacious covered patio for all your guests to enjoy. When it's time to rest, head over to your secluded master bedroom just beside the family room with three windows that let the abundant natural light shine through. Your master bathroom comes complete with cultured marble countertops with dual vanities, a bathtub and a stand-alone shower. You even have the option of switching out your bathtub and stand-alone shower for a super shower, if you prefer. Explore all of the possibilities! As you can see, the Hemingway's favorable options and exclusive features take this home to the next level.
MlsNumber: --
ListingId: 1778384


Listing Provided By: CR TX Houston, original listing
Phone: (936) 755-5445
Agent Name: Chris Szmyr
Disclaimer: Copyright © 2024 DRB Group (BDX). All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App