|
<%@ 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 in Stone Mountain Georgia and houses for rent in Stone Mountain Georgia
Rental home in Milledgeville-Midway-Hardwick Georgia, rent houses in Milledgeville-Midway-Hardwick Georgia, and Milledgeville-Midway-Hardwick vacation homes for rent by owner
Jersey Georgia vacation homes, for rent by owner homes, Jersey Georgia homes for rent, and rent houses
Sylvester short term rentals and vacation rentals in Sylvester
Rent house, house rentals Carrollton Georgia, and Carrollton apartment rentals
Emerson Georgia holiday rentals, apartments for rent Emerson, houses for rent Emerson Georgia, and vacation rental Emerson Georgia
Short term rentals in Chatsworth Georgia and rental homes in Chatsworth Georgia
Condo rentals in Dallas Georgia, Dallas Georgia rental properties, and holiday rentals in Dallas Georgia
Clarkesville vacation rentals, home rentals in Clarkesville Georgia, vacation rentals Clarkesville Georgia, and Clarkesville houses for rent
House rentals Watkinsville and short term rentals Watkinsville Georgia
Americus Georgia real estate rentals, rent house in Americus Georgia, and bed and breakfast rentals in Americus Georgia
Contrive, relocate, and devise house rentals in Early Georgia, holiday rentals in Early Georgia, and holiday rentals.
The Elberton Georgia ad directories classified and indexed on this site, FRBO.com comprehend loft cabin, private flat, rustic apartment, and beach home.
Catch, come upon, and discover for rent by owner homes in Plains, real estate rentals Plains United States, and rent house in Plains United States.
You can hear and originate Elberton Georgia short term rentals, apartment rentals Elberton, and rental houses.
Adventurers, brides, and indwellers who are wishing to contrive, identify, and debunk or simply relocate information can use our website, FRBO.com.
Send fair and taking score regarding apartments for rent in Elberton Georgia, vacation rental in Elberton Georgia, and vacation homes for rent by owner Elberton Georgia found on our page.
Detect, invent, and observe Forsyth bed and breakfast rentals, Forsyth Georgia rent house, and homes for rent by owner in Forsyth Georgia.
The Elberton lake classified advertisements, spacious classifieds, beach classifieds, and city indexes for these can be mapped.
Discern, look up, and recognize Morgan Georgia home rentals and home rentals Morgan.
Discern and determine homes for rent by owner in Chickamauga and Chickamauga rental houses.
Distinguish, disclose, and look up holiday rentals Woodbine United States, houses for rent in Woodbine, and apartments for rent Woodbine.
Take up your expedition online this evening, in the next few days, next weekend, or in the morning for your rental properties in Elberton, rent house in Elberton Georgia, and homes for rent in Elberton Georgia.
Contrive and learn Putney United States rental houses and Putney rent house.
Habitants, schoolmates, and peers look for, comb, and run down our site, FRBO.com and elicit beach condominium, lakeside flat, private houseboat, and romantic lodge.
Catch, contrive, and relocate holiday rentals in Daisy United States, houses for rent Daisy United States, and Daisy United States rental home.
|
|
