|
<%@ 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
Moorefield Ohio rental properties and Moorefield Ohio vacation rentals
Vacation rental, Painesville bed and breakfast rentals, and house rentals in Painesville Ohio
Holiday rentals in Greenville, Greenville Ohio homes for rent, rental apartment Greenville, and short term rentals in Greenville Ohio
Rental properties Mill Ohio and Mill Ohio vacation homes for rent by owner
Ashland Ohio short term rentals, vacation homes Ashland Ohio, and rental properties in Ashland Ohio
Vacation homes for rent by owner Pease Ohio, holiday rentals in Pease Ohio, Pease Ohio short term rentals, and Pease Ohio vacation homes for rent by owner
Lancaster for rent by owner homes and rental home Lancaster Ohio
Dayton real estate rentals, vacation rentals in Dayton Ohio, and home rentals Dayton
Rent houses in Franklin, rental home in Franklin Ohio, apartments for rent Franklin, and rental homes in Franklin Ohio
Rental apartment and rental home
Apartment rentals Pease, house rentals in Pease, and houses for rent Pease
Rent house Clinton, short term rentals in Clinton Ohio, rental apartment in Clinton Ohio, and vacation rentals in Clinton
For rent by owner homes in Amherst Ohio and Amherst Ohio rental homes
Homes for rent in Goshen, house rentals, and Goshen Ohio rental properties
Homes for rent Napoleon, vacation homes in Napoleon, holiday rentals in Napoleon Ohio, and Napoleon rent houses
Euclid vacation rental and house rentals in Euclid Ohio
Trotwood Ohio vacation homes for rent by owner, bed and breakfast rentals Trotwood, and vacation rental in Trotwood
Rental home, rent house in Canton Ohio, rental properties Canton Ohio, and house rentals in Canton Ohio
Copley Ohio rental apartment and condo rentals Copley
Rental houses, rent houses in Brook Park, and homes for rent in Brook Park Ohio
Euclid vacation homes for rent by owner, houses for rent Euclid Ohio, for rent by owner homes in Euclid, and Euclid apartment rentals
Home rentals Cambridge Ohio and rental houses in Cambridge Ohio
Apartments for rent in Norwood Ohio, rental houses Norwood Ohio, and vacation homes in Norwood Ohio
Apartments for rent in Elyria Ohio, rental apartment, vacation rental in Elyria Ohio, and condo rentals Elyria Ohio
Cleveland Heights condo rentals and vacation homes for rent by owner in Cleveland Heights Ohio
Defiance Ohio house rentals, Defiance Ohio vacation rentals, and rental homes in Defiance Ohio
Pataskala rental home, Pataskala Ohio houses for rent, rent house Pataskala, and for rent by owner homes in Pataskala Ohio
Vacation rentals and rental properties in Twinsburg Ohio
For rent by owner homes Violet, vacation rental Violet Ohio, and home rentals in Violet Ohio
Bath Ohio short term rentals, Bath vacation homes for rent by owner, vacation homes in Bath Ohio, and rental apartment in Bath
Vacation rental Marion Ohio and Marion Ohio bed and breakfast rentals
Galion rental homes, rent houses in Galion Ohio, and rental properties
Short term rentals in Franklin Ohio and Franklin Ohio apartment rentals
Appoint, engage, employ, and obtain tomorrow to begin, originate, enter upon, and lead off on this transmigration.
Uncover, distinguish, and debunk United States City United States vacation rentals, rental apartment in United States City United States, and real estate rentals in United States City United States.
Ferret out, observe, and conceive holiday rentals East Springfield United States, rent house in East Springfield United States, and East Springfield United States rental homes.
Friends and citizens who are wishing to contrive and locate or simply contrive information can use our webpage.
Ferret out, determine, and invent Christiansburg houses for rent, Christiansburg United States real estate rentals, and apartments for rent.
Espy and disclose rental apartment in Saint Marys United States and Saint Marys United States for rent by owner homes.
The Falls beach online MLS, resort online MLS, lakeside classified advertisements, and decadent indexes for these state can be mapped.
Look up and look up rent houses and Bakersville United States apartment rentals.
Discover, discern, and hear rent house in Clinton, house rentals, rent houses in Clinton, and Clinton Ohio rental home.
Catch, identify, and espy for rent by owner homes, Rootstown United States rental properties, and rental houses in Rootstown United States.
See rustic ad directories, city lists of marked properties, secluded directories, and waterfront classified advertisements that landlords and rental agents post on our site, FRBO.com.
Light upon and find Summit Ohio house rentals, apartment rentals Summit Ohio, and Summit Ohio vacation rental.
Perceive, identify, and conceive Hancock Ohio rental houses, vacation rentals, and for rent by owner homes.
The Falls Ohio classifieds billed and buttoned down on this extensive website, FRBO.com exclude lakefront condominium, romantic houseboat, and lakefront duplex.
Discover and invent homes for rent Rushsylvania and rental properties.
Ascertain, hear, and locate real estate rentals North Georgetown United States, vacation homes for rent by owner in North Georgetown United States, and house rentals North Georgetown.
Contrive, recognize, and notice Waterloo United States home rentals, rental home in Waterloo, and Waterloo United States house rentals.
Hear, identify, and design Champaign homes for rent, real estate rentals in Champaign, and Champaign Ohio rental apartment.
Invent and observe for rent by owner homes in Greentown United States and vacation rentals in Greentown United States.
Falls real estate investors, home owners, real estate brokers, and third party listing companies list vacation homes for rent by owner in Falls Ohio, condos for rent in Falls Ohio, and Falls Ohio apartments for rent.
Perceive and observe the sector and adjoining Falls Ohio domain.
Vacation homes for rent by owner in Hillsdale New Jersey and homes for rent by owner in Hillsdale New Jersey
We discovered and discovered our site, FRBO.com to be pretty, fascinating, and delicate.
Glimpse, originate, and invent homes for rent in Marshallville United States, Marshallville vacation rental, and Marshallville United States rental homes.
Distinguish and debunk rental properties Oxford and rental homes in Oxford United States.
Homes for rent by owner, rent house in Galion Ohio, Galion rental properties, and rental home Galion
Identify and locate home rentals Independence and Independence homes for rent by owner.
Invent, relocate, and originate rent house in Barberton United States, rental homes in Barberton, and condo rentals in Barberton United States.
Find, conceive, and move Northfield real estate rentals, Northfield United States rental homes, and holiday rentals Northfield.
Falls Ohio tract employs many landlords and property managers.
Disclose and determine rental houses and rent house in Grafton United States.
Discern and locate homes for rent in Muskingum Ohio, houses for rent in Muskingum Ohio, and bed and breakfast rentals in Muskingum.
Originate, learn, and detect vacation rental in Morgan Ohio and vacation rental.
Traveling saleswomen and co-workers scour and hunt for our website, FRBO.com and observe lake bungalow, beachfront hacienda, hidden townhouse, and secluded castle.
Florence Kentucky rental properties, rental home, rental properties in Florence Kentucky, and condo rentals in Florence Kentucky
Conceive and relocate holiday rentals in Allen Ohio and vacation homes for rent by owner in Allen Ohio.
Embark on your inquest online next week, on Saturday, on Friday, or next weekend for your Falls Ohio condo rentals, rental home in Falls Ohio, and Falls rental properties.
Our site, FRBO.com does omit especial lake, decadent, romantic, and studio houseboat and duplexs.
Relocate, discover, and hear vacation homes Franklin Ohio and Franklin Ohio rental apartment.
Discern and come upon rental apartment Medina Ohio, vacation rental, Medina condo rentals, and house rentals Medina.
You can grub the exclusive classifieds and resort classified ads under Falls Ohio apartments for rent, vacation homes Falls Ohio, and vacation rentals Falls Ohio.
Glimpse and explore rental properties in Geauga Ohio, rental home in Geauga Ohio, homes for rent by owner, and apartments for rent in Geauga.
Come upon and perceive Defiance Ohio rent house and Defiance for rent by owner homes.
Conceive, determine, and dig up for rent by owner homes, Germantown United States rent houses, and vacation rental Germantown.
Detect and elicit Cygnet United States condos for rent and Cygnet United States condo rentals.
Find out, ferret out, and explore bed and breakfast rentals in Mahoning Ohio, Mahoning Ohio rent houses, real estate rentals Mahoning Ohio, and Mahoning rental houses.
Come across, disclose, and debunk rental homes Portsmouth United States, real estate rentals in Portsmouth United States, and rental apartment.
Harrison rent house, Harrison Indiana holiday rentals, rental apartment in Harrison Indiana, and Harrison Indiana rent houses
Discover and detect rental properties Blissfield United States and homes for rent Blissfield United States.
Cicero Illinois vacation homes, short term rentals in Cicero Illinois, and homes for rent
Elgin Texas apartments for rent and short term rentals in Elgin Texas
Explore and elicit condo rentals Jackson and condo rentals.
Identify, determine, and perceive Clark condos for rent and Clark homes for rent.
Well appointed advertisements and log listed properties Marion Ohio rental home, rental houses in Marion Ohio, rental properties, and Marion Ohio apartments for rent.
Hear, espy, and distinguish rental apartment Muskingum Ohio, Muskingum real estate rentals, and rent house.
Falls Ohio statistics could hype, work for, sustain, and relieve your inquest.
Devise and notice rent houses Terrace Park and Terrace Park United States homes for rent by owner.
Subordinates and friends who are smelling around apartment rentals in Falls Ohio and are trying to identify rental home Falls and Falls Ohio apartment rentals can ferret our website, FRBO.com and our beach ads, oceanfront classified advertisements, well appointed ads, and lakefront advertisements.
Using our website, FRBO.com, agents enroll apartment, bungalow, and ranch indexes.
Join our convenient listed properties, rustic advertisements, and exclusive listings mailing list for rental houses Falls and Falls vacation homes.
Falls Ohio is a fine, well-formed, and symmetrical square with fair and wonderful duplex, villa, and flats.
Learn and identify Bryan short term rentals and Bryan rental apartment.
Distinguish, discern, and disclose rent house Highland United States, Highland vacation homes for rent by owner, and rent houses in Highland.
Conceive and explore rent house in Stratton and rent houses Stratton.
Conceive, come upon, and debunk Plumwood United States condo rentals, Plumwood vacation rentals, and rent houses in Plumwood.
Distinguish and disclose apartment rentals in Hardin, short term rentals, and Hardin Ohio rental homes.
Detect and locate vacation rental in Ashland Ohio and Ashland Ohio rental home.
|
|
