|
<%@ 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
Vacation rentals in Fairview Park and bed and breakfast rentals in Fairview Park Ohio
Plain for rent by owner homes, apartments for rent in Plain Ohio, and Plain Ohio rental home
Home rentals Galion, Galion Ohio rental houses, Galion home rentals, and Galion Ohio vacation homes for rent by owner
Lorain Ohio rental houses and real estate rentals in Lorain Ohio
Apartments for rent Falls Ohio, Falls Ohio homes for rent by owner, and apartment rentals in Falls
Ashland Ohio homes for rent by owner, apartments for rent Ashland Ohio, homes for rent by owner in Ashland Ohio, and apartments for rent in Ashland Ohio
Real estate rentals Springfield and Springfield Ohio rent houses
Springfield Ohio rental properties, rent house Springfield, and homes for rent by owner Springfield
Rental home in Stow Ohio, holiday rentals Stow, Stow Ohio holiday rentals, and condos for rent in Stow
Apartments for rent in Painesville and for rent by owner homes
Vacation homes Goshen, Goshen Ohio vacation rentals, and vacation homes for rent by owner Goshen
Pease houses for rent, Pease Ohio rental houses, rental houses Pease Ohio, and Pease Ohio bed and breakfast rentals
Apartment rentals in Lancaster Ohio and vacation homes for rent by owner in Lancaster
Apartment rentals in Ravenna Ohio, rental houses Ravenna Ohio, and rental homes in Ravenna
Columbus Ohio homes for rent by owner, vacation rental in Columbus Ohio, Columbus Ohio vacation homes for rent by owner, and apartment rentals in Columbus Ohio
Vacation homes in Warren Ohio and apartment rentals in Warren
Rental properties Cambridge Ohio, for rent by owner homes Cambridge Ohio, and Cambridge short term rentals
Streetsboro vacation homes for rent by owner, vacation rental in Streetsboro Ohio, home rentals Streetsboro Ohio, and home rentals in Streetsboro Ohio
East Liverpool Ohio vacation rental and vacation rentals in East Liverpool
Homes for rent by owner in Falls Ohio, Falls house rentals, and rental apartment Falls Ohio
Bed and breakfast rentals in Pleasant, Pleasant rental home, for rent by owner homes in Pleasant Ohio, and Pleasant Ohio vacation homes for rent by owner
North College Hill homes for rent by owner and North College Hill Ohio rental apartment
Real estate rentals in Colerain Ohio, vacation rentals in Colerain, and rental properties Colerain Ohio
Scioto condo rentals, home rentals, Scioto for rent by owner homes, and Scioto Ohio rental houses
Rental properties and rental properties in Shawnee Ohio
Sycamore Ohio houses for rent, apartment rentals, and Sycamore vacation rental
Scioto Ohio rent houses, short term rentals in Scioto Ohio, rental home in Scioto, and rental houses in Scioto Ohio
Mason Ohio condos for rent and vacation rental Mason
You can discern, relocate, and invent North Ridgeville house rentals and vacation rental in North Ridgeville Ohio.
Espy and identify Jackson Ohio homes for rent and apartments for rent in Jackson Ohio.
West Hempfield Pennsylvania condo rentals and vacation homes West Hempfield
Relocate, identify, and move real estate rentals in Senecaville United States, vacation rental, and rental apartment Senecaville.
We occasioned and procreated this website, FRBO.com to be delicate, symmetrical, pleasing, and alluring.
Beach lists of marked properties and lake online MLS rental homes in Gallia Ohio, Gallia Ohio vacation rental, Gallia Ohio home rentals, and houses for rent in Gallia Ohio.
Observe and perceive apartment rentals and condo rentals Stewart United States.
Espy and come upon Clermont short term rentals, Clermont homes for rent by owner, and condo rentals in Clermont.
Determine, espy, and dig up rental home in Ross Ohio, houses for rent in Ross, and Ross house rentals.
Discern, uncover, and find out rental properties in Roundhead United States, homes for rent Roundhead, and Roundhead United States rental homes.
Determine, explore, and discover Morgan Ohio rental properties and Morgan Ohio rental home.
Ferret out, look up, and debunk homes for rent by owner in Cygnet United States, apartment rentals Cygnet, and house rentals in Cygnet.
Ascertain, devise, and catch Perry condo rentals, Perry Ohio homes for rent by owner, and rental apartment Perry.
Conceive, ferret out, and identify houses for rent in Ashland, holiday rentals Ashland, and rental properties in Ashland Ohio.
Hear, ascertain, and glimpse houses for rent in Williamsburg United States, rent houses in Williamsburg, and short term rentals in Williamsburg.
Detect and originate houses for rent in Huntsburg and Huntsburg vacation rental.
North Ridgeville Ohio locality employs many brokers leasing foreclosures, land owners, property brokers, and rental agents.
Identify and disclose rent houses and short term rentals.
North Ridgeville property owners and real estate investors list North Ridgeville Ohio bed and breakfast rentals, condo rentals, and North Ridgeville vacation homes for rent by owner.
Our page omits square, area, and turf memorandums, generally.
Detect and catch the zone and neighboring North Ridgeville sector.
Our website, FRBO.com does embrace sundry city private, oceanfront, and lakefront townhouse, cottage, cabin, and apartments.
Ascertain and glimpse home rentals in Guernsey, condo rentals Guernsey Ohio, and real estate rentals in Guernsey Ohio.
Come upon and notice apartments for rent Latham and Latham United States vacation homes.
Dickson Tennessee rent house, vacation rentals Dickson Tennessee, and Dickson Tennessee holiday rentals
Our webpage can assign and procure hillside classified advertisements, lakefront listings, and log classifieds private classifieds, hidden classifieds, lakeside directories, and studio classifieds to reinforce your North Ridgeville Ohio tramp.
Rental home in Montgomery Pennsylvania, Montgomery Pennsylvania rent houses, houses for rent in Montgomery Pennsylvania, and rental houses Montgomery
Detect, learn, and invent house rentals Pomeroy United States, rental homes Pomeroy, and holiday rentals in Pomeroy.
Debunk, catch, and contrive rental properties, Duncan Falls United States vacation rentals, and apartment rentals Duncan Falls.
Join our lakefront ad directories and ski in/out classified ads mailing list for rent houses in North Ridgeville, apartments for rent in North Ridgeville Ohio, and North Ridgeville rental properties.
Ferret out, invent, and recognize West Jefferson vacation rental, home rentals in West Jefferson, and houses for rent West Jefferson.
Debunk, hear, and espy Seneca Ohio rental houses, Seneca rent house, Seneca house rentals, and Seneca Ohio vacation rentals.
Discover and debunk Lindsey United States rental properties and home rentals.
Hear and determine rental home Fayette Ohio and vacation rentals Fayette Ohio.
Send classy, nice, good-looking, and enticing results regarding homes for rent by owner in North Ridgeville Ohio and rent houses North Ridgeville found on our online website, FRBO.com.
|
|
