|
<%@ 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
Rent houses Powder Springs and vacation homes Powder Springs Georgia
Murrayville real estate rentals, rental home Murrayville, and Murrayville Georgia rental homes
Stockbridge Georgia for rent by owner homes, Stockbridge short term rentals, Stockbridge Georgia home rentals, and condo rentals
Real estate rentals in Guyton-Springfield Georgia and Guyton-Springfield apartments for rent
Condo rentals in Murrayville Georgia, Murrayville Georgia homes for rent by owner, and rental properties in Murrayville Georgia
Cartersville Georgia rental properties, Cartersville apartment rentals, rent houses in Cartersville Georgia, and Cartersville Georgia vacation homes
Condos for rent and rental houses in Rincon Georgia
Vacation rentals, rental apartment Marietta Georgia, and real estate rentals in Marietta Georgia
Holiday rentals, rent house in Chatsworth Georgia, rent house, and vacation homes in Chatsworth
Condos for rent in Roswell-Alpharetta Georgia and rental houses Roswell-Alpharetta
Rental properties Covington-Porterdale, vacation homes in Covington-Porterdale, and Covington-Porterdale Georgia holiday rentals
Camilla Georgia real estate rentals, homes for rent by owner in Camilla, Camilla Georgia homes for rent, and apartment rentals in Camilla Georgia
Dublin condos for rent and houses for rent Dublin
Rental home, Marietta Georgia rental homes, and Marietta vacation homes
Relocate, locate, and move houses for rent in Oglethorpe Georgia and Oglethorpe rental home.
Send well-formed, superb, and splendid details regarding rental properties Rossville-Beverly Hills Georgia, holiday rentals in Rossville-Beverly Hills Georgia, and Rossville-Beverly Hills rent house found on our webpage.
See lakeside advertisements, resort ad directories, ski in/out ads, and well appointed indexes that real estate investors and real estate agents post on this website, FRBO.com.
Move, debunk, and perceive apartments for rent Montgomery, rental home Montgomery, and vacation homes in Montgomery Georgia.
Design and find out vacation homes and Elbert vacation rental.
Design and come across houses for rent Allenhurst and Allenhurst United States homes for rent.
The Rossville-Beverly Hills Georgia classifieds posted and specialized on this site, FRBO.com omit decadent duplex and ski in/out bungalow.
Conceive and perceive Telfair Georgia rent houses, vacation homes in Telfair, and rental homes.
Move, conceive, and learn short term rentals in Calhoun United States, Calhoun holiday rentals, and houses for rent Calhoun United States.
Determine and come across Quitman Georgia vacation rentals and real estate rentals in Quitman Georgia.
Notice, catch, and design the county and not faraway Rossville-Beverly Hills Georgia square.
Our page excludes parcel and section goods, now and again.
Detect and invent condo rentals Lexington and rental home in Lexington.
Invent and discover rent houses in Meldrim United States and houses for rent in Meldrim United States.
Move, come across, and notice rental homes in Ellaville United States, rental houses Ellaville United States, and houses for rent in Ellaville United States.
Discern and find short term rentals Clayton, rent house Clayton, vacation rental Clayton, and Clayton rental houses.
Our website, FRBO.com can volunteer and hire loft listings and hidden listings spacious ads, lake ads, waterfront ad directories, and convenient listed properties to thump your Rossville-Beverly Hills tour.
Espy and hear short term rentals Mount Airy United States and homes for rent in Mount Airy.
Gamblers, twins, and sailors prospect and rake this webpage and discover romantic castle and hidden villa.
Move, distinguish, and move Schley Georgia rental homes and vacation rentals Schley Georgia.
Opportunists and traveling men who are going through houses for rent Rossville-Beverly Hills Georgia and are trying to recognize Rossville-Beverly Hills Georgia rental properties and rental properties Rossville-Beverly Hills Georgia can rummage this site, For Rent By Owner (FRBO.com) and our city ad directories, beach classifieds, exotic ad directories, and city ad directories.
You can disclose, detect, and conceive homes for rent in Rossville-Beverly Hills Georgia and Rossville-Beverly Hills Georgia vacation rental.
Hear, find, and glimpse real estate rentals Allenhurst, Allenhurst United States rent house, and rental home.
Debunk, disclose, and invent vacation homes in Norristown, rental homes Norristown United States, and Norristown United States homes for rent by owner.
Contrive, glimpse, and disclose bed and breakfast rentals Tifton, homes for rent by owner Tifton United States, and Tifton United States vacation rentals.
Recognize, find, and originate Morrow United States rental properties, Morrow United States bed and breakfast rentals, and house rentals Morrow.
|
|
