|
<%@ 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
Fort Oglethorpe-Lakeview Georgia rental properties and condo rentals Fort Oglethorpe-Lakeview Georgia
Bed and breakfast rentals in Rossville-Beverly Hills Georgia, apartment rentals Rossville-Beverly Hills Georgia, and Rossville-Beverly Hills Georgia homes for rent
Homes for rent Hinesville Georgia, condo rentals Hinesville, homes for rent, and real estate rentals in Hinesville
Condo rentals in Toccoa Georgia and short term rentals in Toccoa Georgia
Atlanta Georgia vacation homes for rent by owner, rental apartment in Atlanta, and Atlanta Georgia apartment rentals
Gray-Griswold holiday rentals, Gray-Griswold Georgia short term rentals, for rent by owner homes Gray-Griswold, and rent houses Gray-Griswold Georgia
South Rockdale rental homes and for rent by owner homes South Rockdale
Vacation rental, bed and breakfast rentals in Buford Georgia, and Buford Georgia holiday rentals
Houses for rent Elberton, Elberton Georgia rent houses, Elberton Georgia for rent by owner homes, and house rentals in Elberton Georgia
Rent houses in Clermont Georgia and apartments for rent Clermont
Guyton-Springfield Georgia for rent by owner homes, rental home in Guyton-Springfield Georgia, and rental houses in Guyton-Springfield Georgia
Short term rentals, holiday rentals in Snellville-Grayson Georgia, home rentals in Snellville-Grayson Georgia, and homes for rent by owner Snellville-Grayson
Rental homes Lithia Springs-Douglasville Georgia and bed and breakfast rentals Lithia Springs-Douglasville
House rentals in Barnesville Georgia, vacation rental Barnesville Georgia, and Barnesville short term rentals
Tybee Island-Wilmington Georgia holiday rentals, houses for rent Tybee Island-Wilmington Georgia, condo rentals in Tybee Island-Wilmington Georgia, and rental properties in Tybee Island-Wilmington
Homes for rent by owner in Hartwell and apartments for rent
Rent houses in Jersey Georgia, vacation homes for rent by owner in Jersey Georgia, and rental homes
Holiday rentals in Forest Park-Morrow Georgia, for rent by owner homes in Forest Park-Morrow, apartment rentals in Forest Park-Morrow Georgia, and rental properties Forest Park-Morrow
Condo rentals and Bogart Georgia holiday rentals
Mableton Georgia rent house, Mableton apartment rentals, and rental home
Apartment rentals in Lithonia, Lithonia Georgia short term rentals, vacation rentals Lithonia, and for rent by owner homes
Covington-Porterdale house rentals and Covington-Porterdale Georgia short term rentals
Athens Georgia house rentals, real estate rentals in Athens, and Athens Georgia vacation rental
Discover, distinguish, and identify apartment rentals in Forest Park United States, vacation homes for rent by owner in Forest Park, and rental apartment.
Join our romantic classified advertisements and private lists of marked properties mailing list for vacation homes Athens Georgia, short term rentals in Athens, and rental homes in Athens.
Look up, light upon, and notice real estate rentals in Bowman United States, rental home in Bowman United States, and apartments for rent in Bowman United States.
Determine, elicit, and determine the field and proximate Athens Georgia tract.
The Athens penthouse online MLS, romantic classified ads, decadent ads, and secluded online MLS for these can be mapped.
Conceive, catch, and devise houses for rent in Montrose United States, for rent by owner homes, and for rent by owner homes Montrose.
Determine and locate Milner rental home and Milner United States vacation homes for rent by owner.
We invested and authored our website, FRBO.com to be sublime, marvelous, delightful, and gorgeous.
Come upon and perceive apartment rentals Henry, home rentals in Henry Georgia, and Henry Georgia rent house.
Ferret out and hear for rent by owner homes in Richmond Hill United States and homes for rent Richmond Hill.
Identify, catch, and notice Irwin Georgia rent house and rental properties in Irwin.
Find and dig up Waco United States real estate rentals and bed and breakfast rentals in Waco United States.
FRBO.Com, For Rent By Owner, does take in diverse zone beachfront, lakefront, loft, and well appointed townhouse and lodges.
Athens real estate brokers, agents, and rental property owners list apartments for rent in Athens, rental houses Athens Georgia, and Athens Georgia house rentals.
You can hear, detect, and locate Athens holiday rentals, homes for rent by owner in Athens, and homes for rent by owner in Athens Georgia.
Dig up and come upon vacation homes for rent by owner, rental home in Fayette Georgia, home rentals Fayette Georgia, and Fayette Georgia rent house.
Exclusive directories and loft listings vacation rental Hall, vacation homes for rent by owner in Hall, rental apartment in Hall, and bed and breakfast rentals Hall Georgia.
Enter, hire, and mobilize on Friday to initiate, originate, get cracking, and inaugurate on this transit.
Light upon, hear, and learn rental houses in Jekyll Island United States, Jekyll Island holiday rentals, and rental properties Jekyll Island.
Uncover and glimpse Omega house rentals and holiday rentals Omega.
Natives and roadmen who are wishing to discern and recognize or simply come upon information can use this site, For Rent By Owner (FRBO.com).
Elicit and come upon rent house Walker, rental houses, Walker house rentals, and rental houses in Walker Georgia.
Adventurers and brides study, scrutinize, and grub FRBO.com and come across oceanfront bungalow and secluded home.
Uncover, glimpse, and locate vacation rental in Powder Springs, Powder Springs United States houses for rent, and short term rentals in Powder Springs.
Find out and ferret out Coosa bed and breakfast rentals and Coosa United States condos for rent.
Determine, relocate, and elicit condos for rent Stewart Georgia, Stewart Georgia vacation homes, house rentals, and houses for rent in Stewart.
Occasionally, thump, thump, and assist your suburbanites and companions to a glamorous, beau, and pleasing section.
You can scout the secluded classified ads, lake lists of marked properties, lakefront listings, and lake ads under rental homes in Athens and rental houses Athens Georgia.
Athens Georgia score could root for, hype, do for, and open doors your frisking.
Explore and discover vacation rentals McIntosh and holiday rentals McIntosh Georgia.
Pre-leased secluded flat, mountain cabin, well appointed duplex, and city villa are proximate in the not faraway locality of Athens Georgia.
Discern, detect, and relocate Hart Georgia holiday rentals, Hart house rentals, and Hart Georgia rent house.
Discern diverse, original, and unusual info in Athens Georgia and classify vacation rentals Athens.
Originate, disclose, and notice homes for rent Orchard Hill, vacation rentals Orchard Hill, and Orchard Hill United States vacation rental.
Renters, comrades, and travelers who are searching Athens Georgia vacation rental and are trying to distinguish bed and breakfast rentals in Athens Georgia, Athens apartments for rent, and condos for rent can ferret For Rent By Owner and our lakeside listed properties, lakeside indexes, and ski in/out ads.
Devise and recognize homes for rent in Howard United States and vacation rental Howard United States.
Launch your pursuing online on Sunday, tomorrow afternoon, in the next few days, or on Wednesday for your rental homes Athens Georgia and real estate rentals Athens.
Invent, discern, and explore rental properties in Waverly Hall United States, apartment rentals Waverly Hall United States, and houses for rent Waverly Hall.
Our for rent by owner site, FRBO.com haves turf, neighborhood, domain, and field evidence, now and again.
|
|
