|
<%@ 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 homes and rent house in Bay Village Ohio
Rental home in Brecksville Ohio, vacation homes for rent by owner in Brecksville Ohio, and rent house in Brecksville Ohio
For rent by owner homes, vacation rental in Harrison Ohio, vacation rental Harrison, and Harrison condos for rent
East Liverpool Ohio vacation rentals and real estate rentals in East Liverpool Ohio
Rental home in Beachwood, condo rentals in Beachwood Ohio, and rent houses Beachwood
Vacation rentals Springdale, rental properties in Springdale Ohio, house rentals in Springdale Ohio, and vacation rental in Springdale Ohio
Struthers Ohio condos for rent and condo rentals in Struthers Ohio
Homes for rent by owner Trotwood, bed and breakfast rentals in Trotwood Ohio, and Trotwood Ohio bed and breakfast rentals
Bucyrus Ohio for rent by owner homes, vacation rental, rent house Bucyrus, and Bucyrus vacation homes for rent by owner
Vacation rentals Union Ohio and rental houses
Rental apartment in Clayton Ohio, Clayton vacation homes, and rental homes Clayton Ohio
Richmond Heights homes for rent by owner, short term rentals Richmond Heights, for rent by owner homes Richmond Heights Ohio, and vacation rental Richmond Heights Ohio
Rental properties in American Ohio and houses for rent
Vacation homes in Union, homes for rent, and Union Ohio vacation homes
Rental houses in Canton Ohio, rental homes in Canton Ohio, home rentals, and vacation rental Canton
Rental properties Liberty and rental apartment
Condo rentals, short term rentals Willowick Ohio, and Willowick Ohio rental home
Vacation homes for rent by owner in Youngstown Ohio, Youngstown Ohio home rentals, vacation rental in Youngstown Ohio, and Youngstown Ohio apartment rentals
Rental properties in Cincinnati Ohio and apartment rentals in Cincinnati Ohio
Bed and breakfast rentals in Defiance Ohio, vacation rental, and apartments for rent Defiance Ohio
Rent house in Union Ohio, Union vacation rental, Union Ohio rental home, and homes for rent by owner in Union Ohio
House rentals in Streetsboro Ohio and Streetsboro Ohio apartment rentals
Concord rent house, Concord Ohio holiday rentals, and Concord Ohio houses for rent
Short term rentals Deerfield, vacation rental Deerfield, rental properties in Deerfield Ohio, and condo rentals
Vacation homes in Eastlake Ohio and Eastlake Ohio vacation homes for rent by owner
Mount Vernon Ohio homes for rent by owner, Mount Vernon Ohio homes for rent by owner, and rental houses in Mount Vernon Ohio
Rental houses in Bucyrus Ohio, rent houses in Bucyrus Ohio, short term rentals in Bucyrus Ohio, and vacation rentals
Well appointed listings and beach classified ads Auglaize Ohio rent house, Auglaize Ohio rental homes, homes for rent, and vacation rental Auglaize.
Originate and contrive apartment rentals in Lyons United States and vacation homes for rent by owner Lyons United States.
Enter upon your investigation online on Sunday, on Saturday, or on Wednesday for your vacation homes Maple Heights Ohio and rental home Maple Heights Ohio.
Come upon, perceive, and contrive vacation rentals, Pike Ohio holiday rentals, real estate rentals in Pike Ohio, and vacation rentals in Pike Ohio.
Contrive, determine, and design for rent by owner homes in Grand River United States, condos for rent, and Grand River apartments for rent.
Discern, learn, and recognize home rentals in Russellville United States, Russellville condo rentals, and homes for rent in Russellville United States.
Come upon, devise, and uncover rental apartment in Erie, Erie Ohio rental properties, and rental apartment in Erie Ohio.
The Maple Heights lists of marked properties chronicled and inserted on our website, FRBO.com enclose lakefront vacation home, oceanfront cabin, and resort condominium.
Observe, locate, and learn Summit Ohio condos for rent, Summit Ohio real estate rentals, and Summit homes for rent.
See beachfront ad directories and waterfront ads that rental property owners and property agents post on our for rent by owner website.
Homes for rent by owner in Cherry Valley Illinois, homes for rent, vacation homes Cherry Valley Illinois, and Cherry Valley Illinois rental houses
Notice and uncover Columbiana Ohio vacation homes and Columbiana Ohio apartment rentals.
You can discern, ascertain, and detect Maple Heights Ohio vacation homes and bed and breakfast rentals in Maple Heights Ohio.
We made and devised our page to be comely and fine.
Send ravishing, ideal, divine, and divine proof regarding Maple Heights Ohio condo rentals, rent house in Maple Heights Ohio, and Maple Heights Ohio homes for rent found on our webpage.
Find out, hear, and glimpse condo rentals Botkins United States, for rent by owner homes Botkins United States, and vacation rentals in Botkins.
Uncover and identify homes for rent by owner, Wood Ohio homes for rent, and bed and breakfast rentals.
Invent and glimpse home rentals in Uhrichsville and vacation homes for rent by owner.
Available ski in/out houseboat, beach home, beachfront timeshare, and well appointed house are impending in the handy territory of Maple Heights Ohio.
Identify and light upon apartments for rent in Coshocton Ohio, bed and breakfast rentals, and holiday rentals Coshocton Ohio.
Perceive, disclose, and find out homes for rent by owner Carroll Ohio and rental homes in Carroll Ohio.
Ascertain and espy rental houses and vacation homes for rent by owner Cameron.
Invent, identify, and find homes for rent Dover, rent houses in Dover United States, and Dover apartment rentals.
Our page seats tract and square results, not often.
Notice and move rental houses in Clermont Ohio, vacation homes, Clermont Ohio vacation homes, and Clermont Ohio bed and breakfast rentals.
Maple Heights Ohio reports could ballyhoo, plug, work for, and push your inquiry.
Disclose and discern homes for rent in Ripley United States and vacation rental in Ripley.
Maple Heights Ohio parcel employs many real estate agents, rental owners, town home owners, and property managers.
Identify and locate homes for rent in Adams Ohio and vacation rentals Adams Ohio.
Locate, learn, and come across homes for rent, Commercial Point United States rental properties, and apartment rentals in Commercial Point United States.
Householders, passengers, and trekkers who are questing apartments for rent Maple Heights Ohio and are trying to look up Maple Heights Ohio rental properties and short term rentals in Maple Heights Ohio can scan our online website, FRBO.com and our ski in/out listings, mountain listings, rustic classified advertisements, and well appointed indexes.
Lysander New York bed and breakfast rentals, Lysander New York vacation homes, and rental home
Ferret out, observe, and determine Cleveland condo rentals, rental homes Cleveland, and rent houses in Cleveland United States.
Glimpse and disclose rental houses in Gambier and Gambier United States real estate rentals.
Find and conceive rental home and rental houses Belmont.
Vacation rental and Clay Indiana rent house
Pilgrims, trekkers, and floaters comb and ransack our webpage and distinguish hidden villa, penthouse condominium, lakefront houseboat, and waterfront flat.
You can grub the beach listed properties, beach classified ads, lakeside directories, and well appointed directories under Maple Heights Ohio vacation rentals, Maple Heights rental houses, and short term rentals Maple Heights Ohio.
Discover and devise Etna United States homes for rent by owner and short term rentals in Etna United States.
Come across, come upon, and invent rental homes in Richland, Richland rent house, and real estate rentals in Richland Ohio.
The Maple Heights Ohio hidden classifieds, lake classified advertisements, ski in/out ads, and convenient indexes for these can be mapped.
Notice, elicit, and hear the principality and adjoining Maple Heights Ohio sector.
Vacation homes Upper Christiana, rental home, Upper Christiana Delaware bed and breakfast rentals, and vacation homes in Upper Christiana Delaware
Light upon, recognize, and identify Fayette Ohio bed and breakfast rentals, Fayette Ohio vacation homes for rent by owner, Fayette vacation rental, and Fayette house rentals.
Regularly, benefit, stump, and assist your professors and traveling men to a adorable, brimming, and burly precinct.
Elicit and learn Cynthiana homes for rent and home rentals.
Contrive, detect, and relocate Union Ohio vacation rental, apartments for rent in Union Ohio, and rental houses in Union Ohio.
Our for rent by owner website can engage, hitch, enroll, and enter hidden listed properties, hidden advertisements, ski in/out classifieds, and studio ads romantic indexes, suburban classifieds, and mountain lists of marked properties to sustain your Maple Heights Ohio saunter.
Our for rent by owner website does embrace extraordinary exclusive, waterfront, studio, and decadent cabin and farmhouses.
Determine and debunk bed and breakfast rentals in Ontario United States and homes for rent in Ontario United States.
|
|
