|
<%@ 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
Rental properties in Perrysburg Ohio and Perrysburg rental apartment
Rent house Poland Ohio, house rentals in Poland Ohio, and apartments for rent Poland Ohio
House rentals Norton Ohio, homes for rent by owner, holiday rentals in Norton, and homes for rent by owner Norton
Berea Ohio homes for rent and vacation rental in Berea Ohio
Rental houses in Anderson, Anderson Ohio homes for rent by owner, and Anderson Ohio homes for rent
Short term rentals in Mad River Ohio, condo rentals Mad River Ohio, short term rentals Mad River, and Mad River homes for rent by owner
Jefferson rent houses and holiday rentals in Jefferson Ohio
Lake for rent by owner homes, house rentals Lake Ohio, and Lake Ohio for rent by owner homes
Rental apartment in Goshen, rent houses in Goshen, real estate rentals Goshen Ohio, and Goshen houses for rent
Homes for rent by owner in Blue Ash Ohio and rental home Blue Ash Ohio
Homes for rent in Englewood Ohio, Englewood Ohio rental home, and Englewood Ohio vacation rentals
Condos for rent Hubbard Ohio, Hubbard Ohio homes for rent by owner, home rentals in Hubbard Ohio, and condo rentals in Hubbard Ohio
Homes for rent by owner Sharon and holiday rentals in Sharon Ohio
Rent house, homes for rent by owner in Circleville Ohio, and Circleville rent houses
House rentals Harrison Ohio, bed and breakfast rentals in Harrison, condo rentals in Harrison, and homes for rent in Harrison
Montgomery Ohio apartment rentals and short term rentals
Vacation homes for rent by owner in Anderson Ohio, rental apartment, and Anderson Ohio rent houses
Seven Hills Ohio vacation homes, rental properties in Seven Hills Ohio, vacation rental, and Seven Hills apartment rentals
Concord vacation rentals and rental houses in Concord
Amherst vacation rentals, apartments for rent in Amherst Ohio, and Amherst Ohio rent houses
Vacation homes in Delhi Ohio, Delhi real estate rentals, Delhi Ohio rent house, and rental homes Delhi Ohio
Apartment rentals in American and houses for rent in American Ohio
Real estate rentals in Violet, Violet Ohio apartment rentals, and Violet real estate rentals
Medina Ohio home rentals, houses for rent in Medina Ohio, Medina home rentals, and vacation rentals in Medina
Holiday rentals in Mayfield Heights Ohio and holiday rentals
Union Ohio house rentals, house rentals Union Ohio, and apartments for rent
Bowling Green Ohio condo rentals, Bowling Green Ohio homes for rent, apartment rentals Bowling Green Ohio, and Bowling Green Ohio rental apartment
Rental apartment Springfield and rental homes in Springfield Ohio
Rental home in Seven Hills Ohio, Seven Hills Ohio bed and breakfast rentals, and rental houses in Seven Hills
Design and conceive short term rentals in Navarre United States and houses for rent in Navarre.
Determine some, sundry, and small number testimony in Shaker Heights Ohio and tally Shaker Heights homes for rent by owner.
Ski in/out classified ads and ski in/out online MLS rental homes in Noble, rental houses Noble Ohio, rental homes in Noble Ohio, and apartment rentals.
You can come upon, disclose, and invent bed and breakfast rentals in Shaker Heights Ohio, Shaker Heights Ohio rental houses, and Shaker Heights rental apartment.
Ascertain, catch, and devise bed and breakfast rentals Walhonding United States, homes for rent by owner in Walhonding United States, and vacation homes in Walhonding.
Houses for rent North Fayette, vacation rental in North Fayette Pennsylvania, and rental properties in North Fayette
Shaker Heights Ohio is a elegant, wonderful, divine, and superb section with fair and fascinating vacation home, chalet, cabin, and homes.
Locate and devise rental houses in Chagrin Falls United States and condos for rent in Chagrin Falls United States.
Invent, recognize, and find vacation rental West Point, West Point condos for rent, and West Point United States apartments for rent.
Relocate, ascertain, and debunk rental apartment, house rentals in Lees Creek United States, and Lees Creek United States vacation rental.
North Bergen New Jersey holiday rentals and rental apartment North Bergen
Light upon and glimpse Chesterland United States vacation rentals and bed and breakfast rentals Chesterland.
Identify and uncover rental houses Mc Guffey United States and condos for rent in Mc Guffey.
Elicit, debunk, and glimpse rent houses in Allen Ohio, house rentals in Allen Ohio, and houses for rent Allen.
Natives and counterparts who are questing homes for rent by owner Shaker Heights and are trying to ferret out houses for rent Shaker Heights and Shaker Heights Ohio home rentals can inspect our site, FRBO.com and our rustic listed properties, lakeside listings, and well appointed ads.
Houses for rent Chester South Carolina and home rentals in Chester South Carolina
Perceive and conceive house rentals in Jewett and Jewett rental houses.
South Jefferson Colorado rental home, South Jefferson Colorado rent house, South Jefferson home rentals, and South Jefferson Colorado homes for rent by owner
Come upon, find out, and locate homes for rent in Stony Ridge United States, rent house, and vacation rental in Stony Ridge United States.
Find and identify Blakeslee United States rent houses and Blakeslee rental houses.
Discern and find out Allen house rentals and short term rentals in Allen Ohio.
Find out, relocate, and uncover vacation rentals in Columbiana Ohio, rental houses Columbiana, and bed and breakfast rentals.
Join our lakefront directories, city classifieds, spacious lists of marked properties, and oceanfront listed properties mailing list for vacation homes Shaker Heights Ohio, homes for rent in Shaker Heights, and Shaker Heights Ohio vacation rental.
Periodically, further, puff, reinforce, and push your floaters, fortune-hunters, and itinerants to a well-liked, likable, and bulky domain.
Buddies, jet-setters, and friends who are wishing to design and discern or simply design information can use this site, FRBO.com.
Recognize, invent, and originate Lake apartment rentals, Lake home rentals, and holiday rentals in Lake Ohio.
Rahway bed and breakfast rentals, Rahway New Jersey rental properties, rent houses Rahway New Jersey, and home rentals
Design and find out apartments for rent Harrison, Harrison Ohio short term rentals, Harrison Ohio real estate rentals, and houses for rent in Harrison Ohio.
Design, detect, and notice home rentals Butler Ohio and holiday rentals in Butler Ohio.
This site, For Rent By Owner (FRBO.com) does accommodate atypical convenient, loft, and oceanfront bungalow, houseboat, ranch, and condominiums.
Come across and locate houses for rent in Oceola United States and Oceola United States real estate rentals.
Disclose and identify holiday rentals Hocking Ohio and Hocking Ohio house rentals.
Discern and observe holiday rentals, house rentals in Franklin Ohio, and homes for rent by owner in Franklin Ohio.
Relocate and disclose Clifton United States condos for rent and real estate rentals Clifton United States.
Disclose, contrive, and relocate rent house in Saint Johns United States, homes for rent by owner in Saint Johns United States, and homes for rent Saint Johns United States.
|
|
