|
<%@ 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 Ottawa and Ottawa Illinois condos for rent
Vacation rentals in Antioch Illinois, homes for rent, and rental home Antioch
Short term rentals Jarvis, bed and breakfast rentals Jarvis, home rentals in Jarvis Illinois, and vacation rental in Jarvis
House rentals in Canton Illinois and Canton Illinois vacation rental
Rental apartment in Charleston, homes for rent in Charleston Illinois, and houses for rent Charleston
Peru condo rentals, vacation homes Peru, condos for rent in Peru Illinois, and for rent by owner homes in Peru Illinois
Vacation homes Belvidere and rent house in Belvidere Illinois
Real estate rentals in Monee Illinois, rental houses in Monee, and Monee Illinois condo rentals
Antioch short term rentals, condo rentals in Antioch Illinois, Antioch vacation rentals, and Antioch vacation homes
Short term rentals and short term rentals Long Creek
Holiday rentals in Fondulac Illinois, homes for rent by owner in Fondulac Illinois, and bed and breakfast rentals in Fondulac Illinois
Calumet Illinois vacation rental, homes for rent in Calumet, apartments for rent Calumet, and Calumet rental houses
House rentals in Canton and for rent by owner homes in Canton Illinois
Rental houses in Naperville Illinois, Naperville Illinois rental home, and condo rentals
Collinsville Illinois homes for rent, for rent by owner homes Collinsville, Collinsville bed and breakfast rentals, and Collinsville Illinois house rentals
Grant apartment rentals and vacation rental
For rent by owner homes in Warren, vacation homes in Warren, and Warren Illinois holiday rentals
Wauconda houses for rent, rental properties in Wauconda Illinois, condo rentals in Wauconda Illinois, and vacation rentals in Wauconda Illinois
Vacation homes for rent by owner in Thornton Illinois and Thornton real estate rentals
Sterling home rentals, vacation rental in Sterling Illinois, and Sterling house rentals
Home rentals in Monee Illinois, vacation rentals in Monee, Monee Illinois rent house, and houses for rent in Monee Illinois
Vacation rentals in Decatur Illinois and Decatur holiday rentals
Rent house in Grafton Illinois, Grafton Illinois homes for rent, and condos for rent
Roscoe Illinois vacation homes for rent by owner, Roscoe Illinois vacation rental, vacation homes for rent by owner Roscoe Illinois, and apartment rentals Roscoe Illinois
Apartments for rent Wheeling Illinois and Wheeling Illinois rent house
Collinsville Illinois rental apartment, home rentals in Collinsville, and rental houses in Collinsville Illinois
Join up, mobilize, and mobilize this evening to originate, begin, and begin on this roaming.
Learn, notice, and come upon Bond Illinois house rentals and Bond rental homes.
Mount Vernon rental agents, home owners, home owners, and land owners list Mount Vernon Illinois homes for rent by owner, rental home in Mount Vernon, and rental apartment in Mount Vernon Illinois.
Hear, look up, and look up vacation homes for rent by owner in Clark, Clark Illinois rental apartment, home rentals Clark, and vacation homes in Clark Illinois.
Explore, look up, and distinguish Mackinaw home rentals, rental homes, and Mackinaw United States short term rentals.
Find and explore Dix United States short term rentals and condos for rent in Dix.
Locate and glimpse Seward United States for rent by owner homes and for rent by owner homes in Seward.
See suburban listings, mountain ads, studio classifieds, and log listings that third party agents and agents post on our for rent by owner site, FRBO.com.
Nearly ready romantic houseboat and decadent hacienda are not far away in the adjoining city of Mount Vernon Illinois.
Longview-Kelso houses for rent and apartments for rent in Longview-Kelso
Debunk and find Arcola United States rental houses and house rentals Arcola United States.
Distinguish, distinguish, and espy rental properties Gibson City United States, Gibson City homes for rent by owner, and vacation rental Gibson City United States.
Using this website, FRBO.com, rental owners classify duplex and apartment classifieds.
Contrive and hear DuPage Illinois vacation homes, DuPage Illinois rental homes, DuPage Illinois condos for rent, and DuPage Illinois apartments for rent.
Navigators and travelers who are raking vacation homes and are trying to ascertain Mount Vernon holiday rentals and Mount Vernon Illinois holiday rentals can probe For Rent By Owner and our mountain listings and rustic classifieds.
Hear, find, and come across apartments for rent Pope, rental apartment Pope, and condos for rent Pope Illinois.
Observe, ascertain, and discern Clinton apartments for rent, homes for rent by owner in Clinton Illinois, Clinton Illinois rental properties, and Clinton apartment rentals.
Move and come across Raritan United States homes for rent by owner and vacation rentals Raritan United States.
Contrive, learn, and identify Stark vacation rental, Stark Illinois rental home, and Stark vacation rental.
Find and come upon houses for rent Braceville and for rent by owner homes.
Ferret out and conceive rental homes Winfield United States and short term rentals Winfield.
We composed and procreated this webpage to be enticing and dazzling.
Disclose and design homes for rent Hardin Illinois, vacation homes for rent by owner Hardin, and rental houses in Hardin Illinois.
Salesmen, educators, and troupers scout, prospect, and rake this website, FRBO.com and catch waterfront chalet, suburban cabin, log apartment, and city duplex.
Launch your pursual online in the morning, on Thursday, next weekend, or in the morning for your Mount Vernon vacation homes and rental home.
Join our city classifieds and secluded directories mailing list for rental home and Mount Vernon real estate rentals.
The Mount Vernon Illinois directories posted and charted on FRBO.Com, For Rent By Owner, incorporate well appointed bungalow, loft house, rustic houseboat, and ski in/out lodge.
Mount Vernon info could puff, abet, work with, and help your inquest.
Detect, glimpse, and move rental homes in Ridgway United States, Ridgway United States vacation rentals, and Ridgway United States apartments for rent.
The Mount Vernon Illinois penthouse ad directories, log directories, private lists of marked properties, and suburban classifieds for these square can be mapped.
Ascertain and hear Winslow United States houses for rent and bed and breakfast rentals Winslow.
Uncover and glimpse house rentals in Bureau Illinois and rental houses.
Contrive, detect, and design rent house in Bardolph, Bardolph United States condos for rent, and holiday rentals Bardolph United States.
Ascertain and learn Byron rental houses and rent house.
Find out and catch rental home in Bond, apartments for rent in Bond Illinois, real estate rentals Bond Illinois, and Bond Illinois houses for rent.
|
|
