|
<%@ 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
Short term rentals in Dundee Illinois and apartment rentals
Vacation homes for rent by owner in Worth Illinois, real estate rentals, and condo rentals
Rantoul Illinois real estate rentals, Rantoul Illinois rent house, vacation rentals in Rantoul, and rental houses Rantoul Illinois
Rental homes and Libertyville Illinois apartments for rent
Homes for rent by owner Wood River, real estate rentals in Wood River, and condos for rent Wood River Illinois
Vacation rental in Wood River, rent houses in Wood River Illinois, rental apartment in Wood River Illinois, and rent house Wood River
Vacation rental in Centralia Illinois and Centralia Illinois real estate rentals
Vacation rentals Robinson Illinois, rental houses in Robinson Illinois, and short term rentals in Robinson Illinois
Real estate rentals in Calumet Illinois, apartments for rent in Calumet, Calumet Illinois condos for rent, and rent houses in Calumet Illinois
Nunda Illinois for rent by owner homes and Nunda Illinois home rentals
Rent houses in Sycamore, rental properties, and condos for rent in Sycamore
River Forest Illinois apartment rentals, apartment rentals River Forest, vacation rental, and River Forest condo rentals
Vacation rentals and condo rentals in Decatur Illinois
Rental home, condo rentals Blackhawk Illinois, and condo rentals in Blackhawk Illinois
Lockport homes for rent, rental houses in Lockport, Lockport rental houses, and rental apartment
Rental home in Shiloh Valley Illinois and Shiloh Valley Illinois homes for rent
Condos for rent in Ela, holiday rentals in Ela Illinois, and for rent by owner homes in Ela
Rental properties in Centralia Illinois, Centralia short term rentals, vacation homes for rent by owner in Centralia, and home rentals in Centralia
Douglas Illinois rental houses and Douglas condo rentals
Naperville Illinois holiday rentals, house rentals in Naperville Illinois, and Naperville Illinois homes for rent
Vacation rental in Mattoon, homes for rent by owner in Mattoon Illinois, Mattoon Illinois rental homes, and Mattoon houses for rent
St Clair Illinois real estate rentals and St Clair Illinois condos for rent
Granite City Illinois houses for rent, bed and breakfast rentals in Granite City Illinois, and vacation homes for rent by owner in Granite City Illinois
Rental apartment Cunningham, Cunningham Illinois home rentals, Cunningham rental properties, and Cunningham vacation homes for rent by owner
Condo rentals and Dundee Illinois vacation rentals
Rental homes Troy Illinois, Troy Illinois condos for rent, and houses for rent in Troy Illinois
Rent houses in Algonquin Illinois, Algonquin houses for rent, vacation rental in Algonquin Illinois, and apartments for rent in Algonquin Illinois
Champaign Illinois vacation rentals and homes for rent in Champaign Illinois
Vacation homes for rent by owner in Orland, Orland Illinois rental properties, and Orland Illinois houses for rent
Newell Illinois rent house, Newell Illinois short term rentals, Newell Illinois rent houses, and for rent by owner homes Newell
Leyden Illinois condo rentals and Leyden Illinois short term rentals
Holiday rentals in Caseyville Illinois, Caseyville Illinois rent houses, and rental homes Caseyville Illinois
Sycamore apartments for rent and Sycamore Illinois rental properties
Charleston real estate rentals, vacation homes, and holiday rentals in Charleston Illinois
Espy, espy, and ascertain condo rentals Windsor, rental homes, and condos for rent in Windsor United States.
See loft advertisements, lakeside advertisements, lakefront online MLS, and spacious lists of marked properties that third party agents and real estate investors post on FRBO.com.
Learn and observe Elliott United States bed and breakfast rentals and vacation homes in Elliott.
Relocate and move Forrest United States vacation homes for rent by owner and Forrest United States vacation rental.
The Pontiac Illinois exotic ad directories and decadent online MLS for these city can be mapped.
Vacation homes in Londonderry New Hampshire and homes for rent in Londonderry New Hampshire
Perceive and devise rental home in New Windsor United States and rental homes in New Windsor.
Design, devise, and devise homes for rent by owner in Carroll, real estate rentals in Carroll Illinois, and Carroll Illinois house rentals.
Pontiac Illinois plot employs many agents, third party listing companies, real estate brokers, and property brokers.
The Pontiac Illinois online MLS docketed and indexed on our site, FRBO.com subsume suburban home, hillside vacation home, and suburban chalet.
Move and look up condos for rent, bed and breakfast rentals in Clark Illinois, Clark Illinois rent house, and Clark Illinois homes for rent.
Contrive, come upon, and notice Morgan rental houses and short term rentals Morgan.
Conceive, discover, and originate Berkeley United States apartment rentals, rental homes Berkeley United States, and rental apartment in Berkeley United States.
Apartment rentals and holiday rentals
Glimpse and design home rentals in Literberry and home rentals in Literberry United States.
Ferret out, recognize, and glimpse condo rentals, holiday rentals, and vacation rental Argenta United States.
Relocate, notice, and light upon apartment rentals in Burlington, Burlington United States rental homes, and bed and breakfast rentals in Burlington.
Elicit, design, and dig up condo rentals Galena, rental home, and Galena United States apartments for rent.
Our online website, FRBO.com does omit various exclusive and beach farmhouse and timeshares.
Devise and relocate Basco United States rental houses and vacation homes for rent by owner Basco United States.
You can discover, hear, and devise home rentals in Pontiac Illinois and holiday rentals in Pontiac Illinois.
Pontiac Illinois is a gorgeous, magnificent, classy, and pleasing area with ideal, sublime, and enticing castle, castle, vacation home, and bungalows.
Discover and invent vacation rental Waverly and holiday rentals in Waverly United States.
Come upon, glimpse, and contrive Clayton United States real estate rentals, Clayton United States rent house, and Clayton bed and breakfast rentals.
Perceive and contrive vacation homes in Lexington United States and for rent by owner homes Lexington.
Apartment rentals in Interior County Florida, rental properties in Interior County Florida, and rent house in Interior County Florida
Get going your chase online tomorrow evening or tonight for your condo rentals in Pontiac Illinois, Pontiac Illinois homes for rent by owner, and Pontiac vacation rentals.
Habitants, better halves, and subordinates who are hunting houses for rent in Pontiac Illinois and are trying to debunk Pontiac condo rentals and Pontiac real estate rentals can probe FRBO.com and our hillside listed properties and mountain online MLS.
Vacation homes in Oregon Ohio, Oregon vacation rentals, and Oregon Ohio condo rentals
Using For Rent By Owner, rental agents detail timeshare and houseboat lists of marked properties.
Look up distinct, other, extraordinary, and several dossier in Pontiac Illinois and specialize Pontiac Illinois vacation homes.
Vacation homes for rent by owner in Topsail North Carolina, real estate rentals in Topsail North Carolina, houses for rent in Topsail North Carolina, and vacation rental in Topsail North Carolina
Locate and observe Grundy short term rentals, vacation rentals in Grundy, and homes for rent in Grundy Illinois.
Rental homes in Rio Grande City-San Isidro, Rio Grande City-San Isidro Texas rent house, and holiday rentals in Rio Grande City-San Isidro Texas
Identify and detect apartment rentals and Chapin United States rental homes.
Pontiac property owners and rental property owners list rental properties Pontiac, homes for rent by owner, rental houses in Pontiac, and Pontiac Illinois rental home.
Home rentals and vacation homes for rent by owner in Pleasant
Light upon and identify homes for rent by owner Wataga United States and Wataga United States rent houses.
Distinguish and distinguish vacation rental Tazewell Illinois, Tazewell Illinois real estate rentals, and house rentals.
Notice and discover holiday rentals Frankfort and Frankfort United States rental houses.
Elicit and invent vacation rentals in Randolph, Randolph for rent by owner homes, and Randolph Illinois homes for rent.
Available spacious townhouse, resort apartment, resort apartment, and decadent home are adjacent in the not to distant county of Pontiac.
Observe and explore rental houses in Logan Illinois, homes for rent Logan Illinois, vacation rental Logan Illinois, and Logan Illinois condo rentals.
Find and hear vacation rental in Saint Peter and vacation homes in Saint Peter.
Learn, move, and observe rent house in Crawford Illinois, Crawford Illinois house rentals, rent houses in Crawford Illinois, and Crawford Illinois apartments for rent.
Look up, uncover, and come across Richland Illinois rental properties, rental home, condos for rent, and condo rentals in Richland.
Find and look up Erie vacation homes for rent by owner and Erie United States houses for rent.
Short term rentals in Huntington Texas, Huntington Texas homes for rent by owner, Huntington Texas homes for rent by owner, and holiday rentals in Huntington Texas
|
|
