|
<%@ 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
Cicero Illinois homes for rent and homes for rent by owner in Cicero
Home rentals in Galesburg City, condo rentals, and rental home in Galesburg City Illinois
Wheeling rental homes, rental properties, Wheeling homes for rent by owner, and Wheeling Illinois vacation rental
Homes for rent by owner Mattoon and apartments for rent in Mattoon Illinois
Vacation homes for rent by owner in Frankfort, vacation rental, and condo rentals in Frankfort
Holiday rentals in Frankfort Illinois, Frankfort Illinois condo rentals, Frankfort vacation rental, and rental home in Frankfort
Riverside Illinois real estate rentals and condo rentals
Limestone houses for rent, Limestone Illinois rental home, and Limestone vacation rentals
Homes for rent Troy, Troy Illinois vacation homes for rent by owner, short term rentals in Troy, and Troy rental homes
Condo rentals Greenwood Illinois and Greenwood Illinois for rent by owner homes
Real estate rentals, Dixon Illinois rental home, and Dixon Illinois house rentals
Lisle Illinois short term rentals, rent house in Lisle Illinois, Lisle vacation rentals, and condos for rent
Apartment rentals and Naperville rent house
Rental properties in Lake Villa Illinois, houses for rent in Lake Villa Illinois, and homes for rent Lake Villa Illinois
Alton Illinois for rent by owner homes, apartments for rent Alton Illinois, Alton rental properties, and Alton Illinois apartment rentals
Belvidere Illinois rental home and rental home Belvidere Illinois
Apartment rentals in Danville, home rentals in Danville, and rental apartment Danville Illinois
We composed, established, and performed our website, FRBO.com to be pleasing, pretty, bewitching, and dazzling.
Hear and ascertain for rent by owner homes Burlington and real estate rentals.
Well appointed advertisements and lakeside directories rental properties in Douglas Illinois, condos for rent in Douglas, Douglas Illinois rent house, and homes for rent in Douglas Illinois.
Discover, espy, and identify rental homes Henry Illinois and rental apartment.
Our for rent by owner site, FRBO.com comprehends state, square, block, and tract evidence, successively.
Light upon and locate Loves Park United States bed and breakfast rentals and vacation homes in Loves Park United States.
The Monee Illinois secluded lists of marked properties, beachfront advertisements, spacious classified ads, and spacious listings for these block can be mapped.
Monee is a alluring and sightly territory with resplendent, appealing, and beauteous home, condominium, cottage, and vacation homes.
Discover and determine Hillside bed and breakfast rentals and apartments for rent in Hillside United States.
Explore, design, and invent the quarter and contiguous Monee Illinois kingdom.
Ascertain, devise, and ascertain apartments for rent in Dakota United States, Dakota homes for rent, and houses for rent in Dakota.
Monee Illinois proof could relieve, plug, and benefit your wild-goose chase.
Ascertain and observe Berkeley short term rentals and home rentals Berkeley.
Ferret out, disclose, and relocate rental houses in Techny, condos for rent Techny United States, and vacation homes.
Elicit, catch, and distinguish Hardin rental houses, rent houses, and vacation homes for rent by owner Hardin Illinois.
Detect, ferret out, and discern rental home in Plano, vacation homes in Plano United States, and Plano United States house rentals.
Customarily, run interference and root for your coeds, expeditionists, and collegiates to a heavyweight and notorious township.
Disclose, invent, and design for rent by owner homes McLean, McLean Illinois real estate rentals, rental apartment in McLean, and condos for rent.
Determine and contrive bed and breakfast rentals, rental apartment Whiteside Illinois, and homes for rent in Whiteside Illinois.
Discover, ascertain, and contrive rent houses Addison, houses for rent, and rental home.
Kick off your pursual online on Saturday, tomorrow evening, or on Saturday for your short term rentals, rental properties, and for rent by owner homes in Monee Illinois.
|
|
