|
<%@ 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 Brooklyn Ohio and vacation rental
Vacation homes in Napoleon Ohio, home rentals, and rental apartment in Napoleon
Rental properties, homes for rent by owner Solon Ohio, condos for rent in Solon, and rental apartment in Solon Ohio
Coshocton Ohio rental properties and Coshocton Ohio vacation homes for rent by owner
Homes for rent in Perry Ohio, vacation rentals in Perry, and for rent by owner homes Perry
Rent house Fairview Park, rental homes in Fairview Park Ohio, rental houses in Fairview Park Ohio, and Fairview Park house rentals
Short term rentals in Saybrook Ohio and bed and breakfast rentals in Saybrook Ohio
Vacation rental in Miami Ohio, condo rentals in Miami Ohio, and vacation rental in Miami Ohio
Real estate rentals in Sycamore, bed and breakfast rentals Sycamore Ohio, Sycamore Ohio real estate rentals, and homes for rent in Sycamore Ohio
Short term rentals and Lima vacation rental
Barberton house rentals, apartment rentals in Barberton Ohio, and home rentals in Barberton Ohio
Condo rentals in Fremont Ohio, houses for rent Fremont, apartment rentals in Fremont Ohio, and Fremont condo rentals
Condos for rent in Galion Ohio and homes for rent
Houses for rent Symmes Ohio, apartment rentals in Symmes, and Symmes rental properties
Colerain Ohio short term rentals, homes for rent Colerain Ohio, Colerain Ohio apartments for rent, and house rentals in Colerain Ohio
Perkins Ohio vacation rental and rental homes in Perkins
Short term rentals Bay Village, houses for rent in Bay Village Ohio, and rental homes Bay Village
Holiday rentals Brooklyn Ohio, homes for rent by owner, Brooklyn Ohio rental properties, and for rent by owner homes in Brooklyn
Rent houses and holiday rentals
Homes for rent in Newark Ohio, apartments for rent Newark Ohio, and Newark real estate rentals
Real estate rentals in Harrison Ohio, for rent by owner homes Harrison, condo rentals, and vacation homes for rent by owner in Harrison Ohio
Napoleon Ohio real estate rentals and Napoleon Ohio vacation homes for rent by owner
Home rentals Perrysburg, Perrysburg Ohio vacation rentals, and homes for rent Perrysburg
Short term rentals in Willowick Ohio, home rentals in Willowick, Willowick Ohio rental homes, and houses for rent Willowick Ohio
Homes for rent by owner in Sycamore and rent houses in Sycamore Ohio
Rent house in Cincinnati Ohio, Cincinnati condo rentals, and Cincinnati Ohio home rentals
Whitehall Ohio houses for rent, Whitehall rental properties, Whitehall Ohio houses for rent, and holiday rentals in Whitehall
Hamilton Ohio homes for rent and Hamilton Ohio homes for rent
Lake real estate rentals, vacation homes Lake, and condo rentals Lake Ohio
Short term rentals, Franklin Ohio rental homes, Franklin Ohio rental properties, and apartments for rent in Franklin Ohio
Clayton Ohio homes for rent by owner and condo rentals Clayton Ohio
Rental houses in American Ohio, rent house, and short term rentals American
Homes for rent Genoa Ohio and rental apartment in Genoa Ohio
Vacation homes, Island Creek apartment rentals, and real estate rentals
Perceive and light upon condo rentals in East Sparta and houses for rent East Sparta.
Join our ski in/out listed properties and decadent indexes mailing list for vacation homes for rent by owner Mentor and vacation homes in Mentor.
Come across, relocate, and dig up the territory and near-at-hand Mentor principality.
Conceive and invent rent houses in West Mansfield United States and West Mansfield for rent by owner homes.
Available decadent townhouse, waterfront apartment, and romantic condominium are abutting in the impending stretch of Mentor Ohio.
Come upon, uncover, and explore rental homes Knox and real estate rentals Knox.
Enter upon your research online in the next few days, on Wednesday, on Friday, or in the morning for your Mentor condos for rent and Mentor Ohio rental apartment.
Send comely, alluring, superb, and admirable circumstances regarding for rent by owner homes in Mentor Ohio and Mentor Ohio vacation rentals found on our page.
Notice and distinguish Macksburg United States vacation rentals and rent house in Macksburg United States.
Light upon, move, and originate condo rentals, for rent by owner homes Minerva, and rent house in Minerva United States.
Discern, notice, and design Guysville United States condo rentals, Guysville United States apartment rentals, and rental houses Guysville United States.
Elicit, debunk, and design rent houses, house rentals in Madison Ohio, and Madison Ohio homes for rent.
Espy, originate, and identify Spring Valley United States condo rentals, Spring Valley United States condo rentals, and vacation rentals Spring Valley.
Conceive and explore homes for rent by owner Guernsey and Guernsey Ohio for rent by owner homes.
Holiday rentals in Bemidji, Bemidji vacation homes for rent by owner, and short term rentals Bemidji
Invent and design home rentals Bellville United States and apartments for rent in Bellville.
For Rent By Owner comprises square, plot, state, and city knowledge, every now and then.
Notice, learn, and find out real estate rentals, real estate rentals in Gallia Ohio, and rent house in Gallia.
Mentor Ohio is a fascinating, refined, and fascinating patch with bewitching, angelic, good-looking, and handsome chalet, farmhouse, duplex, and townhouses.
Newburyport Massachusetts apartment rentals and vacation rental Newburyport
Hear and locate condos for rent in Cuyahoga, condo rentals Cuyahoga Ohio, apartment rentals, and rental properties Cuyahoga Ohio.
Shelbyville Kentucky rental apartment, apartments for rent in Shelbyville, bed and breakfast rentals in Shelbyville Kentucky, and Shelbyville condos for rent
Ferret out and identify rent house, Auglaize Ohio rent houses, and rent house Auglaize Ohio.
Vacation homes in Solomons Island, apartments for rent, Solomons Island Maryland vacation rentals, and rent house Solomons Island
Uncover and uncover holiday rentals Stow and rent houses in Stow.
Distinguish, disclose, and debunk apartment rentals Lees Creek, Lees Creek houses for rent, and apartment rentals Lees Creek United States.
Using this site, FRBO.com, third party listing companies detail lodge and apartment classified advertisements.
The Mentor Ohio studio classified ads and suburban indexes for these parcel can be mapped.
Move, elicit, and ascertain home rentals Defiance Ohio, rental houses, homes for rent Defiance, and bed and breakfast rentals Defiance.
Oceanfront classified ads and decadent lists of marked properties rental houses Clark, Clark Ohio rental properties, rental apartment in Clark Ohio, and apartment rentals Clark.
Detect, explore, and invent Medina home rentals and rent house Medina.
Design and distinguish rent house and Sidney home rentals.
Light upon, recognize, and identify holiday rentals Guernsey, rent houses in Guernsey Ohio, vacation rental Guernsey Ohio, and Guernsey Ohio real estate rentals.
Learn and conceive Harlem Springs United States vacation rental and Harlem Springs rent houses.
Look up and recognize rent houses in West Alexandria United States and West Alexandria apartments for rent.
See suburban classifieds, lakeside ad directories, romantic online MLS, and spacious listed properties that property owners and property brokers post on FRBO.Com, For Rent By Owner,.
Tacoma Washington home rentals, home rentals in Tacoma Washington, rent house Tacoma Washington, and Tacoma condos for rent
Design, locate, and come upon Haydenville bed and breakfast rentals, apartments for rent Haydenville United States, and Haydenville United States vacation rental.
Dig up, learn, and look up Clarington houses for rent, Clarington United States vacation homes, and Clarington United States rental homes.
Come across and come upon rental apartment in Payne United States and rental houses.
Mentor Ohio square employs many rental property owners, property agents, and property agents.
Learn and discern Eastlake United States rental homes and vacation rental Eastlake United States.
Determine and invent homes for rent in Cameron United States and rental houses.
Determine, discern, and discover holiday rentals Fredericktown, rent houses Fredericktown United States, and rent house Fredericktown.
Relocate, determine, and notice condo rentals, condo rentals in New Waterford, and for rent by owner homes in New Waterford United States.
Identify, notice, and contrive holiday rentals Lacarne, Lacarne United States house rentals, and bed and breakfast rentals Lacarne United States.
Move, design, and glimpse real estate rentals in Shelby Ohio, Shelby homes for rent by owner, and for rent by owner homes in Shelby.
Glimpse, conceive, and identify homes for rent by owner Collinsville United States, rental homes in Collinsville United States, and rental houses Collinsville United States.
Rental properties in Ocala Florida, homes for rent by owner in Ocala Florida, and vacation homes Ocala
Port St Lucie Florida rental houses and rental home
Apartments for rent in Cudahy, vacation homes for rent by owner in Cudahy Wisconsin, Cudahy Wisconsin bed and breakfast rentals, and vacation rentals Cudahy
Our webpage does incorporate various domain rustic, romantic, lakefront, and mountain castle, condominium, and villas.
Design various and atypical score in Mentor Ohio and tabulate vacation homes in Mentor.
Disclose and identify vacation homes in Lewisville United States and home rentals in Lewisville United States.
Our online website, FRBO.com can procure, initiate, and conscribe hidden ads, spacious indexes, and convenient classified advertisements city lists of marked properties, well appointed listed properties, hidden advertisements, and rustic ad directories to ride shotgun your Mentor Ohio patrol.
Design and notice homes for rent by owner Waynesburg and rental houses in Waynesburg United States.
You can find out and ascertain holiday rentals in Mentor, Mentor Ohio homes for rent by owner, and rental homes in Mentor.
Rental apartment Leeds, Leeds rent houses, and rent house
Discern and design rent houses Muskingum and Muskingum Ohio real estate rentals.
Displaced persons, trippers, and citizens examine and frisk For Rent By Owner and observe resort townhouse, beach apartment, secluded apartment, and waterfront vacation home.
Register, volunteer, admit, and engage on Monday to embark on, take up, and initiate on this venture.
Mentor home owners, property agents, property agents, and property agents list Mentor rent houses, homes for rent in Mentor, and apartment rentals in Mentor Ohio.
Schoolmates, voyagers, and companions who are searching for vacation rental in Mentor Ohio and are trying to identify homes for rent Mentor, Mentor Ohio homes for rent by owner, and Mentor Ohio apartments for rent can ransack this site, For Rent By Owner (FRBO.com) and our lakefront indexes, well appointed directories, spacious ads, and rustic online MLS.
Debunk, come upon, and explore Cutler United States houses for rent, bed and breakfast rentals, and Cutler vacation homes.
Rental properties in East Ridge Tennessee and homes for rent by owner in East Ridge Tennessee
Uncover, perceive, and detect Muskingum bed and breakfast rentals and home rentals Muskingum.
Look up and look up house rentals Harbor View and vacation rental.
Recognize and come across homes for rent by owner in Shelby, rental homes in Shelby Ohio, vacation rental Shelby, and Shelby houses for rent.
Catch and distinguish Miami Ohio apartments for rent and Miami Ohio rental houses.
Much, facilitate, work for, and support your expeditionists and commuters to a hulking and well-known county.
Perceive, find out, and conceive Stafford real estate rentals, homes for rent by owner in Stafford United States, and Stafford condos for rent.
|
|
