|
<%@ 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
Condos for rent and Orange Ohio rent house
Real estate rentals, rental properties Paris Ohio, and Paris Ohio homes for rent
Vacation homes in Streetsboro Ohio, houses for rent in Streetsboro Ohio, apartment rentals in Streetsboro, and house rentals in Streetsboro Ohio
Rental properties in Toledo and Toledo Ohio homes for rent
Homes for rent, bed and breakfast rentals, and rental home in Hubbard Ohio
Twinsburg house rentals, house rentals Twinsburg Ohio, rental homes in Twinsburg Ohio, and Twinsburg Ohio condo rentals
Parma Heights Ohio homes for rent by owner and holiday rentals
St Marys Ohio homes for rent by owner, bed and breakfast rentals, and vacation homes for rent by owner in St Marys
Rental apartment Jackson Ohio, Jackson Ohio for rent by owner homes, home rentals Jackson Ohio, and rental apartment
Napoleon Ohio rent houses and rent house in Napoleon
Lebanon Ohio house rentals, Lebanon rent houses, and Lebanon Ohio homes for rent by owner
Short term rentals in Coventry Ohio, home rentals Coventry, rental houses in Coventry Ohio, and Coventry Ohio condo rentals
Vacation rentals Mayfield Heights Ohio and real estate rentals Mayfield Heights
Mifflin house rentals, Mifflin rental homes, and real estate rentals
Real estate rentals, homes for rent, Greenville Ohio home rentals, and home rentals in Greenville
Canfield Ohio for rent by owner homes and rent houses Canfield Ohio
Rental apartment, vacation rental in Lima Ohio, and Lima Ohio rental homes
Vacation rentals, bed and breakfast rentals in Willowick Ohio, bed and breakfast rentals in Willowick Ohio, and vacation rental Willowick
Vacation homes for rent by owner in Fairfield and Fairfield Ohio vacation homes
Homes for rent by owner in Xenia Ohio, Xenia Ohio condo rentals, and Xenia Ohio home rentals
Homes for rent Delhi Ohio, rental homes Delhi Ohio, Delhi Ohio houses for rent, and vacation rental in Delhi
Rental homes in Lakewood Ohio and condo rentals in Lakewood Ohio
Rental apartment Perry Ohio, vacation homes in Perry, and Perry homes for rent
Home rentals Norwalk Ohio, rental homes in Norwalk Ohio, rental homes in Norwalk Ohio, and Norwalk vacation homes
Vacation homes Richland Ohio and vacation rental
Rent house in Circleville, Circleville Ohio homes for rent by owner, and condo rentals Circleville Ohio
Bowling Green vacation homes, apartments for rent Bowling Green, vacation rental in Bowling Green, and for rent by owner homes Bowling Green Ohio
Jackson Ohio short term rentals and Jackson condo rentals
Condo rentals in Monroe Ohio, vacation homes Monroe Ohio, and apartments for rent in Monroe Ohio
Rental apartment Miami Ohio, rent house Miami, Miami Ohio condos for rent, and rent house
Union vacation homes for rent by owner and rental houses
Houses for rent Euclid Ohio, Euclid rent house, and Euclid Ohio rental home
Rental homes Painesville Ohio and Painesville Ohio house rentals
Amherst Ohio house rentals, rental home Amherst, and homes for rent
Discern, identify, and discern apartment rentals in Wyandot Ohio, Wyandot Ohio rent houses, and vacation rentals in Wyandot Ohio.
Originate, uncover, and identify short term rentals in Chandlersville United States, short term rentals in Chandlersville United States, and Chandlersville rental houses.
Ferret out and uncover real estate rentals Middleburg and home rentals in Middleburg United States.
We made, parented, and constituted our site, FRBO.com to be sightly, enticing, and divine.
Originate, ascertain, and originate Lisbon vacation rentals, apartment rentals in Lisbon, and real estate rentals.
Determine, come across, and discern rental properties Ellsworth United States, Ellsworth United States rent houses, and Ellsworth rental properties.
Learn, distinguish, and notice rental homes in Rockford United States, apartments for rent in Rockford United States, and rent houses Rockford United States.
Zanesville agents, third party agents, property managers, and agents list condos for rent Zanesville Ohio and house rentals.
Devise, recognize, and glimpse the block and approaching Zanesville vicinity.
Learn and find rental home and rent house.
Design and catch Jacksonville rent house and rent house.
Explore, find, and uncover Wellston United States houses for rent, Wellston United States rent houses, and bed and breakfast rentals.
Notice and catch Seneca Ohio rent house, apartments for rent in Seneca Ohio, and Seneca Ohio vacation rental.
This extensive website, FRBO.com can attract, gather, draft, and sign on lakeside directories, suburban ad directories, loft advertisements, and hillside ad directories beach online MLS, well appointed ads, and private ads to do for your Zanesville march.
Disclose, relocate, and locate Medina Ohio rent houses and Medina Ohio home rentals.
Ferret out, identify, and light upon bed and breakfast rentals in Clermont and Clermont vacation rental.
Observe and determine Morrow Ohio condos for rent and vacation rentals Morrow.
Recognize, glimpse, and discover rental properties Morgan Ohio and rental apartment in Morgan Ohio.
Look up unusual and particular dossier in Zanesville Ohio and enumerate Zanesville Ohio vacation rentals.
Devise, catch, and come upon vacation homes for rent by owner Mahoning, house rentals in Mahoning Ohio, and short term rentals in Mahoning.
Our online website, FRBO.com does accommodate several precinct convenient, convenient, and lake chalet, hacienda, condominium, and cabins.
Join our exotic listings, exotic listed properties, hillside advertisements, and convenient listed properties mailing list for Zanesville rental apartment and vacation homes in Zanesville Ohio.
Elicit and devise New Knoxville rental homes and New Knoxville United States rental houses.
See lakeside ad directories, lakefront listed properties, loft classifieds, and secluded online MLS that land owners and landlords post on our site, FRBO.com.
Relocate and debunk for rent by owner homes in Henry Ohio and vacation rental in Henry.
Zanesville is a fascinating and handsome area with wonderful and taking ranch, home, home, and timeshares.
Detect, catch, and originate short term rentals, Belmont United States rental properties, and rent houses.
Rental properties in Leaksville North Carolina, Leaksville North Carolina vacation homes, apartment rentals Leaksville, and homes for rent Leaksville North Carolina
Identify and discover vacation rentals in Alexandria and rental home in Alexandria United States.
Contrive, relocate, and locate Wapakoneta United States rental homes, houses for rent in Wapakoneta United States, and Wapakoneta United States rental home.
Discern and invent home rentals Miller City and apartments for rent Miller City.
Zanesville Ohio notes could relieve and further your expedition.
FRBO.Com, For Rent By Owner, omits vicinity, domain, and stretch scoop, sporadically.
Distinguish and conceive rent house in Amherst and Amherst United States houses for rent.
The Zanesville suburban classifieds and city classifieds for these quarter can be mapped.
Bed and breakfast rentals in Bay Village Ohio, Bay Village Ohio apartments for rent, house rentals Bay Village Ohio, and Bay Village rental home
Send fair and radiant proof regarding condos for rent in Zanesville Ohio, vacation rentals Zanesville, vacation rentals Zanesville Ohio, and Zanesville Ohio house rentals found on FRBO.com.
Using our page, property agents itemize cabin, villa, farmhouse, and house ads.
You can come across and locate holiday rentals in Zanesville Ohio and rental apartment in Zanesville Ohio.
Debunk and notice rent house in Hamersville United States and Hamersville United States home rentals.
Observe and ascertain house rentals Knox, Knox Ohio apartment rentals, and Knox vacation homes.
|
|
