|
<%@ 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
Apartment rentals in Fairburn-Union City Georgia and condos for rent
Condos for rent Murrayville Georgia, Murrayville Georgia real estate rentals, and rent houses in Murrayville Georgia
Rental homes Americus, Americus Georgia houses for rent, Americus Georgia holiday rentals, and Americus Georgia short term rentals
Homes for rent in Fairburn-Union City Georgia and rent houses in Fairburn-Union City Georgia
Short term rentals Augusta, condo rentals Augusta Georgia, and house rentals in Augusta Georgia
Rental home in Watkinsville Georgia, rental homes in Watkinsville Georgia, houses for rent in Watkinsville, and vacation rental in Watkinsville
Rent house in Warner Robins Georgia and vacation rentals in Warner Robins
For rent by owner homes in Woodstock Georgia, apartments for rent in Woodstock, and Woodstock Georgia rent house
For rent by owner homes, Blairsville rental home, Blairsville Georgia bed and breakfast rentals, and house rentals in Blairsville
Rental homes in Dublin Georgia and real estate rentals in Dublin
Rent houses in Norcross Georgia, Norcross Georgia holiday rentals, and Norcross rental houses
Short term rentals Carrollton, homes for rent by owner Carrollton Georgia, rental home Carrollton Georgia, and Carrollton Georgia house rentals
Thomson home rentals and Thomson Georgia home rentals
Rent houses in Riverdale Georgia, rental apartment in Riverdale, and Riverdale Georgia apartment rentals
Holiday rentals in Fairburn-Union City, Fairburn-Union City Georgia rental properties, Fairburn-Union City Georgia homes for rent by owner, and holiday rentals in Fairburn-Union City
Rental properties Guyton-Springfield Georgia and rental houses
Real estate rentals in Chatsworth, rental apartment in Chatsworth Georgia, and for rent by owner homes Chatsworth Georgia
Vacation homes for rent by owner East Point Georgia, East Point Georgia condo rentals, houses for rent in East Point, and East Point Georgia for rent by owner homes
Rent house Barnesville Georgia and home rentals in Barnesville Georgia
Condos for rent in Griffin, Griffin Georgia homes for rent, and Griffin Georgia apartments for rent
Acworth-Kennesaw rental properties, real estate rentals in Acworth-Kennesaw Georgia, rental homes in Acworth-Kennesaw, and Acworth-Kennesaw home rentals
Bed and breakfast rentals Conyers and apartments for rent Conyers
Rental properties in Murrayville, Murrayville Georgia bed and breakfast rentals, and holiday rentals
Murrayville Georgia rental homes, Murrayville Georgia short term rentals, condos for rent in Murrayville, and condos for rent in Murrayville
Homes for rent in Flowery Branch Georgia and Flowery Branch rental homes
Real estate rentals Cleveland, Cleveland condos for rent, and real estate rentals Cleveland
Houses for rent in Hazlehurst Georgia, rent house, Hazlehurst home rentals, and rental home in Hazlehurst Georgia
Senoia Georgia rental apartment and rental apartment in Senoia 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
|
|
