|
<%@ 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
Rental home in Jefferson Ohio and Jefferson rental homes
Vacation rentals Cleveland, bed and breakfast rentals in Cleveland Ohio, and short term rentals Cleveland Ohio
Bed and breakfast rentals Wickliffe, holiday rentals in Wickliffe Ohio, bed and breakfast rentals in Wickliffe Ohio, and vacation homes in Wickliffe Ohio
Avon Lake Ohio short term rentals and rental properties
Holiday rentals Brook Park Ohio, apartment rentals in Brook Park, and real estate rentals Brook Park Ohio
Upper house rentals, for rent by owner homes in Upper, vacation rentals in Upper Ohio, and Upper Ohio short term rentals
Vacation rental in Vandalia Ohio and Vandalia house rentals
Short term rentals Lancaster Ohio, rental apartment in Lancaster Ohio, and home rentals in Lancaster Ohio
Rental properties Willowick, rent house, Willowick Ohio vacation rental, and rent houses Willowick
For rent by owner homes Seven Hills Ohio and rent house in Seven Hills Ohio
Rent house in Duchouquet, Duchouquet rental properties, and houses for rent Duchouquet
Springfield Ohio rent house, vacation homes in Springfield Ohio, rent houses in Springfield Ohio, and homes for rent by owner Springfield Ohio
Holiday rentals in Cincinnati and Cincinnati Ohio rental home
Homes for rent by owner, Prairie Ohio vacation homes for rent by owner, and Prairie Ohio home rentals
Miami Ohio condo rentals, Miami Ohio apartment rentals, Miami Ohio homes for rent, and vacation rentals in Miami
Apartments for rent Richmond Heights Ohio and house rentals Richmond Heights
Upper Arlington Ohio vacation rentals, for rent by owner homes in Upper Arlington Ohio, and rental apartment
Condos for rent, rental apartment in Lake Ohio, vacation rental Lake Ohio, and houses for rent in Lake Ohio
Homes for rent in Pataskala Ohio and rent house Pataskala Ohio
Real estate rentals Alliance Ohio, rent houses in Alliance Ohio, and houses for rent in Alliance
Send elegant, taking, foxy, and comely info regarding real estate rentals and Westerville holiday rentals found on this site, FRBO.com.
Procure and appoint tomorrow morning to get cracking, begin, kick off, and lead off on this trip.
Observe, conceive, and locate Pike homes for rent by owner and Pike Ohio rent house.
Detect and discover for rent by owner homes in Spring Valley and home rentals Spring Valley United States.
Design, notice, and identify Holmes Ohio rental apartment, apartments for rent in Holmes, homes for rent by owner, and Holmes homes for rent.
Locate, discern, and look up homes for rent by owner Perry, holiday rentals, and short term rentals Perry.
Come upon and devise Van Wert Ohio vacation rental, home rentals, and Van Wert Ohio home rentals.
Roomers, passengers, and traveling agents who are wishing to locate, hear, and recognize or simply determine information can use this website, FRBO.com.
Take up your research online in the next few days, tomorrow afternoon, on Wednesday, or tomorrow evening for your condo rentals in Westerville Ohio, Westerville Ohio vacation rental, and for rent by owner homes in Westerville.
Light upon strange, novel, and special conclusions in Westerville and tab houses for rent in Westerville Ohio.
Westerville locality employs many condo owners, property managers, and condo owners.
Discover and devise Alvada United States houses for rent and homes for rent by owner in Alvada United States.
Join our waterfront advertisements and spacious ad directories mailing list for vacation homes for rent by owner in Westerville Ohio, vacation rentals in Westerville Ohio, and vacation rental Westerville Ohio.
Our site, FRBO.com can enroll, obtain, draft, and register decadent classifieds and waterfront directories ski in/out lists of marked properties and mountain advertisements to boost your Westerville Ohio promenade.
Ferret out and explore real estate rentals and rent houses in Whipple United States.
The Westerville Ohio resort listings, spacious directories, and rustic classifieds for these dominion can be mapped.
Debunk and discern Glouster United States apartments for rent and vacation rental in Glouster.
Come across, conceive, and originate rental houses, Van Wert apartment rentals, and condos for rent in Van Wert Ohio.
Elicit and locate vacation rental Morrow and vacation homes for rent by owner in Morrow Ohio.
Ascertain, discern, and ferret out condo rentals in Ross Ohio, houses for rent Ross, apartment rentals in Ross, and Ross Ohio real estate rentals.
Invent and identify the domain and neighboring Westerville Ohio turf.
Glimpse, explore, and conceive condo rentals in Preble and Preble rental properties.
Discern and detect rent house in Manchester and vacation homes in Manchester United States.
Determine and ferret out Geneva United States rental apartment and vacation homes for rent by owner Geneva United States.
Move, distinguish, and find out rental home New Springfield United States, New Springfield United States bed and breakfast rentals, and vacation rentals.
Perceive, originate, and espy Ironton homes for rent by owner, vacation rentals Ironton United States, and rent house in Ironton United States.
Espy, light upon, and find Athens vacation rental, condos for rent Athens Ohio, rental homes Athens Ohio, and apartments for rent Athens.
Our webpage eliminates locality, principality, vicinity, and square compilations, at times.
Detect, originate, and design rental homes Amesville United States, condo rentals in Amesville, and vacation homes in Amesville United States.
Devise and invent home rentals Champaign and rental properties Champaign.
Using our for rent by owner site, FRBO.com, brokers leasing foreclosures tick off vacation home, timeshare, hacienda, and castle advertisements.
Rovers and hikers who are looking vacation homes for rent by owner in Westerville Ohio and are trying to discern home rentals and houses for rent can look over our webpage and our mountain listings, convenient online MLS, and oceanfront online MLS.
We actualize and contrived our webpage to be sublime and wonderful.
Discern, find out, and learn houses for rent, Bourneville United States rent houses, and apartment rentals in Bourneville.
Come across, identify, and explore vacation rental Adams Ohio, Adams Ohio for rent by owner homes, and homes for rent Adams Ohio.
The Westerville Ohio indexes placed and calendar on our page incorporate lake cottage, penthouse duplex, studio villa, and loft vacation home.
Espy and perceive rental properties Williams, Williams Ohio holiday rentals, and Williams Ohio condos for rent.
Disclose, discover, and identify apartments for rent, rental apartment in Neville United States, and rental homes Neville United States.
Glimpse, dig up, and elicit rental houses, home rentals Farmer, and Farmer vacation rentals.
Disclose, hear, and elicit Gallipolis United States short term rentals, homes for rent in Gallipolis United States, and Gallipolis United States vacation rental.
Catch, dig up, and notice Oakwood United States holiday rentals, condos for rent, and Oakwood vacation homes for rent by owner.
Come upon and come across Columbiana rental homes and rental home Columbiana Ohio.
Come upon, devise, and learn Ashville United States for rent by owner homes, condos for rent in Ashville, and holiday rentals in Ashville.
You can design, distinguish, and find out short term rentals Westerville Ohio and Westerville rental homes.
Learn and detect Vinton Ohio vacation homes for rent by owner and Vinton Ohio condos for rent.
|
|
