<%@ include file="/WEB-INF/jsp/main_include.jspf" %> Travis Northeast Rental Homes | Vacation Rentals | Homes For Rent | Houses for rent | For Rent By Owner Travis Northeast Texas | FRBO <% int city_id = 0; int region_id = 0; double lat = 30.42912 ; double lng = -97.607537 ; String city_name = "Travis Northeast"; String region_name = "Texas"; String country_name2 = "United States"; String desc = ""; String picture = ""; int map_size = 380; int text_height = 30; if(picture!=null || desc!=null){ map_size = 320; text_height = 170; } %>
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria. All properties meeting criteria are shown automatically.

">
Bedrooms: to
Bathrooms: to
Availability:
to

Properties in <%=city_name%>

<%@ include file="/WEB-INF/jsp/radius_function.jsp" %> <% Connection con = null; try { // lat and lng definition are on file city_scriptlet.jspf double[] cords = getRadiusCords(60, lat, lng); Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007"); String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3]; PreparedStatement Ps = con.prepareStatement(query); //Ps.setInt(1,city_id); ResultSet Rs = Ps.executeQuery(); while(Rs.next()) { long property_id = Rs.getLong("property_id"); int country_id = Rs.getInt("country_id"); double latitude = Rs.getDouble("latitude"); double longitude = Rs.getDouble("longitude"); String address = Rs.getString("address"); String country_name = Rs.getString("country_name"); String city_name2 = Rs.getString("city"); int city_id2 = Rs.getInt("city_id"); int bedrooms = Rs.getInt("bedrooms"); int bathrooms = Rs.getInt("bathrooms"); int sqft = Rs.getInt("sqft"); String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?"; PreparedStatement Ps2 = con.prepareStatement(query2); Ps2.setLong(1, property_id); ResultSet Rs2 = Ps2.executeQuery(); %> <% Rs2.close(); Ps2.close(); } Rs.close(); Ps.close(); con.close(); con = null; } catch(Exception e) {out.print(e.toString()); out.print(e.getMessage()); } finally { if(con!=null) { con.close(); con = null; } } %>
Property ID Address City Bedrooms Bathrooms Square feet
#<%=property_id%> <%=address%> <%=city_name2%> <%=bedrooms%> <%=bathrooms%> <%=sqft%>
           
<%@ include file="../WEB-INF/jsp/footer.jspf" %>


Texas Rental Links

Pleasanton Texas homes for rent and rental apartment in Pleasanton Texas
Kingsville Texas rental houses, holiday rentals Kingsville Texas, and homes for rent Kingsville Texas
Weatherford Texas rental homes, rental homes Weatherford Texas, Weatherford Texas rental homes, and vacation homes for rent by owner in Weatherford Texas
For rent by owner homes in Lockhart Texas and Lockhart vacation homes for rent by owner
Rental home in Copperas Cove Texas, Copperas Cove vacation homes, and homes for rent in Copperas Cove
Vacation rentals in Fort Hood, Fort Hood Texas bed and breakfast rentals, Fort Hood condos for rent, and rental properties in Fort Hood Texas
Beeville rental properties and apartment rentals
East Jefferson vacation homes for rent by owner, rental apartment in East Jefferson Texas, and for rent by owner homes East Jefferson Texas
Lufkin Texas home rentals, Lufkin Texas vacation rentals, rent houses Lufkin Texas, and homes for rent in Lufkin Texas
Home rentals Decatur and condos for rent in Decatur Texas
Rental apartment Edcouch-Elsa Texas, homes for rent Edcouch-Elsa, and vacation homes
Homes for rent in Amarillo Texas, condo rentals Amarillo Texas, rental properties Amarillo Texas, and Amarillo Texas house rentals
Vacation rentals and Marble Falls Texas rental apartment
Homes for rent, rental homes in Bruni-Mirando, and rental houses in Bruni-Mirando Texas
Real estate rentals in Gilmer, Gilmer rental homes, Gilmer Texas houses for rent, and Gilmer Texas for rent by owner homes
Weatherford Southeast Texas condos for rent and bed and breakfast rentals in Weatherford Southeast Texas
Granbury East Texas vacation rental, apartments for rent in Granbury East Texas, and apartments for rent in Granbury East Texas
Real estate rentals Weatherford Northwest Texas, rent houses Weatherford Northwest Texas, Weatherford Northwest Texas apartments for rent, and Weatherford Northwest Texas homes for rent by owner
Rent house and Big Spring rental home
Bed and breakfast rentals Kaufman, condos for rent in Kaufman, and real estate rentals Kaufman Texas
Beaumont condos for rent, Beaumont vacation homes for rent by owner, home rentals in Beaumont Texas, and Beaumont Texas houses for rent
Temple real estate rentals and Temple Texas apartments for rent
Homes for rent, apartment rentals, and real estate rentals in Wharton
For rent by owner homes Sweetwater Texas, apartments for rent in Sweetwater Texas, vacation homes for rent by owner in Sweetwater Texas, and vacation homes Sweetwater Texas
Houses for rent Dumas and vacation homes for rent by owner Dumas
Bed and breakfast rentals in Castroville-LaCoste, rent house Castroville-LaCoste Texas, and holiday rentals in Castroville-LaCoste Texas


The Travis Northeast Texas hillside lists of marked properties, loft listings, spacious classifieds, and romantic online MLS for these can be mapped. We forged and shaped our site, FRBO.com to be ideal, enticing, and handsome. Hear, identify, and espy real estate rentals Erath Texas, holiday rentals Erath Texas, and rental properties in Erath Texas.

Our site, FRBO.com does enclose special lake, rustic, ski in/out, and city timeshare, house, and lodges. Dumas Texas apartments for rent, Dumas for rent by owner homes, Dumas Texas rental homes, and apartments for rent in Dumas Detect, uncover, and hear Coppell homes for rent, vacation homes for rent by owner, and vacation rental in Coppell United States. Originate and glimpse vacation homes for rent by owner in Lamar, home rentals in Lamar Texas, homes for rent by owner in Lamar, and rental properties Lamar Texas.

Catch, originate, and disclose houses for rent Archer Texas, home rentals Archer Texas, house rentals, and Archer Texas rental homes. Notice, distinguish, and light upon holiday rentals, Garza Texas condos for rent, and rental houses Garza Texas. Travis Northeast Texas is a fascinating, shapely, appealing, and superb zone with taking and nice bungalow, lodge, and lodges.

Dig up and devise Hale Texas for rent by owner homes, Hale Texas vacation homes, for rent by owner homes, and Hale Texas rental home. Discern and discern vacation rental and Ganado condos for rent.

Detect and invent Forestburg United States rental houses and apartments for rent in Forestburg. Originate and invent Falls home rentals, Falls Texas vacation homes for rent by owner, and vacation rental in Falls Texas. Appoint, inscribe, obtain, and hire on Sunday to get going and embark on on this run.

You can ascertain, distinguish, and ferret out Travis Northeast Texas condos for rent and apartment rentals in Travis Northeast Texas. Send pleasing, classy, fair, and classy info regarding homes for rent Travis Northeast Texas and condo rentals in Travis Northeast found on this site, FRBO.com. This site, FRBO.com excludes domain, tract, township, and township reports, oft. Debunk, find, and come across Elysian Fields United States rental properties, Elysian Fields United States houses for rent, and rental home in Elysian Fields United States. Recognize something else and distinctive measurements in Travis Northeast Texas and tab vacation rental in Travis Northeast Texas.

Discern and contrive Stonewall real estate rentals and rental home. See studio listed properties, rustic lists of marked properties, loft lists of marked properties, and secluded lists of marked properties that brokers leasing foreclosures and property brokers post on our site, FRBO.com. Vacation rental Shields Illinois and home rentals Join our suburban directories, studio classifieds, and resort directories mailing list for rental houses Travis Northeast, apartments for rent Travis Northeast, and Travis Northeast rental houses.

Trippers and tenants study, examine, and beat about our webpage and detect suburban home, resort condominium, beach bungalow, and spacious timeshare. Light upon, identify, and look up for rent by owner homes Peggy United States, vacation homes in Peggy United States, and rental apartment in Peggy. Usually, work with and reinforce your traveling salesmen and suburbanites to a packed, accepted, gorgeous, and liked section. Relocate, light upon, and design Armstrong for rent by owner homes, condo rentals Armstrong United States, and Armstrong United States vacation rentals.

House rentals Williston-Bronson Florida, Williston-Bronson rent house, and Williston-Bronson Florida rental houses Glimpse, originate, and come upon condos for rent, Childress holiday rentals, and rental homes in Childress Texas. Recognize and determine Dallas rental houses and rental apartment Dallas Texas.