Title Page Background
HFQUERY 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 = 2654 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2654 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2654 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

518 Bent Oak
Ingram, TX 78025

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $235,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1456
Agency: Home in The Hills Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Other
Year Built: 1985
Notes: Create a world of graceful living all your own, in this amazingly remodeled Palm Harbor home. The current owners have thought of all the details and design touches you will love to come home to. New to market this beautiful property is situated on a large corner lot featuring 3 bedroom and two baths: a two-car garage and ample parking for guests. This home welcomes you with its lovely covered front concrete patio less maintenance and more time to enjoy the breeze, wildlife and views. Step Inside and see the incredible attention to detail and craftsman quality. New all wood laminate flooring throughout, 4" crown in main living areas, paint and designer colors. The spacious light filled living room gives way to a complete kitchen remodel to envy! Contractors extended the kitchen 3', adding solid surface countertops, new cabinets upper and lower, new vent hood, backsplash, refrigerator, dishwasher and range. The new 60/40 sink showcases a lovely window above it, a perfect view of your private retreat in the back yard. Additional improvements include removing all popcorn ceilings, installing decorative beams in living for a touch of old world charm. Many electrical and system updates as well to include: recessed LED can lighting in the living area and kitchen. Replaced entire A/c system with a new 15 seer 4 ton unit (2024,) Reworking the whole house water filter system with 60 gallon tank and installing LED closet lighting and additional LEDS inside storage shed and garage for ease of use anytime. The spacious primary bedroom offers large windows and a walk-in closet. The primary bathroom has also been completely redesigned removing the old corner tub and installing a large walk in shower; thereby extending counterspace and storage. Improvements to this room include new solid surface countertops, new backsplash, cabinets, fixtures lighting and commode. The back yard is an entertainers delight beautifully landscaped, with ample privacy and shade. The raised garden bed and water feature lend to the peaceful enjoyment of this lovey home. So much to love and list come and see for yourself. Ingram Oaks is an adult retirement community for residents over 55. You purchase your home and pay a monthly space fee of $455 which includes trash pick up, use of the club house, pool and a community functions as well as access to the private dock on Ingram lake come and see why so many people are enjoying the adult retirement lifestyle.
MlsNumber: 11287798


Listing Provided By: Home in The Hills Realty, original listing
Name: Home in The Hills Realty
Phone: (830) 377-7309
Office Name: Home in The Hills Realty
Office Phone: (830) 377-7309
Agent Name: Kimberly Spears
Disclaimer: Copyright © 2024 My State MLS. 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