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;

Windrose Green By Castlerock Communities 3610 Compass Pointe Ct.
Angleton, TX 77515

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $252,990
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1772 Square Feet
Agency: CR TX Houston
Agency Phone:

Map Details Show Map | Show StreetView




House Features

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

Window Features

Property Condition: New Construction

Neighborhood/Schools

Elementary School/District: Rancho Isabella Elementary School/Angleton ISD
Middle/Junior High School/District: /Angleton ISD
High School/District: Angleton High School/Angleton ISD
Subvidision Name: Windrose Green

Description/Comments


Lot Size: 0 sqft
Property Type: Other-Other
Year Built: --
Notes: With convenience at the forefront, our Aquila floor plan will meet the lifestyle needs of most any family.. Boasting two spacious bedrooms and two full bathrooms, this single-story home is the perfect size for growing families or empty-nesters alike. As soon as you open the door, you are greeted by an elegant entryway that leads to the secondary bedroom with the secondary bathroom just beside it. Keep going, and you will find a secluded study past the two-car garage door entry. If you find yourself needing more storage space in the garage, opt for the larger garage and turn it into a 2.5-car garage. Wanting an extra bedroom? Transform the secluded study into a third bedroom, a craft room, a pet room, or whatever else your heart desires. Across from the private study resides the remote Master Bedroom. The attached Master Bathroom consists of dual vanities/sinks and a huge walk-in closet. Looking to add an extra spark to the master bathroom? Choose to revamp your bathroom with a master luxury bath with a bathtub and separate shower, or a master super shower instead of a bathtub! The opportunities are endless. Down the hallway, tying the space together, is the large family room with nine-foot ceilings, and the welcoming dining area combined with the kitchen. The gorgeous kitchen includes sleek granite countertops, flat-panel countertops, and a wide kitchen island that is perfect for added counter space. You'll love entertaining your guests with the open-concept feel of the kitchen, dining room, and family room! Also, the sizable walk-in pantry will help store all of your essentials and more. Off the dining room, you will find the optional covered patio, which can be extended to fit you and your family's needs - the choice is yours. No matter what - whether you choose to keep your new home how it comes, or if you decide to add any of the options available, you will love living in your CastleRock Home. The Aquila plan is a gorgeous, flexible plan that is sure to please.
MlsNumber: --
ListingId: 1914655


Listing Provided By: CR TX Houston, original listing
Phone: (979) 209-0060
Agent Name: Wandalyn Shanklin
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