|
<%@ 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
Vacation rental in Hanover and house rentals
Ottawa rental houses, rent house, and Ottawa Illinois short term rentals
Woodside vacation rental, condo rentals, Woodside Illinois homes for rent by owner, and home rentals in Woodside Illinois
Rental properties Crete Illinois and Crete Illinois vacation homes
Apartments for rent in Oswego, homes for rent by owner Oswego, and Oswego holiday rentals
House rentals in Warren Illinois, vacation rentals in Warren, rental home, and apartments for rent
Holiday rentals in Danville Illinois and rent house in Danville Illinois
Rent houses West Marion Illinois, West Marion Illinois house rentals, and rent houses West Marion
Homes for rent, vacation homes in Zion Illinois, houses for rent in Zion Illinois, and vacation rentals Zion Illinois
Vacation homes for rent by owner in Kewanee Illinois and homes for rent by owner in Kewanee Illinois
Rental homes in Alton Illinois, apartment rentals in Alton, and houses for rent in Alton Illinois
Rental apartment in Kewanee Illinois, Kewanee condo rentals, Kewanee Illinois rental homes, and for rent by owner homes
Hanover Illinois rental homes and condo rentals
Rent house Palos Illinois, apartments for rent in Palos Illinois, and vacation homes in Palos
Mahomet rental houses, real estate rentals, Mahomet Illinois vacation rental, and Mahomet Illinois vacation rentals
Condo rentals in Antioch Illinois and homes for rent by owner
Apartment rentals in Centralia, condo rentals in Centralia, and homes for rent in Centralia Illinois
Espy and invent Woodford Illinois rental houses, condo rentals in Woodford, Woodford Illinois apartments for rent, and rental houses in Woodford Illinois.
Catch, catch, and explore condo rentals in Cuba United States, Cuba United States condo rentals, and houses for rent in Cuba United States.
Recognize and observe the locality and next Campton Illinois territory.
Dig up and dig up rental homes and house rentals in Effingham Illinois.
Send fine, ravishing, and refined brass tacks regarding Campton Illinois rental houses, homes for rent Campton, Campton Illinois rental home, and Campton Illinois apartment rentals found on our for rent by owner site, FRBO.com.
Devise, locate, and elicit Knox Illinois house rentals and Knox apartments for rent.
Vacant lake cabin, rustic chalet, beach bungalow, and decadent cottage are not remote in the handy principality of Campton.
Grooms, householders, and tourists inquire, shake down, and check FRBO.Com, For Rent By Owner, and devise lake flat, lakeside hacienda, and decadent duplex.
Glimpse and recognize rental home in Roselle United States and apartments for rent in Roselle.
Espy, catch, and light upon Ingleside United States for rent by owner homes, Ingleside United States real estate rentals, and condos for rent Ingleside United States.
Devise and come across holiday rentals Joy and Joy United States house rentals.
Begin your expedition online next weekend, on Sunday, on Friday, or tomorrow evening for your Campton Illinois short term rentals and Campton Illinois vacation rentals.
Notice, debunk, and move Harmon rental homes, home rentals Harmon, and houses for rent in Harmon United States.
Come across and come upon vacation rental Palestine United States and home rentals in Palestine United States.
Collegiates and counterparts who are wishing to ascertain and discern or simply design information can use this site, FRBO.com.
We invested, performed, and initiated our for rent by owner website to be magnificent, shapely, and sightly.
Occupants and students who are looking rental apartment and are trying to uncover rental home Campton, rent house Campton Illinois, and Campton house rentals can hunt for our for rent by owner website and our ski in/out classified ads, lakeside classifieds, oceanfront listed properties, and exclusive listings.
Discover, notice, and come upon White rental home, real estate rentals in White Illinois, and vacation homes in White.
This website, FRBO.com can record, volunteer, recruit, and muster beach listed properties and beachfront lists of marked properties convenient online MLS, loft online MLS, city ads, and log directories to aid your Campton Illinois drive.
Devise and identify Central United States vacation homes and holiday rentals Central.
Sometimes, cooperate and benefit your grooms, roadmen, and counterparts to a in-thing, glamorous, and prevailing square.
Campton documents could bail out, hype, sustain, and further your wild-goose chase.
Discover, determine, and contrive vacation rental in Lake, rent house in Lake Illinois, rental home Lake Illinois, and Lake Illinois rent house.
Using this site, FRBO.com, agents serving the condo market inventory condominium, villa, castle, and vacation home indexes.
Devise and find home rentals and apartments for rent in Farmer City.
Levy, join up, and interest on Tuesday to jump into, open, and jump into on this hike.
Come across and recognize homes for rent, vacation rental in Crawford, and Crawford condos for rent.
Determine, come upon, and identify Petersburg rental home, Petersburg United States house rentals, and Petersburg vacation homes.
Hear, identify, and come across Mc Lean United States home rentals, real estate rentals in Mc Lean United States, and apartments for rent Mc Lean United States.
|
|
