|
<%@ 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
Homes for rent by owner in Valdosta Georgia and Valdosta Georgia condos for rent
Apartments for rent in Toccoa Georgia, homes for rent by owner Toccoa Georgia, and apartments for rent
Condos for rent, rental properties, house rentals Waycross, and Waycross rental houses
Home rentals in Atlanta-Decatur Georgia and condo rentals
Rental apartment in Woodstock Georgia, rent houses, and house rentals in Woodstock Georgia
Rent houses in Rutland, rent houses, house rentals in Rutland, and rent houses in Rutland Georgia
Short term rentals in Elberton Georgia and Elberton apartments for rent
Gray-Griswold Georgia apartment rentals, apartment rentals Gray-Griswold, and Gray-Griswold Georgia home rentals
Perry Georgia rental houses, Perry Georgia rental home, Perry holiday rentals, and Perry Georgia condo rentals
Locust Grove bed and breakfast rentals and Locust Grove Georgia apartment rentals
Lawrenceville Georgia condos for rent, vacation homes for rent by owner Lawrenceville, and homes for rent by owner Lawrenceville
Vacation rental in Chatsworth Georgia, Chatsworth Georgia rental houses, for rent by owner homes in Chatsworth, and rental houses Chatsworth Georgia
Vacation homes Eastman Georgia and Eastman houses for rent
Houses for rent in Winterville, Winterville homes for rent by owner, and rental houses Winterville
Homes for rent in Dalton Georgia, rent houses, holiday rentals Dalton, and vacation homes for rent by owner Dalton
Rental apartment in West Dougherty and West Dougherty Georgia vacation rentals
Rent houses Cedartown Georgia, house rentals, and apartment rentals
Vacation rental in Hartwell Georgia, rent house Hartwell Georgia, for rent by owner homes, and rental houses Hartwell Georgia
Snellville-Grayson vacation rentals and rental homes
Short term rentals in Chatsworth Georgia, Chatsworth Georgia houses for rent, and vacation homes
Dacula-Rocky Creek house rentals, vacation homes for rent by owner, rental properties, and rent house Dacula-Rocky Creek
Vacation rentals Summerville Georgia and vacation homes Summerville Georgia
Vacation rentals, vacation rental Newnan Georgia, and house rentals in Newnan Georgia
Rent houses in Cartersville Georgia, Cartersville Georgia holiday rentals, Cartersville Georgia house rentals, and Cartersville Georgia condo rentals
Apartment rentals Bremen Georgia and rent houses in Bremen Georgia
For rent by owner homes Clermont Georgia, Clermont Georgia rental houses, and Clermont Georgia apartment rentals
Rent houses in Juno Georgia, condo rentals Juno Georgia, Juno Georgia holiday rentals, and holiday rentals Juno Georgia
For rent by owner homes in Clermont Georgia and rental homes in Clermont Georgia
Vacation rentals in Bremen, vacation rentals in Bremen Georgia, and Bremen Georgia vacation homes
Vacation homes La Fayette, vacation rental in La Fayette Georgia, for rent by owner homes La Fayette, and bed and breakfast rentals La Fayette
#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
|
|
