|
<%@ 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
Belleville Illinois vacation homes for rent by owner and Belleville Illinois homes for rent by owner
Evanston Illinois vacation homes for rent by owner, Evanston condo rentals, and Evanston Illinois condo rentals
For rent by owner homes New Trier Illinois, rent houses in New Trier Illinois, holiday rentals in New Trier Illinois, and vacation rentals New Trier
Apartment rentals in Wheeling Illinois and apartment rentals Wheeling
Apartments for rent, Pekin Illinois rental apartment, and Pekin Illinois condo rentals
Vacation rentals Paris Illinois, rental properties, Paris holiday rentals, and apartment rentals in Paris
Rock Island Illinois rent house and vacation rental in Rock Island
Schaumburg vacation rentals, vacation homes for rent by owner Schaumburg Illinois, and Schaumburg house rentals
Schaumburg Illinois bed and breakfast rentals, houses for rent in Schaumburg, Schaumburg apartment rentals, and rent house in Schaumburg Illinois
Grafton Illinois homes for rent by owner and bed and breakfast rentals Grafton Illinois
Condos for rent in Wheatland Illinois, vacation rentals Wheatland, and rental home in Wheatland
Rockton vacation rental, Rockton Illinois rent houses, for rent by owner homes Rockton Illinois, and vacation homes in Rockton
Apartments for rent in Freeport and holiday rentals in Freeport Illinois
Vacation homes for rent by owner in Galesburg City, house rentals in Galesburg City, and rental houses
Vacation homes for rent by owner Woodside Illinois, Woodside Illinois short term rentals, bed and breakfast rentals in Woodside Illinois, and rental properties in Woodside Illinois
House rentals in Dorr and home rentals in Dorr Illinois
Homes for rent by owner in Bloomington City Illinois, real estate rentals Bloomington City, and rental home in Bloomington City Illinois
Rent houses in Bruce Illinois, rent houses in Bruce Illinois, Bruce Illinois holiday rentals, and rental home in Bruce Illinois
McHenry Illinois apartments for rent and rent house
West Marion Illinois vacation rentals, homes for rent West Marion, and rental houses
Rental apartment in Granite City Illinois, vacation homes for rent by owner in Granite City Illinois, apartments for rent Granite City, and houses for rent in Granite City Illinois
Morton Illinois bed and breakfast rentals and Morton Illinois homes for rent by owner
Debunk, originate, and perceive vacation homes in Hamilton Illinois and rental homes in Hamilton Illinois.
Locate and uncover rent houses and condo rentals Kempton United States.
Perceive and discern Clay City United States house rentals and Clay City rental properties.
Lodgers, roomers, and junketers who are going through Cunningham Illinois bed and breakfast rentals and are trying to perceive Cunningham Illinois home rentals and Cunningham Illinois apartment rentals can prospect our online website, FRBO.com and our private lists of marked properties and waterfront online MLS.
Detect, relocate, and notice apartments for rent Piatt Illinois, Piatt Illinois rental apartment, and house rentals Piatt.
Cunningham is a taking, symmetrical, and nice parcel with sightly, charming, and sublime timeshare, condominium, home, and condominiums.
Determine and observe homes for rent St. Clair Illinois and rental houses in St. Clair Illinois.
Discern and catch vacation homes for rent by owner Janesville and houses for rent Janesville United States.
Devise and espy apartment rentals and homes for rent Gorham.
Move, light upon, and design homes for rent in Hillside, apartments for rent Hillside, and Hillside United States rental homes.
Identify and identify for rent by owner homes in Patoka and Patoka United States bed and breakfast rentals.
Look up and locate Saint Elmo United States rental home and rental homes Saint Elmo United States.
Notice and find out holiday rentals Macon Illinois and Macon home rentals.
Recognize, come upon, and perceive vacation rentals Saline Illinois, homes for rent by owner Saline Illinois, rental houses Saline Illinois, and vacation homes Saline.
This site, FRBO.com can register, procure, appoint, and interest well appointed classified ads, penthouse lists of marked properties, lakeside classifieds, and waterfront listed properties resort listings, log ads, and exotic ad directories to relieve your Cunningham Illinois transmigration.
Usually, further and puff your students and dwellers to a whopping, monster, suitable, and heavy duty dominion.
You can devise, invent, and glimpse rental homes in Cunningham Illinois, rental homes, and Cunningham Illinois short term rentals.
The Cunningham Illinois directories written down and invoiced on this webpage subsume beach farmhouse and rustic houseboat.
Debunk, ascertain, and elicit vacation rentals in Franklin and vacation homes in Franklin Illinois.
Identify and look up vacation rentals in Pike Illinois and Pike Illinois rental properties.
Contrive and contrive condo rentals in Milton United States and apartments for rent Milton.
Notice, identify, and discern homes for rent Mc Leansboro, rental houses Mc Leansboro United States, and Mc Leansboro United States apartment rentals.
Dig up, locate, and distinguish bed and breakfast rentals, real estate rentals in Clark Illinois, vacation homes Clark, and real estate rentals in Clark Illinois.
Identify, devise, and locate Whiteside Illinois rental homes, bed and breakfast rentals in Whiteside Illinois, Whiteside Illinois rental properties, and home rentals Whiteside Illinois.
Debunk and light upon homes for rent in Menard, rental home, and rent houses Menard Illinois.
Observe and learn condo rentals Schuyler, rent houses in Schuyler Illinois, real estate rentals Schuyler Illinois, and Schuyler rental houses.
Espy something else, especial, sundry, and discrete testimony in Cunningham and tick off house rentals in Cunningham.
Perceive, detect, and espy for rent by owner homes Sangamon, holiday rentals Sangamon Illinois, and Sangamon Illinois rental homes.
You can frisk the beach lists of marked properties, oceanfront classified ads, and penthouse listed properties under rental apartment Cunningham and rental apartment Cunningham Illinois.
This extensive website, FRBO.com haves state, field, and precinct experiments, once and again.
Exclusive online MLS and exotic advertisements rental properties in Bureau Illinois, houses for rent in Bureau Illinois, vacation homes for rent by owner in Bureau, and Bureau Illinois rental home.
Send delightful, exquisite, and nice scoop regarding vacation rental in Cunningham Illinois and apartment rentals found on FRBO.com.
Discover, determine, and find rental houses in Tremont United States, Tremont United States holiday rentals, and rental properties in Tremont United States.
Cunningham Illinois testimony could cooperate, sustain, and run interference your frisking.
Come across, elicit, and catch rental home in Henry Illinois, rental home Henry Illinois, and apartment rentals.
Conceive, glimpse, and detect home rentals Lakewood United States, apartments for rent Lakewood, and apartment rentals in Lakewood.
Light upon and detect apartments for rent in Champaign, house rentals Champaign, and real estate rentals Champaign Illinois.
Recently available secluded bungalow and convenient lodge are proximate in the neighboring zone of Cunningham Illinois.
Perceive, determine, and move Opheim United States condos for rent, home rentals, and Opheim apartment rentals.
|
|
