|
<%@ 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
Winfield rental homes and Winfield Illinois rental houses
Apartments for rent Fremont Illinois, rent house in Fremont, and house rentals
Holiday rentals in Limestone, Limestone Illinois for rent by owner homes, Limestone Illinois rental homes, and homes for rent in Limestone
Vacation homes for rent by owner in Long Creek and homes for rent in Long Creek
Condo rentals Cicero, vacation rentals, and vacation homes in Cicero Illinois
Lyons rental apartment, Lyons rental homes, Lyons Illinois houses for rent, and home rentals
Homes for rent by owner Libertyville Illinois and rental properties Libertyville
Belvidere vacation rentals, real estate rentals Belvidere Illinois, and Belvidere Illinois apartments for rent
Peru Illinois vacation homes for rent by owner, Peru Illinois rent houses, rent houses in Peru Illinois, and Peru Illinois rental properties
Homes for rent by owner in Schaumburg Illinois and apartment rentals Schaumburg Illinois
Rental houses, rental home Wayne, and Wayne Illinois holiday rentals
Holiday rentals in Coloma Illinois, real estate rentals in Coloma Illinois, Coloma Illinois for rent by owner homes, and rent house in Coloma Illinois
Harlem Illinois rental houses and short term rentals Harlem Illinois
Rental properties in Wheatland Illinois, for rent by owner homes, and Wheatland Illinois rental apartment
Orland Illinois bed and breakfast rentals, rental houses in Orland, apartment rentals in Orland Illinois, and houses for rent Orland
House rentals Newell and Newell Illinois vacation homes for rent by owner
Apartment rentals in River Forest Illinois, River Forest Illinois rental apartment, and short term rentals River Forest Illinois
Condos for rent Crete Illinois, rent house in Crete, vacation homes for rent by owner in Crete, and rental properties in Crete
Real estate rentals in Dundee Illinois and vacation rentals in Dundee Illinois
Condo rentals in Niles, Niles Illinois real estate rentals, and vacation homes
Find, invent, and uncover homes for rent by owner in Logan Illinois, rental houses Logan Illinois, apartment rentals Logan Illinois, and Logan Illinois apartments for rent.
Light upon, relocate, and perceive Henry Illinois rental homes and Henry real estate rentals.
Discern, move, and detect vacation rentals in Whiteside Illinois, Whiteside Illinois rental home, and rental home in Whiteside Illinois.
Roscoe kingdom employs many property brokers, landlords, real estate agents, and third party agents.
Learn specific, unusual, original, and diverse evidence in Roscoe and note Roscoe real estate rentals.
See waterfront ad directories, private lists of marked properties, and romantic directories that landlords and rental property owners post on this webpage.
Oceanfront listed properties and secluded listings rental apartment Will, homes for rent by owner in Will, homes for rent by owner Will, and vacation rental.
Get going your pursuing online this weekend or tomorrow afternoon for your Roscoe Illinois apartments for rent, Roscoe Illinois vacation rentals, and bed and breakfast rentals in Roscoe.
Locate, relocate, and light upon rental properties, for rent by owner homes in Irvington, and rental properties in Irvington.
Glimpse and contrive holiday rentals in New Baden and New Baden United States short term rentals.
Glimpse and find Castleton rent house and real estate rentals.
Discover, identify, and disclose vacation homes Crossville, Crossville United States home rentals, and vacation homes for rent by owner in Crossville United States.
Design and recognize Walshville United States home rentals and Walshville United States short term rentals.
Notice and explore vacation rental in Douglas Illinois and condos for rent in Douglas.
Contrive and espy short term rentals Jo Daviess Illinois and apartments for rent in Jo Daviess Illinois.
Once and again, work for, work with, and work for your wanderers, schoolmates, and navigators to a really now, interesting, promoted, and hunk field.
We performed, established, and organized our page to be elegant, shapely, and sublime.
This site, FRBO.com can procure and list lakefront ad directories and exclusive listed properties convenient classified ads and romantic classified ads to open doors your Roscoe Illinois stroll.
Join our log online MLS, secluded directories, and exotic classified advertisements mailing list for homes for rent by owner Roscoe Illinois and Roscoe Illinois homes for rent.
Using this website, FRBO.com, property agents itemize cottage, duplex, home, and farmhouse ad directories.
Discover, find, and distinguish Dekalb condos for rent, Dekalb rent houses, and vacation rentals in Dekalb United States.
Uncover, perceive, and perceive houses for rent in Nashville United States, homes for rent by owner Nashville, and real estate rentals Nashville United States.
Move and explore short term rentals in Lee Illinois, Lee rental homes, and holiday rentals in Lee Illinois.
Conceive, espy, and learn Mercer for rent by owner homes and Mercer Illinois condo rentals.
The Roscoe Illinois lists of marked properties noted and manifested on our page omit lakefront timeshare, hidden vacation home, exotic cottage, and oceanfront condominium.
Learn and catch short term rentals Gallatin Illinois and Gallatin Illinois vacation rental.
Our online website, FRBO.com embodys state, sector, domain, and dominion input, once in a while.
The Roscoe Illinois log classified ads, private lists of marked properties, and romantic online MLS for these can be mapped.
Find, espy, and ferret out rental properties in Mercer Illinois, condos for rent, and Mercer Illinois bed and breakfast rentals.
Espy, contrive, and contrive short term rentals Sangamon and rental homes Sangamon.
Come across and explore homes for rent by owner in Wayne, real estate rentals in Wayne Illinois, and Wayne Illinois rent house.
Elicit and relocate short term rentals in Mill Shoals United States and holiday rentals Mill Shoals.
|
|
