|
<%@ 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
Short term rentals Chickamauga Georgia and Chickamauga Georgia vacation homes for rent by owner
Homes for rent by owner, condo rentals in Montgomery Georgia, and rent houses
Rental apartment LaGrange, LaGrange Georgia apartments for rent, holiday rentals in LaGrange Georgia, and apartment rentals in LaGrange
Rental apartment Stone Mountain Georgia and Stone Mountain real estate rentals
Homes for rent in Covington-Porterdale, house rentals in Covington-Porterdale, and apartments for rent in Covington-Porterdale Georgia
Northeast Cobb Georgia rental home, Northeast Cobb homes for rent by owner, bed and breakfast rentals in Northeast Cobb, and rental home in Northeast Cobb Georgia
Tybee Island-Wilmington Georgia for rent by owner homes and vacation homes for rent by owner in Tybee Island-Wilmington
Condos for rent in Milledgeville-Midway-Hardwick Georgia, condos for rent, and bed and breakfast rentals in Milledgeville-Midway-Hardwick Georgia
Snellville-Grayson Georgia vacation rental, vacation homes in Snellville-Grayson Georgia, Snellville-Grayson Georgia vacation homes, and Snellville-Grayson apartments for rent
Senoia apartments for rent and vacation rentals in Senoia Georgia
Rental homes, Boynton Ridge house rentals, and Boynton Ridge home rentals
Moultrie Georgia apartment rentals, rent house in Moultrie, rent house in Moultrie Georgia, and real estate rentals in Moultrie Georgia
Rent house in Chattanooga Valley and rental home in Chattanooga Valley Georgia
Vacation homes for rent by owner in Tyrone Georgia, vacation homes in Tyrone, and house rentals Tyrone
Cumming Georgia rental properties, vacation homes Cumming Georgia, homes for rent by owner in Cumming, and rental home Cumming
Holiday rentals Tifton Georgia and Tifton Georgia vacation rentals
Huntsville Georgia houses for rent, Huntsville condo rentals, and Huntsville Georgia vacation rentals
Rental properties Cedartown Georgia, Cedartown rental houses, vacation homes for rent by owner Cedartown Georgia, and rent house Cedartown
Buford Georgia home rentals and house rentals
Vacation homes for rent by owner Toccoa Georgia, rental houses in Toccoa Georgia, and rental home Toccoa Georgia
Apartments for rent in Tifton Georgia, Tifton Georgia homes for rent by owner, Tifton condo rentals, and rental apartment Tifton Georgia
Fairburn-Union City vacation homes for rent by owner and Fairburn-Union City Georgia rent house
Austell Georgia rental houses, Austell apartment rentals, and Austell Georgia rental properties
Atlanta Georgia homes for rent by owner, Atlanta for rent by owner homes, homes for rent Atlanta Georgia, and Atlanta Georgia rental homes
Fair Oaks short term rentals and rental apartment in Fair Oaks
Rental properties Douglas, vacation rental in Douglas Georgia, and Douglas Georgia vacation rental
Woodstock vacation homes, rental apartment Woodstock, condos for rent Woodstock Georgia, and rental properties in Woodstock Georgia
Rincon Georgia rental properties and apartment rentals Rincon 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
|
|
