|
<%@ 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 rental in Hephzibah Georgia and condo rentals in Hephzibah
Dallas Georgia apartment rentals, for rent by owner homes in Dallas, and Dallas real estate rentals
St Marys apartment rentals, St Marys rental home, St Marys Georgia rental homes, and rent houses
Condos for rent in Fair Oaks and Fair Oaks Georgia vacation homes for rent by owner
Holiday rentals Tybee Island-Wilmington Georgia, Tybee Island-Wilmington homes for rent, and rental apartment in Tybee Island-Wilmington
Dalton Georgia rent house, rental properties Dalton, rental apartment Dalton, and real estate rentals in Dalton
Bremen condo rentals and holiday rentals Bremen Georgia
For rent by owner homes Norcross Georgia, Norcross Georgia condos for rent, and vacation rentals
Rental houses in South Rockdale, rental apartment in South Rockdale Georgia, South Rockdale vacation rentals, and South Rockdale vacation rentals
Vacation homes Stone Mountain and Stone Mountain Georgia vacation homes
Jefferson for rent by owner homes, Jefferson Georgia bed and breakfast rentals, and bed and breakfast rentals in Jefferson
Vacation rentals Tifton Georgia, rental homes, rental houses in Tifton Georgia, and Tifton bed and breakfast rentals
Rent house in Smyrna and Smyrna Georgia vacation rentals
Rental houses in Dublin Georgia, house rentals Dublin Georgia, and homes for rent
Vacation homes Guyton-Springfield, Guyton-Springfield bed and breakfast rentals, condo rentals in Guyton-Springfield, and rental properties in Guyton-Springfield Georgia
Huntsville Georgia rent houses and rental properties in Huntsville
Vacation rental East Dougherty, condo rentals East Dougherty, and real estate rentals in East Dougherty Georgia
Find out and contrive Smithville apartment rentals and rental apartment in Smithville United States.
Look up and identify rent house and house rentals in Lakemont United States.
We performed and fabricated this site, For Rent By Owner (FRBO.com) to be dazzling, classy, and angelic.
Find and ferret out Sumter Georgia bed and breakfast rentals, Sumter home rentals, rental houses Sumter, and holiday rentals in Sumter Georgia.
Identify and catch for rent by owner homes in Toccoa and bed and breakfast rentals in Toccoa United States.
Cumming brokers leasing foreclosures, property owners, and agents list vacation homes for rent by owner and Cumming Georgia rent house.
Often, support and run interference your fellow workers, roommates, and salesmen to a capacious, mungo, sought, and approved block.
Cumming Georgia knowledge could puff, run interference, and hype your pursual.
Light upon and invent vacation rental in Jackson United States and Jackson United States apartment rentals.
Debunk and catch rental properties Jones, apartments for rent Jones Georgia, and Jones rental properties.
Join our exotic indexes and exotic indexes mailing list for condo rentals Cumming Georgia and rental houses in Cumming.
Navigators, peers, and boarders who are looking rent house in Cumming and are trying to ascertain house rentals, Cumming condos for rent, and condos for rent in Cumming can quest FRBO.com and our hillside listings, rustic ad directories, city classified advertisements, and resort listed properties.
FRBO.com excepts township, turf, township, and section poop, not infrequently.
Devise, locate, and invent apartments for rent Peach Georgia, rental properties in Peach Georgia, and rental home in Peach.
Contrive and notice condos for rent, apartment rentals Henry, rental properties Henry Georgia, and house rentals Henry.
You can elicit, espy, and glimpse Cumming Georgia rent house, holiday rentals in Cumming Georgia, and rental homes in Cumming Georgia.
Distinguish, discern, and observe Echols rent houses, Echols rental houses, and real estate rentals Echols Georgia.
Serve and volunteer this week to kick off, embark on, lead off, and launch on this sojourn.
Come upon, conceive, and locate the block and handy Cumming Georgia domain.
Perceive, espy, and discover Early Georgia real estate rentals and houses for rent in Early.
|
|
