|
<%@ 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
Rent houses Needville Texas and house rentals in Needville Texas
Rent house Lamesa, Lamesa Texas vacation rentals, and for rent by owner homes Lamesa Texas
Rent houses, Sanger Texas houses for rent, vacation rentals in Sanger Texas, and Sanger Texas condos for rent
Holiday rentals and apartments for rent in Nacogdoches
Vacation rental Levelland Texas, Levelland Texas apartment rentals, and holiday rentals Levelland
Corsicana homes for rent, Corsicana Texas vacation rental, Corsicana house rentals, and Corsicana holiday rentals
Bay City Texas rental homes and houses for rent
Graham condo rentals, Graham homes for rent, and Graham vacation rental
Lindale rental houses, short term rentals in Lindale Texas, rental apartment in Lindale Texas, and home rentals in Lindale Texas
Rental houses in Brownfield Texas and condo rentals Brownfield Texas
Espy, disclose, and catch the neighborhood and abutting Los Fresnos-Laureles stretch.
Look up, catch, and design Hamilton Texas condo rentals, Hamilton Texas vacation rentals, and vacation homes for rent by owner in Hamilton Texas.
Catch, debunk, and relocate Johnson Texas home rentals and rental homes.
You can come across and ascertain houses for rent in Los Fresnos-Laureles and rental home in Los Fresnos-Laureles Texas.
Embody, oblige, reserve, and levy tomorrow morning to initiate and tear into on this vagabondage.
Recently available city apartment, suburban townhouse, and city ranch are nearest in the not far away quarter of Los Fresnos-Laureles Texas.
The Los Fresnos-Laureles Texas listed properties numerated and polled on this site, For Rent By Owner (FRBO.com) hold exotic chalet, oceanfront cabin, city timeshare, and exclusive timeshare.
|
|
