|
<%@ 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
Lizella homes for rent and home rentals
Vacation rental Chatsworth, Chatsworth Georgia rental houses, and vacation rentals in Chatsworth Georgia
Winder Georgia real estate rentals, homes for rent by owner in Winder Georgia, rental houses in Winder, and rent house Winder
Condos for rent College Park Georgia and vacation homes in College Park Georgia
Homes for rent in Macon, vacation homes for rent by owner in Macon Georgia, and Macon Georgia holiday rentals
Rent house in Ringgold, Ringgold Georgia rental home, homes for rent in Ringgold Georgia, and condo rentals in Ringgold
Vidalia-Lyons Georgia condos for rent and Vidalia-Lyons Georgia rental home
Rent houses in Big Creek Georgia, vacation homes for rent by owner, and house rentals
Houses for rent, homes for rent by owner in Barretts, house rentals Barretts, and Barretts apartment rentals
Savannah Georgia rental houses and rental properties in Savannah Georgia
Home rentals in Tucker Georgia, rental homes in Tucker Georgia, and vacation rental
House rentals in Barretts Georgia, holiday rentals Barretts, Barretts Georgia holiday rentals, and Barretts Georgia vacation homes for rent by owner
Eastman Georgia bed and breakfast rentals and homes for rent by owner in Eastman Georgia
Rental homes, for rent by owner homes Everett Georgia, and holiday rentals in Everett Georgia
Vacation homes Thomson Georgia, houses for rent Thomson Georgia, Thomson rental houses, and Thomson house rentals
Winterville Georgia bed and breakfast rentals and vacation homes for rent by owner in Winterville Georgia
Rent house in Kingsland Georgia, homes for rent by owner Kingsland, and Kingsland Georgia rental homes
Elberton apartments for rent, bed and breakfast rentals in Elberton Georgia, Elberton Georgia short term rentals, and short term rentals Elberton Georgia
Rent house Summerville and Summerville Georgia holiday rentals
Vacation rental in Cairo, Cairo rent houses, and rent house in Cairo Georgia
Devise and observe Liberty rental home, vacation homes for rent by owner in Liberty Georgia, and Liberty Georgia rental apartment.
Come upon, come upon, and locate home rentals, Franklin rental houses, and rental home Franklin.
Our site, FRBO.com can attract and reserve loft listings, beach online MLS, decadent ads, and well appointed listings hillside directories, log indexes, lakeside ads, and spacious classified advertisements to assist your Calhoun jaunt.
Distinguish, contrive, and dig up Crisp for rent by owner homes, Crisp bed and breakfast rentals, rental apartment in Crisp Georgia, and real estate rentals Crisp Georgia.
Observe and perceive bed and breakfast rentals and Mitchell vacation rentals.
You can scout the city ads and beach ads under condo rentals, Calhoun rental home, and Calhoun Georgia real estate rentals.
Identify and come across for rent by owner homes in Ellenton and rental houses.
Disclose and discover condos for rent Troup Georgia, short term rentals in Troup, apartments for rent Troup Georgia, and apartments for rent in Troup Georgia.
Locate and learn Union Georgia condo rentals, Union Georgia rental home, and rental home Union.
Espy and invent homes for rent by owner in Waynesville United States and house rentals in Waynesville United States.
Light upon, catch, and hear rental properties Brantley Georgia, Brantley Georgia condo rentals, Brantley Georgia rental houses, and vacation rental.
Fraternity members, commuters, and habitants who are wishing to light upon and light upon or simply perceive information can use FRBO.Com, For Rent By Owner,.
Calhoun third party agents, property agents, property owners, and brokers leasing foreclosures list rental homes Calhoun and rental properties Calhoun Georgia.
Discern, perceive, and find Boneville rental properties, rent house in Boneville United States, and rental home Boneville United States.
Distinguish and light upon homes for rent and vacation homes.
Explore and disclose real estate rentals Fayette Georgia and homes for rent Fayette Georgia.
Using our for rent by owner website, property brokers census farmhouse, flat, and flat advertisements.
Glimpse another story and novel circumstances in Calhoun Georgia and write down rent house Calhoun Georgia.
See convenient online MLS, romantic indexes, log classified ads, and well appointed listed properties that condo owners and real estate agents post on FRBO.Com, For Rent By Owner,.
Calhoun Georgia is a radiant and lovely quarter with stunning, refined, pleasing, and delicate timeshare, cottage, condominium, and ranchs.
Relocate and observe homes for rent by owner and vacation homes for rent by owner.
The Calhoun Georgia studio classified ads, waterfront listings, and oceanfront classifieds for these patch can be mapped.
Join our penthouse directories, convenient classifieds, and mountain indexes mailing list for homes for rent by owner Calhoun Georgia, Calhoun bed and breakfast rentals, and Calhoun Georgia vacation homes for rent by owner.
Our for rent by owner website does except extraordinary area penthouse, private, and penthouse cottage, duplex, houseboat, and ranchs.
Invent, come across, and come across Wilkinson rent houses and Wilkinson Georgia homes for rent by owner.
Find out and come across holiday rentals in Brantley, real estate rentals in Brantley Georgia, short term rentals in Brantley Georgia, and Brantley Georgia rent houses.
Observe, discover, and espy the turf and nearby Calhoun vicinity.
Contrive, identify, and ferret out Seminole Georgia vacation rentals and rental properties in Seminole Georgia.
You can light upon, identify, and glimpse homes for rent by owner and vacation rentals in Calhoun Georgia.
Find and discern houses for rent in Perkins and home rentals in Perkins.
|
|
