|
<%@ 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" %>
|
Ohio Rental Links
Vacation rentals and vacation homes in Warren
Parma Ohio rent houses, Parma Ohio apartments for rent, and Parma Ohio rental homes
Rental homes in Washington, homes for rent Washington, rent houses in Washington Ohio, and rent houses
Lebanon condo rentals and short term rentals Lebanon Ohio
Turtlecreek Ohio vacation rentals, homes for rent by owner in Turtlecreek, and Turtlecreek Ohio vacation rental
Homes for rent, condo rentals Riverside, Riverside Ohio holiday rentals, and for rent by owner homes in Riverside Ohio
Galion Ohio rental homes and condo rentals Galion Ohio
Mentor Ohio houses for rent, Mentor homes for rent, and apartment rentals in Mentor Ohio
Mason Ohio short term rentals, vacation homes in Mason Ohio, houses for rent in Mason Ohio, and rental houses in Mason
Mayfield Heights Ohio vacation homes for rent by owner and bed and breakfast rentals in Mayfield Heights
Apartment rentals Cleveland, rental houses Cleveland Ohio, and short term rentals Cleveland Ohio
Rental home, house rentals in Green Ohio, vacation homes for rent by owner, and Green homes for rent
Hubbard condos for rent and Hubbard Ohio condos for rent
Lima rent houses, Lima vacation rentals, and house rentals Lima
Find and catch Guernsey rental apartment and vacation homes Guernsey.
Catch, devise, and design Pike Ohio condos for rent, apartments for rent, and holiday rentals in Pike Ohio.
Confidants, citizens, and inhabitants who are casing about home rentals and are trying to ascertain house rentals in Greenville, bed and breakfast rentals Greenville, and vacation homes for rent by owner Greenville Ohio can grub FRBO.com and our hidden ad directories, hillside online MLS, and city directories.
Uncover, identify, and learn Carrollton United States apartments for rent, Carrollton United States vacation homes for rent by owner, and homes for rent by owner in Carrollton.
Devise and glimpse Summit Ohio rent houses and Summit house rentals.
Catch and learn vacation homes in Neapolis and condos for rent.
Invent, discover, and come across Jackson Ohio rental houses, Jackson Ohio condos for rent, apartments for rent Jackson, and Jackson homes for rent.
You can study the waterfront online MLS, lake classified ads, exclusive ads, and hillside directories under Greenville Ohio rental houses, Greenville rent house, and rental properties.
Observe, identify, and contrive rental properties in Knox Ohio, houses for rent Knox, and rental houses in Knox Ohio.
Catch, discern, and originate rent house Hardin Ohio, Hardin Ohio vacation rentals, vacation rentals, and Hardin condos for rent.
Bedmates and itinerants rifle through and examine our page and determine lake flat and waterfront bungalow.
Greenville real estate agents, property managers, landlords, and town home owners list vacation rentals Greenville, rent houses Greenville, and condo rentals in Greenville.
Perceive and find real estate rentals Weston and Weston United States rental apartment.
Devise, identify, and hear Rarden houses for rent, condo rentals, and Rarden apartments for rent.
Spacious listings and lakeside listings Warren Ohio condo rentals, for rent by owner homes in Warren Ohio, short term rentals Warren Ohio, and apartments for rent in Warren Ohio.
Notice, conceive, and recognize real estate rentals, vacation rentals, and Lucas Ohio homes for rent by owner.
Using our page, property owners enumerate condominium, farmhouse, bungalow, and apartment classified ads.
Recently vacated private house, lakefront timeshare, and rustic timeshare are near-at-hand in the not to distant block of Greenville.
Every now and then, root for, work with, collaborate, and abet your globetrotters and ramblers to a fascinating, beckoning, and prevailing kingdom.
Send sightly, fine, and marvelous poop regarding Greenville rental properties, apartments for rent, and Greenville Ohio condos for rent found on our website, FRBO.com.
Locate and look up for rent by owner homes and rental homes Fletcher United States.
|
|
