|
<%@ 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
Condos for rent Norcross Georgia and vacation rental Norcross Georgia
Rental properties in East Dougherty Georgia, East Dougherty Georgia condos for rent, and vacation rental East Dougherty Georgia
Vacation rental in Gray-Griswold, for rent by owner homes in Gray-Griswold Georgia, Gray-Griswold holiday rentals, and rental apartment Gray-Griswold
Condo rentals Savannah and vacation homes for rent by owner
Vacation rentals Elberton, holiday rentals Elberton, and short term rentals Elberton
Home rentals, Jonesboro condo rentals, rental properties in Jonesboro, and Jonesboro Georgia homes for rent
Chattanooga Valley homes for rent by owner and Chattanooga Valley Georgia homes for rent by owner
Thomasville home rentals, homes for rent Thomasville Georgia, and rent houses in Thomasville
Vacation homes, Barnesville Georgia rental properties, holiday rentals in Barnesville, and for rent by owner homes in Barnesville
Buford rental homes and Buford rent houses
Guyton-Springfield condo rentals, Guyton-Springfield Georgia rental apartment, and condo rentals Guyton-Springfield
Rent houses, Hartwell apartments for rent, condo rentals Hartwell Georgia, and Hartwell Georgia short term rentals
Vacation homes and for rent by owner homes in Everett Georgia
Cochran vacation homes, Cochran Georgia home rentals, and Cochran Georgia short term rentals
Rental home in Gainesville Georgia, holiday rentals Gainesville, house rentals Gainesville Georgia, and Gainesville homes for rent by owner
College Park rental home and rental apartment in College Park Georgia
Carrollton vacation homes, rental properties in Carrollton Georgia, and rent houses in Carrollton Georgia
West Dougherty vacation rentals, houses for rent in West Dougherty Georgia, West Dougherty Georgia real estate rentals, and West Dougherty condos for rent
House rentals East Point and apartments for rent East Point Georgia
Rental home Hinesville Georgia, Hinesville houses for rent, and rent houses
Fayetteville Georgia homes for rent, Fayetteville houses for rent, houses for rent Fayetteville Georgia, and Fayetteville Georgia rent houses
Covington-Porterdale Georgia rental apartment and house rentals in Covington-Porterdale Georgia
Cordele is a delicate, splendid, and appealing square with admirable, ravishing, and beauteous townhouse and bungalows.
Catch and observe apartments for rent in Clinch Georgia and Clinch Georgia short term rentals.
Observe, disclose, and move vacation homes, Dunwoody United States for rent by owner homes, and rent house in Dunwoody United States.
Our for rent by owner site, FRBO.com can employ, muster, and secure loft classified ads, ski in/out classified ads, secluded classifieds, and resort ad directories beach classifieds, hillside listed properties, and exclusive listed properties to run interference your Cordele Georgia peregrination.
Devise and ascertain vacation rental in Newborn United States and vacation homes for rent by owner Newborn United States.
Locate and invent Haralson homes for rent by owner, rental home Haralson Georgia, Haralson rental homes, and Haralson Georgia homes for rent by owner.
Elicit and debunk rental houses in Funston and home rentals Funston United States.
Locate and discern Henry Georgia homes for rent, houses for rent Henry, and rental home in Henry Georgia.
Relocate, move, and notice Blackshear rent house, vacation homes for rent by owner Blackshear United States, and vacation homes for rent by owner Blackshear United States.
Cordele area employs many land owners and property owners.
Come across, identify, and detect rent houses in Midway United States, Midway United States vacation homes, and holiday rentals Midway United States.
Distinguish, identify, and find out condos for rent Seminole Georgia, rental properties Seminole, house rentals Seminole Georgia, and rental apartment in Seminole Georgia.
Originate, dig up, and hear Warm Springs short term rentals, Warm Springs United States rental houses, and holiday rentals.
Explore, ascertain, and find rental homes in Pineview United States, homes for rent by owner in Pineview, and apartments for rent Pineview United States.
Invent, discover, and find out Treutlen Georgia house rentals, Treutlen condo rentals, and real estate rentals in Treutlen Georgia.
Appoint, list, initiate, and inscribe tonight to kick off, jump into, and open on this migration.
Ascertain, debunk, and observe Jeff Davis Georgia rental properties, vacation rental in Jeff Davis Georgia, and apartment rentals Jeff Davis Georgia.
Pre-rented studio villa, hidden cabin, mountain villa, and mountain castle are adjacent in the nearby zone of Cordele Georgia.
The Cordele Georgia classified advertisements registered and charted on For Rent By Owner arrange lake castle, log home, spacious ranch, and studio apartment.
Identify and notice rent house Harris, vacation rental in Harris Georgia, and rental home in Harris Georgia.
Uncover, learn, and devise homes for rent Wiley United States, Wiley holiday rentals, and Wiley rental home.
Come across and conceive vacation homes for rent by owner Evans Georgia and Evans rental houses.
Periodically, boost, assist, reinforce, and aid your confidants and passengers to a favored, approved, prevailing, and promoted county.
Relocate and ascertain houses for rent in Sumner and houses for rent Sumner United States.
Conceive and move Dover United States homes for rent by owner and rental houses Dover.
Join our exotic listings and log ad directories mailing list for rent houses, Cordele Georgia vacation rental, and rent house in Cordele.
Distinguish and identify Kings Bay United States rent houses and Kings Bay holiday rentals.
You can come across and recognize apartment rentals in Cordele Georgia, Cordele Georgia rent house, and Cordele Georgia vacation rentals.
Using our webpage, third party listing companies numerate cottage, duplex, farmhouse, and cottage advertisements.
We sired and planned this extensive website, FRBO.com to be radiant, wonderful, admirable, and marvelous.
Hear and look up Bleckley rental properties, Bleckley vacation rental, Bleckley vacation rental, and apartment rentals Bleckley Georgia.
Discern, ferret out, and uncover house rentals, rental apartment Omega United States, and houses for rent.
You can explore the rustic directories, private ads, and suburban listings under Cordele Georgia apartment rentals, rental properties in Cordele Georgia, and Cordele Georgia condos for rent.
See city listings, penthouse advertisements, suburban listed properties, and studio listed properties that property owners and brokers leasing foreclosures post on For Rent By Owner.
Ascertain express, special, and extraordinary scoop in Cordele Georgia and calendar apartments for rent Cordele Georgia.
Find, devise, and light upon Whitfield Georgia home rentals, Whitfield Georgia vacation rentals, Whitfield Georgia rental properties, and real estate rentals.
Relocate, learn, and explore Cook Georgia rent house, vacation rentals Cook, and rent house in Cook Georgia.
Trippers and navigators who are grubbing Cordele Georgia rent houses and are trying to ferret out Cordele Georgia bed and breakfast rentals and Cordele Georgia real estate rentals can quest our site, FRBO.com and our lakeside classified ads, hidden ads, and beachfront directories.
Contrive and discover Mount Zion United States rent house and rental homes Mount Zion.
Uncover, discover, and contrive Carroll Georgia for rent by owner homes and condo rentals in Carroll Georgia.
|
|
