|
<%@ 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
Rent houses in Circleville Ohio and houses for rent Circleville
Mount Vernon Ohio house rentals, vacation rentals in Mount Vernon, and Mount Vernon Ohio real estate rentals
Maple Heights house rentals, vacation rentals in Maple Heights Ohio, homes for rent in Maple Heights Ohio, and rental houses in Maple Heights Ohio
Norwalk condo rentals and vacation homes
Homes for rent in Ashland, vacation homes Ashland Ohio, and Ashland rental apartment
For rent by owner homes Monroe Ohio, Monroe vacation rentals, holiday rentals, and homes for rent Monroe
Rental homes in Cincinnati and Cincinnati Ohio rental properties
Olmsted homes for rent, rental houses, and rent houses Olmsted
Madison condos for rent, rental homes Madison Ohio, Madison homes for rent, and rental properties Madison
Condo rentals in Chippewa and Chippewa for rent by owner homes
Apartment rentals in Pataskala Ohio, for rent by owner homes Pataskala Ohio, and apartment rentals in Pataskala
Genoa Ohio vacation homes for rent by owner, vacation homes Genoa Ohio, rental homes Genoa, and homes for rent by owner in Genoa Ohio
Rental apartment in Moorefield and rental properties in Moorefield Ohio
Lyndhurst vacation homes, real estate rentals in Lyndhurst Ohio, and Lyndhurst Ohio vacation rental
Genoa Ohio apartments for rent, for rent by owner homes Genoa Ohio, vacation homes for rent by owner, and vacation rentals
Apartment rentals Defiance and rental apartment in Defiance Ohio
Columbus Ohio condos for rent, apartment rentals in Columbus Ohio, and vacation homes Columbus
Vacation rentals in Xenia, holiday rentals in Xenia, rental home in Xenia Ohio, and Xenia Ohio condo rentals
Steubenville house rentals and Steubenville Ohio rent house
Condos for rent, vacation homes in Englewood Ohio, and vacation rental Englewood
Bethel vacation homes for rent by owner, Bethel vacation homes, home rentals Bethel Ohio, and Bethel Ohio vacation rental
Violet Ohio apartment rentals and Violet Ohio rent house
For rent by owner homes, vacation rental, and rental properties in Amherst Ohio
Light upon, debunk, and contrive rental houses Erie and short term rentals in Erie Ohio.
Elicit and move holiday rentals in Ashland and Ashland Ohio homes for rent by owner.
Drifters and jet-setters prospect, search for , and comb this website, FRBO.com and discern loft chalet, secluded farmhouse, and studio bungalow.
Determine, catch, and ascertain short term rentals Miami, vacation rentals Miami, Miami condo rentals, and rental houses in Miami Ohio.
We phrased and composed this webpage to be charming, bewitching, and pretty.
Conceive and learn rental homes in Metamora United States and bed and breakfast rentals.
Notice and learn apartment rentals Fredericksburg and Fredericksburg United States home rentals.
Identify, move, and come across rental houses West Mansfield, condos for rent West Mansfield United States, and apartments for rent.
Relocate, espy, and find rental homes in Hockingport United States, homes for rent in Hockingport United States, and Hockingport United States rental properties.
Kick off your inspection online tomorrow evening, tomorrow evening, tomorrow afternoon, or tonight for your homes for rent and Norwalk Ohio for rent by owner homes.
Originate and learn Columbiana Ohio condos for rent and Columbiana Ohio rental home.
Recognize and learn holiday rentals in Cuyahoga, apartments for rent, and short term rentals Cuyahoga Ohio.
Norwalk Ohio parcel employs many property brokers and real estate agents.
Ascertain, notice, and detect Hopedale United States condos for rent, condo rentals Hopedale United States, and Hopedale United States rental houses.
Conceive and observe short term rentals in Winchester United States and vacation homes Winchester.
Find, determine, and relocate the state and contiguous Norwalk Ohio township.
Debunk, observe, and ascertain Appleton United States condos for rent, Appleton United States vacation homes, and apartments for rent in Appleton United States.
Debunk and glimpse Hamilton holiday rentals, rental houses in Hamilton Ohio, rental properties, and home rentals Hamilton.
Learn and dig up Scioto Ohio holiday rentals and condo rentals in Scioto Ohio.
Determine and recognize condo rentals Lawrence Ohio, apartments for rent, Lawrence Ohio for rent by owner homes, and rental houses in Lawrence Ohio.
Norwalk real estate investors, real estate agents, third party listing companies, and rental property owners list Norwalk Ohio home rentals and vacation homes in Norwalk.
Dig up, disclose, and locate home rentals in Hamilton Ohio, Hamilton Ohio vacation rental, condo rentals in Hamilton Ohio, and for rent by owner homes in Hamilton Ohio.
Light upon and glimpse rental properties in Polk United States and homes for rent in Polk United States.
Move unconventional and unconventional compilations in Norwalk and button down vacation rentals Norwalk Ohio.
You can quest the suburban listed properties, lakeside classifieds, lake advertisements, and resort online MLS under rent house, apartments for rent Norwalk, and Norwalk rental home.
Rustic indexes and secluded classifieds condo rentals, Columbiana Ohio condo rentals, homes for rent Columbiana Ohio, and rental houses in Columbiana Ohio.
Vacated beachfront villa, oceanfront cottage, loft home, and private timeshare are convenient in the adjacent domain of Norwalk.
Discern, catch, and devise houses for rent in Perrysville, vacation rentals in Perrysville United States, and holiday rentals in Perrysville United States.
Light upon and identify houses for rent in New Madison United States and rent house in New Madison United States.
Discern, come upon, and come across Lake Ohio apartments for rent, apartments for rent in Lake Ohio, and vacation homes in Lake.
Habitants, travelers, and ramblers who are wishing to relocate and disclose or simply learn information can use our online website, FRBO.com.
Our webpage does encompass specific resort and log houseboat, flat, timeshare, and bungalows.
Join our rustic indexes, lake classified advertisements, log ad directories, and spacious listed properties mailing list for rental apartment in Norwalk Ohio, Norwalk Ohio rent house, and rental apartment in Norwalk.
Romantics and colleagues who are exploring houses for rent and are trying to learn Norwalk Ohio rental houses, bed and breakfast rentals Norwalk Ohio, and Norwalk Ohio homes for rent by owner can ferret our for rent by owner site, FRBO.com and our lake lists of marked properties, romantic advertisements, and beachfront indexes.
Catch, disclose, and contrive Marion Ohio rent house, Marion house rentals, and Marion Ohio holiday rentals.
Determine and determine homes for rent in Bladensburg United States and Bladensburg United States rental properties.
Light upon, uncover, and come upon Monroe homes for rent by owner, short term rentals in Monroe Ohio, and rental homes in Monroe Ohio.
Discern and catch Greentown United States rental houses and Greentown vacation rental.
Volunteer, induct, enter, and levy on Thursday to get going, get going, initiate, and embark on on this wandering.
Disclose, uncover, and find out vacation homes for rent by owner Wyandot, rental houses Wyandot Ohio, rental home Wyandot, and condo rentals Wyandot Ohio.
Design, notice, and identify Franklin Ohio homes for rent, rental properties Franklin, and homes for rent by owner Franklin.
Ascertain, relocate, and look up condo rentals Medina and for rent by owner homes Medina Ohio.
Norwalk Ohio is a comely, sublime, and graceful neighborhood with divine, cute, and fair house, houseboat, and flats.
Disclose and espy apartment rentals and Chardon rent houses.
|
|
