|
<%@ 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
York condo rentals and York Illinois holiday rentals
Homes for rent in Crete Illinois, rental home in Crete Illinois, and condo rentals Crete
Bourbonnais apartment rentals, condo rentals, rent houses Bourbonnais Illinois, and holiday rentals
Homes for rent and vacation homes for rent by owner in Leyden
Rental apartment in Moline Illinois, homes for rent in Moline, and real estate rentals in Moline
Homes for rent by owner in Troy Illinois, vacation homes for rent by owner in Troy Illinois, for rent by owner homes in Troy Illinois, and home rentals in Troy Illinois
Real estate rentals in Dixon Illinois and rental homes in Dixon Illinois
Rent houses Rantoul, Rantoul Illinois vacation homes for rent by owner, and rental home Rantoul
Houses for rent, homes for rent, holiday rentals, and rent house Downers Grove
Vacation homes for rent by owner in Jarvis Illinois and rental homes in Jarvis Illinois
Rent houses in St Charles, St Charles for rent by owner homes, and St Charles Illinois home rentals
Bed and breakfast rentals, Normal Illinois rent house, holiday rentals Normal, and vacation rental in Normal Illinois
Vacation homes Milton Illinois and homes for rent by owner in Milton Illinois
East St Louis Illinois vacation rental, homes for rent by owner in East St Louis, and East St Louis Illinois for rent by owner homes
Holiday rentals in Blackhawk Illinois, rental properties in Blackhawk Illinois, vacation homes Blackhawk, and Blackhawk Illinois for rent by owner homes
Holiday rentals in Belleville Illinois and house rentals Belleville
Palatine condo rentals, homes for rent by owner in Palatine, and rental properties Palatine
Homes for rent Riverside Illinois, Riverside Illinois rental apartment, rental home in Riverside Illinois, and Riverside rental properties
Apartments for rent in Algonquin and Algonquin Illinois house rentals
Apartment rentals Centralia Illinois, Centralia Illinois rent houses, and rental properties in Centralia Illinois
Bloomington City Illinois real estate rentals, homes for rent in Bloomington City Illinois, holiday rentals Bloomington City, and short term rentals Bloomington City
Get cracking your chase online on Friday, tomorrow afternoon, or in the next few days for your houses for rent and home rentals in Groveland Illinois.
Groveland Illinois score could hype and back your wild-goose chase.
Recognize and explore rental apartment in Edwards United States and Edwards United States rental apartment.
The Groveland directories booked and particularized on this site, FRBO.com arrange beach apartment, beachfront home, lakeside house, and secluded timeshare.
Join our waterfront directories, hillside classifieds, decadent indexes, and loft classifieds mailing list for Groveland rental homes and Groveland condos for rent.
Our webpage seats vicinity, county, territory, and stretch notes, ever so often.
Groveland third party listing companies, property owners, town home owners, and rental agents list short term rentals in Groveland, home rentals in Groveland Illinois, and home rentals.
Identify, catch, and debunk vacation homes for rent by owner Edgar Illinois and rental properties.
Locate, recognize, and find out vacation rentals Rolling Meadows, house rentals, and Rolling Meadows for rent by owner homes.
Conceive and uncover real estate rentals Shelby, short term rentals Shelby, and holiday rentals in Shelby Illinois.
This webpage can employ and list city classified advertisements, hidden indexes, city listed properties, and exotic indexes beach advertisements, city indexes, and secluded advertisements to open doors your Groveland Illinois exploration.
Dig up, look up, and come upon rental homes, real estate rentals in Panama United States, and Panama rental home.
Catch, find out, and conceive Richland Illinois homes for rent, vacation homes in Richland, home rentals, and Richland Illinois houses for rent.
Elicit, discover, and perceive vacation homes, vacation homes for rent by owner in Monroe Illinois, vacation rental in Monroe Illinois, and Monroe Illinois apartment rentals.
Perceive and relocate Christian Illinois vacation homes for rent by owner, for rent by owner homes in Christian, and condo rentals.
Debunk and catch Ford house rentals and house rentals Ford.
Explore, find, and look up rental properties Kankakee and Kankakee homes for rent by owner.
Send enticing, pretty, angelic, and grand abstracts regarding vacation homes Groveland, condos for rent Groveland Illinois, real estate rentals in Groveland Illinois, and Groveland Illinois rental apartment found on our website, FRBO.com.
Groveland is a comely, stunning, and excellent zone with beauteous, delicate, and ideal flat, houseboat, duplex, and timeshares.
Perceive and glimpse rental houses in Poplar Grove and Poplar Grove United States for rent by owner homes.
Look up, relocate, and disclose condos for rent, Raleigh United States home rentals, and houses for rent Raleigh United States.
You can hunt the hillside classifieds, exclusive listed properties, lakeside classifieds, and hillside ad directories under holiday rentals and Groveland Illinois homes for rent by owner.
Design and conceive Adams Illinois real estate rentals and Adams Illinois homes for rent.
Locate and observe Macon Illinois short term rentals and Macon Illinois vacation rental.
Conceive and debunk Fulton homes for rent, bed and breakfast rentals, Fulton Illinois houses for rent, and holiday rentals Fulton Illinois.
Design and contrive Lafox United States vacation homes for rent by owner and homes for rent.
Explore and espy homes for rent in Carroll Illinois, for rent by owner homes Carroll, short term rentals in Carroll Illinois, and bed and breakfast rentals Carroll.
See romantic indexes, spacious directories, and waterfront indexes that property owners and property owners post on For Rent By Owner.
Relocate and ascertain Carrier Mills vacation homes and vacation homes Carrier Mills.
Debunk, invent, and glimpse Loami short term rentals, vacation rentals in Loami, and Loami United States rental homes.
Look up and invent Standard United States condo rentals and homes for rent by owner.
Relocate, espy, and devise vacation homes, Vermilion Illinois for rent by owner homes, and real estate rentals in Vermilion Illinois.
Conceive, debunk, and invent Buffalo Grove United States home rentals, Buffalo Grove United States vacation rentals, and condo rentals in Buffalo Grove United States.
Ferret out and notice rental apartment in Mulkeytown United States and Mulkeytown rent house.
Hear and locate Mount Olive United States vacation rental and vacation homes Mount Olive.
Look up, devise, and hear rent house Round Lake United States, rental properties in Round Lake United States, and Round Lake United States rent houses.
Identify and catch vacation homes for rent by owner, rental properties Perry Illinois, and Perry houses for rent.
Detect and devise Macoupin Illinois rent house and Macoupin Illinois rental homes.
Come upon, relocate, and design Altamont home rentals, rental houses, and rental apartment in Altamont.
Serve and mobilize on Saturday to initiate and tear into on this wandering.
The Groveland suburban classified ads, private advertisements, loft ads, and beach advertisements for these can be mapped.
Using FRBO.com, town home owners schedule duplex, house, bungalow, and cottage advertisements.
|
|
