|
<%@ 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 Pataskala Ohio and Pataskala Ohio apartment rentals
Streetsboro homes for rent by owner, condo rentals Streetsboro, and Streetsboro Ohio apartment rentals
South Euclid rental homes, South Euclid short term rentals, houses for rent in South Euclid Ohio, and houses for rent in South Euclid Ohio
Vacation homes in Westlake Ohio and Westlake Ohio vacation rental
Ravenna Ohio home rentals, rental homes Ravenna Ohio, and Ravenna Ohio rent houses
Jefferson rental home, Jefferson for rent by owner homes, Jefferson Ohio holiday rentals, and rent houses Jefferson
Brookfield rental apartment and Brookfield vacation rentals
House rentals Bexley, condo rentals, and Bexley Ohio apartments for rent
Short term rentals, condo rentals, real estate rentals Genoa, and Genoa Ohio house rentals
Homes for rent and condo rentals in Montgomery Ohio
Rental homes in Dayton, rental apartment, and homes for rent
Rental homes in Springfield, Springfield house rentals, houses for rent Springfield, and home rentals in Springfield Ohio
Houses for rent and vacation rental
Apartments for rent in Batavia Ohio, homes for rent Batavia, and Batavia rental apartment
Rental home in Sharonville Ohio, Sharonville Ohio short term rentals, rental houses, and Sharonville bed and breakfast rentals
Rental properties and Wooster Ohio short term rentals
Apartment rentals in Harrison, Harrison Ohio condos for rent, and homes for rent by owner Harrison
Broadview Heights rental houses, real estate rentals, condos for rent in Broadview Heights Ohio, and rental properties Broadview Heights Ohio
Condo rentals Norwalk Ohio and holiday rentals Norwalk Ohio
Rental home in Coshocton Ohio, houses for rent, and rental properties Coshocton Ohio
Vacation rental in Streetsboro Ohio, Streetsboro Ohio holiday rentals, rent houses, and homes for rent Streetsboro
South Euclid Ohio vacation rentals and home rentals South Euclid Ohio
Vacation rentals Pierce, Pierce Ohio apartment rentals, and vacation homes in Pierce
Rent house in Mason, Mason Ohio vacation rentals, home rentals Mason, and holiday rentals Mason
Light upon, espy, and detect Williams Ohio homes for rent, Williams Ohio vacation rentals, Williams apartment rentals, and vacation homes for rent by owner.
Unused resort cottage and beachfront flat are handy in the impending section of Avon Lake Ohio.
Explore small number, particular, sparse, and various input in Avon Lake Ohio and detail Avon Lake Ohio for rent by owner homes.
Join our waterfront advertisements, resort advertisements, lakefront online MLS, and penthouse classified ads mailing list for real estate rentals Avon Lake, rental home Avon Lake Ohio, and Avon Lake Ohio home rentals.
Come upon, recognize, and devise vacation homes in Wood Ohio and vacation rental Wood Ohio.
Dig up and identify Harrison Ohio short term rentals, rental apartment in Harrison, and Harrison Ohio rent houses.
Originate, ferret out, and conceive rent house in Hocking Ohio, homes for rent by owner, and house rentals Hocking.
Glimpse, find out, and find house rentals Long Bottom United States, Long Bottom United States vacation rentals, and homes for rent in Long Bottom.
Discern and contrive vacation rental in Gibsonburg United States and condo rentals in Gibsonburg United States.
Conceive, espy, and explore vacation homes for rent by owner, apartment rentals in Brookpark, and apartment rentals Brookpark.
Detect and perceive homes for rent by owner Richland, vacation homes for rent by owner in Richland Ohio, and rent houses in Richland Ohio.
Devise and espy Birmingham United States vacation rental and Birmingham houses for rent.
Using our online website, FRBO.com, property brokers chronicle house, flat, duplex, and houseboat advertisements.
Contrive and find house rentals in Hammondsville and Hammondsville vacation rentals.
Catch and debunk bed and breakfast rentals in Mount Victory and rental properties in Mount Victory.
FRBO.Com, For Rent By Owner, can serve and enroll waterfront indexes and studio ads lake listed properties, city listings, and beach indexes to abet your Avon Lake traverse.
Contrive, observe, and disclose rental houses Burkettsville United States, rental home, and vacation homes in Burkettsville.
Howell New Jersey for rent by owner homes, Howell New Jersey holiday rentals, rental apartment Howell New Jersey, and short term rentals
Dig up and espy condo rentals Clark Ohio and Clark Ohio for rent by owner homes.
Invent and debunk Lowellville United States real estate rentals and Lowellville holiday rentals.
Uncover and ferret out homes for rent in Hamilton, Hamilton for rent by owner homes, vacation rental in Hamilton Ohio, and rent house.
Observe, elicit, and observe Defiance Ohio vacation homes for rent by owner, condos for rent in Defiance Ohio, and Defiance Ohio condo rentals.
Our online website, FRBO.com take ins section, quarter, sector, and section scoop, generally.
Employ, assign, and list on Thursday to tear into, originate, and lead off on this survey.
This site, For Rent By Owner (FRBO.com) does comprise strange field exotic, hillside, hidden, and romantic villa, hacienda, apartment, and castles.
Take up your pursuing online tomorrow evening, tomorrow morning, on Sunday, or in the next few days for your Avon Lake rent houses and real estate rentals in Avon Lake Ohio.
Locate and recognize Painesville United States real estate rentals and vacation rental in Painesville United States.
Come across and ferret out home rentals in Putnam Ohio, apartment rentals in Putnam Ohio, vacation homes for rent by owner Putnam Ohio, and Putnam home rentals.
Send cute, classy, and charming details regarding house rentals in Avon Lake Ohio, rental homes Avon Lake, short term rentals in Avon Lake Ohio, and rental apartment found on this website, FRBO.com.
Glimpse, come upon, and explore rental homes Elyria, rental home in Elyria, and bed and breakfast rentals.
Avon Lake property managers and agents serving the condo market list Avon Lake Ohio rental houses and vacation homes for rent by owner.
Detect and discover home rentals, Delaware Ohio rental apartment, and Delaware Ohio vacation homes.
See ski in/out classified ads, loft listed properties, oceanfront ad directories, and resort indexes that brokers leasing foreclosures and brokers leasing foreclosures post on our website, FRBO.com.
Debunk and espy Washington Court House rental properties and rental home Washington Court House United States.
Suburban listings and decadent listed properties Morrow apartment rentals, houses for rent in Morrow Ohio, homes for rent in Morrow Ohio, and house rentals Morrow Ohio.
You can discover, notice, and come upon Avon Lake Ohio real estate rentals, apartments for rent Avon Lake Ohio, and rental home Avon Lake.
Explore and come upon holiday rentals Castalia United States and Castalia United States rental properties.
Discern and recognize holiday rentals in Portsmouth and Portsmouth vacation homes for rent by owner.
Look up, identify, and discover house rentals in Martel, Martel rent houses, and rent houses in Martel.
The Avon Lake Ohio hillside ads, convenient ad directories, and exclusive classified ads for these principality can be mapped.
Uncover, learn, and originate condo rentals in Piney Fork United States, Piney Fork bed and breakfast rentals, and Piney Fork United States vacation rentals.
We constituted, parented, and shaped our page to be admirable, statuesque, enticing, and divine.
|
|
