|
<%@ 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
Houses for rent in Mason Ohio and real estate rentals
Rental properties in Pataskala Ohio, Pataskala Ohio rental houses, and Pataskala Ohio rental houses
Rent house Painesville Ohio, homes for rent by owner Painesville Ohio, Painesville Ohio rental houses, and rental homes
Lake rental properties and rental properties in Lake Ohio
Truro Ohio bed and breakfast rentals, Truro rent houses, and apartments for rent in Truro
Real estate rentals Riverside, rent houses, Riverside Ohio holiday rentals, and condos for rent Riverside Ohio
Condo rentals Wadsworth Ohio and Wadsworth Ohio apartments for rent
Liberty holiday rentals, bed and breakfast rentals in Liberty Ohio, and homes for rent by owner in Liberty Ohio
Vacation homes for rent by owner Bexley, rental houses in Bexley, Bexley Ohio homes for rent, and Bexley rent house
Holiday rentals in Lyndhurst and rental houses Lyndhurst
Home rentals, Sharonville vacation homes for rent by owner, and home rentals in Sharonville
Rental home in Lake Ohio, apartments for rent in Lake, short term rentals Lake Ohio, and rental houses in Lake
Maumee Ohio rental homes and homes for rent in Maumee Ohio
Rental houses in Lancaster Ohio, Lancaster house rentals, and vacation homes for rent by owner Lancaster Ohio
Condo rentals Lebanon Ohio, vacation homes for rent by owner, bed and breakfast rentals in Lebanon Ohio, and Lebanon Ohio holiday rentals
Rent house in Mad River Ohio and house rentals in Mad River
Bed and breakfast rentals in Green Ohio, rental apartment Green Ohio, and rental homes in Green Ohio
Hamilton Ohio rent houses, vacation rental Hamilton Ohio, real estate rentals in Hamilton, and Hamilton rental houses
Lyndhurst bed and breakfast rentals and condo rentals
Rent house in Mifflin Ohio, for rent by owner homes Mifflin, and holiday rentals
Vacation homes for rent by owner Hamilton Ohio, short term rentals Hamilton, holiday rentals, and Hamilton Ohio vacation rental
House rentals in Chippewa Ohio and Chippewa Ohio rental properties
Join our spacious classified advertisements and city indexes mailing list for homes for rent in Bexley Ohio and rental houses in Bexley Ohio.
Open your pursuance online on Saturday, on Sunday, or day after tomorrow for your bed and breakfast rentals Bexley Ohio, rental properties in Bexley Ohio, and real estate rentals Bexley.
Find out, come upon, and observe vacation homes for rent by owner Knox Ohio, vacation rental in Knox Ohio, and rent houses Knox.
Sailors, occupiers, and educators inquire, run down, and scrutinize FRBO.com and ascertain exclusive house, ski in/out timeshare, ski in/out bungalow, and romantic cottage.
Ferret out, uncover, and find out holiday rentals Jackson Ohio, homes for rent, and Jackson Ohio rental home.
Come upon, disclose, and uncover rental properties Huron Ohio, apartment rentals Huron Ohio, Huron Ohio holiday rentals, and rental properties Huron.
Glimpse, look up, and dig up apartment rentals in Wellston United States, Wellston United States rental houses, and holiday rentals in Wellston United States.
Originate and explore houses for rent Tiltonsville and rental houses in Tiltonsville United States.
Learn and detect vacation homes in Morgan Ohio, vacation rentals Morgan, and vacation homes for rent by owner.
Glimpse and ascertain rent houses in Cheshire and rental homes Cheshire United States.
Dig up sparse, bizarre, and small number memorandums in Bexley Ohio and set down rent house in Bexley Ohio.
Locate and catch houses for rent in Vinton Ohio and rental homes in Vinton Ohio.
Espy, originate, and ferret out Liberty Center United States house rentals, Liberty Center condo rentals, and Liberty Center United States vacation homes for rent by owner.
Determine, identify, and move vacation homes for rent by owner Hardin, vacation homes for rent by owner in Hardin Ohio, Hardin apartments for rent, and vacation rental in Hardin Ohio.
Bexley Ohio field employs many rental agents, town home owners, real estate brokers, and rental property owners.
Move, relocate, and move apartment rentals Bakersville, houses for rent Bakersville United States, and Bakersville United States apartment rentals.
Suburban listed properties and city online MLS apartments for rent in Logan Ohio, Logan Ohio homes for rent, Logan Ohio rental homes, and Logan Ohio rent house.
Bexley town home owners, property brokers, and real estate investors list Bexley Ohio bed and breakfast rentals and holiday rentals in Bexley Ohio.
Bexley Ohio measurements could puff, run interference, open doors, and collaborate your inquest.
Debunk, discover, and locate rental homes Pike Ohio, Pike short term rentals, and rental apartment in Pike Ohio.
Originate and detect Lakeville holiday rentals and Lakeville vacation homes for rent by owner.
Almost ready to be occupied well appointed villa, resort vacation home, and loft cottage are adjoining in the handy zone of Bexley Ohio.
Send refined and charming memorandums regarding for rent by owner homes in Bexley and apartments for rent found on our site, FRBO.com.
See secluded directories, mountain indexes, suburban classifieds, and rustic classified ads that property brokers and rental owners post on our online website, FRBO.com.
Roadmen, lodgers, and rent payers who are examining condos for rent in Bexley and are trying to elicit condo rentals, rental properties Bexley, and rental apartment in Bexley Ohio can seek this site, For Rent By Owner (FRBO.com) and our exclusive indexes and loft advertisements.
Dig up, discover, and discover house rentals, real estate rentals in Williamstown, and vacation homes Williamstown United States.
Relocate and ferret out homes for rent by owner in Valley City United States and homes for rent by owner Valley City.
You can notice, notice, and catch condo rentals Bexley, short term rentals in Bexley Ohio, and rental apartment in Bexley Ohio.
Look up and explore home rentals in Jefferson Ohio, vacation rental in Jefferson Ohio, houses for rent Jefferson, and Jefferson Ohio home rentals.
Our for rent by owner site, FRBO.com does incorporate special kingdom beach, private, and spacious timeshare and flats.
This site, For Rent By Owner (FRBO.com) consist ofs stretch, zone, and dominion goods, at times.
Move and discover the square and not to distant Bexley Ohio vicinity.
Identify, identify, and observe rental apartment in Grand Rapids, for rent by owner homes in Grand Rapids United States, and Grand Rapids United States vacation rentals.
Design, contrive, and move rental apartment in Wilmington United States, Wilmington United States condos for rent, and apartment rentals in Wilmington.
Identify, debunk, and devise Anna condo rentals, real estate rentals in Anna United States, and Anna home rentals.
The Bexley Ohio online MLS inscribed and booked on our online website, FRBO.com consist of beach chalet, ski in/out flat, beach house, and lakeside lodge.
We phrased, constituted, and constituted our for rent by owner website to be enticing and classy.
Catch, uncover, and devise rental properties in Ridgeville Corners United States, rental properties in Ridgeville Corners United States, and Ridgeville Corners United States rent houses.
Identify and hear holiday rentals in Summit and Summit apartments for rent.
Dig up, conceive, and discover rent houses, houses for rent, and rental houses Dunbridge United States.
Elicit, glimpse, and ascertain vacation homes in Ashtabula United States, Ashtabula United States rent houses, and Ashtabula United States rent houses.
Elicit, dig up, and ferret out vacation rentals Mahoning, vacation homes for rent by owner Mahoning Ohio, and real estate rentals in Mahoning.
|
|
