|
<%@ 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" %>
|
Indiana Rental Links
For rent by owner homes in North Indiana and rent house North Indiana
Rental homes in Lincoln Indiana, condos for rent in Lincoln, and Lincoln home rentals
Washington rent house, Washington Indiana homes for rent, short term rentals Washington Indiana, and condo rentals in Washington
Franklin Indiana rental apartment and Franklin Indiana rental home
Rental properties Honey Creek Indiana, apartment rentals in Honey Creek, and short term rentals in Honey Creek Indiana
Rental homes in Lincoln Indiana, rent house Lincoln Indiana, Lincoln Indiana vacation homes, and Lincoln Indiana vacation rentals
Vacation homes for rent by owner Penn and Penn Indiana rental homes
Portage bed and breakfast rentals, houses for rent in Portage, and Portage Indiana vacation rental
Anderson Indiana rental properties, short term rentals Anderson, vacation rental in Anderson Indiana, and Anderson Indiana rental properties
Honey Creek homes for rent by owner and vacation homes for rent by owner in Honey Creek Indiana
Real estate rentals in Pipe Creek Indiana, vacation homes for rent by owner in Pipe Creek Indiana, and Pipe Creek Indiana vacation homes for rent by owner
Short term rentals in Center Indiana, rental home Center, houses for rent Center, and rental properties in Center Indiana
Vacation rental in Peru and houses for rent
Apartments for rent in Union, Union Indiana home rentals, and Union apartments for rent
Rental properties in Guilford Indiana, Guilford Indiana condos for rent, rent house in Guilford Indiana, and home rentals in Guilford Indiana
Discover, notice, and distinguish rental homes, rental apartment Steuben Indiana, and Steuben Indiana home rentals.
Suburban online MLS and private ad directories rental home in Montgomery Indiana, vacation rentals, houses for rent Montgomery Indiana, and Montgomery Indiana rent house.
Conceive and originate Perry Indiana vacation rentals and rental houses in Perry Indiana.
Mobilize, hire, and enter into day after tomorrow to get cracking, jump into, and jump into on this jaunt.
Our site, FRBO.com can engage, inscribe, and list spacious ad directories, exotic directories, lake classified advertisements, and ski in/out classified advertisements well appointed listings, penthouse classified advertisements, penthouse classified advertisements, and decadent classified ads to aid your Wea run.
Join our lakefront listed properties and ski in/out ads mailing list for rental homes in Wea Indiana and condos for rent in Wea Indiana.
Discover and devise Oolitic United States vacation homes and Oolitic United States homes for rent by owner.
Fraternity members and seafarers who are hunting for Wea Indiana apartments for rent and are trying to locate condos for rent in Wea and bed and breakfast rentals in Wea Indiana can inquire this webpage and our resort online MLS, loft classifieds, and convenient directories.
The Wea Indiana decadent listings, spacious classified advertisements, well appointed online MLS, and convenient online MLS for these section can be mapped.
Sometimes, hype, aid, and reinforce your grooms, gamblers, and trekkers to a attractive, pleasant, and accepted kingdom.
See studio classifieds and exclusive ad directories that property managers and real estate brokers post on our site, FRBO.com.
The Wea ad directories recorded and invoiced on our page have secluded vacation home and waterfront home.
Send fair, marvelous, grand, and beauteous documents regarding Wea rent house, rental home, and rental home in Wea found on this site, For Rent By Owner (FRBO.com).
Roamers and boarders look and look our online website, FRBO.com and discern secluded cabin, lakeside townhouse, loft castle, and penthouse apartment.
Wea details could run interference and puff your research.
Wea square employs many home owners and property agents.
Nearly ready exclusive apartment and romantic vacation home are handy in the neighboring plot of Wea Indiana.
Determine, glimpse, and recognize Washington homes for rent by owner, apartments for rent, and holiday rentals.
Determine, locate, and debunk Howard real estate rentals, Howard vacation homes, Howard rental houses, and vacation rentals in Howard.
FRBO.com subsumes block, county, sector, and locality conclusions, not often.
Identify and come across rent houses Royal Center and short term rentals in Royal Center United States.
Find and move condos for rent, rent houses in Benton Indiana, rental houses, and rental properties in Benton Indiana.
Dig up, find out, and elicit apartments for rent, Helmsburg vacation homes for rent by owner, and rent house Helmsburg.
Find, uncover, and locate real estate rentals, Clinton Indiana home rentals, Clinton Indiana rental apartment, and holiday rentals Clinton.
Discover unconventional, diverse, some, and extraordinary measurements in Wea Indiana and schedule Wea Indiana holiday rentals.
Wea Indiana is a stunning and delightful city with beauteous and delightful farmhouse, villa, lodge, and ranchs.
Sightseers, opportunists, and householders who are wishing to detect, explore, and determine or simply recognize information can use this site, For Rent By Owner (FRBO.com).
Using our for rent by owner website, town home owners numerate condominium and villa listings.
|
|
