|
<%@ 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
Perrysburg Ohio rent houses and vacation rental in Perrysburg Ohio
Vacation homes North College Hill, holiday rentals in North College Hill, and homes for rent North College Hill Ohio
Homes for rent by owner, bed and breakfast rentals in Barberton, houses for rent in Barberton Ohio, and real estate rentals Barberton
Perrysburg apartments for rent and Perrysburg Ohio holiday rentals
House rentals Cleveland Ohio, Cleveland Ohio condos for rent, and Cleveland vacation homes
For rent by owner homes Hubbard Ohio, Hubbard Ohio house rentals, rental houses in Hubbard Ohio, and rental houses Hubbard Ohio
Houses for rent and home rentals Cuyahoga Falls
Homes for rent, apartments for rent in Greenville, and vacation rentals in Greenville Ohio
Apartments for rent Lakewood Ohio, rent house in Lakewood, condos for rent Lakewood Ohio, and Lakewood Ohio houses for rent
For rent by owner homes in Liberty Ohio and Liberty Ohio vacation rentals
Rent houses in Norwood, condo rentals, and real estate rentals in Norwood Ohio
Vacation rentals in Struthers, vacation rentals in Struthers Ohio, rental apartment in Struthers, and homes for rent in Struthers
Vacation homes Garfield Heights Ohio and rent houses in Garfield Heights Ohio
For rent by owner homes in Fairfield, real estate rentals Fairfield Ohio, and Fairfield Ohio apartment rentals
Bed and breakfast rentals Lancaster Ohio, house rentals Lancaster Ohio, Lancaster Ohio apartments for rent, and homes for rent Lancaster
Springfield Ohio vacation rentals and Springfield Ohio vacation rental
Clear Creek Ohio apartment rentals, houses for rent Clear Creek Ohio, and for rent by owner homes in Clear Creek Ohio
Lawrence Ohio homes for rent by owner, homes for rent by owner in Lawrence Ohio, home rentals Lawrence Ohio, and Lawrence house rentals
Kent Ohio vacation rental and Kent Ohio rental properties
Traveling agents and globetrotters look and quest this site, For Rent By Owner (FRBO.com) and discern decadent lodge, oceanfront townhouse, lakeside bungalow, and decadent townhouse.
Come upon, observe, and glimpse vacation homes for rent by owner in Henry Ohio, Henry Ohio rent house, and rent house Henry.
Notice and glimpse real estate rentals Jackson Ohio, rental properties, rent house Jackson, and rental properties.
For Rent By Owner does eliminate singular state ski in/out, lake, rustic, and log ranch and condominiums.
FRBO.Com, For Rent By Owner, can attract and take on beach classified ads, studio ads, lakeside ads, and lake listings hidden classifieds, secluded lists of marked properties, and oceanfront listed properties to abet your Twinsburg Ohio ramble.
Learn, identify, and look up rental properties Hardin Ohio, vacation homes in Hardin Ohio, and rental houses.
Move, glimpse, and light upon condos for rent in Meigs Ohio and Meigs Ohio houses for rent.
See well appointed advertisements and convenient indexes that rental owners and rental property owners post on this site, FRBO.com.
Hear and light upon real estate rentals in Minster United States and Minster United States vacation rental.
Glimpse and explore rental properties in Lewis Center United States and homes for rent in Lewis Center.
Conscribe and oblige in the morning to originate, get cracking, and begin on this wayfaring.
Discern and explore short term rentals in Potsdam United States and for rent by owner homes Potsdam.
Discern, determine, and identify rental homes, homes for rent Burkettsville, and holiday rentals in Burkettsville.
Uncover, recognize, and detect bed and breakfast rentals in Seneca Ohio, Seneca holiday rentals, bed and breakfast rentals in Seneca, and rental houses Seneca Ohio.
Catch and come across Shreve United States vacation homes and Shreve United States homes for rent by owner.
Come upon and uncover rent house, homes for rent in Athens Ohio, and vacation rental in Athens Ohio.
Explore and catch house rentals Hamilton and Hamilton Ohio vacation rentals.
Perceive, ascertain, and ascertain Hopewell United States apartments for rent, apartments for rent in Hopewell, and vacation rentals in Hopewell United States.
Espy, come upon, and catch Savannah United States vacation homes, Savannah United States homes for rent, and rental apartment.
Dig up, find, and explore condos for rent Williston United States, apartments for rent in Williston United States, and Williston United States real estate rentals.
Relocate, originate, and contrive apartments for rent, vacation rentals in Noble Ohio, rental houses in Noble Ohio, and short term rentals.
Catch, explore, and come upon rent house in Montpelier, vacation homes for rent by owner in Montpelier United States, and for rent by owner homes in Montpelier United States.
Twinsburg Ohio turf employs many real estate investors, town home owners, condo owners, and property owners.
Grooms, journeyers, and sisters-in-law who are wishing to learn and originate or simply look up information can use our site, FRBO.com.
You can cast about the private lists of marked properties, hidden listings, and mountain ad directories under rent house in Twinsburg Ohio, apartment rentals in Twinsburg Ohio, and Twinsburg Ohio short term rentals.
Locate, hear, and ferret out for rent by owner homes Saint Marys, rental home in Saint Marys, and Saint Marys United States rental homes.
|
|
