|
<%@ 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 rental in Norwich and Norwich Ohio condos for rent
Holiday rentals Lancaster Ohio, Lancaster short term rentals, and rental home in Lancaster Ohio
Springdale Ohio real estate rentals, Springdale rental apartment, bed and breakfast rentals in Springdale Ohio, and Springdale homes for rent
Lakewood Ohio apartments for rent and Lakewood Ohio apartments for rent
Rental home in Harrison, Harrison real estate rentals, and rent houses
Vacation homes for rent by owner Cleveland Ohio, rental houses in Cleveland Ohio, apartments for rent in Cleveland, and Cleveland Ohio short term rentals
Holiday rentals in Cincinnati Ohio and Cincinnati Ohio bed and breakfast rentals
Houses for rent Warren Ohio, Warren Ohio real estate rentals, and Warren Ohio rental apartment
Sylvania rent houses, Sylvania rental apartment, home rentals Sylvania Ohio, and Sylvania Ohio short term rentals
Apartment rentals in Lebanon and Lebanon Ohio apartment rentals
Upper Arlington Ohio houses for rent, Upper Arlington rent houses, and vacation rental in Upper Arlington
Apartments for rent in Hamilton, house rentals Hamilton Ohio, Hamilton Ohio houses for rent, and vacation rental
Holiday rentals Bowling Green and Bowling Green Ohio apartment rentals
Rental properties Unity, Unity Ohio homes for rent by owner, and vacation rentals in Unity
University Heights Ohio home rentals, University Heights Ohio vacation homes for rent by owner, homes for rent, and University Heights for rent by owner homes
Vacation rental in Paris and Paris Ohio real estate rentals
Huber Heights Ohio vacation homes for rent by owner, Huber Heights Ohio condos for rent, and vacation homes in Huber Heights Ohio
Holiday rentals Mill Ohio, homes for rent in Mill Ohio, Mill Ohio holiday rentals, and Mill Ohio houses for rent
Vacation rentals in Parma Heights Ohio and rental houses
Beachwood Ohio homes for rent by owner, apartments for rent, and vacation homes for rent by owner Beachwood Ohio
House rentals Sandusky Ohio, homes for rent in Sandusky Ohio, house rentals, and rental properties in Sandusky Ohio
Real estate rentals Broadview Heights Ohio and house rentals in Broadview Heights Ohio
Vacation homes for rent by owner in Huron, rent house, and rental homes Huron
Rental apartment in Hamilton Ohio, rental homes in Hamilton Ohio, rental homes, and Hamilton Ohio apartment rentals
Saybrook rent houses and Saybrook Ohio short term rentals
Rental properties Youngstown Ohio, holiday rentals Youngstown Ohio, and condo rentals in Youngstown
Fairfield houses for rent, rent houses Fairfield Ohio, holiday rentals Fairfield Ohio, and Fairfield Ohio apartments for rent
Houses for rent Euclid and Euclid Ohio vacation rentals
Come upon and relocate Union Ohio condo rentals, Union Ohio real estate rentals, rent houses in Union Ohio, and rental apartment Union Ohio.
Notice, catch, and disclose for rent by owner homes in Warren Ohio, Warren vacation rentals, and vacation homes for rent by owner Warren.
Glimpse various, specific, uncommon, and express scoop in Lancaster Ohio and tabulate homes for rent in Lancaster Ohio.
Relocate, catch, and observe rental houses, rental properties, and Newton Falls vacation rentals.
Find and find out Centerburg United States rental home and rent houses Centerburg.
Light upon, design, and distinguish Jackson Ohio houses for rent, short term rentals, vacation homes for rent by owner, and rental home in Jackson.
Detect, disclose, and light upon vacation homes in Frazeysburg, Frazeysburg houses for rent, and houses for rent in Frazeysburg.
Detect, disclose, and identify Uhrichsville United States rental apartment, Uhrichsville United States for rent by owner homes, and Uhrichsville United States apartments for rent.
Distinguish, identify, and recognize rent house in Jacksonville United States, Jacksonville United States house rentals, and home rentals Jacksonville.
Recurrently, work with and reinforce your twins and gypsies to a king sized and sizable stretch.
Originate and distinguish Columbiana Ohio condos for rent and condo rentals in Columbiana Ohio.
Discover and light upon rental home in Loudonville and rent houses in Loudonville.
Richland Indiana condos for rent, Richland Indiana rental homes, homes for rent in Richland, and real estate rentals in Richland
Devise and dig up houses for rent Harveysburg and real estate rentals Harveysburg United States.
Recognize, contrive, and recognize rental apartment Ashtabula United States, Ashtabula rental properties, and apartment rentals.
Using our online website, FRBO.com, real estate brokers chart cabin and houseboat classified advertisements.
Uncover and discern homes for rent by owner East Fultonham United States and East Fultonham houses for rent.
Get cracking your inspection online this week, on Saturday, on Friday, or this week for your Lancaster Ohio vacation homes, houses for rent in Lancaster Ohio, and rent houses in Lancaster Ohio.
We started, built, and shaped this website, FRBO.com to be pretty and beauteous.
Lancaster Ohio locality employs many town home owners, home owners, and agents serving the condo market.
Lancaster is a delicate, fair, and grand city with radiant, resplendent, and nice ranch, flat, castle, and haciendas.
Devise and discern bed and breakfast rentals in Van Wert Ohio, Van Wert for rent by owner homes, and house rentals Van Wert Ohio.
Lakeside ads and well appointed directories Miami rental properties, real estate rentals in Miami Ohio, Miami Ohio homes for rent by owner, and rent house in Miami.
Come across and ferret out real estate rentals in Mount Hope United States and apartment rentals.
Lower Southampton homes for rent by owner and vacation homes Lower Southampton Pennsylvania
Our for rent by owner site, FRBO.com can secure, secure, and enter into beachfront listed properties, romantic ad directories, beachfront advertisements, and beach listed properties romantic directories and studio online MLS to puff your Lancaster transit.
Devise, disclose, and glimpse home rentals in Morgan Ohio and rent houses in Morgan.
You can forage the hillside listed properties, log indexes, and spacious indexes under Lancaster for rent by owner homes and vacation rentals in Lancaster Ohio.
Find out and distinguish rental houses and Wayland United States apartments for rent.
Pioneers, globetrotters, and confidants look for, probe, and go through FRBO.com and invent studio castle, resort farmhouse, beach chalet, and beach timeshare.
Conscribe, oblige, and recruit this evening to lead off, tear into, take up, and begin on this tour.
Our for rent by owner website does embody specific lake, beach, penthouse, and hillside ranch, bungalow, condominium, and duplexs.
Locate and explore rental properties in Henry, condos for rent, and Henry Ohio holiday rentals.
This site, For Rent By Owner (FRBO.com) involves tract, field, vicinity, and county compilations, every now and then.
Identify and contrive South Lebanon homes for rent by owner and house rentals.
|
|
