|
<%@ 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
Rental homes and vacation rental in LaGrange Georgia
West Dougherty vacation homes for rent by owner, West Dougherty vacation rental, and houses for rent in West Dougherty Georgia
Douglas vacation rental, Douglas rent house, Douglas condo rentals, and Douglas Georgia real estate rentals
Home rentals and Elberton Georgia vacation rental
Holly Springs Georgia rental properties, home rentals, and rent houses
Dallas rental homes, rental properties in Dallas Georgia, vacation rental, and vacation rental in Dallas Georgia
Stockbridge Georgia apartment rentals and vacation rental in Stockbridge Georgia
Vacation rental, Chatsworth Georgia vacation rental, and home rentals Chatsworth
Bed and breakfast rentals in Norcross, home rentals in Norcross, vacation homes Norcross Georgia, and Norcross Georgia homes for rent
Condos for rent in Sylvester and rental home Sylvester
Homes for rent by owner, rental apartment, and Woodstock Georgia for rent by owner homes
Homes for rent, condo rentals Huntsville, rental homes, and houses for rent in Huntsville
Atlanta-Decatur Georgia rental houses and holiday rentals in Atlanta-Decatur Georgia
Snellville-Grayson Georgia homes for rent, bed and breakfast rentals Snellville-Grayson Georgia, and vacation rental in Snellville-Grayson
For rent by owner homes Powder Springs, apartments for rent, homes for rent by owner Powder Springs, and vacation homes for rent by owner in Powder Springs Georgia
Milledgeville-Midway-Hardwick Georgia holiday rentals and rental home in Milledgeville-Midway-Hardwick Georgia
Gray-Griswold short term rentals, rental apartment in Gray-Griswold Georgia, and real estate rentals Gray-Griswold
Rent house Swainsboro Georgia, Swainsboro Georgia homes for rent, apartment rentals in Swainsboro Georgia, and bed and breakfast rentals Swainsboro
Holiday rentals Hazlehurst and rent house in Hazlehurst Georgia
St Simons Georgia rental properties, bed and breakfast rentals in St Simons Georgia, and rent houses in St Simons Georgia
House rentals Athens, homes for rent by owner in Athens, rental apartment in Athens, and Athens Georgia rent houses
Carrollton apartment rentals and rental home in Carrollton
Vacation rental Cornelia Georgia, Cornelia house rentals, and real estate rentals in Cornelia Georgia
Huntsville Georgia short term rentals, vacation homes for rent by owner in Huntsville Georgia, apartments for rent, and real estate rentals in Huntsville
Vacation rentals in Roswell-Alpharetta and Roswell-Alpharetta house rentals
Homes for rent by owner in Carrollton Georgia, Carrollton Georgia bed and breakfast rentals, and rent houses Carrollton
Rental houses in Stockbridge, home rentals Stockbridge Georgia, Stockbridge Georgia rental apartment, and rental apartment in Stockbridge Georgia
Norcross Georgia rental apartment and Norcross vacation rentals
Homes for rent by owner Columbus, real estate rentals Columbus Georgia, and Columbus Georgia vacation rentals
Statesboro Georgia rental apartment, vacation rental in Statesboro, vacation homes Statesboro, and Statesboro Georgia houses for rent
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
