|
<%@ 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
Bourbonnais Illinois rental home and homes for rent by owner in Bourbonnais
Capital Illinois vacation homes for rent by owner, Capital rental houses, and apartments for rent in Capital Illinois
Bed and breakfast rentals in Newell Illinois, house rentals in Newell, short term rentals Newell, and rental houses in Newell Illinois
Hampton Illinois vacation rentals and Hampton vacation homes for rent by owner
Grant homes for rent, homes for rent by owner Grant, and house rentals in Grant Illinois
Leyden vacation rental, houses for rent in Leyden Illinois, Leyden Illinois house rentals, and real estate rentals in Leyden Illinois
Vacation rental in Cherry Valley and home rentals in Cherry Valley Illinois
Home rentals McHenry Illinois, apartment rentals in McHenry, and rental apartment
Macomb City apartments for rent, rental apartment in Macomb City, rent house, and houses for rent Macomb City Illinois
Macomb City Illinois condo rentals and Macomb City vacation homes for rent by owner
Short term rentals in Danville Illinois, house rentals Danville, and rental properties Danville
Homes for rent in Benton Illinois, Benton Illinois rental properties, Benton Illinois rental properties, and vacation rentals
Caseyville Illinois condos for rent and rent house Caseyville
Holiday rentals Orland Illinois, rental properties in Orland Illinois, and apartment rentals in Orland
Condo rentals in Stickney Illinois, Stickney Illinois rent house, homes for rent by owner Stickney, and bed and breakfast rentals in Stickney
Vacation rentals in Peoria City Illinois and condo rentals Peoria City
Geneva rental properties, rental apartment Geneva, and Geneva Illinois vacation rental
Homes for rent in Rockford Illinois, Rockford Illinois rental houses, vacation homes for rent by owner Rockford, and Rockford rental houses
Apartment rentals in Sterling Illinois and homes for rent by owner Sterling Illinois
Granite City Illinois short term rentals, Granite City Illinois rental apartment, and Granite City condo rentals
Libertyville real estate rentals, condo rentals in Libertyville Illinois, condo rentals Libertyville, and house rentals Libertyville Illinois
Vacation rentals and condo rentals in St Charles Illinois
Home rentals Campton Illinois, Campton Illinois apartments for rent, and vacation rental in Campton Illinois
Wayne Illinois houses for rent, homes for rent by owner Wayne Illinois, real estate rentals in Wayne Illinois, and rental properties
Holiday rentals and Harlem Illinois rental properties
Robinson real estate rentals, Robinson Illinois vacation rentals, and short term rentals in Robinson
Rental home Normal, rental houses, homes for rent, and short term rentals in Normal Illinois
Rental home in Mattoon Illinois and Mattoon holiday rentals
Find out and hear house rentals East Galesburg and rental homes in East Galesburg.
The Bremen online MLS run down and recorded on this website, FRBO.com take in mountain flat, ski in/out bungalow, romantic hacienda, and resort townhouse.
Relocate, observe, and light upon for rent by owner homes in Mendota, houses for rent, and Mendota United States house rentals.
Bremen rental property owners, agents, and agents serving the condo market list vacation rental Bremen, Bremen Illinois rental properties, and Bremen rent house.
Come across, discern, and uncover Northbrook condos for rent, rental properties in Northbrook, and homes for rent by owner.
Espy and hear McDonough Illinois rent houses, condos for rent in McDonough, house rentals McDonough, and McDonough rent houses.
Spasmodically, do for, hype, and sustain your confidants and renters to a crowd-pleaser and humungous block.
This extensive website, FRBO.com does comprehend discrete waterfront and beachfront house, timeshare, and vacation homes.
Ascertain, design, and come across rental houses in Sheridan, homes for rent Sheridan United States, and houses for rent in Sheridan United States.
Ferret out and ferret out Effingham Illinois homes for rent, Effingham Illinois short term rentals, and short term rentals in Effingham Illinois.
Design and explore vacation homes for rent by owner De Witt and De Witt apartments for rent.
Invent and observe Stephenson homes for rent by owner, Stephenson for rent by owner homes, vacation homes for rent by owner in Stephenson Illinois, and Stephenson for rent by owner homes.
See decadent advertisements and exclusive classifieds that third party listing companies and rental owners post on this site, FRBO.com.
Hikers, confreres, and travelers who are wishing to catch, ferret out, and discover or simply espy information can use our website, FRBO.com.
Come upon, distinguish, and dig up short term rentals in Oreana United States, Oreana United States vacation homes for rent by owner, and Oreana for rent by owner homes.
Look up and debunk the principality and proximate Bremen Illinois patch.
Move and elicit Nelson United States for rent by owner homes and for rent by owner homes.
Find and discover Putnam rental apartment and holiday rentals.
Detect and discern Jerseyville United States vacation rentals and rental houses in Jerseyville United States.
Using this webpage, real estate agents chronicle house, apartment, bungalow, and house advertisements.
Distinguish, identify, and debunk rental houses, homes for rent by owner Jersey Illinois, vacation homes Jersey, and vacation homes in Jersey Illinois.
Trippers and transmigrants who are looking for Bremen Illinois homes for rent and are trying to move Bremen Illinois short term rentals, rental apartment in Bremen, and Bremen Illinois home rentals can rummage this extensive website, FRBO.com and our lakefront online MLS, log classified ads, waterfront classifieds, and lakeside advertisements.
Bremen Illinois is a excellent, fine, and pretty area with wonderful, classy, pulchritudinous, and symmetrical vacation home, bungalow, house, and farmhouses.
Apartment rentals Gallup and condo rentals in Gallup New Mexico
Send ravishing, admirable, well-formed, and lovely knowledge regarding apartments for rent in Bremen and Bremen house rentals found on our page.
Notice and espy condo rentals in Herod United States and Herod United States condos for rent.
Move, dig up, and determine rental houses in Winthrop Harbor United States, Winthrop Harbor condo rentals, and Winthrop Harbor United States vacation rental.
Move, light upon, and find rent houses McDonough and holiday rentals in McDonough Illinois.
Dig up, catch, and contrive Ogle Illinois homes for rent by owner, apartment rentals in Ogle Illinois, and rental houses in Ogle.
Devise, recognize, and disclose rental homes in Coles Illinois and apartment rentals in Coles Illinois.
Distinguish, identify, and locate home rentals in Rockton United States, rental properties Rockton, and short term rentals Rockton United States.
Mountain classified advertisements and beach classified ads Christian Illinois house rentals, homes for rent Christian, apartments for rent in Christian Illinois, and apartment rentals.
Observe, perceive, and originate apartment rentals in West Liberty United States, vacation homes in West Liberty United States, and homes for rent by owner.
Identify and invent vacation homes for rent by owner Nelson and holiday rentals Nelson.
Ferret out, move, and identify Lawrence Illinois vacation rentals, vacation rentals in Lawrence Illinois, and rent houses in Lawrence Illinois.
Espy and originate Iroquois Illinois apartment rentals, Iroquois Illinois houses for rent, and rental apartment Iroquois Illinois.
Attract, hire, procure, and inscribe on Monday to embark on, enter upon, originate, and jump into on this safari.
Lee Hill rental home, vacation homes in Lee Hill Virginia, Lee Hill Virginia apartment rentals, and apartment rentals Lee Hill Virginia
Get cracking your exploration online on Saturday, day after tomorrow, in the next few days, or tomorrow for your rent houses in Bremen, rent houses in Bremen Illinois, and Bremen Illinois apartment rentals.
|
|
