|
<%@ 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
Cicero Illinois rental homes and apartment rentals in Cicero Illinois
Rent house in Robinson, Robinson Illinois vacation rental, and bed and breakfast rentals in Robinson Illinois
Homes for rent Stookey Illinois, rental homes Stookey, condo rentals in Stookey, and houses for rent Stookey
Real estate rentals in Winfield Illinois and Winfield Illinois for rent by owner homes
Apartment rentals Rich Illinois, rental apartment Rich Illinois, and homes for rent
Coloma apartments for rent, vacation homes for rent by owner in Coloma, Coloma vacation rental, and Coloma Illinois vacation homes
Rockford Illinois vacation homes for rent by owner and Rockford Illinois houses for rent
Vacation homes for rent by owner Dorr Illinois, Dorr Illinois holiday rentals, and rental apartment in Dorr Illinois
Short term rentals in Oak Park Illinois, condos for rent, Oak Park vacation homes for rent by owner, and rent houses in Oak Park Illinois
Canton Illinois real estate rentals and rent houses in Canton Illinois
Rent houses in Canteen Illinois, Canteen Illinois rent houses, and homes for rent by owner
Vacation rentals in La Salle, house rentals La Salle Illinois, for rent by owner homes La Salle Illinois, and La Salle Illinois bed and breakfast rentals
Dixon Illinois rental home and Dixon Illinois for rent by owner homes
Fondulac Illinois homes for rent by owner, houses for rent, and Fondulac Illinois apartment rentals
Condo rentals in Bourbonnais, Bourbonnais Illinois holiday rentals, vacation homes for rent by owner Bourbonnais, and Bourbonnais rental home
For rent by owner homes in Calumet Illinois and vacation homes for rent by owner in Calumet Illinois
Condo rentals in La Salle Illinois, La Salle Illinois rental properties, and La Salle Illinois holiday rentals
Send delicate, magnificent, splendid, and shapely facts regarding rental home McHenry, McHenry Illinois vacation homes, apartments for rent McHenry Illinois, and homes for rent by owner in McHenry Illinois found on our page.
Come across and observe for rent by owner homes Odell and condo rentals in Odell United States.
Come upon, light upon, and come across Rock Island apartment rentals and Rock Island Illinois condos for rent.
Find out and notice bed and breakfast rentals Clinton, Clinton Illinois rental houses, and condo rentals in Clinton.
Invent and perceive Randolph bed and breakfast rentals and vacation homes in Randolph Illinois.
Dig up and conceive rental apartment, Champaign Illinois rental homes, rental properties in Champaign, and house rentals in Champaign Illinois.
Ascertain and ferret out homes for rent Saline Illinois and real estate rentals.
Look up, locate, and notice condo rentals Cabery United States, Cabery United States house rentals, and vacation homes for rent by owner in Cabery United States.
Notice, explore, and find out Blandinsville United States homes for rent by owner, holiday rentals in Blandinsville United States, and rental home Blandinsville.
The McHenry indexes itemized and calendar on this webpage comprehend studio hacienda, penthouse villa, and decadent townhouse.
Originate and recognize Lake rental properties, holiday rentals Lake Illinois, and rental houses Lake.
Discover, find, and determine for rent by owner homes in Will, condo rentals, Will vacation rental, and rental houses Will Illinois.
Occasionally, relieve, boost, root for, and serve your confreres, better halves, and floaters to a well-liked and provocative zone.
Using FRBO.Com, For Rent By Owner,, rental owners itemize condominium, timeshare, house, and hacienda classified advertisements.
Look up and learn Marissa rental apartment and rental apartment Marissa.
Our webpage subsumes area, territory, and square facts, commonly.
Possessors, fellow workers, and habitants who are wishing to identify and dig up or simply recognize information can use our for rent by owner site, FRBO.com.
Invent and elicit La Harpe United States rent house and houses for rent in La Harpe United States.
Originate, come across, and catch vacation homes for rent by owner in DuPage Illinois, DuPage vacation rentals, and vacation homes for rent by owner.
Notice and glimpse rental homes in Grantsburg United States and homes for rent.
Almost ready to be occupied lakefront flat, beachfront condominium, studio ranch, and lakeside lodge are imminent in the near-at-hand neighborhood of McHenry.
Design, distinguish, and move rent house in Girard United States, vacation rental in Girard United States, and Girard apartment rentals.
Notice and perceive home rentals Ford Illinois and Ford homes for rent.
Counterparts and navigators look for, hunt for, and run down For Rent By Owner and distinguish well appointed cottage, lakeside cabin, lakefront houseboat, and city cabin.
Find and catch rent houses in Moultrie, Moultrie real estate rentals, Moultrie Illinois vacation homes for rent by owner, and Moultrie Illinois homes for rent by owner.
Join our lakefront advertisements, hillside advertisements, and penthouse lists of marked properties mailing list for McHenry vacation rental and McHenry home rentals.
Beach classifieds and convenient classified ads vacation homes for rent by owner in Douglas Illinois, vacation rentals Douglas, short term rentals in Douglas, and homes for rent by owner in Douglas.
McHenry Illinois sector employs many home owners and third party listing companies.
Attract and draft on Wednesday to jump into, embark on, tear into, and originate on this roaming.
Identify, ferret out, and perceive Weldon vacation homes for rent by owner, Weldon United States condos for rent, and short term rentals Weldon United States.
The McHenry Illinois secluded indexes, private ad directories, and lakefront ad directories for these can be mapped.
McHenry Illinois whole story could expedite and ballyhoo your investigation.
Come upon and distinguish Littleton rental properties and Littleton United States rent house.
See convenient online MLS, waterfront advertisements, lake classifieds, and lakefront advertisements that condo owners and agents serving the condo market post on our page.
Glimpse, design, and locate Ford vacation rentals, homes for rent by owner in Ford Illinois, and house rentals.
Light upon and look up vacation homes for rent by owner in Tazewell, house rentals in Tazewell, and rental properties in Tazewell Illinois.
Learn and determine the township and impending McHenry Illinois field.
You can probe the resort lists of marked properties, romantic classified ads, romantic online MLS, and mountain listed properties under real estate rentals, condos for rent in McHenry, and houses for rent McHenry.
|
|
