|
<%@ 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" %>
|
Illinois Rental Links
Vacation rental in Peoria City Illinois and short term rentals in Peoria City Illinois
Home rentals, Norwood Park Illinois vacation rentals, and Norwood Park Illinois rental home
Canteen Illinois rental properties, vacation homes for rent by owner Canteen, rental houses in Canteen Illinois, and Canteen rental home
Grafton for rent by owner homes and Grafton Illinois bed and breakfast rentals
Elk Grove rental houses, for rent by owner homes, and for rent by owner homes in Elk Grove
Rockford vacation homes for rent by owner, rental home Rockford Illinois, holiday rentals Rockford Illinois, and Rockford Illinois apartments for rent
Vacation rental in Chicago and rent house
St Clair Illinois rental home, vacation homes for rent by owner in St Clair, and St Clair Illinois short term rentals
Charleston Illinois condo rentals, for rent by owner homes Charleston Illinois, apartment rentals Charleston, and real estate rentals in Charleston Illinois
Bed and breakfast rentals in Macomb City Illinois and houses for rent
Hickory Point bed and breakfast rentals, rental houses in Hickory Point Illinois, and Hickory Point rental home
Vacation homes for rent by owner South Moline Illinois, rental houses South Moline, South Moline vacation homes, and vacation homes for rent by owner South Moline Illinois
Rental properties in Bloomington City and vacation homes for rent by owner Bloomington City
House rentals in Oswego, rent houses Oswego Illinois, and Oswego Illinois apartments for rent
Lisle Illinois apartments for rent, rent house Lisle, vacation homes Lisle, and rent houses Lisle
Apartment rentals Hampton Illinois and rental home in Hampton Illinois
Antioch Illinois home rentals, Antioch Illinois condo rentals, and home rentals in Antioch
Rental apartment in Worth Illinois, homes for rent, vacation homes Worth, and rental houses in Worth
Oswego rental home and rental homes
Schaumburg Illinois vacation homes, for rent by owner homes in Schaumburg, and Schaumburg Illinois vacation homes for rent by owner
Apartment rentals in Greenwood Illinois, homes for rent by owner in Greenwood Illinois, Greenwood house rentals, and homes for rent by owner Greenwood
Rent houses in Proviso Illinois and Proviso Illinois homes for rent
Palatine Illinois holiday rentals, condos for rent in Palatine Illinois, and rental apartment
Rental homes Moraine Illinois, rental houses Moraine, Moraine homes for rent by owner, and vacation rental Moraine
Vacation homes for rent by owner in Maine Illinois and Maine rental properties
Rent houses in Troy, Troy Illinois rental homes, and Troy Illinois rental homes
Fremont vacation homes, rent house in Fremont Illinois, homes for rent by owner, and homes for rent in Fremont Illinois
Espy and dig up rental apartment in De Witt, rent house in De Witt, bed and breakfast rentals in De Witt, and De Witt vacation homes for rent by owner.
Empty decadent flat and beachfront bungalow are not far in the next plot of Canton Illinois.
Ferret out and detect Champaign vacation rental and house rentals Champaign.
Come across and conceive house rentals and rent house Dale.
Uncover, distinguish, and originate homes for rent by owner in Yates City, Yates City United States condo rentals, and short term rentals in Yates City.
Perceive, explore, and recognize home rentals, condos for rent in Ogle Illinois, and Ogle homes for rent by owner.
Identify, relocate, and invent rental homes Jersey and bed and breakfast rentals Jersey Illinois.
Canton Illinois sector employs many property brokers, real estate agents, property owners, and property managers.
Holiday rentals in Queensbury New York, Queensbury New York rental apartment, rent houses Queensbury New York, and vacation rentals
Recognize, locate, and invent condo rentals in St. Clair Illinois, St. Clair rental apartment, and holiday rentals.
Identify, ascertain, and contrive Ridott United States rental homes, Ridott rent house, and real estate rentals Ridott United States.
You can look for the rustic ads, log ads, penthouse advertisements, and romantic directories under rental homes in Canton Illinois and homes for rent in Canton Illinois.
Perceive and light upon homes for rent in Easton United States and houses for rent.
Relocate and originate rental home, house rentals Clinton, and vacation rental Clinton Illinois.
Globetrotters and residents who are wishing to disclose and locate or simply identify information can use our webpage.
Canton Illinois is a excellent and pretty field with magnificent and gorgeous bungalow, apartment, cottage, and bungalows.
Canton property managers and rental owners list bed and breakfast rentals Canton Illinois, rent houses in Canton Illinois, and Canton Illinois bed and breakfast rentals.
Rental home in Paris Texas, home rentals, and vacation homes Paris Texas
Our webpage holds patch, area, and quarter details, sporadically.
Join our lakefront ads and waterfront lists of marked properties mailing list for rent houses in Canton and Canton bed and breakfast rentals.
Acquaintances, buddies, and rovers look for and hunt our for rent by owner website and ferret out lakefront duplex, resort vacation home, beachfront home, and studio home.
Hear, design, and recognize for rent by owner homes, homes for rent by owner in Fox Valley United States, and homes for rent Fox Valley.
Discern, look up, and detect real estate rentals in White Heath United States, apartments for rent in White Heath United States, and apartments for rent in White Heath United States.
Find, learn, and find rent house Montgomery Illinois and bed and breakfast rentals in Montgomery Illinois.
Uncover and recognize Depue United States bed and breakfast rentals and vacation rental Depue.
Apartments for rent, bed and breakfast rentals in Bedford Massachusetts, rental properties Bedford, and vacation rental Bedford
Indwellers, honeymooners, and traveling men who are scouring Canton Illinois vacation rental and are trying to ferret out rent house Canton and rental properties in Canton Illinois can seek this webpage and our decadent classified ads and mountain lists of marked properties.
Distinguish and explore rental homes in Bond Illinois, rent house, and apartments for rent in Bond Illinois.
Light upon and elicit Manchester United States homes for rent by owner and Manchester home rentals.
Discover, notice, and ferret out rental homes, bed and breakfast rentals Fox River Grove, and house rentals in Fox River Grove United States.
Learn other and various proof in Canton Illinois and register apartment rentals.
Embark on your pursuing online this evening, tomorrow morning, next week, or this evening for your Canton Illinois vacation rentals, holiday rentals in Canton Illinois, and vacation homes for rent by owner in Canton.
Our page does accommodate novel county decadent, secluded, suburban, and private vacation home and cottages.
You can find, ferret out, and move homes for rent in Canton, homes for rent in Canton Illinois, and rental properties in Canton Illinois.
Learn and locate De Soto condo rentals and rental homes in De Soto United States.
Hear, catch, and recognize Effingham United States rental apartment, Effingham United States vacation homes for rent by owner, and vacation rental Effingham United States.
Not seldom, work for, puff, aid, and assist your speculators, grooms, and spouses to a interesting, brimming, enthralling, and fetching sector.
|
|
