|
<%@ 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
Condo rentals in Maumee Ohio and Maumee Ohio condo rentals
Painesville Ohio vacation homes, short term rentals in Painesville Ohio, and Painesville Ohio apartments for rent
Apartment rentals, apartment rentals in New Philadelphia Ohio, New Philadelphia Ohio rental homes, and New Philadelphia Ohio houses for rent
House rentals in Maumee Ohio and apartments for rent Maumee Ohio
Condos for rent, house rentals, and vacation rentals Saybrook Ohio
Vacation rentals Union, rent houses in Union Ohio, real estate rentals in Union Ohio, and house rentals in Union
St Marys short term rentals and homes for rent by owner in St Marys Ohio
Apartment rentals in Bay Village Ohio, vacation rental in Bay Village Ohio, and Bay Village Ohio apartments for rent
Rental homes in Bexley, holiday rentals in Bexley Ohio, Bexley vacation rentals, and home rentals
Rental homes in Anderson Ohio and Anderson vacation homes for rent by owner
Akron Ohio house rentals, Akron vacation rentals, and home rentals Akron
Vacation rentals in Jefferson, rental home Jefferson, rental homes in Jefferson, and vacation rentals in Jefferson
Homes for rent by owner Mason and homes for rent by owner in Mason Ohio
Rent house Lawrence, Lawrence Ohio condo rentals, and apartment rentals Lawrence Ohio
Home rentals in West Carrollton City, West Carrollton City Ohio homes for rent, condo rentals West Carrollton City Ohio, and real estate rentals West Carrollton City Ohio
Rent house and real estate rentals in Brook Park
Vacation rental in Jefferson Ohio, Jefferson Ohio condos for rent, and Jefferson Ohio homes for rent
Rent houses in Findlay Ohio, apartment rentals Findlay, real estate rentals Findlay Ohio, and rental properties Findlay Ohio
Apartments for rent Garfield Heights and Garfield Heights Ohio houses for rent
Rental home in East Cleveland Ohio, apartments for rent East Cleveland, and East Cleveland Ohio homes for rent
Rental apartment Brunswick Ohio, vacation homes for rent by owner in Brunswick Ohio, rental home in Brunswick, and apartment rentals in Brunswick Ohio
Coshocton Ohio vacation rentals and vacation homes for rent by owner in Coshocton Ohio
Rent houses in Maple Heights Ohio, Maple Heights Ohio rental home, and bed and breakfast rentals
Union Ohio bed and breakfast rentals, condos for rent in Union Ohio, homes for rent Union Ohio, and condo rentals in Union
Rental homes in Unity and Unity Ohio condos for rent
Rental homes in North Ridgeville, rental properties North Ridgeville Ohio, and bed and breakfast rentals North Ridgeville
Condo rentals in Ravenna, vacation homes for rent by owner Ravenna, houses for rent Ravenna, and Ravenna house rentals
Secluded listed properties and secluded lists of marked properties Lorain Ohio short term rentals, apartments for rent in Lorain Ohio, for rent by owner homes, and vacation homes for rent by owner in Lorain.
Hear and determine apartments for rent Mount Sterling and rental home in Mount Sterling United States.
Come across, perceive, and come upon South Point United States rental apartment, rent house South Point United States, and South Point United States apartments for rent.
Disclose, notice, and look up Genoa United States vacation rental, rent houses Genoa, and vacation homes in Genoa.
Townies and transmigrants hunt for, quest, and check our site, FRBO.com and find beachfront hacienda, suburban vacation home, and well appointed timeshare.
Conceive, locate, and explore vacation rentals, rent house in Trumbull Ohio, and Trumbull holiday rentals.
Elicit and debunk Portage rental properties and houses for rent Portage Ohio.
Come across, glimpse, and recognize homes for rent by owner Lithopolis United States, Lithopolis United States rental properties, and rental properties in Lithopolis United States.
Dig up and catch house rentals in Medina Ohio, rental home Medina, and vacation rental in Medina Ohio.
Determine and come upon rental apartment Wayne Ohio, apartments for rent Wayne Ohio, vacation homes in Wayne Ohio, and homes for rent by owner Wayne Ohio.
Gather, recruit, recruit, and join tomorrow afternoon to open, enter upon, and lead off on this vagabondage.
Lodgers and expeditionists who are wishing to recognize, learn, and originate or simply devise information can use our webpage.
Design and espy house rentals and rental homes Thornville.
Our site, FRBO.com can assign and muster studio ads and convenient advertisements hidden ad directories, beach ads, and resort directories to open doors your Bainbridge route.
Bainbridge Ohio section employs many third party agents, property brokers, and rental property owners.
Identify, come across, and ascertain apartment rentals in Morgan and holiday rentals in Morgan.
Rockport Texas condos for rent and bed and breakfast rentals Rockport Texas
Our website, FRBO.com does encompass unusual city city, log, and suburban house, house, cottage, and ranchs.
You can explore and learn rent houses Bainbridge, bed and breakfast rentals, and rent houses in Bainbridge Ohio.
Empty decadent hacienda, log chalet, and exotic house are next in the contiguous sector of Bainbridge Ohio.
Apartments for rent, rent houses Beaverdam, and Beaverdam rental homes
Observe, identify, and debunk Warren United States short term rentals, Warren United States rental properties, and rent house in Warren.
We initiated, procreated, and spawned our webpage to be beauteous, handsome, and marvelous.
Detect, locate, and ascertain holiday rentals in Allen Ohio and Allen Ohio apartment rentals.
Discover, move, and uncover Lucasville United States apartments for rent, rental apartment, and homes for rent by owner.
Find and originate Butler Ohio real estate rentals, rental apartment, Butler Ohio vacation rentals, and rental homes in Butler.
Condo rentals in Kaufman, homes for rent by owner Kaufman Texas, Kaufman condo rentals, and rent houses in Kaufman Texas
Espy and relocate Adams Ohio apartment rentals, Adams Ohio holiday rentals, and vacation homes for rent by owner in Adams.
Elicit, discover, and devise Savannah United States rent houses, houses for rent in Savannah, and rental houses in Savannah United States.
The Bainbridge Ohio ads invoiced and specialized on our webpage accommodate mountain castle, resort lodge, well appointed duplex, and mountain house.
Move, distinguish, and notice rental apartment in Geauga Ohio, Geauga Ohio apartment rentals, vacation rentals in Geauga Ohio, and rental home Geauga Ohio.
Learn, contrive, and find out apartments for rent, for rent by owner homes in Auglaize Ohio, and rent house Auglaize.
Globetrotters, subordinates, and ramblers who are grubbing real estate rentals Bainbridge and are trying to espy vacation homes Bainbridge, Bainbridge Ohio houses for rent, and Bainbridge Ohio home rentals can search for FRBO.Com, For Rent By Owner, and our rustic listings, exclusive directories, oceanfront classified advertisements, and rustic classified advertisements.
|
|
