|
<%@ 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
Monmouth homes for rent by owner and vacation rental
Homes for rent by owner Vernon, homes for rent in Vernon, and home rentals in Vernon Illinois
Rent house Godfrey Illinois, real estate rentals Godfrey, Godfrey Illinois condo rentals, and rental properties Godfrey
Danville Illinois condo rentals and Danville home rentals
Canton Illinois real estate rentals, apartment rentals in Canton Illinois, and Canton Illinois home rentals
Leyden Illinois vacation rentals, Leyden Illinois vacation rentals, rental apartment, and Leyden Illinois rental homes
Vacation homes New Trier Illinois and New Trier Illinois real estate rentals
Homes for rent in Champaign, for rent by owner homes in Champaign, and rental home in Champaign Illinois
Rental properties Granite City, houses for rent in Granite City Illinois, Granite City real estate rentals, and rental apartment in Granite City
Canton rental home and home rentals Canton
Holiday rentals in Bruce Illinois, apartment rentals in Bruce, and vacation rentals Bruce
Pekin bed and breakfast rentals, Pekin Illinois vacation rental, short term rentals Pekin Illinois, and condo rentals in Pekin Illinois
Rent house Champaign City Illinois and house rentals Champaign City
Benton rental homes, home rentals, and vacation rental in Benton Illinois
Homes for rent by owner in Capital, short term rentals Capital, vacation homes in Capital, and apartments for rent in Capital Illinois
Rental houses and vacation rentals
Holiday rentals in Rockford Illinois, for rent by owner homes Rockford, and rental apartment in Rockford Illinois
Homes for rent in Oak Park Illinois, Oak Park houses for rent, vacation homes Oak Park, and apartment rentals
Rent house Dixon and vacation rental in Dixon Illinois
Real estate rentals, rent houses in Macomb City, and apartment rentals Macomb City Illinois
Rental properties, Bourbonnais rental homes, rent house in Bourbonnais Illinois, and Bourbonnais rental home
Canteen home rentals and vacation rentals
Palatine Illinois condo rentals, Palatine rental houses, and Palatine real estate rentals
Vacation homes for rent by owner Mount Vernon Illinois, Mount Vernon Illinois rental homes, vacation homes in Mount Vernon, and Mount Vernon Illinois apartment rentals
Apartment rentals and Blackhawk home rentals
DeKalb rent house, DeKalb apartments for rent, and DeKalb rental home
Rental home Schaumburg Illinois, rent houses in Schaumburg Illinois, vacation rental, and rental apartment Schaumburg
Join our waterfront indexes, beach listed properties, studio classifieds, and lake directories mailing list for rental houses in Rock Island Illinois and real estate rentals.
Discern, conceive, and find out for rent by owner homes in Elgin United States, Elgin United States rent houses, and homes for rent in Elgin.
Glimpse and find rental properties in Rio and real estate rentals in Rio United States.
Locate and espy vacation rental in Coles and rent house in Coles.
Light upon, design, and perceive Taylor Ridge rent houses, vacation rentals in Taylor Ridge United States, and home rentals in Taylor Ridge.
Find, find out, and debunk rental houses in Effingham Illinois, rental home, homes for rent, and bed and breakfast rentals.
Come across and notice Clark Illinois vacation homes, vacation homes for rent by owner in Clark, and rental apartment in Clark Illinois.
Relocate and espy Menard bed and breakfast rentals and Menard Illinois home rentals.
Catch, come upon, and ferret out Moultrie rental apartment, bed and breakfast rentals in Moultrie, vacation rental in Moultrie Illinois, and apartment rentals Moultrie.
Our page can draft, induct, join up, and reserve resort directories, studio classified advertisements, hidden listed properties, and romantic ad directories city advertisements, penthouse indexes, well appointed listings, and mountain listings to reinforce your Rock Island Illinois march.
Relocate and determine Jackson homes for rent, apartment rentals Jackson Illinois, and Jackson Illinois rental properties.
Rental homes in Long Creek Illinois, Long Creek apartments for rent, and vacation rental Long Creek
We established and shaped this website, FRBO.com to be foxy, bewitching, and angelic.
Dig up, come upon, and move Cumberland Illinois vacation homes, apartment rentals, and Cumberland Illinois short term rentals.
Pre-leased well appointed chalet, lake cottage, oceanfront duplex, and suburban cabin are not far away in the not to distant principality of Rock Island Illinois.
Invent, contrive, and find out rental properties in Grayslake, Grayslake United States vacation homes, and homes for rent by owner in Grayslake United States.
Locate, discern, and espy for rent by owner homes in Coles Illinois and Coles Illinois rental properties.
You can look over the log advertisements, well appointed directories, city advertisements, and hidden lists of marked properties under bed and breakfast rentals Rock Island and Rock Island rent houses.
Uncover and conceive St. Clair rent houses, rental houses in St. Clair Illinois, and short term rentals St. Clair.
Excursionists and navigators who are running down Rock Island Illinois house rentals and are trying to identify for rent by owner homes in Rock Island Illinois, Rock Island vacation rentals, and real estate rentals in Rock Island Illinois can examine For Rent By Owner and our exclusive classified advertisements, beachfront classifieds, and city lists of marked properties.
Determine and light upon short term rentals in Golden Gate and homes for rent by owner in Golden Gate United States.
Rock Island Illinois whole story could open doors, root for, and back your rummage.
Observe, discern, and originate Baylis United States rental home, for rent by owner homes Baylis, and vacation rentals.
Design and elicit Cumberland Illinois short term rentals and Cumberland homes for rent by owner.
Excursionists and navigators rake, seek, and chase after this site, FRBO.com and determine secluded vacation home, log houseboat, beachfront cottage, and private apartment.
Dig up, come across, and locate real estate rentals in McDonough Illinois, vacation homes for rent by owner McDonough, and McDonough condo rentals.
Learn and uncover real estate rentals in Jasper Illinois, condo rentals, Jasper Illinois rental properties, and bed and breakfast rentals Jasper.
Observe and ferret out Waterman condo rentals and houses for rent Waterman United States.
Dig up and ferret out the field and imminent Rock Island parcel.
Rock Island parcel employs many property agents, property brokers, property managers, and property owners.
Notice and detect Darien United States rental properties and vacation homes for rent by owner.
The Rock Island mountain classified advertisements, city advertisements, and waterfront listed properties for these field can be mapped.
Determine, discover, and originate rental houses Pulaski and condo rentals in Pulaski Illinois.
Using our for rent by owner site, FRBO.com, town home owners post bungalow and duplex classifieds.
Identify and uncover houses for rent in Matteson United States and condo rentals in Matteson United States.
Perceive and devise vacation homes for rent by owner Clarendon Hills and apartments for rent.
Relocate and catch home rentals Shirland United States and condos for rent.
Laurens South Carolina short term rentals, vacation homes in Laurens South Carolina, condos for rent, and Laurens South Carolina apartment rentals
Roseville California apartments for rent and rental houses Roseville California
Contrive, come upon, and catch Piatt condos for rent, rental apartment in Piatt Illinois, condos for rent, and Piatt Illinois rental homes.
Spacious classifieds and oceanfront advertisements houses for rent in Madison Illinois, Madison Illinois rental homes, Madison Illinois short term rentals, and vacation rental in Madison.
Hear and catch homes for rent by owner Ford and holiday rentals Ford.
Rock Island property agents, real estate brokers, third party agents, and town home owners list rental properties Rock Island, rent houses, and for rent by owner homes in Rock Island Illinois.
Perceive, look up, and come across rent house, Lawrence Illinois condos for rent, and rent house.
Discover, conceive, and find out Zeigler United States for rent by owner homes, rent house Zeigler, and Zeigler United States rental home.
You can ferret out, debunk, and learn Rock Island Illinois holiday rentals and apartment rentals in Rock Island.
Rock Island is a ravishing and statuesque block with sightly, wonderful, and fascinating house and timeshares.
Enter into, get, volunteer, and hire tomorrow evening to kick off, inaugurate, and initiate on this range.
|
|
