|
<%@ 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" %>
|
Georgia Rental Links
Condos for rent and apartment rentals
Apartments for rent Atlanta, Atlanta Georgia vacation rentals, and rental houses Atlanta Georgia
Vacation rental in Pooler-Burroughs Georgia, rental houses Pooler-Burroughs, for rent by owner homes, and homes for rent Pooler-Burroughs Georgia
Rent house in Forsyth Georgia and vacation homes for rent by owner in Forsyth
Woodstock Georgia house rentals, Woodstock for rent by owner homes, and homes for rent by owner Woodstock Georgia
Dalton rent houses, rental apartment, Dalton condos for rent, and rental homes in Dalton
Rental apartment Jesup Georgia and Jesup Georgia vacation homes
Roswell-Alpharetta Georgia rental houses, Roswell-Alpharetta rent house, and rental homes
Condos for rent, vacation rentals in Warner Robins Georgia, homes for rent by owner Warner Robins Georgia, and rental apartment in Warner Robins Georgia
Villa Rica Georgia vacation rentals and apartments for rent Villa Rica
Chamblee-Doraville Georgia apartment rentals, Chamblee-Doraville Georgia real estate rentals, and apartments for rent in Chamblee-Doraville Georgia
Homes for rent in Forest Park-Morrow Georgia, condos for rent in Forest Park-Morrow, real estate rentals in Forest Park-Morrow Georgia, and rental home Forest Park-Morrow Georgia
Sylvester Georgia real estate rentals and Sylvester rent house
Bill Arp Georgia for rent by owner homes, vacation rentals Bill Arp, and Bill Arp condo rentals
For rent by owner homes in Lawrenceville Georgia, rent house Lawrenceville, Lawrenceville homes for rent by owner, and bed and breakfast rentals in Lawrenceville
Rental properties in Cartersville Georgia and for rent by owner homes Cartersville
Vacation homes in Brunswick Georgia, apartment rentals Brunswick Georgia, and holiday rentals in Brunswick Georgia
House rentals, houses for rent in Clermont, Clermont Georgia homes for rent by owner, and holiday rentals in Clermont
Vacation homes for rent by owner in Lithonia Georgia and Lithonia rent houses
Vacation rental in Cartersville Georgia, rental home Cartersville Georgia, and real estate rentals in Cartersville
Cordele Georgia for rent by owner homes, rental homes Cordele, house rentals in Cordele Georgia, and Cordele vacation homes for rent by owner
Chattanooga Valley Georgia condo rentals and rental home Chattanooga Valley Georgia
Homes for rent by owner Bainbridge, rental properties in Bainbridge, and rent house
Fayetteville apartment rentals, homes for rent in Fayetteville Georgia, Fayetteville Georgia vacation homes for rent by owner, and homes for rent in Fayetteville
Auburn Georgia real estate rentals and rent houses in Auburn Georgia
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
