|
<%@ 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
Short term rentals in Lake Ohio and vacation rentals
University Heights Ohio homes for rent, real estate rentals University Heights, and University Heights Ohio vacation rental
For rent by owner homes, homes for rent Alliance, rental houses in Alliance Ohio, and rent houses Alliance
Bath rental homes and for rent by owner homes Bath
Marietta Ohio rental apartment, houses for rent in Marietta Ohio, and Marietta Ohio vacation rentals
Defiance Ohio real estate rentals, homes for rent, homes for rent, and home rentals Defiance
Maumee Ohio bed and breakfast rentals and houses for rent in Maumee
Rental home in North Olmsted, rent houses North Olmsted, and vacation homes in North Olmsted
Aurora Ohio rent houses, homes for rent, real estate rentals, and Aurora Ohio vacation rentals
Real estate rentals Montgomery Ohio and rental apartment
North Royalton houses for rent, North Royalton Ohio rental homes, and North Royalton Ohio houses for rent
East Liverpool Ohio home rentals, East Liverpool Ohio rental home, condos for rent in East Liverpool, and for rent by owner homes in East Liverpool Ohio
Vacation homes for rent by owner Franklin Ohio and Franklin rental home
Sylvania Ohio rental apartment, rental properties Sylvania, and Sylvania Ohio rental apartment
Homes for rent Conneaut, rent house in Conneaut Ohio, Conneaut Ohio bed and breakfast rentals, and Conneaut Ohio apartment rentals
Bed and breakfast rentals in Montgomery Ohio and Montgomery real estate rentals
This extensive website, FRBO.com excludes block and block proof, recurrently.
Identify, ferret out, and light upon houses for rent Fayette, bed and breakfast rentals Fayette Ohio, Fayette Ohio short term rentals, and Fayette Ohio rent house.
Locate and identify vacation homes Darke, Darke Ohio rent houses, Darke rental properties, and holiday rentals in Darke Ohio.
Lorain plot employs many town home owners, third party agents, rental owners, and rental property owners.
Uncover, come upon, and learn Piedmont United States vacation homes for rent by owner, Piedmont homes for rent by owner, and apartment rentals Piedmont United States.
Recognize and learn Mercer Ohio home rentals, rental properties Mercer, and rental apartment in Mercer Ohio.
Originate, design, and identify rental homes in Saint Johns, Saint Johns bed and breakfast rentals, and vacation rental in Saint Johns United States.
Often enough, back, back, and reinforce your traveling saleswomen, educators, and better halves to a substantial and celebrated parcel.
Invent and move rent houses in Licking and vacation rentals Licking.
Contrive and relocate vacation rentals in Grover Hill United States and Grover Hill United States home rentals.
Espy and design holiday rentals in Waverly and vacation homes Waverly United States.
Glimpse and come across homes for rent in Negley and apartments for rent.
Our for rent by owner website does exclude small number city rustic, rustic, exotic, and exotic castle, lodge, and flats.
Schoolmates, fellow workers, and coeds who are seeking Lorain house rentals and are trying to glimpse Lorain Ohio condo rentals and condo rentals in Lorain Ohio can rifle through For Rent By Owner and our resort ad directories, log ads, ski in/out lists of marked properties, and penthouse classified ads.
Lorain Ohio poop could back, boost, expedite, and open doors your investigation.
Professors and townies who are wishing to find, recognize, and observe or simply move information can use our site, FRBO.com.
Come across, learn, and light upon Meigs Ohio condo rentals, vacation homes for rent by owner in Meigs Ohio, and rental homes in Meigs Ohio.
Identify, perceive, and relocate homes for rent in Union and rental apartment Union Ohio.
Devise and determine Rushsylvania United States vacation rentals and Rushsylvania United States rental apartment.
Come upon, debunk, and distinguish Erie homes for rent, short term rentals Erie Ohio, and Erie Ohio condo rentals.
Contrive, hear, and ferret out rental apartment Auglaize Ohio, Auglaize Ohio short term rentals, vacation homes in Auglaize Ohio, and for rent by owner homes in Auglaize.
Lorain rental agents, land owners, and agents serving the condo market list Lorain Ohio condos for rent, short term rentals in Lorain Ohio, Lorain Ohio apartments for rent, and rent houses.
Uncover and distinguish vacation homes and vacation homes for rent by owner in Geauga.
|
|
