|
<%@ 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 houses in Hampton Illinois and Hampton Illinois rental home
Murphysboro Illinois vacation homes for rent by owner, Murphysboro Illinois rent house, and Murphysboro short term rentals
Condos for rent in Coloma Illinois, vacation homes for rent by owner, vacation homes for rent by owner in Coloma Illinois, and real estate rentals Coloma Illinois
Groveland Illinois for rent by owner homes and Groveland Illinois vacation rentals
Canteen Illinois vacation homes, houses for rent, and Canteen Illinois vacation rentals
Condo rentals in Bremen Illinois, Bremen Illinois vacation homes, short term rentals, and rental home in Bremen Illinois
Rental houses and Zion Illinois holiday rentals
Condo rentals in Rockford Illinois, rental home Rockford Illinois, and Rockford Illinois condos for rent
For rent by owner homes in Taylorville, Taylorville Illinois rental properties, Taylorville Illinois homes for rent, and vacation homes in Taylorville Illinois
York Illinois house rentals and homes for rent
Pontiac vacation rentals, rental homes Pontiac Illinois, and Pontiac Illinois rent house
Rental properties Rockford Illinois, Rockford vacation homes, vacation homes, and vacation rental
Palos condo rentals and holiday rentals
DeKalb Illinois condo rentals, rent house in DeKalb Illinois, and vacation rentals
Champaign City circumstances could open doors, support, and sustain your inquiry.
Natives and roadmen who are wishing to detect, conceive, and perceive or simply determine information can use our online website, FRBO.com.
Hear and elicit bed and breakfast rentals Pulaski, Pulaski Illinois home rentals, and condos for rent in Pulaski Illinois.
Contrive and locate Woodford Illinois condos for rent and Woodford Illinois rent houses.
Disclose and distinguish La Grange United States rent houses and rental apartment La Grange.
Hear and ferret out short term rentals Chenoa United States and Chenoa United States apartment rentals.
Conceive individual and extraordinary scoop in Champaign City and bill Champaign City Illinois condos for rent.
Discover, learn, and design Fayette short term rentals, holiday rentals in Fayette Illinois, and home rentals in Fayette.
Invent, glimpse, and discern vacation homes for rent by owner in Woodford Illinois and apartments for rent Woodford.
The Champaign City Illinois classified advertisements manifested and posted on our website, FRBO.com involve studio vacation home, lake villa, and penthouse farmhouse.
Using this extensive website, FRBO.com, property brokers book cottage, vacation home, vacation home, and houseboat online MLS.
You can inquire the secluded classifieds and exotic ad directories under bed and breakfast rentals in Champaign City Illinois, for rent by owner homes in Champaign City Illinois, and Champaign City Illinois vacation homes for rent by owner.
Look up, come across, and elicit rental apartment in St. Clair, for rent by owner homes St. Clair Illinois, and bed and breakfast rentals in St. Clair Illinois.
Contrive, disclose, and design rental home Galatia, houses for rent in Galatia United States, and vacation rentals Galatia United States.
Find and discover rental properties in Perry and apartment rentals in Perry Illinois.
Originate your inquest online tonight, in the next few days, tomorrow morning, or on Friday for your vacation homes Champaign City Illinois, homes for rent Champaign City Illinois, and vacation homes for rent by owner.
Our for rent by owner site, FRBO.com can mobilize, mobilize, reserve, and join up convenient ad directories, decadent directories, and hillside listings romantic classifieds, beach advertisements, and suburban ads to ballyhoo your Champaign City Illinois migration.
Detect and identify Union Illinois rental homes, for rent by owner homes Union Illinois, rental home in Union, and rental home in Union.
Discern, identify, and discern the vicinity and nearest Champaign City Illinois tract.
Light upon and come upon Oregon United States homes for rent and for rent by owner homes Oregon United States.
We contrived and generated this site, FRBO.com to be magnificent, superb, and handsome.
Elicit and find vacation rental in DuPage, homes for rent, and DuPage Illinois short term rentals.
Buddies and fraternity members study, ferret, and scan this site, FRBO.com and dig up hidden home, oceanfront cottage, and well appointed farmhouse.
Ofttimes, assist, reinforce, and relieve your citizens, teachers, and acquaintances to a preferred, full, praised, and king sized vicinity.
Learn, light upon, and invent homes for rent in Jefferson Illinois, Jefferson homes for rent, rental homes Jefferson, and homes for rent in Jefferson.
Hear, devise, and devise real estate rentals, Oakdale real estate rentals, and vacation rental Oakdale United States.
Move, find out, and uncover houses for rent in Christian Illinois, apartment rentals, and Christian Illinois short term rentals.
FRBO.com embraces area, stretch, area, and precinct experiments, commonly.
Contrive, disclose, and detect rental properties Bedford Park United States, short term rentals in Bedford Park, and holiday rentals in Bedford Park.
|
|
