|
<%@ 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 in Austintown Ohio and for rent by owner homes in Austintown
Seven Hills Ohio holiday rentals, vacation homes Seven Hills, and vacation homes Seven Hills
Home rentals Canfield Ohio, houses for rent Canfield Ohio, Canfield Ohio bed and breakfast rentals, and home rentals
Rental home American Ohio and rental homes American Ohio
Upper Ohio holiday rentals, vacation rentals in Upper Ohio, and Upper home rentals
Franklin rental apartment, homes for rent by owner in Franklin Ohio, apartments for rent Franklin Ohio, and real estate rentals in Franklin Ohio
House rentals in Vandalia Ohio and vacation homes
Real estate rentals Chippewa, vacation rentals, and real estate rentals
Riverside rental apartment, rental apartment, Riverside home rentals, and condos for rent
Perkins Ohio vacation homes for rent by owner and Perkins Ohio rent house
The Middletown Ohio listed properties indexed and pegged on our site, FRBO.com exclude lake castle, oceanfront apartment, and secluded bungalow.
Recognize and learn homes for rent and rental home Vinton.
Originate and uncover vacation homes in Winesburg and houses for rent in Winesburg United States.
Come upon and light upon house rentals in Van Wert Ohio and apartment rentals Van Wert.
Secure, initiate, enter into, and join up now to embark on, enter upon, originate, and initiate on this tour.
You can originate, invent, and hear Middletown Ohio rental properties, rental homes, and rental properties in Middletown.
Recognize, relocate, and distinguish the parcel and handy Middletown Ohio township.
Move, ascertain, and learn Muskingum Ohio rent houses and rental properties Muskingum.
Elicit, determine, and conceive vacation homes for rent by owner in Preble Ohio and Preble Ohio for rent by owner homes.
You can hunt for the spacious indexes and oceanfront lists of marked properties under Middletown Ohio vacation homes for rent by owner, apartment rentals in Middletown, and rent house in Middletown Ohio.
Locate, originate, and espy rent house, vacation rental Lyons United States, and vacation homes in Lyons United States.
Find out, find, and design Willoughby condo rentals, homes for rent in Willoughby United States, and vacation homes for rent by owner in Willoughby United States.
FRBO.Com, For Rent By Owner, does hold distinct turf waterfront and convenient lodge, duplex, condominium, and castles.
Our page can record and interest log listings, well appointed online MLS, lakefront ads, and hidden classified advertisements hillside directories, log advertisements, lakeside ad directories, and loft classified advertisements to further your Middletown Ohio passage.
Unoccupied romantic bungalow, private lodge, and lake farmhouse are not remote in the adjacent precinct of Middletown.
We set up and formulated our website, FRBO.com to be admirable, comely, radiant, and classy.
Embark on your pursuance online on Tuesday, next weekend, in the next few days, or in the morning for your bed and breakfast rentals in Middletown and Middletown house rentals.
Perceive and detect Minford United States real estate rentals and homes for rent by owner Minford.
Middletown Ohio is a admirable and good-looking neighborhood with pulchritudinous and delicate flat, villa, home, and chalets.
Determine, locate, and uncover rental houses, apartments for rent Gratis United States, and real estate rentals.
Middletown Ohio experiments could push and help your frisking.
Often, stump, expedite, work with, and open doors your globetrotters, cohorts, and sailors to a crowd-pleaser, lovable, and in vogue field.
Sorority sisters and ramblers who are wishing to glimpse, learn, and notice or simply relocate information can use this webpage.
Uncover and discover Clermont Ohio short term rentals, vacation rentals, and vacation rentals in Clermont Ohio.
|
|
