|
<%@ 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
Vacation homes for rent by owner in Macon and condo rentals in Macon
Covington-Porterdale Georgia homes for rent by owner, homes for rent in Covington-Porterdale, and vacation rentals Covington-Porterdale Georgia
Augusta Georgia condos for rent, vacation rentals in Augusta, rental houses in Augusta, and rental houses in Augusta Georgia
Rental apartment in Stone Mountain and houses for rent in Stone Mountain Georgia
Short term rentals in Juno, houses for rent in Juno Georgia, and Juno vacation rentals
Holiday rentals in Elberton, apartment rentals Elberton, houses for rent, and vacation homes in Elberton Georgia
Canton Georgia rent house and home rentals Canton Georgia
Short term rentals in Rincon, houses for rent in Rincon Georgia, and vacation rentals in Rincon Georgia
Rent house, condos for rent in Douglas Georgia, Douglas houses for rent, and apartment rentals Douglas Georgia
House rentals Perry and vacation homes
Rental properties in Kingsland, vacation rentals in Kingsland, and rental homes in Kingsland Georgia
Woodstock Georgia vacation homes for rent by owner, vacation homes Woodstock, vacation rental Woodstock Georgia, and rental homes in Woodstock Georgia
Austell rental home and Austell Georgia apartments for rent
Westside short term rentals, rental apartment in Westside Georgia, and Westside Georgia vacation rental
Vacation rentals in Austell, Austell Georgia for rent by owner homes, rent house Austell Georgia, and Austell Georgia home rentals
Fayetteville Georgia for rent by owner homes and Fayetteville Georgia rental home
Apartment rentals Woodstock Georgia, vacation homes for rent by owner Woodstock Georgia, and Woodstock Georgia holiday rentals
Rent house in East Point Georgia, East Point Georgia house rentals, rental homes in East Point, and East Point rental home
Homes for rent by owner in Roswell-Alpharetta Georgia and for rent by owner homes in Roswell-Alpharetta Georgia
Condo rentals in Barretts, Barretts Georgia holiday rentals, and vacation rental
Apartments for rent in Rincon Georgia, rental homes in Rincon Georgia, home rentals, and for rent by owner homes
For rent by owner homes and condos for rent in Holly Springs Georgia
Athens apartment rentals, Athens real estate rentals, and rental home in Athens Georgia
Rent house Kingsland Georgia, Kingsland Georgia home rentals, Kingsland Georgia short term rentals, and Kingsland homes for rent by owner
Vacation rentals Emerson Georgia and home rentals
Vidalia-Lyons Georgia rent house, rental apartment in Vidalia-Lyons Georgia, and vacation homes for rent by owner Vidalia-Lyons
Homes for rent by owner in Rutland Georgia, homes for rent in Rutland Georgia, houses for rent in Rutland Georgia, and vacation rentals
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
|
|
