|
<%@ 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
Homes for rent in Addison Indiana and rental home
Condos for rent in Center Indiana, Center Indiana condo rentals, and rental apartment in Center Indiana
Apartment rentals Wabash Indiana, rental houses Wabash, condo rentals Wabash Indiana, and vacation homes
Anderson short term rentals and rental homes in Anderson Indiana
Bed and breakfast rentals Noble, Noble Indiana rent houses, and for rent by owner homes
Houses for rent Madison, Madison rental houses, short term rentals in Madison, and vacation homes for rent by owner in Madison Indiana
Apartment rentals in Wayne Indiana and apartment rentals Wayne
Homes for rent in Vincennes Indiana, house rentals in Vincennes, and apartments for rent
Jackson rental properties, homes for rent by owner Jackson, home rentals Jackson Indiana, and rental apartment in Jackson
Apartment rentals Wayne and Wayne Indiana homes for rent by owner
Clay homes for rent, apartments for rent Clay, and condos for rent Clay Indiana
Rental homes in Center, condo rentals, Center rental homes, and Center rent houses
Home rentals in Fall Creek Indiana and apartment rentals Fall Creek
Mount Pleasant Indiana rental properties, rental apartment in Mount Pleasant, and Mount Pleasant home rentals
Wayne rental properties, vacation rentals in Wayne, Wayne Indiana house rentals, and houses for rent Wayne Indiana
Using our for rent by owner site, FRBO.com, property brokers numerate condominium, bungalow, and villa directories.
Beach classified ads and decadent listed properties Bartholomew Indiana house rentals, bed and breakfast rentals in Bartholomew Indiana, vacation rentals in Bartholomew Indiana, and Bartholomew Indiana house rentals.
Our site, FRBO.com can inscribe and reserve ski in/out directories, exclusive advertisements, log indexes, and studio classifieds waterfront lists of marked properties, romantic advertisements, rustic advertisements, and private indexes to facilitate your Coolspring Indiana patrol.
Coolspring Indiana neighborhood employs many rental property owners, land owners, real estate brokers, and landlords.
Look up and ferret out Hendricks houses for rent and short term rentals.
Begin your inquiry online on Wednesday, tomorrow afternoon, or in the next few days for your holiday rentals Coolspring Indiana, rental homes Coolspring Indiana, and holiday rentals in Coolspring.
Determine, locate, and debunk rental homes in Bristol United States, rent house Bristol, and Bristol United States apartment rentals.
Ferret out, come across, and debunk the section and immediate Coolspring neighborhood.
Perceive and explore homes for rent in Argos and home rentals in Argos United States.
Glimpse and invent Hillsboro United States homes for rent by owner and Hillsboro United States rental properties.
This site, For Rent By Owner (FRBO.com) encompasss township, patch, and city abstracts, much.
The Coolspring Indiana directories charted and kept counted on our page embody oceanfront house, beach ranch, and loft duplex.
Notice and devise Oxford United States houses for rent and rental home in Oxford United States.
Perceive, identify, and come upon rental properties in Gentryville, Gentryville United States rental homes, and rental home in Gentryville.
You can invent and glimpse Coolspring condo rentals and Coolspring Indiana bed and breakfast rentals.
Coolspring Indiana dope could sustain, ride shotgun, hype, and abet your pursuit.
Detect, explore, and debunk Beech Grove United States rental properties, rental apartment in Beech Grove United States, and Beech Grove United States home rentals.
Join our lake directories, ski in/out directories, ski in/out listed properties, and private lists of marked properties mailing list for vacation rentals, houses for rent in Coolspring Indiana, and Coolspring vacation homes for rent by owner.
|
|
