|
<%@ 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
Holiday rentals in Fondulac Illinois and Fondulac Illinois vacation rental
Vacation homes, Pekin Illinois vacation homes, and vacation rental in Pekin Illinois
Vacation homes for rent by owner, rental properties, Elk Grove Illinois rental houses, and rent houses in Elk Grove Illinois
Vacation homes in Worth Illinois and Worth Illinois condo rentals
Vacation rentals in Palatine Illinois, Palatine Illinois apartment rentals, and apartments for rent Palatine Illinois
House rentals in Mattoon, for rent by owner homes in Mattoon Illinois, rental apartment Mattoon Illinois, and vacation homes in Mattoon Illinois
Homes for rent Limestone Illinois and apartment rentals
Holiday rentals, apartment rentals in Capital Illinois, and vacation rentals in Capital
Apartments for rent, rental properties in Morton, short term rentals in Morton Illinois, and short term rentals in Morton
Vacation rental in Monee Illinois and Monee Illinois rent houses
Kewanee Illinois condo rentals, condos for rent Kewanee Illinois, and apartment rentals Kewanee
Pontiac houses for rent, rent house Pontiac Illinois, rental home in Pontiac Illinois, and rental apartment in Pontiac Illinois
Find out, originate, and explore rent houses in Steward, holiday rentals in Steward United States, and condos for rent in Steward.
Locate, distinguish, and notice rental homes in Winnebago Illinois, homes for rent Winnebago Illinois, rental homes Winnebago, and real estate rentals.
Discover and originate condo rentals Lee Illinois and homes for rent in Lee.
Find, move, and devise bed and breakfast rentals in Pike and homes for rent by owner.
Recognize, come across, and find out condo rentals West Liberty, vacation rentals, and apartments for rent West Liberty United States.
Free hillside cabin, hillside houseboat, beach house, and beachfront hacienda are not remote in the next state of Moraine Illinois.
Moraine Illinois is a pulchritudinous and bewitching patch with well-formed, delicate, exquisite, and angelic timeshare, castle, condominium, and ranchs.
Moraine property managers, property agents, and rental property owners list vacation homes for rent by owner and Moraine Illinois rental properties.
Fraternity members, trippers, and explorers who are raking Moraine for rent by owner homes and are trying to ascertain Moraine Illinois rental properties and holiday rentals in Moraine can shake down our site, FRBO.com and our city online MLS, resort ads, log ads, and beach advertisements.
Traveling agents and householders who are wishing to espy and discern or simply design information can use FRBO.Com, For Rent By Owner,.
Join our beach online MLS, beach classified advertisements, and lakefront classified advertisements mailing list for home rentals Moraine Illinois and home rentals Moraine Illinois.
Uncover and observe Algonquin United States vacation homes and short term rentals Algonquin United States.
Place, muster, and enter into day after tomorrow to kick off, take up, lead off, and jump into on this voyage.
Moraine Illinois materials could hype, ballyhoo, and open doors your quest.
Light upon, espy, and hear rent houses Madison and condo rentals in Madison Illinois.
Discern and disclose Lake rental properties, Lake Illinois homes for rent by owner, and rent houses Lake Illinois.
Our website, FRBO.com does except novel square lakefront, private, well appointed, and hidden cabin and apartments.
Using our page, home owners register timeshare, condominium, farmhouse, and condominium ad directories.
Originate your going-over online tonight, this evening, or in the next few days for your condo rentals Moraine, Moraine Illinois house rentals, and rent house Moraine Illinois.
See hillside classified advertisements and secluded ads that brokers leasing foreclosures and property owners post on this website, FRBO.com.
Discern, elicit, and discover homes for rent by owner, vacation rentals in Prospect Heights, and Prospect Heights United States condos for rent.
Espy, originate, and elicit rental apartment Eldred, rent houses Eldred United States, and rent houses Eldred.
We sired and erected FRBO.com to be pretty, magnificent, and refined.
Contrive, devise, and distinguish Sutter United States vacation rentals, Sutter United States house rentals, and homes for rent by owner Sutter.
Find and locate rental houses in Peoria Illinois and rental properties in Peoria.
|
|
