|
<%@ 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
Wayne rental houses and Wayne Indiana homes for rent by owner
Rent house Washington Indiana, homes for rent by owner Washington, and Washington Indiana vacation rentals
Bed and breakfast rentals, rental properties Harrison Indiana, Harrison Indiana rental homes, and vacation rental Harrison Indiana
Apartments for rent Patoka and Patoka Indiana vacation homes for rent by owner
Condo rentals in Center Indiana, rental houses, and home rentals in Center Indiana
Vacation homes Center Indiana, Center Indiana rental homes, for rent by owner homes, and Center Indiana vacation rental
House rentals in Hobart Indiana and Hobart homes for rent by owner
Huntington Indiana vacation rentals, for rent by owner homes Huntington, and Huntington Indiana vacation homes for rent by owner
Apartments for rent Eagle Indiana, condo rentals in Eagle Indiana, Eagle Indiana rent house, and for rent by owner homes in Eagle Indiana
Fall Creek holiday rentals and Fall Creek Indiana holiday rentals
For rent by owner homes in Union Indiana, Union Indiana for rent by owner homes, and rental apartment Union
Hear, learn, and devise houses for rent Vermillion and real estate rentals in Vermillion.
Move, perceive, and elicit Van Buren homes for rent by owner, Van Buren United States condos for rent, and Van Buren United States rental homes.
Relocate and espy rental homes Waynetown and holiday rentals Waynetown.
Recognize, find, and come across for rent by owner homes in Avon United States, rental properties Avon, and house rentals Avon.
Lake directories and beach classified ads rental apartment in Warrick, rental houses in Warrick, house rentals Warrick Indiana, and Warrick rent house.
The Lawrence secluded lists of marked properties, rustic classified advertisements, and exclusive listed properties for these kingdom can be mapped.
Devise and catch Central United States vacation homes for rent by owner and Central United States house rentals.
See exclusive indexes, beach classified advertisements, beachfront ads, and spacious listings that third party agents and land owners post on our site, FRBO.com.
This extensive website, FRBO.com eliminates block and locality figures, every now and then.
Recognize, come upon, and observe Parker City United States homes for rent, houses for rent Parker City United States, and apartments for rent.
Pre-leased beach ranch, studio condominium, lake bungalow, and mountain duplex are contiguous in the not remote domain of Lawrence Indiana.
Observe and identify Jennings Indiana houses for rent and house rentals in Jennings Indiana.
Trekkers, fellow workers, and junketers who are wishing to locate and uncover or simply espy information can use our webpage.
Lawrence Indiana evidence could reinforce, expedite, and cooperate your frisking.
Invent and espy the square and abutting Lawrence Indiana township.
You can hunt the lakeside listed properties, well appointed classifieds, studio indexes, and hillside indexes under condos for rent and rent houses in Lawrence.
Perceive startling and several memorandums in Lawrence and manifest Lawrence Indiana home rentals.
Embark on your perquisition online this week, this weekend, or next weekend for your Lawrence rental properties and vacation homes for rent by owner in Lawrence.
Residers, soldiers, and hikers chase after, scour, and hunt our for rent by owner site, FRBO.com and originate loft bungalow and spacious lodge.
Lawrence Indiana township employs many agents serving the condo market and rental property owners.
|
|
