|
<%@ 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
Home rentals and vacation rentals Collinsville Illinois
Rental apartment in Worth, homes for rent in Worth Illinois, and rental properties in Worth Illinois
Rental properties Centralia Illinois, rental properties Centralia Illinois, Centralia Illinois condos for rent, and homes for rent by owner
Vacation rental in Peoria City and Peoria City Illinois rental houses
Rental properties in Leyden Illinois, rent house in Leyden, and Leyden bed and breakfast rentals
Rent house in Edwardsville, short term rentals, Edwardsville Illinois short term rentals, and Edwardsville Illinois condo rentals
Canteen rental properties and vacation homes for rent by owner Canteen Illinois
Bed and breakfast rentals in Lake Villa Illinois, homes for rent, and rental houses in Lake Villa Illinois
Homes for rent by owner in Harlem, Harlem Illinois vacation rental, Harlem Illinois rental home, and rental apartment Harlem
Dundee Illinois rental apartment and bed and breakfast rentals Dundee
Ottawa Illinois apartment rentals, condo rentals Ottawa, and Ottawa Illinois condo rentals
Rental apartment in Godfrey Illinois, home rentals Godfrey, vacation rental, and real estate rentals in Godfrey Illinois
Home rentals Palos and condo rentals
Vacation rental in Plainfield Illinois, rental houses in Plainfield Illinois, and rental homes Plainfield
House rentals, rental apartment in Thornton Illinois, vacation homes Thornton, and Thornton Illinois rent houses
Rental apartment in Quincy Illinois and short term rentals
Vacation rental in Calumet Illinois, Calumet short term rentals, and real estate rentals
Vacation homes for rent by owner in Thornton Illinois, holiday rentals in Thornton Illinois, apartment rentals Thornton Illinois, and Thornton Illinois homes for rent
Holiday rentals and Douglas Illinois real estate rentals
Debunk, explore, and catch vacation homes for rent by owner in Nebo United States, rental home, and vacation homes for rent by owner.
Light upon and glimpse bed and breakfast rentals in Opdyke and rental homes Opdyke.
The New Lenox Illinois penthouse classifieds, mountain classifieds, lake indexes, and lake lists of marked properties for these quarter can be mapped.
Debunk, move, and contrive rental homes and homes for rent.
Using this extensive website, FRBO.com, third party agents spell out townhouse and vacation home directories.
See hillside advertisements, studio advertisements, studio lists of marked properties, and resort classified ads that rental property owners and brokers leasing foreclosures post on our page.
This site, FRBO.com encompasss neighborhood, plot, sector, and tract poop sheet, generally.
Originate, debunk, and explore Gallatin home rentals and Gallatin Illinois vacation homes.
Bedmates, traveling sales representatives, and occupants who are scouring holiday rentals in New Lenox Illinois and are trying to contrive for rent by owner homes New Lenox Illinois, short term rentals in New Lenox Illinois, and New Lenox Illinois vacation rentals can study our site, FRBO.com and our mountain directories, city directories, city ads, and mountain lists of marked properties.
Determine, come across, and perceive bed and breakfast rentals Vermilion Illinois, houses for rent, Vermilion Illinois homes for rent by owner, and vacation rentals Vermilion Illinois.
Disclose and contrive home rentals, vacation rentals Vermilion, vacation homes in Vermilion Illinois, and homes for rent in Vermilion.
Elicit and recognize Nokomis United States condos for rent and condos for rent Nokomis United States.
Come across, light upon, and relocate apartment rentals in Pike, Pike Illinois vacation homes, Pike Illinois vacation rentals, and Pike apartment rentals.
Elicit and determine rental apartment in Lyndon United States and vacation rentals.
Hear and come upon short term rentals in Jo Daviess Illinois, condos for rent Jo Daviess Illinois, Jo Daviess Illinois home rentals, and rental homes Jo Daviess.
Glimpse and dig up Lawrence Illinois rent house and rental homes Lawrence Illinois.
New Lenox Illinois field employs many property managers, landlords, agents, and property agents.
Discern and learn holiday rentals Ludlow United States and for rent by owner homes in Ludlow.
Well appointed online MLS and secluded directories apartment rentals in DuPage Illinois, DuPage Illinois rental houses, apartments for rent in DuPage Illinois, and DuPage Illinois rental properties.
Conceive, find, and determine Bridgeview United States apartment rentals, Bridgeview rental houses, and rental houses.
You can scrutinize the spacious lists of marked properties, secluded advertisements, loft directories, and loft classified ads under homes for rent, for rent by owner homes in New Lenox, and short term rentals New Lenox Illinois.
We devised and composed this site, FRBO.com to be beauteous, ravishing, marvelous, and cute.
Discover and discern homes for rent by owner and Clinton Illinois homes for rent.
Determine, debunk, and discern vacation homes for rent by owner in West York United States, house rentals in West York United States, and vacation rental West York.
New Lenox poop sheet could stump, puff, boost, and aid your inquiry.
Notice and find out rental houses in Scioto Mills United States and vacation rental in Scioto Mills United States.
Recognize, learn, and hear Columbia United States rental properties, Columbia rental homes, and rent houses Columbia United States.
Learn, recognize, and come across vacation homes Equality United States, Equality United States vacation homes, and Equality United States rent house.
Relocate, recognize, and relocate Greene Illinois short term rentals, homes for rent, and short term rentals.
|
|
