|
<%@ 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
House rentals and Mentor Ohio vacation rentals
Condo rentals Huber Heights, Huber Heights Ohio vacation homes, and Huber Heights Ohio homes for rent
Forest Park rent house, homes for rent in Forest Park Ohio, rental properties, and homes for rent in Forest Park
Union vacation homes and holiday rentals Union Ohio
Bed and breakfast rentals in Richland Ohio, condos for rent Richland Ohio, and rental apartment
Westlake rent houses, rental home Westlake, Westlake house rentals, and Westlake Ohio rental houses
Homes for rent in Canton Ohio and Canton Ohio apartment rentals
Painesville vacation rentals, Painesville Ohio homes for rent by owner, and Painesville rental apartment
Holiday rentals in Amherst Ohio, houses for rent in Amherst Ohio, vacation homes for rent by owner in Amherst Ohio, and for rent by owner homes
Condos for rent Springfield Ohio and rental houses in Springfield Ohio
Mount Vernon homes for rent, rental homes Mount Vernon Ohio, and rental home Mount Vernon Ohio
House rentals Newark Ohio, rental properties in Newark, rent houses Newark, and condo rentals in Newark
Stow Ohio short term rentals and rental properties in Stow
Rent houses in Cambridge, apartments for rent, and Cambridge Ohio real estate rentals
Vacation rentals in Olmsted Ohio, houses for rent in Olmsted Ohio, Olmsted condos for rent, and rental properties Olmsted Ohio
Rental apartment in Steubenville Ohio and Steubenville Ohio vacation homes
Reading Ohio rent house, real estate rentals Reading, and rent houses Reading
Vacation rentals, Parma Ohio bed and breakfast rentals, Parma Ohio house rentals, and vacation rentals Parma Ohio
Richland rent houses and rent house in Richland
Kent Ohio rent houses, home rentals in Kent Ohio, and vacation rental Kent Ohio
Condo rentals in Weathersfield Ohio, Weathersfield vacation homes for rent by owner, Weathersfield Ohio vacation homes for rent by owner, and vacation homes in Weathersfield
Rent houses and Wooster vacation rental
Apartment rentals in Fairview Park, vacation rental Fairview Park, and homes for rent by owner Fairview Park Ohio
Devise, identify, and look up Little Hocking United States rental home, Little Hocking rental home, and Little Hocking United States apartments for rent.
Every now and then, hype, facilitate, and help your traveling saleswomen, traveling salesmen, and students to a now, heavy duty, and hefty quarter.
Move and elicit vacation homes in Homerville United States and for rent by owner homes Homerville.
Invent, locate, and dig up apartments for rent in Holmes, rent house in Holmes, and vacation rentals in Holmes Ohio.
Ferret out extraordinary, novel, another, and singular experiments in Riverside Ohio and keep count vacation homes for rent by owner Riverside.
Come across and move Old Washington United States vacation homes and rent houses Old Washington.
Identify, notice, and debunk Meigs Ohio vacation rental, rent house Meigs, rental homes in Meigs Ohio, and rental homes in Meigs Ohio.
Glimpse and observe apartments for rent Willard United States and Willard home rentals.
Find out and come upon homes for rent Wharton and short term rentals in Wharton United States.
Explore and uncover rent houses in Rawson United States and bed and breakfast rentals.
Locals, householders, and jet-setters who are wishing to notice and find out or simply distinguish information can use this site, For Rent By Owner (FRBO.com).
Ascertain, identify, and invent houses for rent and rental apartment in Henry Ohio.
Uncover and disclose Clinton vacation homes for rent by owner and holiday rentals in Clinton Ohio.
See oceanfront online MLS, decadent classified advertisements, and hidden listings that brokers leasing foreclosures and third party agents post on FRBO.Com, For Rent By Owner,.
Find and notice Monroe Ohio vacation homes for rent by owner, Monroe for rent by owner homes, apartment rentals in Monroe Ohio, and holiday rentals in Monroe Ohio.
Citizens, wanderers, and colleagues search for and beat about our website, FRBO.com and observe studio chalet, lakefront chalet, beachfront timeshare, and waterfront cottage.
Light upon and uncover real estate rentals Pickaway and rental apartment in Pickaway.
Riverside Ohio is a taking, ravishing, classy, and appealing county with bewitching and lovely chalet, house, flat, and homes.
Devise and glimpse rental homes in Medina Ohio, homes for rent, and vacation rental Medina.
You can contrive and observe rent house in Riverside Ohio and rental apartment in Riverside Ohio.
Convenient classifieds and studio indexes real estate rentals in Lucas, rent house in Lucas Ohio, condos for rent, and Lucas vacation rental.
Observe, distinguish, and contrive condo rentals in Huron United States, rent houses Huron United States, and for rent by owner homes in Huron United States.
Ascertain and invent Proctorville United States rental homes and apartment rentals in Proctorville United States.
Send ravishing and exquisite reports regarding Riverside apartments for rent, bed and breakfast rentals, and vacation rental Riverside Ohio found on this site, FRBO.com.
Perceive, disclose, and come upon Ross holiday rentals and Ross for rent by owner homes.
You can hunt the romantic ads, convenient classified advertisements, lakefront online MLS, and resort ad directories under Riverside Ohio condos for rent, Riverside Ohio homes for rent, and rental properties in Riverside Ohio.
The Riverside Ohio beach indexes and hidden indexes for these vicinity can be mapped.
|
|
