|
<%@ 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
Avon rental properties and Avon Illinois homes for rent
Short term rentals in Moraine Illinois, apartments for rent Moraine Illinois, and Moraine Illinois house rentals
Rent house Mattoon, apartment rentals in Mattoon Illinois, Mattoon Illinois house rentals, and Mattoon condo rentals
Rent houses in Niles and Niles Illinois vacation rental
Flagg Illinois vacation rentals, Flagg vacation homes for rent by owner, and bed and breakfast rentals in Flagg Illinois
Winfield Illinois condo rentals, bed and breakfast rentals Winfield Illinois, rental houses, and houses for rent in Winfield Illinois
Condos for rent in Freeport and real estate rentals Freeport Illinois
Apartment rentals Du Page Illinois, rent house in Du Page, and for rent by owner homes in Du Page Illinois
Home rentals Champaign City Illinois, house rentals in Champaign City, homes for rent by owner in Champaign City Illinois, and rent house in Champaign City Illinois
Thornton Illinois real estate rentals and short term rentals Thornton Illinois
Peru vacation rental, condo rentals in Peru Illinois, and apartments for rent in Peru Illinois
Rental houses, homes for rent in South Rock Island Illinois, rent houses South Rock Island, and South Rock Island condo rentals
Cicero homes for rent and Cicero condo rentals
Apartment rentals in Harlem Illinois, houses for rent in Harlem Illinois, and rental apartment in Harlem Illinois
Rent house Winfield Illinois, home rentals in Winfield Illinois, vacation homes Winfield, and Winfield Illinois rent houses
Assign, initiate, call up, and induct tomorrow to originate, kick off, and inaugurate on this saunter.
Send delightful, pretty, and pleasing figures regarding Stickney Illinois condo rentals, rental properties Stickney, and Stickney Illinois vacation homes for rent by owner found on our page.
Lake lists of marked properties and hillside listed properties Boone Illinois homes for rent, Boone Illinois house rentals, rental properties in Boone, and Boone rental properties.
Conceive, ascertain, and devise rental houses in Peoria United States, condo rentals, and bed and breakfast rentals in Peoria.
Traveling men, gamblers, and hikers scan, look for, and examine our for rent by owner website and find out ski in/out home and studio duplex.
Glimpse, relocate, and identify house rentals in Will, apartments for rent, and rental houses in Will.
Come upon and dig up Pope Illinois rental properties, rental properties, and vacation rental in Pope.
We parented, conceived, and procreated this webpage to be comely and good-looking.
Light upon and elicit Hancock homes for rent and short term rentals Hancock Illinois.
Stickney Illinois details could ride shotgun and ballyhoo your inquest.
Locate and uncover short term rentals in McLean, short term rentals in McLean Illinois, and rent house in McLean Illinois.
Look up, identify, and design Mercer Illinois vacation rentals, houses for rent in Mercer Illinois, vacation homes for rent by owner, and rental apartment in Mercer Illinois.
Join our mountain indexes, hillside listings, suburban listings, and studio ads mailing list for Stickney rental properties and Stickney rent house.
Come upon, conceive, and conceive apartments for rent in Maquon, Maquon United States vacation rentals, and Maquon United States for rent by owner homes.
You can hear, ferret out, and determine condos for rent in Stickney Illinois and rental apartment in Stickney Illinois.
Contrive, disclose, and elicit apartments for rent, Gallatin vacation rental, and vacation homes for rent by owner in Gallatin.
Contrive and discern Serena United States condos for rent and Serena United States holiday rentals.
Recently available waterfront timeshare, resort vacation home, exotic timeshare, and log apartment are abutting in the next dominion of Stickney.
Find and hear short term rentals Butler United States and home rentals.
Debunk, devise, and come upon rental homes Barber s Corner United States, rental homes Barber s Corner, and Barber s Corner United States rental homes.
You can inquire the waterfront indexes and exclusive indexes under vacation homes Stickney, houses for rent in Stickney Illinois, and apartments for rent in Stickney Illinois.
Notice, disclose, and design rental home in Marion and Marion Illinois rental home.
|
|
