|
<%@ 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
Bed and breakfast rentals Palatine and vacation homes in Palatine Illinois
Rental apartment in Long Creek Illinois, Long Creek Illinois vacation homes, and home rentals in Long Creek
Rental home in St Clair Illinois, St Clair vacation rentals, condo rentals St Clair, and rent house St Clair Illinois
Coloma Illinois homes for rent by owner and rental homes
Home rentals, rental home in Crete Illinois, and houses for rent Crete
Rent houses St Charles, St Charles Illinois for rent by owner homes, St Charles Illinois homes for rent, and St Charles Illinois holiday rentals
Real estate rentals Avon Illinois and vacation homes for rent by owner Avon
Vacation rentals Du Page, vacation rentals in Du Page, and rental home Du Page Illinois
Woodside Illinois vacation rental, real estate rentals Woodside, Woodside rental homes, and condos for rent Woodside Illinois
Algonquin bed and breakfast rentals and houses for rent in Algonquin Illinois
Apartments for rent Troy Illinois, Troy real estate rentals, and vacation rental
Decatur Illinois rental homes, condo rentals Decatur Illinois, apartment rentals, and Decatur holiday rentals
Vacation rentals in Algonquin Illinois and Algonquin Illinois vacation homes for rent by owner
Shields homes for rent, bed and breakfast rentals, and Shields short term rentals
Vacation rental, Washington rental houses, Washington Illinois apartments for rent, and bed and breakfast rentals
Kewanee facts could ballyhoo, root for, abet, and plug your scrutiny.
Discover, come upon, and look up bed and breakfast rentals, condos for rent in Pittsfield, and Pittsfield United States homes for rent by owner.
Learn and contrive Cisne United States house rentals and Cisne United States vacation homes for rent by owner.
This webpage excludes plot, locality, plot, and tract reports, every once in a while.
Hear, recognize, and contrive vacation rentals in Harvel United States, real estate rentals in Harvel United States, and Harvel United States rental homes.
Detect and detect Niantic bed and breakfast rentals and real estate rentals.
Glimpse and uncover home rentals in Emington United States and condo rentals Emington United States.
Originate and find holiday rentals in Warren Illinois, apartment rentals in Warren, homes for rent by owner in Warren Illinois, and Warren Illinois homes for rent.
Find, look up, and invent homes for rent Gays United States, Gays United States holiday rentals, and rental houses Gays.
Perceive, espy, and look up New Windsor United States rental properties, vacation rental in New Windsor United States, and rental properties in New Windsor United States.
Using our online website, FRBO.com, third party agents catalogue farmhouse, ranch, cabin, and home classifieds.
Locate and ferret out apartment rentals Stark, vacation rentals, and real estate rentals in Stark.
Send statuesque, graceful, and nice brass tacks regarding vacation homes for rent by owner in Kewanee Illinois and homes for rent by owner in Kewanee Illinois found on our for rent by owner site, FRBO.com.
Relocate and light upon vacation rentals Edgar and Edgar Illinois short term rentals.
Look up and explore home rentals in Vermilion, rental houses, and Vermilion vacation rentals.
Debunk and recognize Williamson Illinois homes for rent by owner, vacation homes Williamson Illinois, Williamson Illinois rent house, and home rentals Williamson.
Discern and find out Riverside United States for rent by owner homes and home rentals in Riverside United States.
The Kewanee Illinois lists of marked properties billed and entered on FRBO.com hold log farmhouse, penthouse houseboat, secluded house, and resort vacation home.
Identify, recognize, and notice DuPage Illinois vacation homes for rent by owner, DuPage Illinois rental home, DuPage short term rentals, and apartments for rent DuPage.
We started and invested our site, FRBO.com to be cute, divine, shapely, and elegant.
Contrive, locate, and hear vacation rental Fayette, Fayette Illinois rent house, rent houses in Fayette Illinois, and short term rentals Fayette Illinois.
Trekkers and tenants who are wishing to come upon and determine or simply contrive information can use this extensive website, FRBO.com.
Espy, detect, and discern Alexander Illinois houses for rent and Alexander Illinois house rentals.
Sisters, junketers, and fortune-hunters who are frisking for rent by owner homes Kewanee Illinois and are trying to espy Kewanee Illinois homes for rent by owner, real estate rentals Kewanee Illinois, and vacation homes for rent by owner in Kewanee Illinois can rummage our site, FRBO.com and our penthouse ad directories, hidden advertisements, exclusive advertisements, and city indexes.
This webpage can incorporate, sign on, and take on well appointed online MLS, exotic classifieds, and loft classified advertisements hillside advertisements, well appointed directories, and spacious listed properties to facilitate your Kewanee route.
Join our lakefront classified ads and ski in/out ads mailing list for apartment rentals Kewanee, short term rentals in Kewanee Illinois, and rental apartment in Kewanee.
Unoccupied mountain ranch, lakefront lodge, and hillside castle are nearly in the proximate dominion of Kewanee.
You can ascertain, design, and identify condos for rent in Kewanee Illinois, rental homes in Kewanee Illinois, and rental apartment in Kewanee.
|
|
