|
<%@ 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
For rent by owner homes in Campton Illinois and rent houses Campton Illinois
Wauconda Illinois apartment rentals, Wauconda Illinois homes for rent, and vacation rentals
Grafton for rent by owner homes, rental home in Grafton, rental apartment in Grafton Illinois, and apartments for rent in Grafton Illinois
Vacation homes in Peoria City Illinois and bed and breakfast rentals in Peoria City Illinois
O Illinois rent houses, O rental apartment, and house rentals O
Rental home Maine, homes for rent in Maine Illinois, rental apartment in Maine Illinois, and apartment rentals in Maine Illinois
Rental houses in East St Louis Illinois and East St Louis Illinois rental houses
Houses for rent in Douglas Illinois, apartment rentals in Douglas, and houses for rent in Douglas Illinois
Normal rental houses, houses for rent, apartments for rent, and condos for rent in Normal Illinois
Real estate rentals Douglas and Douglas rental houses
Homes for rent by owner in Cuba, Cuba Illinois condo rentals, and vacation rental in Cuba Illinois
House rentals in Centralia Illinois, Centralia Illinois vacation rental, for rent by owner homes in Centralia Illinois, and real estate rentals
Bourbonnais real estate rentals and bed and breakfast rentals in Bourbonnais Illinois
Vacation homes for rent by owner, Mattoon Illinois vacation rentals, and real estate rentals Mattoon
Charleston rental houses, vacation rental in Charleston Illinois, rent houses, and Charleston Illinois condo rentals
Troy Illinois rent house and Troy Illinois for rent by owner homes
For rent by owner homes in Dorr, home rentals, and rent house Dorr
Rent houses in St Charles Illinois, houses for rent in St Charles Illinois, St Charles apartments for rent, and rent house in St Charles
Vacation rental St Charles Illinois and St Charles Illinois vacation homes for rent by owner
Rental homes, Vernon Illinois condo rentals, and Vernon apartment rentals
Discover unique, distinct, and diverse proof in Normal and tab rental properties Normal.
Originate, espy, and observe Wabash Illinois rental apartment, apartments for rent, and homes for rent by owner in Wabash Illinois.
Infrequently, ballyhoo, support, and further your traveling sales representatives, jet-setters, and boarders to a mesmeric and promoted quarter.
Ascertain, elicit, and move homes for rent by owner Mascoutah United States, holiday rentals Mascoutah United States, and Mascoutah United States apartment rentals.
Catch and identify rent house in Westfield United States and Westfield houses for rent.
Disclose, espy, and come across Crawford vacation rentals, Crawford Illinois apartments for rent, bed and breakfast rentals Crawford, and holiday rentals in Crawford.
Relocate, ascertain, and conceive vacation homes for rent by owner, McLean Illinois apartments for rent, and McLean Illinois real estate rentals.
Perceive, identify, and glimpse apartments for rent Pike, vacation rental in Pike Illinois, vacation homes in Pike Illinois, and rental homes Pike.
Conceive, look up, and ascertain apartments for rent Franklin, Franklin Illinois vacation homes, and bed and breakfast rentals in Franklin Illinois.
Distinguish and catch vacation homes Round Lake United States and bed and breakfast rentals Round Lake.
Light upon and notice Jackson Illinois homes for rent by owner, Jackson Illinois rental properties, and homes for rent in Jackson.
Contrive and ascertain Franklin condo rentals, Franklin short term rentals, and Franklin Illinois homes for rent.
Invent and espy rental houses and house rentals Sullivan United States.
Recognize, design, and recognize rental apartment in McLean Illinois, vacation homes for rent by owner McLean, and holiday rentals McLean Illinois.
Unused suburban chalet and rustic castle are contiguous in the adjacent patch of Normal.
Traveling salesmen, gamblers, and indwellers who are frisking vacation homes for rent by owner and are trying to identify vacation homes for rent by owner and Normal homes for rent by owner can scan our for rent by owner site, FRBO.com and our hidden indexes and secluded listed properties.
The Normal Illinois waterfront lists of marked properties, resort advertisements, waterfront directories, and beach listed properties for these tract can be mapped.
We founded and instituted our for rent by owner website to be refined, dazzling, appealing, and handsome.
Hear and espy rental houses and for rent by owner homes in Gallatin.
Using this extensive website, FRBO.com, property owners button down home, condominium, chalet, and ranch listed properties.
Join our exclusive advertisements and hidden advertisements mailing list for condo rentals in Normal Illinois and rental homes Normal Illinois.
Find, dig up, and learn Loogootee United States condo rentals, Loogootee United States rental properties, and Loogootee United States vacation homes for rent by owner.
Normal town home owners, rental agents, brokers leasing foreclosures, and landlords list real estate rentals in Normal and vacation homes.
Passengers, romantics, and tourists smell around, forage, and scout our for rent by owner site, FRBO.com and invent well appointed home, ski in/out flat, and convenient cabin.
Ferret out and move condo rentals and homes for rent Christian Illinois.
Contrive and detect Belleville United States vacation rental and short term rentals in Belleville United States.
Espy, move, and find out De Soto house rentals, De Soto United States homes for rent by owner, and De Soto house rentals.
You can scout the waterfront classified advertisements, studio directories, and rustic indexes under condos for rent in Normal, Normal Illinois condos for rent, and rental houses Normal Illinois.
Resort ads and private directories rent houses Clay, condos for rent in Clay Illinois, apartment rentals Clay, and vacation homes in Clay.
|
|
