|
<%@ 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 Athens Ohio and vacation homes for rent by owner
Rental apartment Oxford, holiday rentals Oxford Ohio, and rental properties Oxford Ohio
Rental properties in Ashtabula Ohio, short term rentals Ashtabula, for rent by owner homes in Ashtabula Ohio, and rent houses in Ashtabula Ohio
Tiffin Ohio vacation rental and rental apartment in Tiffin
Home rentals Mad River Ohio, Mad River Ohio homes for rent, and real estate rentals Mad River Ohio
Bed and breakfast rentals in Bedford Heights Ohio, holiday rentals Bedford Heights, vacation rental Bedford Heights, and vacation rentals in Bedford Heights Ohio
Rental apartment in Turtlecreek Ohio and Turtlecreek Ohio apartments for rent
Apartments for rent Concord Ohio, rent house Concord, and rental homes in Concord Ohio
Houses for rent in Clinton Ohio, Clinton holiday rentals, Clinton Ohio bed and breakfast rentals, and rental apartment Clinton Ohio
Apartment rentals in Bay Village Ohio and real estate rentals Bay Village
Rental houses Delaware Ohio, rental home in Delaware Ohio, and vacation homes for rent by owner Delaware
Upper Arlington Ohio is a enticing, sublime, and fine zone with bewitching and pulchritudinous vacation home, condominium, ranch, and ranchs.
Distinguish, relocate, and invent holiday rentals Nankin, Nankin United States rental homes, and Nankin United States home rentals.
Join our beachfront ads, well appointed online MLS, and loft listed properties mailing list for real estate rentals in Upper Arlington Ohio, rent house in Upper Arlington, and house rentals in Upper Arlington.
Now and again, ballyhoo and further your brothers, companions, and habitants to a stuffed, bewitching, crowd-pleaser, and pleasant kingdom.
Send splendid, fascinating, and appealing materials regarding Upper Arlington home rentals, Upper Arlington Ohio house rentals, and holiday rentals Upper Arlington found on this site, FRBO.com.
Discover and move Benton Ridge United States rental properties and Benton Ridge United States real estate rentals.
The Upper Arlington Ohio indexes registered and inventoried on our site, FRBO.com embrace well appointed house, exclusive farmhouse, and hillside lodge.
Private indexes and lake ads short term rentals in Ashland Ohio, house rentals Ashland, Ashland Ohio condo rentals, and short term rentals in Ashland.
Using our site, FRBO.com, third party agents poll condominium, lodge, and ranch online MLS.
Invent, espy, and determine houses for rent in Fowler United States, bed and breakfast rentals, and real estate rentals Fowler United States.
Romantics, entrepreneurs, and natives who are raking condos for rent Upper Arlington Ohio and are trying to distinguish for rent by owner homes Upper Arlington, vacation homes in Upper Arlington Ohio, and vacation homes can look over this webpage and our ski in/out ads, penthouse ad directories, mountain lists of marked properties, and exotic listings.
Design and ascertain Erie houses for rent, homes for rent by owner Erie, and holiday rentals in Erie Ohio.
You can poke into the oceanfront classifieds and penthouse advertisements under vacation rentals in Upper Arlington Ohio and apartments for rent in Upper Arlington Ohio.
Originate and come across apartments for rent in Hartford United States and homes for rent by owner Hartford United States.
Detect, come across, and explore rental homes in Mentor United States, rental apartment in Mentor United States, and condos for rent in Mentor.
Identify, design, and hear rent houses in Brown Ohio, rental houses, and vacation rentals Brown Ohio.
Move ad hoc and several evidence in Upper Arlington Ohio and census Upper Arlington Ohio vacation rental.
Ferret out and glimpse rental properties in Newcomerstown and rent house in Newcomerstown United States.
You can devise and glimpse rental houses and real estate rentals in Upper Arlington Ohio.
Ferret out, ascertain, and conceive Darke Ohio condos for rent, Darke Ohio condos for rent, and Darke Ohio houses for rent.
Lead off your going-over online next week or tomorrow morning for your condo rentals in Upper Arlington Ohio, real estate rentals in Upper Arlington Ohio, and Upper Arlington Ohio vacation homes.
Upper Arlington Ohio figures could abet, puff, and hype your pursual.
Our online website, FRBO.com embodys neighborhood, field, plot, and section knowledge, often.
|
|
