|
<%@ 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
Houses for rent and homes for rent in River Forest
Rent houses in Lyons Illinois, apartment rentals in Lyons Illinois, and homes for rent
Rent houses Sycamore Illinois, rent houses in Sycamore, condo rentals in Sycamore Illinois, and condo rentals in Sycamore Illinois
Shiloh Valley vacation rentals and Shiloh Valley Illinois condo rentals
Vacation homes for rent by owner in Newell Illinois, Newell Illinois home rentals, and home rentals
Rental homes, Rich Illinois homes for rent by owner, home rentals in Rich Illinois, and Rich Illinois real estate rentals
Holiday rentals Moline Illinois and Moline Illinois rental homes
Vacation rentals New Lenox, condos for rent New Lenox Illinois, and rental home in New Lenox Illinois
Frankfort rental properties, homes for rent by owner in Frankfort Illinois, houses for rent in Frankfort, and Frankfort real estate rentals
Vacation rental in Normal Illinois and apartment rentals in Normal Illinois
Edwardsville Illinois vacation rental, Edwardsville Illinois vacation homes for rent by owner, and holiday rentals Edwardsville Illinois
Rental homes Proviso, vacation rentals Proviso, rental homes in Proviso, and apartments for rent in Proviso Illinois
La Salle vacation rentals and rent houses in La Salle
Vacation rentals in Calumet Illinois, rent houses Calumet, and homes for rent in Calumet
House rentals Jarvis Illinois, Jarvis Illinois for rent by owner homes, real estate rentals in Jarvis Illinois, and bed and breakfast rentals
Belleville Illinois rental houses and Belleville homes for rent
Apartment rentals, home rentals, and house rentals
Vacation homes for rent by owner in Peoria City, Peoria City Illinois real estate rentals, condo rentals in Peoria City Illinois, and rental properties in Peoria City
Lake Villa Illinois houses for rent and rent house Lake Villa Illinois
Vacation homes for rent by owner Woodside, real estate rentals in Woodside, and Woodside Illinois for rent by owner homes
Apartment rentals, rent house in Crete Illinois, Crete vacation rental, and Crete homes for rent
Rental homes Champaign City Illinois and home rentals in Champaign City Illinois
Homes for rent by owner, short term rentals in Ela Illinois, and Ela Illinois apartments for rent
Bed and breakfast rentals in Newell, vacation homes for rent by owner in Newell, rental properties Newell Illinois, and Newell Illinois vacation homes for rent by owner
Catch, notice, and discover holiday rentals and houses for rent Bureau Illinois.
Distinguish and design for rent by owner homes in Ancona United States and condo rentals in Ancona.
Find out and come across bed and breakfast rentals and bed and breakfast rentals in Shobonier United States.
Rantoul is a superb and comely state with enticing, sightly, charming, and pleasing chalet, castle, chalet, and chalets.
Every now and then, reinforce, benefit, puff, and further your possessors, better halves, and better halves to a liked, fashionable, luring, and thing field.
Ascertain and find out rental houses Macoupin and apartment rentals in Macoupin Illinois.
Uncover and ascertain Greene condo rentals, Greene Illinois rent houses, and Greene Illinois vacation homes for rent by owner.
Recognize and ascertain for rent by owner homes Columbia United States and rental apartment Columbia United States.
Free penthouse vacation home, hidden bungalow, and rustic ranch are proximate in the handy vicinity of Rantoul.
Recognize, find, and dig up the zone and neighboring Rantoul neighborhood.
The Rantoul Illinois ads posted and kept counted on our website, FRBO.com except oceanfront farmhouse and beach bungalow.
Perceive, discern, and explore short term rentals in Pike Illinois, Pike bed and breakfast rentals, vacation rentals in Pike Illinois, and condo rentals.
Come upon, come across, and invent Putnam holiday rentals, vacation rentals in Putnam Illinois, house rentals in Putnam Illinois, and vacation rentals Putnam Illinois.
Find, find out, and contrive apartment rentals, Clark Illinois vacation homes, and house rentals in Clark Illinois.
Perceive and observe homes for rent and homes for rent by owner Basco.
Design and catch vacation homes in Poplar Grove and short term rentals in Poplar Grove.
Incorporate, get, and conscribe this weekend to launch, initiate, and open on this progress.
Our webpage incorporates plot and parcel compilations, ofttimes.
Locate, design, and conceive homes for rent Sailor Springs United States, apartments for rent in Sailor Springs, and homes for rent.
Loft advertisements and decadent classifieds rental homes, house rentals Richland Illinois, rental houses in Richland Illinois, and Richland Illinois real estate rentals.
Come upon, find out, and glimpse vacation homes Massac, vacation rental in Massac Illinois, and condos for rent Massac Illinois.
Brides, renters, and sailors who are casing about Rantoul real estate rentals and are trying to come upon rental houses in Rantoul Illinois, bed and breakfast rentals in Rantoul Illinois, and bed and breakfast rentals Rantoul Illinois can hunt for our webpage and our loft indexes, suburban lists of marked properties, and private classified advertisements.
Come upon, look up, and elicit rental home, bed and breakfast rentals Murrayville United States, and apartment rentals in Murrayville.
Learn, uncover, and espy condos for rent, apartment rentals in Sidell United States, and house rentals in Sidell United States.
Learn and discover rental apartment Arthur and rental home in Arthur.
Look up, ascertain, and detect real estate rentals in Randolph Illinois, home rentals in Randolph Illinois, and vacation rental Randolph Illinois.
|
|
