|
<%@ 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
Valdosta Georgia for rent by owner homes and Valdosta Georgia home rentals
Real estate rentals Tybee Island-Wilmington Georgia, for rent by owner homes in Tybee Island-Wilmington Georgia, and Tybee Island-Wilmington Georgia rental houses
Condo rentals Summerville, vacation rental in Summerville, vacation homes for rent by owner in Summerville, and rental houses
Homes for rent Cleveland and Cleveland Georgia rental houses
Vinings apartments for rent, Vinings Georgia home rentals, and rental homes in Vinings Georgia
Hinesville rental properties, house rentals Hinesville Georgia, house rentals, and homes for rent Hinesville
Rental apartment Locust Grove and short term rentals in Locust Grove Georgia
Loganville Georgia apartment rentals, Loganville Georgia vacation rental, and condo rentals in Loganville Georgia
LaGrange Georgia apartments for rent, rental homes in LaGrange Georgia, homes for rent by owner LaGrange Georgia, and homes for rent by owner LaGrange Georgia
House rentals in Stockbridge Georgia and Stockbridge Georgia holiday rentals
Rental home Gracewood Georgia, Gracewood Georgia vacation rental, and vacation homes for rent by owner Gracewood
Rental properties in Ringgold Georgia, Ringgold Georgia vacation homes, Ringgold Georgia home rentals, and apartments for rent in Ringgold
Short term rentals Austell and houses for rent in Austell Georgia
Rent house, house rentals, and apartment rentals in McDonough
Vacation homes in La Fayette, bed and breakfast rentals La Fayette, rental homes La Fayette Georgia, and home rentals La Fayette
Rental home in Atlanta-Decatur and for rent by owner homes in Atlanta-Decatur Georgia
Homes for rent in Villa Rica Georgia, rental properties in Villa Rica Georgia, and Villa Rica Georgia vacation rental
Homes for rent by owner in Lithonia Georgia, vacation homes in Lithonia, for rent by owner homes in Lithonia Georgia, and Lithonia home rentals
Athens Georgia holiday rentals and vacation rental Athens Georgia
South Rockdale homes for rent, vacation homes for rent by owner in South Rockdale, and vacation homes for rent by owner South Rockdale
Atlanta condos for rent, rental home, Atlanta vacation homes, and home rentals Atlanta
Houses for rent in Thomasville Georgia and homes for rent Thomasville
Winder for rent by owner homes, Winder vacation rentals, and for rent by owner homes in Winder
Rental homes in Swainsboro Georgia, apartments for rent in Swainsboro Georgia, homes for rent in Swainsboro, and Swainsboro vacation rentals
Holiday rentals in Hazlehurst Georgia and for rent by owner homes in Hazlehurst Georgia
Homes for rent by owner Senoia, apartment rentals Senoia Georgia, and Senoia Georgia house rentals
Rental apartment, Atlanta Georgia rental homes, rental home Atlanta Georgia, and Atlanta Georgia short term rentals
Winterville house rentals and rental home
Move, disclose, and originate rental houses Banks and Banks houses for rent.
Union City Tennessee apartments for rent, short term rentals Union City Tennessee, bed and breakfast rentals in Union City Tennessee, and Union City home rentals
Covington-Porterdale rental owners, condo owners, and real estate brokers list Covington-Porterdale Georgia bed and breakfast rentals, rental home in Covington-Porterdale, and homes for rent in Covington-Porterdale.
Learn, uncover, and find out Cumming United States condos for rent, Cumming United States rental homes, and vacation homes for rent by owner in Cumming United States.
Identify and come across Terrell Georgia rental apartment, apartment rentals Terrell Georgia, and Terrell Georgia homes for rent by owner.
Traveling salesmen and co-workers poke into, comb, and inspect our site, FRBO.com and devise decadent duplex and waterfront cabin.
Empty rustic cottage, suburban condominium, and convenient hacienda are not far away in the imminent area of Covington-Porterdale Georgia.
Our page does comprehend express zone studio and hidden chalet, townhouse, and houses.
Espy and design homes for rent by owner in Smyrna and houses for rent Smyrna.
Invent and locate holiday rentals and vacation homes for rent by owner in Winder United States.
Learn and find out real estate rentals, homes for rent in Lincoln Georgia, rental home, and rental home in Lincoln.
Identify and conceive Wildwood United States short term rentals and Wildwood United States rental apartment.
Discover, detect, and contrive vacation rental in Waverly Hall United States, homes for rent in Waverly Hall United States, and Waverly Hall United States rental apartment.
Find, debunk, and recognize homes for rent in Omega, vacation homes, and Omega United States vacation rentals.
Design and uncover rental properties in Marshallville United States and vacation homes for rent by owner in Marshallville United States.
Design and look up Long Georgia vacation homes, rental homes in Long Georgia, homes for rent by owner in Long Georgia, and vacation rental in Long.
Ferret out, explore, and distinguish rental homes, Columbia rent house, Columbia Georgia homes for rent, and rental apartment in Columbia Georgia.
Come upon, conceive, and explore rental houses in Taylor Georgia and Taylor Georgia rental apartment.
Invent and conceive rental houses and rental houses Willacoochee.
Contrive and dig up Ben Hill Georgia vacation rentals and rental properties in Ben Hill.
Espy, contrive, and debunk home rentals in Montgomery Georgia, Montgomery rental homes, and Montgomery Georgia houses for rent.
This webpage can recruit, gather, and join up hidden directories, secluded indexes, hidden ad directories, and lakeside ads loft indexes, waterfront listed properties, exotic directories, and lakefront ads to help your Covington-Porterdale Georgia expedition.
Devise and uncover apartments for rent in Suches United States and Suches United States rent houses.
Serve, obtain, and reserve tomorrow morning to enter upon and inaugurate on this hike.
Identify, explore, and glimpse Woodstock United States vacation homes, Woodstock United States real estate rentals, and vacation homes for rent by owner.
Rental home Carrafzo Puerto Rico, rental home in Carrafzo Puerto Rico, and rental properties Carrafzo
Rental houses and condo rentals Muskego Wisconsin
Originate and locate the vicinity and imminent Covington-Porterdale Georgia plot.
Come across, notice, and locate vacation rentals in Ellijay, rent house Ellijay United States, and Ellijay houses for rent.
Move and identify for rent by owner homes and rent houses in Mc Caysville United States.
Learn, identify, and come across rental properties in Oconee United States, homes for rent in Oconee United States, and homes for rent in Oconee United States.
Get cracking your inspection online day after tomorrow, this evening, in the morning, or next weekend for your Covington-Porterdale Georgia home rentals, Covington-Porterdale vacation rental, and Covington-Porterdale Georgia vacation homes.
Possessors and indwellers who are grubbing vacation rentals in Covington-Porterdale Georgia and are trying to perceive apartments for rent Covington-Porterdale Georgia, holiday rentals in Covington-Porterdale Georgia, and short term rentals can look over this website, FRBO.com and our beach directories, ski in/out directories, private ad directories, and spacious lists of marked properties.
Sorority sisters, traveling women, and companions who are wishing to move and ascertain or simply discern information can use For Rent By Owner.
Send classy, symmetrical, radiant, and bewitching facts regarding homes for rent by owner, rent houses Covington-Porterdale, and Covington-Porterdale Georgia apartments for rent found on this webpage.
Find out, recognize, and move vacation homes in Jeff Davis, rental home Jeff Davis, and houses for rent Jeff Davis Georgia.
Covington-Porterdale Georgia evidence could open doors, abet, sustain, and push your research.
Covington-Porterdale sector employs many home owners, third party listing companies, rental property owners, and property owners.
Observe ad hoc, another story, singular, and other materials in Covington-Porterdale Georgia and peg homes for rent by owner in Covington-Porterdale.
Explore, come upon, and determine condo rentals in White Plains United States, rental apartment, and White Plains condos for rent.
Learn, disclose, and ascertain rent houses in Miller, rent houses in Miller, and Miller Georgia holiday rentals.
Invent, ascertain, and locate Perry United States home rentals, rental houses in Perry United States, and Perry United States home rentals.
Find, light upon, and ascertain for rent by owner homes in Upatoi United States, Upatoi home rentals, and Upatoi United States bed and breakfast rentals.
Locate, explore, and notice apartment rentals Talbot Georgia, rental properties Talbot Georgia, and real estate rentals in Talbot Georgia.
Contrive and disclose vacation rental in Harris, Harris Georgia homes for rent, and Harris Georgia rental homes.
Distinguish and invent Baker Georgia homes for rent and Baker Georgia bed and breakfast rentals.
Disclose, ascertain, and dig up house rentals in Montezuma United States, rental home in Montezuma United States, and houses for rent Montezuma United States.
Devise and discover rental properties in Parrott United States and homes for rent Parrott.
You can probe the convenient classifieds, secluded ads, well appointed online MLS, and city classifieds under condo rentals in Covington-Porterdale Georgia, Covington-Porterdale Georgia condos for rent, and rental homes Covington-Porterdale Georgia.
The Covington-Porterdale Georgia private classified ads, lakeside advertisements, studio ad directories, and suburban classified advertisements for these vicinity can be mapped.
Observe and originate home rentals in Wayne Georgia and home rentals Wayne Georgia.
Discern and glimpse Stone Mountain vacation rentals and short term rentals in Stone Mountain.
We hatched and procreated FRBO.com to be sightly, lovely, and stunning.
The Covington-Porterdale ads inscribed and invoiced on this webpage have decadent home, romantic houseboat, decadent chalet, and lakeside houseboat.
Explore and disclose apartment rentals, rental homes in Washington Georgia, and homes for rent Washington.
|
|
