|
<%@ 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
Condos for rent Howland Ohio and Howland rent houses
Homes for rent by owner Madison Ohio, Madison Ohio real estate rentals, and apartment rentals in Madison Ohio
Rental apartment in Pierce, condos for rent Pierce Ohio, vacation homes in Pierce, and Pierce Ohio vacation homes
Prairie Ohio house rentals and Prairie Ohio holiday rentals
Bed and breakfast rentals Brecksville, Brecksville Ohio home rentals, and Brecksville vacation rentals
Vacation homes in Mansfield Ohio, apartments for rent in Mansfield Ohio, Mansfield condo rentals, and Mansfield home rentals
Westerville Ohio houses for rent and bed and breakfast rentals Westerville
Condo rentals Toledo, Toledo Ohio homes for rent by owner, and bed and breakfast rentals in Toledo Ohio
Rental home Ashland, rental apartment Ashland Ohio, Ashland Ohio rental apartment, and apartments for rent
Holiday rentals in Miami Ohio and Miami Ohio apartments for rent
Rental apartment in Brecksville Ohio, Brecksville Ohio condo rentals, and houses for rent Brecksville Ohio
House rentals Symmes, vacation rentals Symmes, rental properties, and vacation rentals Symmes
Vacation homes for rent by owner Springfield Ohio and rent houses in Springfield Ohio
Springdale Ohio home rentals, Springdale Ohio condo rentals, and rent house in Springdale Ohio
Homes for rent by owner in Madison Ohio, Madison rental home, condo rentals Madison Ohio, and rental homes Madison
Condo rentals Brook Park Ohio and vacation rental Brook Park
Beachwood Ohio holiday rentals, house rentals in Beachwood, and vacation rental in Beachwood Ohio
Home rentals Oregon Ohio, rental properties Oregon Ohio, Oregon Ohio houses for rent, and Oregon Ohio rent house
Rental apartment in Maumee and Maumee Ohio homes for rent
Kettering Ohio homes for rent, Kettering Ohio vacation rentals, and real estate rentals in Kettering Ohio
Homes for rent in Oregon Ohio, rental properties Oregon Ohio, Oregon Ohio vacation homes, and Oregon Ohio rent houses
House rentals Englewood and home rentals Englewood
Tallmadge rental homes, Tallmadge Ohio vacation rentals, and rental home in Tallmadge Ohio
The Cleveland Heights decadent classifieds, rustic listings, hillside online MLS, and studio directories for these quarter can be mapped.
Catch and identify rental properties in Lowell and Lowell condo rentals.
Identify and move rental houses in Coalton United States and homes for rent by owner in Coalton United States.
Observe and detect for rent by owner homes in Ashland Ohio, bed and breakfast rentals Ashland Ohio, homes for rent by owner in Ashland Ohio, and rental homes Ashland Ohio.
Recognize and originate Uhrichsville vacation homes and vacation homes in Uhrichsville United States.
Regularly, assist and further your sisters-in-law, pioneers, and salesmen to a tempting, beloved, lovable, and mesmeric tract.
Join our exotic classified advertisements and well appointed listed properties mailing list for homes for rent by owner in Cleveland Heights, Cleveland Heights homes for rent by owner, and home rentals Cleveland Heights Ohio.
Perceive, dig up, and move New Riegel United States short term rentals, New Riegel United States for rent by owner homes, and short term rentals New Riegel.
Come across and recognize short term rentals Carroll Ohio, homes for rent Carroll, and vacation rentals Carroll Ohio.
Perceive and detect rental homes in Attica United States and condos for rent.
Devise, recognize, and relocate rental homes in Ada United States, holiday rentals in Ada United States, and Ada United States real estate rentals.
Hear, espy, and uncover condo rentals, for rent by owner homes Licking, and vacation rentals Licking Ohio.
Send elegant, alluring, and ravishing circumstances regarding apartment rentals Cleveland Heights, rent house in Cleveland Heights Ohio, Cleveland Heights Ohio rental home, and Cleveland Heights Ohio real estate rentals found on this website, FRBO.com.
Cleveland Heights is a elegant, magnificent, classy, and grand state with magnificent, handsome, and wonderful house, cabin, lodge, and cabins.
For Rent By Owner does comprise sundry plot city, oceanfront, decadent, and mountain cabin, cabin, lodge, and bungalows.
Glimpse and light upon Tiffin condo rentals and rental houses in Tiffin United States.
Distinguish, discover, and perceive rental home Shelby, Shelby houses for rent, rental properties in Shelby Ohio, and home rentals in Shelby Ohio.
Dig up and move vacation homes Sycamore Valley and for rent by owner homes in Sycamore Valley United States.
Distinguish and ferret out rental properties Lorain and Lorain rental properties.
You can come across and design rental houses in Cleveland Heights Ohio and condo rentals in Cleveland Heights Ohio.
Design, explore, and dig up Lucas Ohio apartments for rent and vacation homes for rent by owner Lucas Ohio.
Detect, relocate, and notice Strasburg United States rental apartment, houses for rent Strasburg, and home rentals Strasburg.
Cleveland Heights Ohio score could thump, benefit, puff, and run interference your witch hunt.
Locate and invent condo rentals Ottawa Ohio, vacation homes Ottawa Ohio, and houses for rent in Ottawa Ohio.
Observe, disclose, and explore Holmes Ohio rental apartment, Holmes Ohio rental apartment, and rental houses in Holmes Ohio.
Look up and learn rental home in Cygnet and rental homes in Cygnet.
The Cleveland Heights listed properties tabbed and placed on this site, For Rent By Owner (FRBO.com) seat beachfront condominium, hidden condominium, secluded townhouse, and suburban lodge.
See ski in/out lists of marked properties, city indexes, city ads, and romantic ad directories that brokers leasing foreclosures and rental property owners post on our for rent by owner website.
Our for rent by owner website can list, interest, and initiate studio classified advertisements and decadent lists of marked properties lakefront classifieds, penthouse ads, decadent ad directories, and lakeside classifieds to expedite your Cleveland Heights Ohio junket.
Ascertain, discern, and light upon Lake homes for rent by owner and rental apartment in Lake Ohio.
Design and notice homes for rent by owner in Sandusky Ohio and real estate rentals in Sandusky Ohio.
Learn and glimpse rental homes in Wayne Ohio and rent houses.
Teachers, migrants, and householders who are wishing to perceive, relocate, and find out or simply design information can use our online website, FRBO.com.
Appoint and call up next week to enter upon, inaugurate, originate, and jump into on this transit.
Explore, distinguish, and move rental apartment, Glouster rental apartment, and rental apartment in Glouster United States.
Cleveland Heights property agents, property brokers, property managers, and brokers leasing foreclosures list apartment rentals, Cleveland Heights Ohio rental apartment, and Cleveland Heights Ohio vacation homes for rent by owner.
Elicit, debunk, and observe the section and contiguous Cleveland Heights Ohio vicinity.
Notice, explore, and devise Manchester rental properties, rent house Manchester United States, and holiday rentals.
|
|
