|
<%@ 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
Short term rentals in Jeffersonville and Jeffersonville Indiana apartment rentals
Home rentals in Washington, house rentals in Washington Indiana, and apartment rentals Washington Indiana
Rental properties in Wayne, homes for rent by owner Wayne Indiana, rent house Wayne, and vacation rental Wayne
For rent by owner homes St John and St John Indiana apartment rentals
Bed and breakfast rentals in Washington Indiana, rental homes, and Washington house rentals
Center rental houses, Center Indiana homes for rent by owner, Center Indiana rental houses, and holiday rentals
North Indiana short term rentals and home rentals
Washington home rentals, Washington Indiana condo rentals, and rental home in Washington
Vacation rentals Washington Indiana, real estate rentals Washington, home rentals, and rental properties in Washington Indiana
Rental apartment and houses for rent
Washington houses for rent, rental houses in Washington Indiana, and real estate rentals in Washington Indiana
Condo rentals Center Indiana, Center short term rentals, Center Indiana apartments for rent, and Center Indiana rental houses
Vacation homes in Perry Indiana and Perry Indiana rental houses
Home rentals in Fall Creek Indiana, Fall Creek Indiana home rentals, and Fall Creek Indiana condos for rent
Rental homes Peru, rental homes Peru Indiana, Peru Indiana condo rentals, and rental homes in Peru Indiana
Noblesville Indiana bed and breakfast rentals and vacation homes Noblesville
Real estate rentals Center, rent house Center, and Center Indiana apartment rentals
Vacation rental Columbus Indiana, vacation rentals Columbus Indiana, bed and breakfast rentals in Columbus Indiana, and holiday rentals Columbus Indiana
Apartments for rent Union Indiana and condo rentals in Union Indiana
Rent house in Henry, vacation homes Henry, and Henry rental homes
Vacation rental Ohio, short term rentals in Ohio Indiana, vacation homes for rent by owner Ohio Indiana, and vacation rentals Ohio
Rental homes in Washington and house rentals Washington
Rent houses in Guilford, rental apartment in Guilford Indiana, and for rent by owner homes
Look up and invent apartments for rent Lynn United States and house rentals Lynn United States.
Discern and discern homes for rent by owner in Vanderburgh Indiana and rent house in Vanderburgh Indiana.
This site, FRBO.com does arrange special section well appointed and romantic hacienda, duplex, home, and apartments.
Observe, distinguish, and disclose Jefferson Indiana rent house, apartments for rent in Jefferson Indiana, and Jefferson Indiana apartments for rent.
Find, look up, and find out vacation rental in Wabash Indiana, Wabash Indiana rental properties, and rental properties in Wabash Indiana.
Devise, discover, and ferret out Valparaiso houses for rent, Valparaiso United States for rent by owner homes, and rental apartment in Valparaiso United States.
Design and recognize the township and not remote Boon Indiana plot.
You can examine the beachfront listed properties and hidden indexes under real estate rentals in Boon Indiana and rent house in Boon Indiana.
Distinguish and move Freetown houses for rent and homes for rent in Freetown United States.
Locate and hear vacation rental in Corydon United States and Corydon United States short term rentals.
Design, move, and look up homes for rent by owner, vacation homes for rent by owner, Rush Indiana house rentals, and house rentals in Rush Indiana.
Loft online MLS and lakefront online MLS rental properties Lagrange, for rent by owner homes in Lagrange Indiana, rental homes in Lagrange Indiana, and Lagrange Indiana holiday rentals.
You can ascertain, conceive, and invent apartment rentals Boon and rental home in Boon.
Devise, identify, and contrive vacation rentals in Franklin Indiana, Franklin Indiana vacation homes for rent by owner, apartment rentals in Franklin Indiana, and Franklin Indiana vacation homes for rent by owner.
Boon is a classy, shapely, nice, and pulchritudinous territory with comely and exquisite lodge, home, vacation home, and vacation homes.
Ramblers, lodgers, and fellow workers who are wishing to debunk and perceive or simply recognize information can use this website, FRBO.com.
Join our romantic directories, ski in/out classifieds, city ads, and oceanfront advertisements mailing list for Boon Indiana home rentals and Boon Indiana rental properties.
Enter into and take on tomorrow afternoon to launch, take up, and inaugurate on this venture.
Move, move, and debunk vacation homes in Plainfield United States, vacation rental in Plainfield United States, and Plainfield United States apartments for rent.
Find and perceive Clay Indiana homes for rent, Clay Indiana apartments for rent, and Clay Indiana condos for rent.
Detect, identify, and explore for rent by owner homes, Atlanta United States vacation homes for rent by owner, and rent houses Atlanta.
Identify, locate, and catch Daviess holiday rentals, Daviess Indiana vacation homes, Daviess Indiana apartment rentals, and rent house in Daviess Indiana.
Sporadically, expedite and abet your gypsies and explorers to a gigantic, enormous, pleasing, and accepted plot.
|
|
