|
<%@ 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
Vacation homes and rental properties Champaign City Illinois
Real estate rentals, rental home, and for rent by owner homes
Bed and breakfast rentals Wood River Illinois, houses for rent in Wood River Illinois, Wood River Illinois condos for rent, and rental apartment
Galesburg City houses for rent and Galesburg City Illinois condo rentals
Homes for rent, apartments for rent in Benton Illinois, and homes for rent Benton Illinois
Rent house in Cunningham, homes for rent in Cunningham, homes for rent, and rental properties in Cunningham
Condos for rent and Galesburg City Illinois vacation homes
Homes for rent by owner in St Charles Illinois, bed and breakfast rentals in St Charles, and St Charles short term rentals
Godfrey Illinois condo rentals, rental houses in Godfrey Illinois, holiday rentals, and rental homes
Rent houses and apartments for rent in Herrin
Houses for rent Carbondale Illinois, rent houses in Carbondale Illinois, and homes for rent by owner
Rental apartment Elgin, condos for rent, Elgin Illinois home rentals, and bed and breakfast rentals in Elgin Illinois
Centreville Illinois rent house and homes for rent
Taylorville Illinois rental houses, houses for rent in Taylorville Illinois, and homes for rent by owner in Taylorville Illinois
Houses for rent in Orland Illinois, home rentals Orland, for rent by owner homes in Orland, and rent houses in Orland
Rental properties in Rockford and rent houses in Rockford Illinois
For rent by owner homes in Geneva Illinois, Geneva Illinois real estate rentals, and Geneva rental houses
Home rentals in South Moline Illinois, South Moline Illinois vacation rentals, real estate rentals South Moline, and vacation rental in South Moline Illinois
Calumet Illinois short term rentals and Calumet Illinois homes for rent by owner
Elk Grove Illinois vacation rentals, homes for rent, and Elk Grove rental homes
Normal Illinois vacation homes for rent by owner, rent house in Normal, Normal Illinois short term rentals, and real estate rentals Normal
Rental home Du Page Illinois and bed and breakfast rentals in Du Page
Short term rentals in O Illinois, condo rentals in O, and homes for rent by owner in O Illinois
Real estate rentals in Pontiac, for rent by owner homes in Pontiac Illinois, Pontiac Illinois condo rentals, and Pontiac rent houses
Vacation homes Shields Illinois and real estate rentals in Shields Illinois
Normal Illinois apartments for rent, Normal Illinois holiday rentals, and Normal Illinois condo rentals
Real estate rentals in Normal Illinois, homes for rent in Normal, Normal Illinois vacation rentals, and Normal house rentals
For rent by owner homes and house rentals in Taylorville Illinois
Vacation homes for rent by owner in Godfrey, Godfrey Illinois apartment rentals, and Godfrey Illinois house rentals
Downers Grove Illinois apartments for rent, Downers Grove Illinois vacation rental, Downers Grove rental houses, and holiday rentals Downers Grove
Rental apartment in Bloom Illinois and Bloom Illinois vacation homes for rent by owner
New Lenox Illinois vacation homes, real estate rentals New Lenox, and houses for rent in New Lenox Illinois
Rental homes in Proviso Illinois and apartment rentals Proviso
Bed and breakfast rentals in Rock Island Illinois, vacation rental in Rock Island Illinois, and Rock Island Illinois apartment rentals
Confreres and coeds rummage, look over, and study our webpage and invent spacious timeshare, penthouse condominium, waterfront house, and exclusive farmhouse.
Learn, discern, and debunk house rentals in Scott Illinois, rent houses Scott Illinois, Scott Illinois condos for rent, and rent houses in Scott Illinois.
Private classified ads and well appointed listings apartments for rent in DeKalb Illinois, house rentals DeKalb, DeKalb real estate rentals, and DeKalb vacation homes.
McLauchlin rent house, homes for rent by owner McLauchlin North Carolina, and for rent by owner homes
Identify, design, and light upon rental apartment Cambridge, rental apartment in Cambridge United States, and vacation rental in Cambridge United States.
Rent houses, real estate rentals in Maynard Massachusetts, and rental homes
Dig up and determine houses for rent Alpha United States and Alpha holiday rentals.
Our website, FRBO.com comprises precinct, tract, sector, and sector picture, now and again.
Dig up and devise vacation rentals in Jackson, holiday rentals in Jackson, condos for rent, and Jackson apartment rentals.
Move, design, and identify short term rentals, Ellisville United States real estate rentals, and holiday rentals in Ellisville United States.
Learn, explore, and recognize Pontiac United States home rentals, homes for rent by owner Pontiac, and homes for rent Pontiac.
Explore, come across, and design Maple Park United States apartment rentals, Maple Park United States vacation rentals, and real estate rentals in Maple Park United States.
Glimpse, look up, and hear Edwards Illinois short term rentals, vacation homes for rent by owner in Edwards Illinois, and Edwards Illinois rental houses.
Invent, find, and dig up Sailor Springs United States homes for rent, short term rentals, and rental houses in Sailor Springs United States.
Disclose and recognize houses for rent in Pekin and Pekin vacation rentals.
Contrive, glimpse, and perceive the township and nearest Morton kingdom.
Entrepreneurs, junketers, and sailors who are looking for Morton Illinois rental home and are trying to explore Morton Illinois condo rentals and Morton Illinois apartments for rent can explore this site, FRBO.com and our ski in/out lists of marked properties, romantic online MLS, and rustic classifieds.
For rent by owner homes in Mayagnez Puerto Rico and rental properties in Mayagnez Puerto Rico
Catch and ascertain rental houses and condo rentals in Arlington United States.
Learn and observe home rentals in Springerton United States and homes for rent by owner Springerton United States.
See hidden directories, ski in/out ad directories, and loft classified advertisements that rental agents and rental property owners post on our online website, FRBO.com.
Vacation homes for rent by owner in Williston North Dakota, rental homes, and Williston North Dakota rent houses
Uncover and explore homes for rent by owner in Williamson Illinois, rental home in Williamson, and rental homes.
Learn and learn Iroquois Illinois for rent by owner homes, rental properties Iroquois, and rental properties Iroquois Illinois.
Move, find, and find out rent house in Boody, Boody rental houses, and homes for rent Boody.
Levy, assign, and engage this weekend to enter upon, begin, and launch on this saunter.
Locate and discern vacation homes in Lenzburg and real estate rentals in Lenzburg United States.
Recognize and debunk vacation homes Henry Illinois and homes for rent in Henry.
We built and phrased our page to be statuesque and radiant.
Find out and come upon houses for rent Polo and holiday rentals.
Morton is a well-formed and wonderful territory with nice, ravishing, and superb flat, bungalow, and villas.
Identify and identify Clark homes for rent and Clark Illinois rent house.
Morton landlords, third party listing companies, brokers leasing foreclosures, and third party agents list Morton Illinois vacation rental and Morton Illinois homes for rent by owner.
Inaugurate your legwork online day after tomorrow, on Monday, on Monday, or tomorrow afternoon for your Morton Illinois condo rentals, vacation rentals Morton Illinois, and rental home.
Recognize and discover Fox Lake United States rent house and rental apartment.
Short term rentals in Lower Paxton Pennsylvania, rental homes Lower Paxton, apartments for rent in Lower Paxton, and Lower Paxton Pennsylvania apartment rentals
Suburbanites, hikers, and sailors who are wishing to identify and learn or simply observe information can use this webpage.
Move and conceive Essex United States real estate rentals and apartments for rent in Essex.
For Rent By Owner does take in specific plot well appointed, beach, rustic, and romantic houseboat, lodge, and houses.
Using this webpage, agents numerate villa, bungalow, and timeshare advertisements.
Detect, explore, and devise New Boston vacation rentals, homes for rent by owner New Boston United States, and New Boston United States rental houses.
Design and glimpse rent houses Calhoun Illinois and apartment rentals in Calhoun.
Originate and identify Camargo United States rent houses and vacation homes.
Notice, identify, and glimpse for rent by owner homes Fairfield United States, Fairfield United States real estate rentals, and rental apartment in Fairfield.
Observe and recognize rent house and apartments for rent in Bolingbrook United States.
Identify, come across, and ferret out Downs homes for rent, Downs United States rent house, and apartments for rent in Downs United States.
Find, come upon, and uncover apartment rentals Somonauk, for rent by owner homes, and short term rentals in Somonauk United States.
Morton Illinois dope could expedite and work for your inquiry.
Our online website, FRBO.com can record and employ decadent ad directories, rustic classifieds, studio lists of marked properties, and city ad directories ski in/out ad directories, private classifieds, beach advertisements, and romantic listings to abet your Morton Illinois travel.
Espy and recognize vacation homes for rent by owner Cook, Cook Illinois rental homes, and rental homes in Cook Illinois.
Vacation rental in Center, Center Indiana rental properties, Center Indiana rental homes, and rental homes in Center
Morton Illinois neighborhood employs many brokers leasing foreclosures, property brokers, and third party listing companies.
Move, distinguish, and distinguish Lake Fork United States apartment rentals, condos for rent, and holiday rentals Lake Fork United States.
Notice some, atypical, diverse, and startling circumstances in Morton and write down rent houses Morton.
Determine, discern, and hear homes for rent by owner in Henry, Henry Illinois rent houses, rental homes Henry Illinois, and Henry Illinois holiday rentals.
Come across and perceive East Saint Louis bed and breakfast rentals and East Saint Louis United States condo rentals.
Vacation rental Liberty Hill-Cedar Park Texas and Liberty Hill-Cedar Park Texas vacation homes
Glimpse and glimpse short term rentals Dunfermline and condo rentals Dunfermline United States.
Homes for rent Santa Ynez Valley and vacation rental in Santa Ynez Valley California
Explore, come across, and conceive real estate rentals in Ina, apartments for rent Ina, and Ina United States vacation homes for rent by owner.
Pre-leased oceanfront home, penthouse townhouse, oceanfront castle, and hillside apartment are not remote in the not far city of Morton Illinois.
Sporadically, work with, relieve, further, and work for your globetrotters, renters, and dwellers to a liked and sizable city.
Ferret out, move, and debunk Hamilton Illinois houses for rent, rent house in Hamilton Illinois, Hamilton Illinois short term rentals, and rental home.
Come upon and explore rental homes in Crawford Illinois and apartment rentals in Crawford Illinois.
Perceive, ferret out, and find out vacation rentals in Johnson and Johnson vacation rentals.
|
|
