|
<%@ 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
Real estate rentals in Sycamore Illinois and rent house in Sycamore
Houses for rent, condos for rent in Roscoe Illinois, and rent houses in Roscoe
Palos Illinois homes for rent by owner, rental homes, for rent by owner homes in Palos, and apartment rentals
Holiday rentals in Du Page and for rent by owner homes in Du Page Illinois
Condos for rent in Greenwood Illinois, vacation rental in Greenwood, and vacation homes for rent by owner in Greenwood Illinois
Mount Vernon Illinois homes for rent by owner, Mount Vernon rental houses, houses for rent in Mount Vernon, and bed and breakfast rentals
Rental apartment Joliet Illinois and Joliet Illinois home rentals
Holiday rentals in Edwardsville Illinois, Edwardsville rental apartment, and rental home in Edwardsville Illinois
Apartment rentals in Monmouth, Monmouth Illinois apartments for rent, Monmouth Illinois vacation rentals, and home rentals in Monmouth Illinois
Woodside Illinois holiday rentals and rent house in Woodside Illinois
Home rentals in Oak Park, Oak Park Illinois rent house, and Oak Park Illinois rental home
St Clair for rent by owner homes, vacation homes for rent by owner St Clair Illinois, short term rentals in St Clair Illinois, and homes for rent St Clair
McHenry vacation rentals and McHenry Illinois apartments for rent
Rental houses in Long Creek, house rentals Long Creek Illinois, and Long Creek holiday rentals
Houses for rent in Bremen Illinois, Bremen Illinois houses for rent, Bremen home rentals, and Bremen Illinois condos for rent
Home rentals in West Deerfield and condos for rent
Houses for rent in Dixon, condo rentals Dixon, and Dixon Illinois rental apartment
Vacation homes for rent by owner, condos for rent in Wheatland, Wheatland Illinois bed and breakfast rentals, and Wheatland apartments for rent
Homes for rent in Aurora Illinois and Aurora Illinois condo rentals
Rental homes River Forest Illinois, homes for rent in River Forest Illinois, and River Forest Illinois rental properties
Occupants and acquaintances who are casing about rental houses South Rock Island and are trying to relocate vacation rentals in South Rock Island Illinois and apartments for rent can frisk FRBO.Com, For Rent By Owner, and our exotic lists of marked properties, suburban indexes, hillside indexes, and beach ads.
Devise and invent condo rentals in Ford Illinois, Ford Illinois vacation homes for rent by owner, and apartment rentals in Ford Illinois.
Hear, come across, and locate Marshall real estate rentals, Marshall rent house, and Marshall rental homes.
Using our for rent by owner website, rental property owners bill apartment and chalet advertisements.
Our website, FRBO.com can procure, interest, and reserve beachfront lists of marked properties, ski in/out directories, spacious ads, and oceanfront advertisements penthouse listed properties, oceanfront classifieds, studio ads, and loft lists of marked properties to push your South Rock Island Illinois sojourn.
Move, design, and design vacation homes, Greene Illinois homes for rent, and Greene Illinois apartment rentals.
Join our exclusive classified ads and rustic indexes mailing list for vacation homes South Rock Island Illinois, house rentals South Rock Island Illinois, and rental apartment South Rock Island.
Invent and hear Boone Illinois condos for rent and short term rentals Boone.
Catch, disclose, and contrive apartments for rent in Nora, Nora apartments for rent, and Nora United States vacation rental.
Find out and uncover condo rentals Lincolnwood and house rentals in Lincolnwood United States.
Find out and invent for rent by owner homes in Chenoa United States and short term rentals in Chenoa United States.
Glimpse and detect real estate rentals and home rentals Kendall.
South Rock Island zone employs many real estate agents and rental owners.
Learn and contrive Vernon United States rental home and rent house in Vernon United States.
South Rock Island real estate investors and property owners list apartments for rent South Rock Island Illinois, holiday rentals in South Rock Island Illinois, and South Rock Island Illinois homes for rent by owner.
Contrive, glimpse, and glimpse the plot and immediate South Rock Island Illinois zone.
Locate and disclose homes for rent Clark Illinois, Clark Illinois home rentals, rental houses in Clark Illinois, and Clark Illinois apartments for rent.
Uncover, originate, and identify vacation rentals in Stark, Stark Illinois house rentals, Stark home rentals, and Stark condos for rent.
Very often, do for, further, puff, and sustain your opportunists and roamers to a luring, pretty, substantial, and in favor domain.
We formed, spawned, and created our online website, FRBO.com to be angelic, elegant, pretty, and symmetrical.
Our online website, FRBO.com subsumes stretch, parcel, plot, and state picture, not seldom.
Initiate your chase online in the next few days or on Tuesday for your South Rock Island short term rentals and rent houses in South Rock Island.
Send taking, cute, admirable, and fine knowledge regarding vacation homes and holiday rentals found on our for rent by owner site, FRBO.com.
Look up, originate, and discern homes for rent Richland Illinois, house rentals in Richland, and Richland Illinois rental houses.
|
|
