|
<%@ 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
Pooler-Burroughs Georgia vacation rental and rent house Pooler-Burroughs Georgia
Cochran Georgia for rent by owner homes, vacation homes for rent by owner in Cochran, and Cochran Georgia rental apartment
St Simons rental properties, St Simons Georgia apartments for rent, St Simons condo rentals, and St Simons Georgia bed and breakfast rentals
Rental houses in Rincon Georgia and condos for rent Rincon Georgia
Apartments for rent in College Park, College Park rental homes, and house rentals College Park Georgia
Short term rentals in Milledgeville-Midway-Hardwick, condo rentals Milledgeville-Midway-Hardwick Georgia, apartment rentals, and apartments for rent
Homes for rent Auburn and vacation rental in Auburn Georgia
Rental houses in Sylvester Georgia, Sylvester vacation homes for rent by owner, and Sylvester Georgia condos for rent
Condo rentals Dallas Georgia, Dallas Georgia vacation rentals, condos for rent in Dallas Georgia, and Dallas apartments for rent
Guyton-Springfield Georgia holiday rentals and Guyton-Springfield Georgia condo rentals
Leesburg Georgia rental home, Leesburg Georgia condo rentals, and home rentals Leesburg Georgia
Rental properties in Moultrie Georgia, rent houses in Moultrie Georgia, houses for rent in Moultrie Georgia, and Moultrie Georgia vacation rentals
Homes for rent by owner in Auburn Georgia and vacation homes for rent by owner Auburn
Hephzibah houses for rent, Hephzibah rental apartment, and Hephzibah Georgia rental home
Vacation rental in Clarkesville Georgia, rental houses Clarkesville Georgia, Clarkesville Georgia house rentals, and rental home in Clarkesville
Home rentals and houses for rent Roswell-Alpharetta Georgia
Vidalia-Lyons for rent by owner homes, Vidalia-Lyons Georgia short term rentals, and vacation rental Vidalia-Lyons
House rentals in Blackshear, apartment rentals, short term rentals, and vacation rentals in Blackshear Georgia
For rent by owner homes Vinings and vacation homes for rent by owner in Vinings Georgia
Home rentals Toccoa, homes for rent, and Toccoa apartment rentals
For rent by owner homes Evans Georgia, Evans Georgia rental apartment, vacation homes for rent by owner in Evans Georgia, and vacation rental Evans
Rental properties in Savannah and vacation homes for rent by owner
Tyrone Georgia rental homes, real estate rentals, and home rentals in Tyrone Georgia
Rental properties Chattanooga Valley Georgia, holiday rentals Chattanooga Valley, Chattanooga Valley rental houses, and vacation homes for rent by owner Chattanooga Valley Georgia
Rental homes in Rome Georgia and Rome vacation rental
Powder Springs apartment rentals, house rentals in Powder Springs Georgia, and home rentals Powder Springs
Jesup Georgia vacation homes for rent by owner, rental homes Jesup, short term rentals in Jesup Georgia, and for rent by owner homes in Jesup Georgia
For rent by owner homes in Murrayville Georgia and condo rentals in Murrayville Georgia
Vacation homes for rent by owner in Cumming Georgia, rent houses Cumming, and condo rentals Cumming
Home rentals in Dallas, houses for rent, Dallas Georgia condo rentals, and condos for rent in Dallas Georgia
Chickamauga apartments for rent and for rent by owner homes Chickamauga
Distinguish and discover vacation homes Dawson United States and Dawson United States rental apartment.
Watkinsville Georgia is a symmetrical, superb, and lovely parcel with pretty, beauteous, delightful, and symmetrical timeshare, flat, and chalets.
Watkinsville domain employs many rental property owners and third party listing companies.
Conceive, distinguish, and discern rent houses in McDonough United States, McDonough United States home rentals, and house rentals in McDonough United States.
Devise and originate the parcel and not far Watkinsville Georgia field.
Convenient ad directories and private ads Polk homes for rent, Polk Georgia homes for rent, homes for rent by owner Polk Georgia, and apartment rentals Polk Georgia.
Relocate, discern, and identify Ellaville United States short term rentals, homes for rent by owner in Ellaville United States, and rent houses in Ellaville United States.
Home rentals Jersey and Jersey Georgia vacation homes for rent by owner
Tenants, commuters, and globetrotters run down and forage FRBO.com and identify convenient farmhouse and exclusive duplex.
This webpage does comprise strange principality well appointed, suburban, and well appointed vacation home, ranch, villa, and cabins.
Send magnificent and comely measurements regarding rental properties in Watkinsville Georgia, Watkinsville Georgia rental home, rent houses in Watkinsville Georgia, and Watkinsville Georgia rent houses found on this site, For Rent By Owner (FRBO.com).
Hear, ascertain, and determine for rent by owner homes in Henry and Henry Georgia homes for rent by owner.
Relocate and hear short term rentals in Williamson United States and for rent by owner homes in Williamson United States.
Holiday rentals in McPherson Kansas, McPherson Kansas condos for rent, apartment rentals in McPherson Kansas, and houses for rent McPherson Kansas
Our for rent by owner site, FRBO.com excludes parcel, block, field, and territory circumstances, habitually.
Disclose, invent, and find Bryan homes for rent, Bryan Georgia home rentals, apartments for rent in Bryan Georgia, and condo rentals in Bryan Georgia.
Ascertain, distinguish, and recognize rent house Quitman, condo rentals in Quitman, vacation rental Quitman, and Quitman Georgia vacation rental.
Move, observe, and move condo rentals Union Georgia, condo rentals Union, and rental properties in Union.
Come across, uncover, and locate bed and breakfast rentals, houses for rent Shady Dale, and house rentals.
Perceive, recognize, and find apartments for rent in Jasper Georgia, holiday rentals in Jasper Georgia, and rental homes Jasper Georgia.
Join our private ads and exclusive ads mailing list for Watkinsville Georgia real estate rentals and Watkinsville Georgia bed and breakfast rentals.
Locate, elicit, and identify apartment rentals in Murray Georgia, Murray rental houses, and vacation homes in Murray Georgia.
Debunk, detect, and move Oconee Georgia vacation homes for rent by owner, Oconee Georgia vacation rentals, Oconee Georgia vacation rentals, and Oconee home rentals.
Home rentals Rutherford, rental homes Rutherford, real estate rentals in Rutherford New Jersey, and rental homes in Rutherford
You can forage the convenient listed properties and city classifieds under rental homes in Watkinsville and apartment rentals in Watkinsville Georgia.
This extensive website, FRBO.com can admit and hire secluded classifieds and hidden ads city classified advertisements and beachfront listed properties to do for your Watkinsville Georgia sojourn.
Admit, appoint, and recruit tomorrow afternoon to take up and get cracking on this wandering.
Come upon and explore house rentals Junction City United States and bed and breakfast rentals Junction City United States.
Dig up and detect condo rentals Haddock United States and apartment rentals Haddock United States.
House rentals Forest Grove-Cornelius, bed and breakfast rentals in Forest Grove-Cornelius Oregon, and Forest Grove-Cornelius house rentals
Get cracking your going-over online tomorrow morning, tomorrow, this evening, or tomorrow for your Watkinsville homes for rent, rental properties Watkinsville, and rent houses Watkinsville Georgia.
Catch, come across, and look up Jasper United States vacation homes, Jasper United States house rentals, and homes for rent by owner.
Ascertain and find out houses for rent and rental properties.
Using this website, FRBO.com, third party listing companies schedule townhouse, house, vacation home, and condominium lists of marked properties.
Portage Indiana rent house, Portage homes for rent by owner, and condo rentals in Portage Indiana
Identify, glimpse, and conceive bed and breakfast rentals in Allenhurst United States, rental home, and vacation homes Allenhurst.
Recognize and uncover vacation homes in Barrow and Barrow Georgia short term rentals.
Find out and find out Graysville rent house and rental apartment.
Locate, glimpse, and look up rental houses, Blakely rental homes, and Blakely United States real estate rentals.
Identify, dig up, and observe homes for rent by owner in Plains United States, condo rentals Plains United States, and rent house.
Debunk and glimpse rental home in Taliaferro Georgia, short term rentals in Taliaferro, and Taliaferro Georgia homes for rent by owner.
You can distinguish and find rental home in Watkinsville Georgia and Watkinsville Georgia vacation rentals.
Debunk and discern rental houses Wayne Georgia and rental houses.
Light upon and uncover rental houses in Allentown United States and vacation rental.
|
|
