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 = 2663 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 = 2663 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 = 2663 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;

3656 Fm 2657
Kempner, TX 76539
Rodney Topper with Topper Real Estate, original listing - (830) 868-4663

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $960,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 4590 Square Feet
Agency: Topper Real Estate
Agency Phone: (830) 868-4663

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Property Type: Farm-Farm
Year Built: 2002
Notes: Whether you are looking for a horse property, a commercial/ income producing endeavor or multi-generational residence- This place has is all. Situated on 27 acres sits a well maintained 2000 sqft 3 bedroom 3 bath main home. The main residence has two master suites including a full handicap accessibly recently renovated bathroom. The kitchen has also been recently renovated. In addition to the 3 bedrooms enjoy the light and bright study or art room. The property also has TWO detached 1 bed/ 1 bath guest homes complete with full kitchens and bathrooms. In addition, the guest homes share a separate shared large laundry room facility. There is also a full RV Hookup space with its own private onsite laundry and FULL bathroom facility. Behind the home sits a large workshop with electric and 18x20 AC / Heat garage space with concrete flooring. The back 25 acres sits at higher elevation making for beautiful views. It is full fenced with a stock pond, two pole barns-one for hay or equipment and one for livestock shelter. There is also an additional water tap on the back 25 acres making future subdivision and development a possibility. The land is a combination of both beautiful open fields with oak groves along with some heavier treed areas on the perimeter adding to the privacy and character. Property is currently Ag Exempt with approximately 200ft of road frontage. Less than 10 minutes to Copperas Cove and 15 minutes to Killeen.
MlsNumber: --
ListingId: 170420


Listing Provided By: Topper Real Estate, original listing
Phone: (830) 385-9658
Office Phone: (830) 868-4663
Agent Name: Rodney Topper
Disclaimer: Copyright © 2024 Highland Lakes Association of Realtors 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