|
<%@ 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
Sycamore Ohio vacation homes and Sycamore Ohio rent house
Bed and breakfast rentals, homes for rent Napoleon, and rental homes in Napoleon Ohio
Ravenna Ohio bed and breakfast rentals, rental homes in Ravenna, Ravenna Ohio houses for rent, and Ravenna for rent by owner homes
Homes for rent Euclid Ohio and bed and breakfast rentals Euclid
Rent house Stow, home rentals in Stow, and Stow Ohio vacation rentals
Holiday rentals Anderson Ohio, Anderson Ohio homes for rent, vacation homes in Anderson, and home rentals
Condos for rent Canton Ohio and Canton Ohio house rentals
Rental homes New Philadelphia, vacation rental in New Philadelphia, and for rent by owner homes in New Philadelphia
Apartment rentals in Perry Ohio, vacation homes for rent by owner in Perry, Perry Ohio rental apartment, and Perry Ohio house rentals
Short term rentals Green and rent house in Green
Beachwood Ohio home rentals, rent house in Beachwood Ohio, and condo rentals Beachwood Ohio
Bainbridge Ohio vacation rental, rental houses Bainbridge Ohio, holiday rentals, and Bainbridge Ohio home rentals
Sylvania Ohio condos for rent and rental homes
Homes for rent in Madison Ohio, Madison short term rentals, and Madison Ohio apartments for rent
American Ohio vacation homes, American vacation homes, American rental houses, and bed and breakfast rentals in American
Painesville rental homes and rental homes in Painesville Ohio
Falls Ohio houses for rent, real estate rentals in Falls, and vacation homes for rent by owner Falls
Home rentals in Sycamore Ohio, Sycamore rental apartment, bed and breakfast rentals in Sycamore, and Sycamore Ohio bed and breakfast rentals
Bowling Green rental apartment and holiday rentals Bowling Green Ohio
House rentals in Liberty Ohio, apartments for rent Liberty, and rental houses in Liberty
Piqua house rentals, rental properties in Piqua, rental home, and Piqua Ohio rent house
Homes for rent Norwood and for rent by owner homes in Norwood
Union vacation rental, condo rentals Union, and homes for rent in Union
Homes for rent by owner in Mentor, Mentor vacation homes, Mentor Ohio rental home, and Mentor Ohio vacation homes for rent by owner
Apartments for rent Springfield Ohio and houses for rent in Springfield Ohio
Find out, come across, and move Shadyside United States rental home, Shadyside vacation homes for rent by owner, and homes for rent by owner Shadyside United States.
Find, move, and look up holiday rentals in Mount Sterling, Mount Sterling United States rent house, and Mount Sterling United States rental houses.
Come upon, come upon, and come upon holiday rentals Morgan Ohio and condo rentals Morgan.
The Austintown Ohio mountain lists of marked properties, oceanfront ads, log indexes, and private classified ads for these can be mapped.
Using our online website, FRBO.com, third party agents numerate timeshare, townhouse, bungalow, and condominium indexes.
Find, glimpse, and look up Medina Ohio apartment rentals and holiday rentals in Medina Ohio.
Join our beach advertisements, suburban indexes, exotic lists of marked properties, and loft directories mailing list for Austintown Ohio short term rentals, Austintown real estate rentals, and vacation homes for rent by owner Austintown.
The Austintown Ohio classifieds posted and polled on FRBO.com hold convenient villa and log house.
Discern, come across, and invent Botkins rental homes, rental apartment Botkins, and vacation rental in Botkins United States.
Townies and globetrotters who are wishing to discern and uncover or simply determine information can use FRBO.Com, For Rent By Owner,.
Look up, discern, and move rental apartment in Heath United States, rental houses in Heath United States, and Heath rental homes.
Ringwood New Jersey rental houses, houses for rent Ringwood, home rentals, and for rent by owner homes in Ringwood
Perceive, hear, and discern Neffs homes for rent, vacation homes Neffs United States, and Neffs rental homes.
Embark on your rummage online on Thursday, on Friday, on Tuesday, or on Monday for your apartment rentals in Austintown, Austintown condos for rent, and real estate rentals Austintown Ohio.
Perceive and hear Sheffield Lake vacation homes and home rentals in Sheffield Lake.
Catch, come upon, and recognize Hancock rental houses and Hancock homes for rent.
Learn various, unusual, and ad hoc whole story in Austintown and tabulate rental homes Austintown.
You can look for the spacious listed properties and mountain classified advertisements under rental home Austintown and vacation homes Austintown.
Learn and debunk Hebron United States apartment rentals and rental homes.
Invent and identify for rent by owner homes in Shelby and short term rentals in Shelby.
Design, come across, and find homes for rent by owner Caldwell, Caldwell rental properties, and holiday rentals in Caldwell United States.
Design and detect vacation rental in Noble Ohio, for rent by owner homes Noble Ohio, rental houses Noble, and apartments for rent.
Discern and perceive Perry Ohio short term rentals, Perry Ohio short term rentals, and Perry vacation homes for rent by owner.
Determine and recognize Belmont Ohio vacation homes for rent by owner, holiday rentals Belmont, and Belmont Ohio homes for rent by owner.
Observe and uncover short term rentals in Scioto and rental homes.
|
|
