Title Page Background
DEBUG FN args: Array ( [0] => 2702 [1] => [2] => [3] => agent ) BEFORE: Site: 2702 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2702 Igate: njhud LocID: 2702 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 = 2702 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2702 [1] => [2] => [3] => lender ) BEFORE: Site: 2702 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2702 Igate: njhud LocID: 2702 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 = 2702 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2702 [1] => [2] => [3] => other ) BEFORE: Site: 2702 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2702 Igate: njhud LocID: 2702 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 = 2702 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

9005 Jewel Dr.
Orange, TX 77630

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $430,000
Beds: 3
Baths:
Status: Active
SqFt: 2400 Square Feet
Agency: CB&A, REALTORS -- 9001502

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer
Architectural Style: Other
Construction Materials: Brick, Vinyl Siding, Brick Veneer
Heating: Central Furnace, Fireplace
Interior Features: Dishwasher, Refrigerator, Microwave, Inside Utility Room, Garbage Disposal, Quartz, Convection Oven
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Kitchen, Living Room

Window Features

Exterior Features: Double Pane Windows, Workshop, Pond(s)
Parking Features: Carport
Other Features: Workshop
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Terry Estate

Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Located in Terry Estates, this stunning 3 bedroom, 2.5 bath home is on a sprawling 2.43 acres in Orangefield ISD! The living room has amazing natural lighting with 20ft ceilings and a cozy fireplace. In the kitchen, you will find quartz countertops, an adorable coffee nook, stainless appliances, a large island for cooking and entertaining and a built-in storage bench that doubles as seating in the breakfast area. Filled with special details like custom made barn doors, shiplap and extra hidden storage, this home was well thought out! The master suite has a freestanding soaker tub with a beautifully tiled large shower and custom-made vanity with double sinks. Upstairs past the wooden beaded chandelier, you will find two large bedrooms sharing a jack & jill bathroom with a balcony overlooking the living area. The connecting lot has plenty of room for a shop or pool! Flood insurance is transferable at only $1,500 per year and is paid until Sept 2024.
MlsNumber: --


Listing Provided By: CB&A, REALTORS -- 9001502, original listing
Phone: (832) 678-4770
Office Phone: (832) 678-4770
Agent Name: LAUREN HALLMARK
Disclaimer: Copyright © 2024 Beaumont Board - Southeast Texas MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => orange [3] => TX [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: orange State: TX Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: orange State: TX 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 = 2702 AND i.igate IN ('txhud','usahud','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 = 'txhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Tim Williams
ASCIIKeller Williams Realty - The Tim Williams Realty Group
Call Today!: (409) 460-3777

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App