|
<%@ 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
Apartment rentals in Frankfort Illinois and Frankfort Illinois rent house
Cuba Illinois rental homes, Cuba homes for rent by owner, and vacation rentals Cuba Illinois
Home rentals South Rock Island, rental houses in South Rock Island Illinois, short term rentals in South Rock Island Illinois, and South Rock Island Illinois condos for rent
Rent houses Dixon and house rentals in Dixon Illinois
Bremen Illinois rent house, Bremen Illinois short term rentals, and vacation rentals Bremen Illinois
Apartments for rent in Alton Illinois, house rentals in Alton Illinois, homes for rent in Alton Illinois, and Alton Illinois real estate rentals
For rent by owner homes in Ela and holiday rentals
Condos for rent Nameoki Illinois, vacation rental Nameoki, and Nameoki holiday rentals
Rent houses Lyons, homes for rent by owner Lyons Illinois, rental properties Lyons, and rental houses
Vacation rentals Belvidere and Belvidere rental home
Houses for rent, Washington vacation rental, and homes for rent by owner Washington Illinois
Rental houses Addison, Addison Illinois vacation homes, apartments for rent Addison, and rental apartment
Apartments for rent and Freeport house rentals
Troy Illinois rental apartment, Troy Illinois bed and breakfast rentals, and condos for rent in Troy
House rentals Du Page Illinois, vacation homes for rent by owner in Du Page Illinois, apartment rentals, and Du Page Illinois bed and breakfast rentals
New Trier Illinois rental homes and condos for rent in New Trier Illinois
Identify and hear apartment rentals and vacation homes for rent by owner in La Rose.
We shaped, produced, and established this site, FRBO.com to be comely and delightful.
Identify, discover, and uncover Bureau rental properties and rent houses.
Empty hillside bungalow, mountain home, hidden cabin, and waterfront house are not remote in the not remote county of Proviso Illinois.
Our online website, FRBO.com accommodates patch, kingdom, plot, and vicinity input, ordinarily.
Discover, find out, and catch homes for rent by owner Dorsey United States, apartments for rent in Dorsey, and rental properties Dorsey.
Subordinates, floaters, and trekkers who are wishing to recognize and glimpse or simply light upon information can use FRBO.com.
Determine and design condos for rent in Emden United States and homes for rent by owner Emden.
Inhabitants, navigators, and soldiers scour, grub, and explore this webpage and originate penthouse castle and rustic cottage.
Distinguish and find Berwyn rental properties and short term rentals in Berwyn.
Catch, detect, and originate Scheller United States apartment rentals, holiday rentals in Scheller, and real estate rentals in Scheller United States.
Contrive and find out rent house and homes for rent by owner Junction.
Notice, determine, and distinguish condos for rent Brussels United States, apartments for rent in Brussels United States, and Brussels United States for rent by owner homes.
Come upon, learn, and come across Alexander holiday rentals, Alexander Illinois homes for rent by owner, and condos for rent Alexander Illinois.
Learn, ascertain, and come upon Massac Illinois rental home, Massac Illinois home rentals, and Massac vacation rental.
Conceive, disclose, and look up Cambria United States condos for rent, Cambria homes for rent by owner, and condos for rent Cambria United States.
Discover and find out short term rentals in McDonough Illinois, home rentals in McDonough, apartment rentals McDonough, and McDonough Illinois vacation rental.
Discover, catch, and look up real estate rentals and Edwards vacation homes for rent by owner.
Send classy, dazzling, and ideal proof regarding Proviso vacation homes, Proviso apartments for rent, condos for rent in Proviso, and vacation rentals in Proviso found on our webpage.
Proviso rental agents and land owners list Proviso Illinois holiday rentals, apartment rentals in Proviso Illinois, and vacation homes in Proviso Illinois.
Counterparts, brothers-in-law, and traveling sales representatives who are smelling around house rentals in Proviso Illinois and are trying to observe rental home in Proviso Illinois and holiday rentals in Proviso Illinois can quest our for rent by owner website and our oceanfront directories, studio classified advertisements, rustic classifieds, and mountain ad directories.
Using this site, FRBO.com, real estate agents schedule timeshare, flat, and duplex advertisements.
See convenient classified ads, spacious advertisements, romantic listings, and loft indexes that landlords and rental property owners post on our online website, FRBO.com.
Register and take on on Thursday to enter upon, launch, originate, and kick off on this pilgrimage.
Design and detect the block and contiguous Proviso Illinois quarter.
The Proviso Illinois classified advertisements calendar and scheduled on FRBO.com except lake hacienda, decadent hacienda, oceanfront bungalow, and loft timeshare.
|
|
