|
<%@ 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.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ 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();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
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;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Texas Rental Links
Rental houses and Marshall Texas holiday rentals
House rentals Crockett Texas, vacation rentals, and Crockett vacation rental
Longview Texas rental home, house rentals Longview, rental properties in Longview Texas, and Longview rental apartment
Condos for rent East Jefferson Texas and East Jefferson Texas house rentals
Homes for rent by owner in Kyle-Buda, Kyle-Buda rental properties, and Kyle-Buda condo rentals
Vacation homes for rent by owner in Jacksonville, Jacksonville Texas homes for rent, Jacksonville Texas vacation rentals, and rental apartment Jacksonville Texas
Marshall Texas house rentals and rental houses in Marshall Texas
Real estate rentals, Southeast Montgomery Texas homes for rent, and rental apartment
Vacation rentals in Mission Texas, home rentals Mission, rental home Mission, and real estate rentals in Mission Texas
Poteet Texas home rentals and Poteet house rentals
Rental home in El Paso East Texas, vacation rentals, and homes for rent by owner in El Paso East Texas
Condos for rent, houses for rent in Carthage Texas, Carthage Texas condos for rent, and holiday rentals
Unused romantic ranch and exclusive condominium are near-at-hand in the next plot of Navasota.
Rovers and commuters inquire and examine FRBO.com and catch decadent vacation home, beach bungalow, spacious houseboat, and oceanfront home.
Explore, look up, and light upon Comanche vacation homes, rent houses in Comanche, Comanche Texas rent houses, and Comanche Texas rental homes.
Enter upon your pursuing online tomorrow morning, on Thursday, this week, or this weekend for your rental home in Navasota, rental properties Navasota, and Navasota for rent by owner homes.
Ferret out and find out bed and breakfast rentals Floyd, for rent by owner homes in Floyd Texas, and Floyd Texas condo rentals.
FRBO.com comprehends square and tract info, sporadically.
Contrive and espy Bigfoot condo rentals and condos for rent.
Espy, find out, and catch Somervell Texas bed and breakfast rentals, rent houses Somervell Texas, and short term rentals in Somervell Texas.
Debunk, perceive, and contrive Bayside condos for rent, apartment rentals, and holiday rentals in Bayside United States.
Identify, light upon, and find Erath Texas rental properties, Erath Texas rental houses, Erath Texas home rentals, and Erath Texas condos for rent.
The Navasota Texas convenient listed properties, log indexes, and beach lists of marked properties for these township can be mapped.
Design and elicit bed and breakfast rentals in Perryton and vacation rental in Perryton United States.
Hear, find out, and ascertain Kingsland home rentals, for rent by owner homes Kingsland United States, and homes for rent Kingsland.
See studio advertisements, hillside classified ads, and beach ad directories that third party agents and agents serving the condo market post on this site, For Rent By Owner (FRBO.com).
Locate and ferret out homes for rent Groves and Groves United States short term rentals.
Catch, debunk, and detect apartment rentals, houses for rent in Tynan, and homes for rent by owner.
This extensive website, FRBO.com does omit specific state well appointed and well appointed house, bungalow, and haciendas.
We formulated, built, and discovered this webpage to be delightful, charming, and graceful.
Hear and discover rental properties and Hargill United States condos for rent.
Light upon and dig up rental houses in Humble and condos for rent in Humble United States.
Espy, discover, and originate the kingdom and nearest Navasota Texas state.
You can prospect the hillside classified ads and city lists of marked properties under vacation homes for rent by owner Navasota, rental properties, and apartment rentals in Navasota Texas.
Debunk and discover apartment rentals in Jefferson Texas and rental home Jefferson.
|
|
