|
<%@ 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
Rent house Niles and Niles Illinois rent house
Rental homes Cicero Illinois, Cicero Illinois apartments for rent, and Cicero Illinois vacation rental
Rental properties in Monmouth Illinois, vacation homes for rent by owner Monmouth, Monmouth Illinois vacation homes, and Monmouth rental properties
Houses for rent and house rentals
Wheeling apartments for rent, Wheeling Illinois home rentals, and short term rentals in Wheeling
Holiday rentals in Robinson Illinois, for rent by owner homes in Robinson Illinois, Robinson Illinois house rentals, and short term rentals in Robinson Illinois
Barrington Illinois rental home and holiday rentals
Ela house rentals, rental properties in Ela Illinois, and Ela Illinois rental houses
Rental houses Bloomington City, for rent by owner homes Bloomington City Illinois, apartments for rent in Bloomington City, and homes for rent Bloomington City
Condos for rent Lyons Illinois and vacation homes
Vacation rentals in Jarvis, Jarvis Illinois vacation homes, and vacation rental in Jarvis Illinois
For rent by owner homes Schaumburg, Schaumburg Illinois vacation homes, rental properties Schaumburg, and Schaumburg Illinois rental houses
Schaumburg rent house and Schaumburg Illinois bed and breakfast rentals
Rental home in Rantoul Illinois, rent house, and Rantoul Illinois short term rentals
Rental apartment in Mattoon Illinois, Mattoon Illinois rental apartment, Mattoon Illinois rental houses, and Mattoon real estate rentals
Short term rentals Bloom Illinois and Bloom Illinois rent house
Houses for rent in Decatur Illinois, short term rentals Decatur Illinois, and homes for rent Decatur
Homes for rent by owner in Campton Illinois, house rentals, Campton homes for rent by owner, and rental properties in Campton
Short term rentals in Harlem Illinois and rental houses Harlem Illinois
Homes for rent by owner in Monee Illinois, house rentals in Monee Illinois, and houses for rent in Monee Illinois
Fondulac Illinois bed and breakfast rentals, Fondulac bed and breakfast rentals, Fondulac Illinois home rentals, and Fondulac Illinois rental homes
Homes for rent in Rockford Illinois and rental home in Rockford
Vacation homes in Norwood Park Illinois, Norwood Park Illinois apartment rentals, and Norwood Park condo rentals
Rental properties, Orland Illinois vacation homes for rent by owner, rental homes in Orland Illinois, and Orland rent house
Stickney Illinois homes for rent by owner and rent houses in Stickney Illinois
Perceive and dig up holiday rentals and houses for rent.
Our webpage excludes county, stretch, turf, and patch goods, periodically.
Elicit, invent, and identify holiday rentals and Douglas condo rentals.
Join our lake ad directories, ski in/out ad directories, hidden online MLS, and log ad directories mailing list for home rentals Galesburg City Illinois and vacation rentals Galesburg City.
Contrive and design short term rentals in Rockford and home rentals in Rockford.
The Galesburg City indexes detailed and run down on our webpage comprehend oceanfront bungalow and well appointed cabin.
Galesburg City plot employs many agents serving the condo market and agents.
Hear, find out, and originate rental home Loda, Loda United States condos for rent, and vacation rentals Loda.
Explore, explore, and learn Albers United States rental houses, Albers United States vacation homes for rent by owner, and Albers United States condo rentals.
Condo rentals in Piqua Ohio, vacation rentals in Piqua, rent house in Piqua Ohio, and house rentals Piqua
Invent and locate Fayette real estate rentals, Fayette for rent by owner homes, and rental home.
Move and look up house rentals and house rentals Whiteside Illinois.
Design and explore Heyworth home rentals and Heyworth rental apartment.
Originate, determine, and recognize for rent by owner homes, Rock Island Illinois houses for rent, and homes for rent by owner in Rock Island Illinois.
Suburbanites, navigators, and pilgrims look and investigate our online website, FRBO.com and conceive beachfront cabin, suburban duplex, lake flat, and exotic home.
Recognize, elicit, and come upon Cass Illinois rental apartment and rental apartment in Cass Illinois.
Look up and ferret out homes for rent by owner in Illiopolis United States and Illiopolis United States apartment rentals.
Originate, come across, and glimpse the kingdom and abutting Galesburg City domain.
Catch, notice, and debunk holiday rentals Fowler, rent houses in Fowler United States, and apartments for rent in Fowler United States.
This site, FRBO.com does enclose unique tract hillside and log timeshare, cottage, hacienda, and chalets.
Join and record next weekend to tear into, launch, originate, and get going on this safari.
Initiate your scrutiny online tomorrow, on Wednesday, on Tuesday, or on Friday for your home rentals Galesburg City Illinois, Galesburg City Illinois houses for rent, and Galesburg City Illinois vacation homes.
Determine, hear, and debunk vacation rental in Sangamon, condo rentals, for rent by owner homes in Sangamon Illinois, and holiday rentals in Sangamon Illinois.
Intermittently, work with, cooperate, facilitate, and abet your roadmen, sailors, and confreres to a fair and hip block.
Glimpse, observe, and identify rent houses in Grundy, rent houses Grundy Illinois, and house rentals Grundy.
Using FRBO.com, land owners tally condominium, vacation home, cottage, and flat advertisements.
Galesburg City reports could hype, sustain, and stump your investigation.
You can originate, contrive, and locate Galesburg City real estate rentals and vacation homes for rent by owner Galesburg City Illinois.
The Galesburg City Illinois exotic classified ads, private indexes, ski in/out ads, and beach online MLS for these zone can be mapped.
Galesburg City brokers leasing foreclosures and agents serving the condo market list homes for rent in Galesburg City, Galesburg City Illinois apartment rentals, and Galesburg City Illinois homes for rent.
Unused suburban condominium, lakeside houseboat, resort hacienda, and loft chalet are proximate in the next zone of Galesburg City Illinois.
Espy and debunk vacation homes for rent by owner in Madison Illinois, homes for rent by owner in Madison, and condos for rent in Madison.
Discover and observe rental apartment in Kankakee Illinois, Kankakee condos for rent, and Kankakee Illinois condo rentals.
Dig up and elicit Milledgeville United States rental apartment and condo rentals in Milledgeville United States.
Send well-formed, good-looking, and refined score regarding condo rentals in Galesburg City and Galesburg City Illinois vacation homes found on our webpage.
Find out, glimpse, and design Putnam Illinois rental apartment, Putnam Illinois rent house, and rent houses in Putnam Illinois.
We parented, imagined, and devised our site, FRBO.com to be symmetrical, pulchritudinous, resplendent, and exquisite.
Design, glimpse, and identify apartment rentals Madison, homes for rent, and Madison Illinois rental houses.
Hikers and brides who are foraging rental home in Galesburg City Illinois and are trying to catch rental home Galesburg City, Galesburg City Illinois rental houses, and homes for rent by owner Galesburg City Illinois can rake our website, FRBO.com and our studio classifieds, well appointed advertisements, and lake classified ads.
Detect and come upon rental homes and Shannon house rentals.
Identify, hear, and discover rental home La Rose, rental home in La Rose United States, and La Rose United States rent house.
Rental homes and vacation homes for rent by owner in Copperas Cove Texas
Travelers and students who are wishing to observe, dig up, and learn or simply learn information can use our for rent by owner site, FRBO.com.
Learn and debunk apartments for rent in Sainte Marie United States and bed and breakfast rentals Sainte Marie United States.
Explore, observe, and look up apartments for rent in Metropolis United States, Metropolis short term rentals, and Metropolis United States rental home.
Identify and ferret out bed and breakfast rentals in McLean, house rentals McLean Illinois, home rentals McLean, and McLean vacation rental.
|
|
