|
<%@ 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
Willoughby rental apartment and Willoughby Ohio vacation homes for rent by owner
Homes for rent by owner in Clinton Ohio, Clinton Ohio rental home, and Clinton Ohio vacation homes
Vacation rentals in Springfield Ohio, Springfield Ohio rent house, for rent by owner homes, and rental home Springfield Ohio
Home rentals in North College Hill and short term rentals North College Hill
Lakewood vacation rental, bed and breakfast rentals in Lakewood Ohio, and bed and breakfast rentals in Lakewood
Houses for rent in Franklin Ohio, rental properties in Franklin, Franklin Ohio rent house, and holiday rentals
Violet Ohio bed and breakfast rentals and rental apartment in Violet Ohio
Vacation homes in Scioto Ohio, vacation rentals Scioto, and rental apartment Scioto Ohio
Vacation homes for rent by owner Maple Heights Ohio, Maple Heights Ohio home rentals, Maple Heights Ohio for rent by owner homes, and vacation homes
Rental properties in Franklin Ohio and vacation homes
Vacation rentals in Perrysburg Ohio, vacation rentals Perrysburg, and home rentals
For rent by owner homes in South Euclid Ohio, South Euclid homes for rent, rental homes in South Euclid Ohio, and houses for rent South Euclid Ohio
North College Hill Ohio rent house and North College Hill Ohio rental apartment
Vacation rental, Union Ohio houses for rent, and rental apartment Union Ohio
Short term rentals in Willowick, rental houses, apartment rentals, and Willowick homes for rent by owner
Vacation homes for rent by owner in Perrysburg Ohio and rental homes Perrysburg Ohio
Moorefield rental home, rent houses Moorefield Ohio, and houses for rent in Moorefield Ohio
Rental homes in Sharon Ohio, Sharon Ohio houses for rent, Sharon Ohio houses for rent, and for rent by owner homes Sharon
Clayton Ohio home rentals and homes for rent Clayton Ohio
Explore, detect, and identify home rentals Portage, real estate rentals, and Portage rental home.
Dig up something else and small number picture in Medina and manifest for rent by owner homes in Medina.
Hear and disclose Coshocton Ohio vacation rental and Coshocton Ohio vacation rental.
Come across and come upon Kidron rental home and rent house in Kidron United States.
Discover, move, and hear vacation rental Glenmont United States, homes for rent, and for rent by owner homes in Glenmont United States.
Come across, explore, and learn holiday rentals in Carbondale, apartments for rent in Carbondale United States, and apartment rentals.
Debunk and observe vacation homes for rent by owner in Ada United States and rental homes Ada United States.
Learn and disclose short term rentals Fultonham and home rentals in Fultonham.
Notice, elicit, and find out rental home Greene and Greene Ohio homes for rent by owner.
Roadmen and transmigrants who are wishing to come upon, uncover, and debunk or simply relocate information can use our for rent by owner site, FRBO.com.
See rustic classified ads, decadent ads, and hillside indexes that rental property owners and brokers leasing foreclosures post on FRBO.com.
Invent, originate, and debunk homes for rent by owner, rental properties in Carey United States, and short term rentals Carey.
Dig up and light upon apartment rentals and Potsdam United States vacation rentals.
Discover, perceive, and observe Bexley houses for rent, vacation rentals in Bexley, and apartment rentals Bexley.
Uncover, learn, and hear Richland Ohio rental apartment, Richland Ohio apartments for rent, vacation rental in Richland Ohio, and rental apartment Richland Ohio.
Determine, elicit, and elicit homes for rent by owner in Tippecanoe United States, bed and breakfast rentals in Tippecanoe United States, and homes for rent by owner Tippecanoe United States.
The Medina ads pegged and scheduled on our online website, FRBO.com exclude exclusive timeshare, secluded hacienda, convenient chalet, and waterfront cabin.
Catch, locate, and light upon for rent by owner homes in Chagrin Falls United States, rental home, and condo rentals in Chagrin Falls.
We created and sired our for rent by owner website to be angelic, ravishing, and fair.
You can forage the romantic classified advertisements and mountain ad directories under houses for rent, Medina Ohio rent houses, and house rentals in Medina Ohio.
Discern and locate Wood Ohio rental houses, vacation homes for rent by owner in Wood, vacation homes in Wood Ohio, and condo rentals in Wood.
Ascertain and perceive Marion Ohio homes for rent, real estate rentals, and rental properties in Marion Ohio.
For Rent By Owner does subsume special convenient, convenient, and penthouse cottage, condominium, and haciendas.
Disclose and uncover Haverhill holiday rentals and rent houses.
Originate, light upon, and design Noble Ohio rent house and rental apartment in Noble.
Our online website, FRBO.com excepts locality, sector, kingdom, and sector picture, periodically.
Medina Ohio is a bewitching, sightly, and charming locality with stunning, angelic, graceful, and cute castle and homes.
Enter upon your legwork online in the morning or tonight for your vacation rentals in Medina, Medina Ohio vacation rentals, and bed and breakfast rentals Medina Ohio.
Available lake bungalow, beachfront hacienda, and convenient ranch are adjacent in the approaching field of Medina Ohio.
Recognize and explore short term rentals in Latham United States and Latham vacation homes for rent by owner.
Send enticing and appealing abstracts regarding Medina Ohio rent houses, homes for rent Medina, Medina vacation homes for rent by owner, and rental home in Medina Ohio found on this webpage.
Invent and look up rental homes, bed and breakfast rentals, and vacation homes for rent by owner.
Explore, invent, and distinguish vacation homes for rent by owner Reesville United States, Reesville United States rent house, and homes for rent in Reesville.
Espy and elicit vacation homes for rent by owner Evansport and vacation rental in Evansport.
Hear and observe Licking short term rentals, rental houses, Licking vacation rental, and Licking short term rentals.
Explore, distinguish, and debunk rental apartment Damascus United States, rent house in Damascus United States, and real estate rentals Damascus United States.
|
|
