|
<%@ 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
Washington Indiana home rentals and condo rentals Washington
Perry Indiana rental homes, Perry Indiana real estate rentals, and rental homes Perry
Rent houses Fall Creek, home rentals in Fall Creek Indiana, rent house in Fall Creek Indiana, and for rent by owner homes in Fall Creek
Center Indiana rental houses and rent house Center
Perry Indiana bed and breakfast rentals, vacation homes for rent by owner in Perry Indiana, and vacation homes for rent by owner Perry
Homes for rent in Clay Indiana, vacation homes, Clay Indiana real estate rentals, and rent houses in Clay
Vacation homes for rent by owner in White River Indiana and apartment rentals in White River Indiana
Center Indiana houses for rent, vacation homes in Center Indiana, and for rent by owner homes in Center Indiana
Rental homes Calumet, Calumet for rent by owner homes, bed and breakfast rentals, and real estate rentals in Calumet
Homes for rent by owner in Center Indiana and Center Indiana vacation homes for rent by owner
Holiday rentals in Center Indiana, holiday rentals Center Indiana, and Center Indiana rental houses
Rental homes in Center Indiana, Center Indiana home rentals, Center Indiana vacation homes for rent by owner, and Center Indiana homes for rent
Apartments for rent and rental homes in Aboite
Short term rentals in Franklin Indiana, apartments for rent Franklin Indiana, and Franklin rental apartment
Vacation rentals in Union Indiana, rent house Union Indiana, Union Indiana houses for rent, and holiday rentals in Union Indiana
Perry Indiana homes for rent and vacation rentals in Perry
Washington Indiana real estate rentals, bed and breakfast rentals, and Washington Indiana rent house
Harris Indiana bed and breakfast rentals, Harris Indiana short term rentals, vacation homes for rent by owner Harris Indiana, and rent houses Harris Indiana
Apartment rentals in Shawswick Indiana and apartments for rent Shawswick Indiana
Short term rentals in Union Indiana, Union Indiana apartments for rent, and rental apartment
Home rentals Aboite, holiday rentals, vacation rentals in Aboite Indiana, and rental properties
Explore and hear rental home Rush Indiana and home rentals Rush.
Eel Indiana is a fair and elegant turf with taking, sublime, and statuesque flat and duplexs.
Conceive, find, and explore Lapel United States rental homes, homes for rent in Lapel United States, and apartments for rent Lapel.
You can examine the exclusive ads, well appointed ads, and exotic listings under real estate rentals in Eel Indiana, short term rentals Eel, and vacation rentals in Eel.
Debunk, notice, and observe rental houses in De Kalb Indiana, De Kalb Indiana home rentals, homes for rent in De Kalb Indiana, and apartment rentals De Kalb.
Identify, ascertain, and invent Parke Indiana homes for rent by owner and condos for rent in Parke.
Recognize and find out Logansport United States home rentals and Logansport United States vacation rentals.
Uncover, recognize, and conceive rent houses in Orange and house rentals in Orange Indiana.
Notice, relocate, and glimpse the vicinity and not faraway Eel Indiana area.
Dig up, ascertain, and come upon Guilford United States house rentals, holiday rentals Guilford, and condos for rent in Guilford United States.
You can perceive, perceive, and recognize vacation rental in Eel and houses for rent in Eel Indiana.
Disclose, uncover, and originate short term rentals Shelburn United States, Shelburn United States homes for rent, and Shelburn rental properties.
Dig up and devise homes for rent by owner in Monterey and real estate rentals in Monterey.
Recognize and originate vacation homes for rent by owner in Parke Indiana and short term rentals.
Ascertain and contrive houses for rent Waldron and rental home in Waldron United States.
Eel Indiana domain employs many condo owners, agents, property owners, and town home owners.
Incorporate, draft, and muster tomorrow evening to get cracking, begin, and embark on on this migration.
Invent, distinguish, and debunk Inglefield United States vacation homes for rent by owner, rental houses Inglefield, and Inglefield United States real estate rentals.
Identify and determine short term rentals, real estate rentals Starke Indiana, Starke Indiana rental homes, and real estate rentals in Starke.
Tenants, traveling men, and professors scout and smell around For Rent By Owner and come across well appointed home, lakefront house, exclusive townhouse, and lakeside castle.
Come across, disclose, and glimpse rental apartment in De Kalb Indiana, apartment rentals, real estate rentals in De Kalb, and for rent by owner homes in De Kalb Indiana.
Design and originate vacation rental Crawford, short term rentals in Crawford, and vacation homes in Crawford.
Discover, disclose, and ferret out Jasper Indiana vacation rentals, Jasper Indiana vacation rental, rental apartment in Jasper, and vacation rental in Jasper.
Floaters, traveling women, and venturers who are chasing after vacation rental Eel Indiana and are trying to come across vacation homes for rent by owner, vacation homes for rent by owner, and Eel vacation homes can scour our webpage and our suburban lists of marked properties, resort classified ads, spacious listings, and lakeside lists of marked properties.
Using this website, FRBO.com, property agents inventory cabin, ranch, ranch, and houseboat online MLS.
Lakefront classified advertisements and well appointed classifieds rental properties Vigo Indiana, Vigo for rent by owner homes, real estate rentals in Vigo, and Vigo rent house.
Our for rent by owner site, FRBO.com can draft and join decadent advertisements and lakefront advertisements private online MLS, suburban lists of marked properties, decadent listings, and decadent classifieds to serve your Eel Indiana patrol.
Learn, look up, and come upon rental home Clinton, Clinton rental houses, and vacation homes.
Ferret out, identify, and detect Elkhart Indiana rent houses and rent houses Elkhart.
Elicit and uncover Adams Indiana condos for rent and Adams Indiana rental properties.
|
|
