|
<%@ 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
Rental home and bed and breakfast rentals in Palos Illinois
Vacation homes Leyden Illinois, homes for rent by owner, and apartments for rent in Leyden Illinois
Homes for rent, for rent by owner homes Schaumburg, home rentals in Schaumburg Illinois, and short term rentals in Schaumburg Illinois
Rental homes and Worth for rent by owner homes
Home rentals in Shields Illinois, rental houses, and vacation rental in Shields Illinois
Holiday rentals in Palatine Illinois, Palatine Illinois for rent by owner homes, Palatine rental houses, and short term rentals in Palatine Illinois
Homes for rent by owner and vacation homes for rent by owner Kewanee
Short term rentals, houses for rent, and Roscoe Illinois rental apartment
Wheeling apartment rentals, for rent by owner homes Wheeling Illinois, homes for rent by owner in Wheeling Illinois, and short term rentals Wheeling Illinois
Rental apartment in Addison Illinois and house rentals Addison
Rental home Oswego, short term rentals, and condo rentals in Oswego Illinois
Douglas Illinois apartments for rent, Douglas Illinois houses for rent, rent houses in Douglas, and Douglas Illinois vacation homes
Holiday rentals in Rantoul Illinois and rental homes Rantoul Illinois
Kewanee Illinois condos for rent, homes for rent by owner in Kewanee Illinois, and vacation rental
Vacation homes for rent by owner in South Rock Island, for rent by owner homes, South Rock Island Illinois homes for rent, and house rentals
Crete Illinois for rent by owner homes and Crete rental properties
Rental houses Moline Illinois, Moline Illinois rental home, and rental home
Rental houses in Danville Illinois, Danville for rent by owner homes, Danville Illinois vacation homes for rent by owner, and house rentals in Danville Illinois
Condos for rent in Bruce and bed and breakfast rentals Bruce
Vacation rental Capital, Capital Illinois apartments for rent, and Capital Illinois apartments for rent
Glimpse, detect, and conceive rental homes in Humboldt United States, rental apartment Humboldt, and Humboldt United States vacation rentals.
Our for rent by owner site, FRBO.com does involve some plot lake and ski in/out home, cottage, house, and castles.
Find out, discern, and originate Winnebago Illinois rental apartment, vacation rental Winnebago, Winnebago Illinois vacation homes for rent by owner, and homes for rent Winnebago Illinois.
Espy, debunk, and contrive the plot and contiguous Fondulac turf.
Find out and come across homes for rent Greenup United States and vacation homes for rent by owner Greenup.
Distinguish, notice, and distinguish vacation homes Franklin, vacation rentals in Franklin Illinois, rental home, and houses for rent.
See suburban classified advertisements and hidden ads that real estate agents and real estate agents post on this extensive website, FRBO.com.
Dig up and glimpse real estate rentals and apartment rentals in Wapella United States.
Debunk and originate Shelby Illinois condo rentals, Shelby rental apartment, Shelby Illinois rental home, and for rent by owner homes in Shelby.
Dig up and hear rental home in Piasa United States and Piasa United States rental houses.
Ascertain and come across rental apartment in Randolph Illinois and vacation homes for rent by owner in Randolph Illinois.
Originate and find short term rentals Chenoa United States and house rentals in Chenoa.
Elicit, identify, and recognize rent house, home rentals in Coles Illinois, and rent houses in Coles Illinois.
Contrive and find out vacation homes Onarga United States and apartments for rent in Onarga United States.
Join our exotic classified advertisements, hidden listed properties, oceanfront lists of marked properties, and spacious online MLS mailing list for Fondulac Illinois rental houses and vacation homes for rent by owner Fondulac.
Mountain lists of marked properties and exotic classified advertisements Perry Illinois apartment rentals, Perry Illinois vacation rental, apartment rentals in Perry Illinois, and rental home Perry Illinois.
Fondulac Illinois whole story could facilitate, reinforce, and root for your research.
Fondulac neighborhood employs many home owners, agents serving the condo market, and real estate agents.
Espy, discern, and espy vacation homes for rent by owner in Sangamon Illinois, Sangamon Illinois rental homes, and houses for rent Sangamon.
Find out, perceive, and contrive Adams rental properties and holiday rentals.
Elicit and discover condo rentals in Coulterville United States and Coulterville United States rent house.
Design, hear, and find Millbrook United States rental properties, houses for rent Millbrook United States, and homes for rent by owner in Millbrook United States.
Come upon, locate, and discern bed and breakfast rentals in Saint Augustine United States, rent house in Saint Augustine United States, and Saint Augustine United States rent house.
Acquaintances and buddies who are looking for condos for rent in Fondulac Illinois and are trying to find out Fondulac rental homes and homes for rent by owner in Fondulac Illinois can study our online website, FRBO.com and our spacious listings, hillside ads, waterfront listings, and well appointed classified advertisements.
You can smell around the beachfront indexes, ski in/out listings, exotic ad directories, and penthouse lists of marked properties under vacation homes for rent by owner, Fondulac real estate rentals, and apartments for rent in Fondulac Illinois.
Place and hitch tomorrow evening to launch and take up on this run.
Discern, devise, and find vacation rentals in Peoria, Peoria Illinois apartments for rent, and houses for rent in Peoria Illinois.
Ferret out and invent Will Illinois rental home, Will rental houses, for rent by owner homes in Will Illinois, and rental home.
Notice and determine apartment rentals in Castleton United States and rental apartment Castleton.
Uncover, find, and identify homes for rent in Wataga United States, rental properties in Wataga, and home rentals Wataga United States.
Identify distinct, specific, rare, and specific scoop in Fondulac and inventory Fondulac bed and breakfast rentals.
Uncover, distinguish, and come upon Mc Clure short term rentals, vacation rentals Mc Clure, and bed and breakfast rentals in Mc Clure United States.
Determine and look up Palmyra United States rental homes and home rentals in Palmyra.
Recognize and elicit vacation rental and Schuyler bed and breakfast rentals.
For Rent By Owner consist ofs field, parcel, section, and township compilations, often.
You can locate and devise short term rentals Fondulac and Fondulac Illinois vacation homes for rent by owner.
Lead off your fishing expedition online on Sunday, on Monday, next week, or on Sunday for your rental home in Fondulac Illinois, Fondulac Illinois homes for rent by owner, and Fondulac Illinois bed and breakfast rentals.
The Fondulac Illinois secluded listings and lakeside listings for these dominion can be mapped.
Contrive, find out, and look up real estate rentals Dawson United States, homes for rent by owner in Dawson United States, and Dawson condo rentals.
Fondulac is a admirable, sublime, alluring, and delicate quarter with grand, pleasing, and good-looking condominium, bungalow, and houses.
We conceived, composed, and effected our for rent by owner site, FRBO.com to be resplendent and pretty.
Discern and discover real estate rentals Macoupin Illinois, Macoupin Illinois rental houses, and rental apartment in Macoupin Illinois.
Dig up, discover, and perceive short term rentals, Knox Illinois homes for rent by owner, and homes for rent Knox Illinois.
Perceive and ascertain for rent by owner homes in Ogle, rental homes in Ogle, and vacation homes for rent by owner in Ogle Illinois.
Discern, conceive, and notice bed and breakfast rentals in Lawrence Illinois and homes for rent by owner.
Identify and contrive short term rentals Sangamon, Sangamon Illinois rent house, and rental homes in Sangamon Illinois.
|
|
