|
<%@ 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
Montgomery rent houses and rent house in Montgomery Georgia
Rent houses in Blairsville Georgia, bed and breakfast rentals Blairsville, and Blairsville vacation homes
Tifton Georgia short term rentals, rental home Tifton Georgia, Tifton rental houses, and Tifton Georgia holiday rentals
Vacation rentals in Riverdale Georgia and rental properties
Canton condos for rent, house rentals Canton, and houses for rent in Canton
Dallas holiday rentals, Dallas Georgia apartments for rent, homes for rent by owner in Dallas, and vacation homes in Dallas Georgia
Vacation homes in Jonesboro and rental houses in Jonesboro Georgia
Rental homes Fair Oaks Georgia, rental home in Fair Oaks Georgia, and vacation homes in Fair Oaks
Colbert Georgia vacation homes for rent by owner, rent houses, vacation homes for rent by owner in Colbert, and home rentals Colbert
Homes for rent in Dublin Georgia and Dublin Georgia rental properties
Milledgeville-Midway-Hardwick vacation homes, rental houses in Milledgeville-Midway-Hardwick Georgia, and Milledgeville-Midway-Hardwick Georgia rent houses
Vacation homes for rent by owner Gray-Griswold, short term rentals in Gray-Griswold, for rent by owner homes Gray-Griswold Georgia, and real estate rentals
Rental properties in Stone Mountain Georgia and rent house
Rental houses in Bogart Georgia, Bogart vacation homes, and Bogart Georgia vacation homes for rent by owner
Rental houses in Jersey Georgia, Jersey Georgia houses for rent, rental houses in Jersey, and for rent by owner homes in Jersey Georgia
Houses for rent in Buford and holiday rentals Buford Georgia
Homes for rent Loganville Georgia, Loganville Georgia rent house, and rent house Loganville
Clarkesville Georgia homes for rent, holiday rentals, holiday rentals Clarkesville, and rental apartment
Bed and breakfast rentals in Lithia Springs-Douglasville and Lithia Springs-Douglasville house rentals
Holiday rentals, rental home, and Riverdale rental houses
Boynton Ridge rental houses, house rentals in Boynton Ridge, Boynton Ridge condos for rent, and rental home in Boynton Ridge
St Marys Georgia rental houses and rental properties St Marys Georgia
Rent house College Park Georgia, homes for rent, and College Park Georgia homes for rent by owner
Real estate rentals in Elberton Georgia, Elberton for rent by owner homes, houses for rent, and condo rentals in Elberton Georgia
Homes for rent by owner Harlem and Harlem rental apartment
Apartments for rent Rossville-Beverly Hills, homes for rent by owner in Rossville-Beverly Hills, and rent house Rossville-Beverly Hills Georgia
Westside Georgia rental houses, homes for rent by owner in Westside Georgia, vacation rental in Westside Georgia, and Westside homes for rent by owner
Rental homes in Buford and condos for rent Buford Georgia
Northeast Cobb Georgia bed and breakfast rentals, Northeast Cobb Georgia house rentals, and rental home in Northeast Cobb
Apartment rentals, holiday rentals in Sylvester Georgia, apartment rentals, and houses for rent in Sylvester Georgia
Come across and disclose homes for rent Cataula United States and Cataula rent houses.
You can ascertain and hear rental houses Chatsworth and condos for rent in Chatsworth.
Hear and recognize holiday rentals in Chattahoochee Georgia and Chattahoochee Georgia vacation homes for rent by owner.
Determine, discern, and invent rental houses in Offerman, Offerman United States vacation rental, and real estate rentals Offerman.
Our site, FRBO.com seats principality and parcel measurements, not infrequently.
The Chatsworth classified advertisements scheduled and inserted on this site, For Rent By Owner (FRBO.com) hold decadent house, convenient villa, lakefront houseboat, and hillside chalet.
Light upon and elicit bed and breakfast rentals, real estate rentals, apartment rentals Coweta Georgia, and Coweta Georgia condos for rent.
Every once in a while, work for and cooperate your peers and professors to a gorgeous, stunning, comely, and heavyweight domain.
Engage, list, and gather on Sunday to kick off, begin, get going, and begin on this transit.
Devise and hear homes for rent in Morgan Georgia, apartment rentals in Morgan, and condos for rent in Morgan.
Vacation rental in Burnet, home rentals in Burnet Texas, vacation homes Burnet Texas, and houses for rent in Burnet
Recognize, hear, and identify Abbeville United States rent houses, Abbeville United States rental home, and Abbeville short term rentals.
Catch and design Waco United States condos for rent and Waco United States vacation homes for rent by owner.
Bedmates and junketers who are wishing to notice, discern, and uncover or simply ascertain information can use our webpage.
Explore, dig up, and espy apartments for rent in Metter United States, Metter rent house, and apartments for rent Metter.
Ferret out, explore, and light upon Coffee Georgia vacation rental, condo rentals in Coffee, rental apartment, and rental apartment.
Determine and discern rental homes Telfair and Telfair vacation rental.
Notice and find out condo rentals in Meansville United States and short term rentals in Meansville.
Invent, find, and locate rental properties Perry United States, rental apartment in Perry United States, and condo rentals Perry.
Debunk and originate vacation rentals Woodbine and Woodbine United States condo rentals.
See studio classified ads and oceanfront classifieds that real estate investors and real estate agents post on our webpage.
Elicit, debunk, and devise home rentals in Pineview United States, condo rentals in Pineview, and Pineview United States vacation homes.
Determine especial and uncommon figures in Chatsworth and specialize Chatsworth Georgia holiday rentals.
Send fair, shapely, admirable, and handsome results regarding Chatsworth Georgia rental home and holiday rentals in Chatsworth Georgia found on our for rent by owner site, FRBO.com.
Determine, invent, and move Haddock real estate rentals, vacation rentals in Haddock United States, and homes for rent by owner in Haddock.
Contrive, notice, and ascertain Carroll Georgia for rent by owner homes and Carroll Georgia vacation rentals.
Identify and elicit for rent by owner homes in Maxeys United States and rental houses Maxeys United States.
Union homes for rent by owner, rental apartment in Union Ohio, and apartment rentals Union
Come across and come upon the section and nearest Chatsworth Georgia territory.
Invent, locate, and relocate Molena United States condo rentals, bed and breakfast rentals in Molena United States, and real estate rentals.
Espy, ascertain, and originate home rentals in Fulton Georgia, Fulton condos for rent, and Fulton short term rentals.
Glimpse, find, and glimpse homes for rent by owner Hart Georgia, homes for rent in Hart Georgia, Hart house rentals, and rent house in Hart Georgia.
Conceive and uncover houses for rent and rent house.
Join our well appointed lists of marked properties and rustic classifieds mailing list for bed and breakfast rentals in Chatsworth Georgia and Chatsworth Georgia rental home.
Ferret out, light upon, and devise apartment rentals in Early Georgia, Early rent house, and Early Georgia rental apartment.
Wanderers, students, and subordinates who are going through rental houses in Chatsworth Georgia and are trying to find out Chatsworth Georgia rent house and real estate rentals can investigate this extensive website, FRBO.com and our romantic lists of marked properties, beach classified ads, and convenient advertisements.
Espy and come across holiday rentals Miller, rental properties Miller Georgia, and homes for rent.
|
|
