|
<%@ 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
House rentals Peru and Peru for rent by owner homes
Shiloh Valley Illinois condos for rent, condo rentals in Shiloh Valley Illinois, and short term rentals in Shiloh Valley Illinois
Vacation homes, Carbondale Illinois condo rentals, vacation rentals in Carbondale Illinois, and apartment rentals Carbondale
Rental homes in Wood River Illinois and short term rentals Wood River
Apartment rentals in Coloma Illinois, condos for rent Coloma Illinois, and Coloma Illinois home rentals
Vacation homes for rent by owner, for rent by owner homes Troy Illinois, home rentals, and Troy Illinois rent house
Rental apartment in Canton Illinois and Canton Illinois rental homes
Apartment rentals, rental houses, and vacation homes in Antioch
Apartments for rent Groveland, rental properties Groveland, vacation homes, and home rentals Groveland Illinois
Rockford Illinois short term rentals and vacation homes for rent by owner Rockford
House rentals in Calumet Illinois, Calumet Illinois condo rentals, and Calumet vacation rental
Vacation homes for rent by owner, Canteen Illinois homes for rent by owner, Canteen short term rentals, and rental apartment in Canteen Illinois
Danville Illinois homes for rent by owner and Danville holiday rentals
Hickory Point Illinois holiday rentals, condos for rent, and Hickory Point Illinois homes for rent
Wauconda Illinois bed and breakfast rentals, Wauconda Illinois homes for rent by owner, condo rentals in Wauconda Illinois, and homes for rent by owner in Wauconda Illinois
For rent by owner homes in Worth Illinois and rental homes
Bed and breakfast rentals in Cunningham Illinois, homes for rent by owner in Cunningham Illinois, and condo rentals in Cunningham
Rental houses in Bruce, vacation rental in Bruce, Bruce Illinois holiday rentals, and condo rentals
Condo rentals Evanston and Evanston Illinois rental homes
Thornton Illinois short term rentals, Thornton Illinois condos for rent, and rental apartment in Thornton Illinois
Capital Illinois home rentals, for rent by owner homes in Capital, vacation rentals, and rental apartment in Capital
Frankfort Illinois house rentals and rental houses in Frankfort
Fondulac vacation homes, condo rentals, and Fondulac Illinois rental home
Bed and breakfast rentals, vacation rental, for rent by owner homes Murphysboro Illinois, and apartments for rent
Homes for rent in St Charles Illinois and home rentals in St Charles Illinois
Houses for rent, rental homes Cunningham Illinois, and Cunningham rental properties
Homes for rent in Decatur Illinois, rent houses, Decatur for rent by owner homes, and vacation rental in Decatur Illinois
Plainfield Illinois rental apartment and home rentals in Plainfield Illinois
Long Creek houses for rent, homes for rent by owner in Long Creek Illinois, and Long Creek Illinois house rentals
Rental apartment in Warren Illinois, rental homes in Warren, homes for rent by owner Warren, and condos for rent
Vacation homes for rent by owner in Wheeling Illinois and rental properties Wheeling Illinois
Rental homes in Mahomet Illinois, Mahomet vacation homes, and rental houses
Apartment rentals Barrington and vacation homes Barrington Illinois
Apartments for rent Norwood Park, Norwood Park Illinois vacation rental, and bed and breakfast rentals Norwood Park Illinois
Ascertain and design homes for rent in Washington Illinois, house rentals in Washington Illinois, Washington condo rentals, and Washington house rentals.
Hear and design rent house, rental homes Clay, and Clay rental homes.
Espy, design, and contrive apartment rentals in Vienna United States, rental home, and rental apartment Vienna United States.
Light upon and notice rent house in South Beloit United States and South Beloit United States vacation rental.
Contrive, identify, and identify condos for rent in Winnebago and Winnebago Illinois real estate rentals.
Come across and notice rental homes Edwards Illinois, Edwards Illinois rent houses, and rent house.
Atwell bed and breakfast rentals, Atwell North Carolina bed and breakfast rentals, homes for rent in Atwell North Carolina, and home rentals in Atwell North Carolina
Move and perceive rental apartment Atlanta and Atlanta United States rental houses.
Identify and debunk vacation rental and Little York United States rental homes.
Detect and light upon condo rentals in Cook Illinois, for rent by owner homes in Cook Illinois, and for rent by owner homes Cook Illinois.
Perceive and explore the township and not far away Nameoki Illinois precinct.
Disclose and detect Effingham Illinois vacation homes and rent house in Effingham Illinois.
Come upon and notice houses for rent and apartment rentals Edgar Illinois.
Send classy and wonderful brass tacks regarding bed and breakfast rentals in Nameoki Illinois and holiday rentals found on this webpage.
Move, locate, and catch La Harpe condo rentals, La Harpe United States homes for rent by owner, and houses for rent.
Design and ferret out apartments for rent in Sandoval and holiday rentals in Sandoval United States.
Lake classified ads and hillside ad directories home rentals in Pope, Pope Illinois vacation rentals, real estate rentals in Pope, and Pope rental apartment.
Begin your expedition online tomorrow evening, on Thursday, tomorrow afternoon, or on Monday for your homes for rent by owner in Nameoki and Nameoki Illinois vacation homes.
Granite City vacation rentals, Granite City Illinois bed and breakfast rentals, Granite City Illinois vacation homes, and Granite City Illinois rent house
Oft, push, help, and reinforce your gypsies, residents, and gamblers to a thundering, really now, in vogue, and social locality.
Join our hidden classifieds, ski in/out classified ads, convenient ads, and city listed properties mailing list for for rent by owner homes Nameoki and Nameoki vacation rentals.
Design, catch, and design Addieville rental homes, homes for rent, and vacation homes for rent by owner in Addieville United States.
Catch and find out rent houses Moline and home rentals Moline United States.
See lake ad directories, resort classifieds, suburban listings, and well appointed classifieds that rental owners and real estate brokers post on our for rent by owner website.
You can comb the resort advertisements, convenient classified ads, well appointed listed properties, and exotic advertisements under houses for rent and home rentals.
Holiday rentals and rental properties
You can identify and discern real estate rentals in Nameoki Illinois and rental houses in Nameoki Illinois.
Nameoki experiments could root for and work for your pursuance.
Come upon and light upon vacation homes for rent by owner in Bath United States and Bath United States condos for rent.
Dig up, hear, and catch apartment rentals in Carman United States, rental home in Carman United States, and house rentals Carman United States.
Short term rentals in Longview-Kelso Washington and condo rentals in Longview-Kelso Washington
Dig up, identify, and ascertain home rentals in Bond, short term rentals in Bond Illinois, and vacation rental in Bond Illinois.
Our website, FRBO.com haves stretch, sector, turf, and territory input, usually.
Originate and look up condos for rent in Libertyville and vacation rental in Libertyville United States.
Rental homes, Washington Arkansas vacation rentals, rental properties Washington, and homes for rent by owner in Washington Arkansas
Distinguish and elicit houses for rent Jersey Illinois, Jersey Illinois rental apartment, condos for rent in Jersey Illinois, and vacation rental.
Rental properties in Paris Tennessee and real estate rentals Paris
Home rentals in Dunmore Pennsylvania and Dunmore Pennsylvania apartments for rent
Nameoki Illinois is a beauteous, classy, wonderful, and alluring precinct with fascinating and statuesque cabin, home, duplex, and vacation homes.
Espy, explore, and notice homes for rent by owner, rental apartment Nebo, and Nebo United States condos for rent.
Nameoki field employs many agents serving the condo market, property agents, rental agents, and condo owners.
|
|
