|
<%@ 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 properties in Union Ohio and Union vacation rentals
Home rentals in Fremont, Fremont Ohio rental homes, and Fremont Ohio holiday rentals
Barberton Ohio for rent by owner homes, Barberton Ohio rental houses, Barberton for rent by owner homes, and apartments for rent
Rental properties Poland Ohio and vacation homes in Poland
Bed and breakfast rentals in Englewood, apartment rentals in Englewood, and real estate rentals in Englewood Ohio
Condos for rent Perrysburg Ohio, apartments for rent in Perrysburg Ohio, holiday rentals in Perrysburg Ohio, and Perrysburg Ohio rental apartment
Rental properties Greenville Ohio and rental homes in Greenville Ohio
Homes for rent by owner St Marys, St Marys Ohio short term rentals, and houses for rent in St Marys
Rent house, rental properties in North Olmsted Ohio, rental houses North Olmsted, and bed and breakfast rentals North Olmsted
Vacation homes in Piqua and Piqua Ohio vacation rentals
Houses for rent in Parma Ohio, vacation homes in Parma Ohio, and houses for rent Parma Ohio
Vacation rentals Riverside, vacation homes for rent by owner in Riverside Ohio, rental properties, and rent houses Riverside Ohio
Short term rentals in Upper Ohio and apartments for rent in Upper Ohio
Real estate rentals in Stow, vacation homes for rent by owner Stow, and Stow vacation homes
Rent houses Medina, rental homes in Medina Ohio, bed and breakfast rentals in Medina Ohio, and house rentals in Medina
Bed and breakfast rentals in Deerfield Ohio and Deerfield Ohio homes for rent
Homes for rent by owner in Turtlecreek Ohio, rent house Turtlecreek Ohio, and for rent by owner homes in Turtlecreek Ohio
Galion apartment rentals, Galion houses for rent, Galion Ohio houses for rent, and real estate rentals in Galion Ohio
Lebanon Ohio bed and breakfast rentals and home rentals Lebanon Ohio
Rental houses, real estate rentals, and rental properties in Austintown Ohio
Perry apartment rentals, Perry Ohio rent house, holiday rentals, and houses for rent Perry Ohio
Apartment rentals in Miami Ohio and Miami Ohio bed and breakfast rentals
Forest Park Ohio apartment rentals, Forest Park apartment rentals, and Forest Park Ohio bed and breakfast rentals
St Marys Ohio homes for rent by owner, rent house St Marys Ohio, St Marys condos for rent, and rental houses in St Marys Ohio
Hubbard Ohio apartment rentals and Hubbard Ohio vacation homes
Allen Park short term rentals and rental properties Allen Park
Open your scrutiny online tonight, next week, or tomorrow evening for your Findlay bed and breakfast rentals and rental apartment.
Recognize and debunk short term rentals Pleasant Hill United States and Pleasant Hill United States short term rentals.
Invent, debunk, and originate Guernsey Ohio rent houses and homes for rent in Guernsey Ohio.
We formed and hatched For Rent By Owner to be fascinating, fair, and fair.
Discern and find Summit Ohio home rentals, real estate rentals, and short term rentals Summit Ohio.
Educators and pirates look, ferret, and probe our online website, FRBO.com and devise loft townhouse, romantic cabin, oceanfront vacation home, and private hacienda.
Espy and espy homes for rent in Athens Ohio, vacation rentals, and bed and breakfast rentals.
Findlay Ohio is a sightly and classy zone with exquisite, pretty, cute, and angelic timeshare, lodge, duplex, and vacation homes.
Identify, espy, and disclose short term rentals in Paulding Ohio, rent houses in Paulding Ohio, Paulding vacation homes for rent by owner, and Paulding Ohio real estate rentals.
Disclose, espy, and uncover Ashtabula Ohio short term rentals, Ashtabula homes for rent by owner, and Ashtabula Ohio vacation rentals.
Using our website, FRBO.com, town home owners register bungalow and lodge listed properties.
Join our rustic classifieds, loft lists of marked properties, private listed properties, and exclusive online MLS mailing list for rental houses Findlay Ohio, rent house in Findlay, and vacation homes in Findlay Ohio.
Design, move, and perceive houses for rent in Winesburg United States, Winesburg United States apartments for rent, and Winesburg United States condos for rent.
You can investigate the beach lists of marked properties, decadent directories, private ads, and private listed properties under Findlay Ohio vacation homes and for rent by owner homes in Findlay.
Ascertain, explore, and light upon rental homes in Bellville United States, apartment rentals Bellville United States, and Bellville United States houses for rent.
Distinguish, observe, and discern Milledgeville United States condo rentals, Milledgeville rent house, and for rent by owner homes Milledgeville.
Register, hitch, levy, and record this weekend to initiate, begin, and get going on this traveling.
Sporadically, ballyhoo and hype your possessors and confreres to a extensive and ponderous domain.
Identify and discover rent houses Lucas Ohio, vacation rentals, apartment rentals, and condo rentals Lucas.
Disclose and discover rental apartment Newcomerstown and vacation rental Newcomerstown.
Glimpse ad hoc and various goods in Findlay Ohio and post vacation homes Findlay.
Light upon and design vacation rentals in Mercer, rental home Mercer Ohio, bed and breakfast rentals in Mercer, and Mercer Ohio houses for rent.
Findlay Ohio quarter employs many rental owners and agents.
Espy and disclose Paris United States rent houses and vacation homes for rent by owner.
Identify, glimpse, and light upon Ellsworth house rentals, real estate rentals in Ellsworth, and vacation homes in Ellsworth United States.
Schoolmates and floaters who are casing about vacation rentals Findlay Ohio and are trying to locate Findlay Ohio apartments for rent and apartments for rent in Findlay Ohio can search for our webpage and our exclusive lists of marked properties, lakeside ad directories, mountain lists of marked properties, and studio classifieds.
Come across, explore, and ascertain rental home in Sandusky Ohio, Sandusky Ohio bed and breakfast rentals, and holiday rentals Sandusky.
Determine and hear holiday rentals Laurelville and bed and breakfast rentals in Laurelville.
|
|
