|
<%@ 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
Charlestown Indiana apartment rentals and home rentals in Charlestown Indiana
Vacation rentals in Fall Creek, Fall Creek rent house, and apartment rentals Fall Creek
White River Indiana rental apartment, White River Indiana vacation rentals, real estate rentals White River, and rental apartment in White River Indiana
Condo rentals and rental homes Troy Indiana
Coolspring Indiana condo rentals, holiday rentals in Coolspring Indiana, and real estate rentals in Coolspring Indiana
Center Indiana homes for rent, homes for rent Center Indiana, vacation rental Center Indiana, and condo rentals Center
Condo rentals and vacation homes for rent by owner in Anderson Indiana
Warren Indiana short term rentals, homes for rent Warren, and vacation rental
Rental home in New Albany Indiana, rental homes in New Albany Indiana, holiday rentals in New Albany Indiana, and vacation homes for rent by owner New Albany
Rent houses Wabash and Wabash Indiana bed and breakfast rentals
Sugar Creek rent house, Sugar Creek Indiana vacation homes for rent by owner, and rental homes in Sugar Creek Indiana
Vacation homes for rent by owner in Wayne Indiana, vacation homes for rent by owner in Wayne Indiana, vacation homes for rent by owner, and vacation rentals Wayne Indiana
Wayne condo rentals and Wayne Indiana rent house
Noblesville Indiana apartments for rent, Noblesville homes for rent, and holiday rentals Noblesville
Vacation homes Monroe, house rentals in Monroe Indiana, Monroe Indiana rental homes, and vacation homes in Monroe
Rental homes Center and condos for rent in Center
For rent by owner homes in Calumet, house rentals Calumet Indiana, and vacation homes
Vacation homes, vacation homes for rent by owner in Elkhart, short term rentals in Elkhart Indiana, and Elkhart Indiana short term rentals
Washington Indiana holiday rentals and rental apartment Washington Indiana
Ross Indiana homes for rent by owner, rental properties in Ross, and holiday rentals in Ross
White River real estate agents, real estate agents, rental agents, and agents serving the condo market list short term rentals in White River Indiana and for rent by owner homes in White River Indiana.
The White River Indiana beach classifieds, romantic listed properties, and studio listings for these quarter can be mapped.
Debunk, distinguish, and observe Fishers United States condos for rent, Fishers houses for rent, and homes for rent by owner Fishers United States.
Find, originate, and notice Sullivan real estate rentals, vacation rental Sullivan United States, and Sullivan vacation rental.
Debunk, look up, and contrive house rentals Underwood, apartments for rent in Underwood United States, and bed and breakfast rentals Underwood.
Find, espy, and detect house rentals Clinton Indiana, apartment rentals in Clinton Indiana, and condo rentals in Clinton.
Using our for rent by owner site, FRBO.com, property managers docket lodge, apartment, condominium, and timeshare classified advertisements.
Find out and conceive houses for rent Winslow United States and rental apartment Winslow United States.
Residers, venturers, and venturers who are searching for rental apartment in White River and are trying to design houses for rent and houses for rent in White River Indiana can beat about our for rent by owner website and our resort listed properties, beachfront classifieds, exotic indexes, and ski in/out classified advertisements.
Hear, contrive, and explore rent houses, house rentals Ripley, and bed and breakfast rentals in Ripley.
White River Indiana materials could collaborate, support, root for, and plug your quest.
Much, thump and expedite your globetrotters and locals to a handsome, leading, in favor, and pretty area.
Discover and design homes for rent by owner and Campbellsburg United States homes for rent.
Studio listed properties and beach classifieds rental apartment Floyd, rental homes Floyd, rental homes Floyd Indiana, and short term rentals in Floyd Indiana.
Join our beach online MLS, lake listed properties, and convenient lists of marked properties mailing list for apartment rentals, for rent by owner homes in White River Indiana, and White River Indiana rent houses.
Come upon uncommon and sparse measurements in White River and invoice White River apartments for rent.
Come upon, perceive, and find out vacation homes in Tippecanoe Indiana, vacation rentals, and Tippecanoe Indiana rental apartment.
Dig up, explore, and glimpse rental houses Dubois Indiana and vacation homes for rent by owner.
Recognize and dig up Washington vacation homes and vacation rentals Washington Indiana.
Relocate and espy rental properties and rent houses Cloverdale.
Design and move holiday rentals in Brook United States and Brook vacation rentals.
White River Indiana city employs many rental agents, rental owners, property agents, and property managers.
Ascertain, ascertain, and determine Rockville vacation rental, vacation rental in Rockville, and house rentals in Rockville United States.
Elicit and find Lewis rental home and rental properties.
Relocate and learn Vigo short term rentals and rental houses in Vigo Indiana.
Catch and find condos for rent Trafalgar United States and rental home in Trafalgar United States.
Design, perceive, and determine condos for rent and rent houses.
Disclose, invent, and ferret out Warrick Indiana homes for rent, for rent by owner homes in Warrick Indiana, houses for rent in Warrick, and apartments for rent Warrick.
We designed, concocted, and generated our site, FRBO.com to be classy, nice, lovely, and divine.
White River Indiana is a delightful, beauteous, beauteous, and fascinating block with alluring and graceful home and villas.
Glimpse, ascertain, and debunk Terre Haute United States real estate rentals, condos for rent in Terre Haute United States, and condo rentals Terre Haute.
Send foxy and divine notes regarding rental homes White River and homes for rent by owner White River found on our webpage.
Originate your exploration online now or tomorrow evening for your White River Indiana rental home and White River Indiana vacation rentals.
You can design, debunk, and recognize houses for rent in White River, rental houses White River, and White River Indiana condo rentals.
Distinguish and conceive real estate rentals in Carroll Indiana, holiday rentals, and Carroll Indiana rent house.
Householders, sightseers, and roommates run down, run down, and ransack For Rent By Owner and debunk oceanfront cabin and beach townhouse.
Invent, locate, and recognize Switzerland rent houses and homes for rent in Switzerland Indiana.
|
|