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

607 S First Street
Rosebud, TX 76570

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $925,000
Beds: 5
Baths: 2
Status: Active
SqFt: 2311
Agency: Twin Lakes Ranch Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential
Year Built: --
Notes: Step into a piece of history with the perfect combination of Victorian era architecture and modern amenities. Inside there is plenty of room for any purpose with 5 bedrooms, office and 2 full bathrooms, one with a clawfoot tub! There are a lot of original features, such as the wrap around front and side porches, tall ceilings, 2 fireplaces, operable pocket door and the original hardwood floors. There is a convenient laundry room, large kitchen with built-ins and eat at bar area, which connects to the formal dining area and living area with fireplace. Kitchen area also boasts an original built-in China Cabinet. The home is completely insulated, as well as underneath . There is a new roof, less than a year old and newer central air and heat and an Alarm System. There are Solar Panels with a Generac System to lower utilities.<br /> Included is a metal workshop with foam insulation and an overhang on two sides and two overhead doors so you can drive thru the building. Also an older wooden shop which is great for storage. The property also has a hand dug water well that just needs a pump. It could be used to water the yard.<br /> Step out of the back of the home and you enter a covered bar-b-que, party area, which overlooks the backyard and pond.<br /> The front and side of the home have huge Live Oak Trees. The rest of the yard has Pecan Trees and Crap Myrtle Trees. All of this sits on a pretty 8 acres with City Utilities. Property is just outside of the City Limits.<br /> The property is fenced with black chain link fencing. <br /> Whatever your needs, this gem is primed and ready for your vision!
MlsNumber: 220809


Listing Provided By: Twin Lakes Ranch Realty, original listing
Name: Twin Lakes Ranch Realty
Phone: (254) 803-5276
Office Name: Twin Lakes Ranch Realty
Office Phone: (254) 803-5276
Agent Name: Irene Zapalac
Disclaimer: Copyright © 2024 Waco Association of REALTORS®. 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