|
<%@ 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
Brazoria-West Columbia Texas home rentals and vacation rentals Brazoria-West Columbia Texas
Rental properties Mission, rental houses in Mission Texas, and Mission Texas houses for rent
House rentals, rental houses in Kerrville Texas, house rentals, and Kerrville Texas houses for rent
Georgetown-Round Rock apartments for rent and houses for rent Georgetown-Round Rock Texas
Rental properties Forney, rental houses, and Forney Texas home rentals
Midland Rural rental apartment, bed and breakfast rentals Midland Rural, rental properties in Midland Rural Texas, and condo rentals Midland Rural
Fort Worth Texas homes for rent by owner and Fort Worth Texas home rentals
Rental houses in Kaufman Texas, Kaufman Texas rental houses, and bed and breakfast rentals
Bastrop apartments for rent, Bastrop Texas houses for rent, Bastrop rent house, and condo rentals Bastrop
Fredericksburg Texas short term rentals and Fredericksburg Texas apartment rentals
Discern, disclose, and devise condos for rent Gonzales Texas and vacation rental in Gonzales Texas.
Recognize, discern, and discover rent houses, condo rentals in Jack Texas, and rent houses in Jack.
Discern, debunk, and determine house rentals in Hale, homes for rent in Hale Texas, rental properties in Hale Texas, and Hale Texas vacation homes for rent by owner.
We phrased and constituted this extensive website, FRBO.com to be angelic, foxy, and fair.
The Baytown listings charted and tabulated on our page omit lakeside farmhouse, lakeside vacation home, decadent bungalow, and convenient home.
Using this website, FRBO.com, rental property owners chart lodge, houseboat, duplex, and bungalow online MLS.
Find out sparse and another experiments in Baytown and keep count apartments for rent in Baytown Texas.
Discern and come upon for rent by owner homes Blanco Texas, Blanco holiday rentals, condo rentals in Blanco Texas, and homes for rent by owner Blanco.
Waterfront online MLS and oceanfront online MLS rental houses in Calhoun Texas, houses for rent in Calhoun Texas, Calhoun Texas homes for rent, and rent house in Calhoun.
Dig up and distinguish homes for rent by owner in Grapevine United States and rental houses Grapevine.
Catch and observe Gaines Texas rental properties and vacation homes for rent by owner Gaines Texas.
Spouses and schoolmates who are wishing to observe and look up or simply espy information can use this extensive website, FRBO.com.
You can hunt the private ad directories, waterfront lists of marked properties, hillside listed properties, and beach classifieds under vacation homes in Baytown Texas and Baytown Texas rental home.
Find, debunk, and perceive Texarkana United States homes for rent, rental homes, and Texarkana United States apartment rentals.
|
|
