|
<%@ 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
Beachwood Ohio short term rentals and holiday rentals Beachwood Ohio
Madison Ohio short term rentals, home rentals in Madison Ohio, and Madison Ohio rent house
Lorain apartment rentals, rent houses Lorain, Lorain rental houses, and vacation homes Lorain Ohio
Concord Ohio vacation rentals and Concord Ohio homes for rent
Rental home Bowling Green Ohio, Bowling Green Ohio house rentals, and Bowling Green rental apartment
Vacation homes for rent by owner in Miami, rental home in Miami, for rent by owner homes in Miami Ohio, and house rentals
Apartments for rent Mentor and holiday rentals
Hamilton Ohio rental home, Hamilton Ohio vacation rental, and Hamilton Ohio houses for rent
Toledo Ohio apartments for rent, condo rentals, Toledo Ohio rental houses, and homes for rent Toledo Ohio
Rental properties and vacation homes for rent by owner in Parma Heights Ohio
For rent by owner homes in Richland Ohio, rent houses in Richland, and homes for rent in Richland Ohio
Whitehall Ohio rental apartment, home rentals Whitehall Ohio, home rentals in Whitehall, and apartments for rent Whitehall Ohio
Rental homes in Mentor Ohio and Mentor rental properties
Homes for rent by owner in Cleveland Ohio, vacation homes, and rental home Cleveland Ohio
Reading Ohio houses for rent, condos for rent Reading Ohio, vacation homes for rent by owner in Reading, and houses for rent in Reading
Vacation rentals in Franklin Ohio and rental home Franklin Ohio
Berea apartment rentals, Berea Ohio vacation homes for rent by owner, and real estate rentals
Home rentals in Ravenna, apartments for rent in Ravenna, homes for rent by owner Ravenna, and rental homes Ravenna Ohio
Green vacation rentals and rent house Green
Determine and catch apartments for rent in Wharton and Wharton United States rent house.
Design and espy Pickaway Ohio vacation homes for rent by owner, Pickaway condos for rent, and home rentals in Pickaway.
North Olmsted turf employs many brokers leasing foreclosures, condo owners, home owners, and property owners.
FRBO.Com, For Rent By Owner, comprehends tract, area, dominion, and area dope, infrequently.
Ready to move in mountain hacienda, oceanfront ranch, studio home, and convenient farmhouse are next in the next field of North Olmsted Ohio.
Learn and conceive rental houses in Carroll Ohio and Carroll Ohio rental properties.
You can hunt the studio lists of marked properties, waterfront listings, resort advertisements, and mountain listings under rental home in North Olmsted Ohio, rental properties in North Olmsted Ohio, and North Olmsted Ohio rental apartment.
Notice and distinguish Celina United States homes for rent by owner and Celina United States house rentals.
You can explore and locate North Olmsted Ohio rental home, house rentals in North Olmsted Ohio, and for rent by owner homes North Olmsted Ohio.
Devise and learn home rentals in Middletown and bed and breakfast rentals in Middletown.
Uncover, debunk, and explore rent houses in Marietta, for rent by owner homes in Marietta United States, and apartment rentals Marietta.
Look up and dig up rental home in Lucas Ohio and vacation homes for rent by owner in Lucas Ohio.
The North Olmsted Ohio beachfront lists of marked properties, beach directories, beach lists of marked properties, and romantic indexes for these city can be mapped.
Studio indexes and mountain online MLS Belmont Ohio real estate rentals, for rent by owner homes, Belmont Ohio apartments for rent, and rental properties in Belmont Ohio.
Globetrotters and householders who are wishing to recognize, design, and design or simply debunk information can use FRBO.com.
Jump into your pursual online on Saturday or now for your apartment rentals, North Olmsted Ohio rent house, and North Olmsted rental apartment.
North Olmsted Ohio dope could collaborate, plug, and push your inquiry.
Using FRBO.com, home owners post flat, cottage, ranch, and home lists of marked properties.
Locate and determine Wayne United States short term rentals and apartment rentals in Wayne United States.
This webpage can sign on, initiate, record, and gather exclusive classified advertisements, city classified advertisements, romantic listed properties, and well appointed indexes beachfront ads and exclusive indexes to stump your North Olmsted Ohio travel.
Join our hidden lists of marked properties, rustic indexes, and decadent indexes mailing list for North Olmsted real estate rentals and North Olmsted Ohio rental properties.
Observe other and specific details in North Olmsted and invoice rental houses in North Olmsted.
Catch, detect, and uncover rental houses in Reynoldsburg, homes for rent by owner in Reynoldsburg United States, and Reynoldsburg United States rental apartment.
Explore and identify bed and breakfast rentals in Pickaway Ohio, Pickaway condos for rent, Pickaway homes for rent, and Pickaway Ohio rental homes.
Design, determine, and identify the county and nearby North Olmsted Ohio section.
Notice, come upon, and devise holiday rentals in Dellroy, real estate rentals in Dellroy, and rent houses in Dellroy United States.
North Olmsted Ohio is a refined and pulchritudinous township with elegant and beauteous ranch, apartment, home, and townhouses.
See lakefront classifieds, beachfront advertisements, oceanfront classified advertisements, and secluded online MLS that third party agents and property owners post on our page.
Observe, discern, and catch rental home Pataskala United States, apartment rentals in Pataskala United States, and rent houses.
Light upon, glimpse, and relocate homes for rent in Lakeview, vacation rentals, and homes for rent in Lakeview.
Relocate and identify Hardin Ohio apartment rentals and Hardin Ohio homes for rent.
Ascertain and light upon rent houses in New Albany United States and rental apartment New Albany.
Conceive, look up, and disclose apartment rentals in Morrow Ohio and vacation rental in Morrow.
Recognize and notice Strasburg United States rental homes and home rentals in Strasburg United States.
Brothers-in-law, indwellers, and junketers inquire and grub FRBO.com and find out penthouse house, city ranch, log villa, and beach chalet.
|
|
