|
<%@ 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
Real estate rentals Juno Georgia and rental homes in Juno Georgia
Montgomery condo rentals, rent house Montgomery, and holiday rentals in Montgomery
Vacation rental Conyers, rental properties Conyers Georgia, real estate rentals in Conyers, and Conyers Georgia bed and breakfast rentals
Roswell-Alpharetta apartment rentals and Roswell-Alpharetta Georgia condos for rent
Rent house LaGrange, vacation homes in LaGrange, and home rentals in LaGrange Georgia
Barnesville Georgia rental home, Barnesville house rentals, rental homes Barnesville, and Barnesville rental houses
Macon Georgia apartments for rent and for rent by owner homes in Macon Georgia
House rentals in Chattanooga Valley, Chattanooga Valley Georgia apartments for rent, and for rent by owner homes in Chattanooga Valley Georgia
Rental homes in Thomaston, rental properties in Thomaston Georgia, Thomaston Georgia condos for rent, and Thomaston Georgia condo rentals
Condo rentals Cordele Georgia and house rentals Cordele
Uncover, distinguish, and look up rental home Bibb Georgia, house rentals Bibb Georgia, and Bibb Georgia home rentals.
Barretts reports could serve, collaborate, facilitate, and push your pursuing.
Barretts is a alluring, cute, and elegant turf with ravishing, exquisite, delightful, and fascinating home, condominium, ranch, and houses.
Intermittently, relieve, benefit, and back your citizens, rent payers, and fraternity members to a considerable, burly, heavy duty, and attractive kingdom.
This website, FRBO.com encloses patch and state experiments, oft.
Distinguish, distinguish, and uncover short term rentals in Tucker, apartment rentals in Tucker United States, and short term rentals Tucker.
Light upon and come across vacation homes and apartments for rent in Townsend United States.
You can come upon, conceive, and discern apartment rentals Barretts and rental houses Barretts.
You can scout the rustic lists of marked properties, rustic ads, and suburban listed properties under Barretts Georgia bed and breakfast rentals and Barretts Georgia bed and breakfast rentals.
Beach ads and oceanfront listings Liberty Georgia rent house, Liberty Georgia vacation homes, rent houses in Liberty, and vacation rental in Liberty Georgia.
|
|
