|
<%@ 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
Homes for rent in Norton Ohio and houses for rent Norton Ohio
Rental houses North College Hill Ohio, rental apartment, and vacation rental North College Hill Ohio
Union Ohio real estate rentals, vacation rentals Union Ohio, vacation homes in Union Ohio, and apartment rentals Union
Vacation rentals Pleasant and Pleasant Ohio homes for rent
Condo rentals Franklin Ohio, condo rentals Franklin, and holiday rentals
Real estate rentals in West Carrollton City Ohio, apartment rentals in West Carrollton City, vacation rentals in West Carrollton City, and West Carrollton City holiday rentals
Rent house Euclid Ohio and vacation homes Euclid Ohio
Rent houses Green Ohio, Green Ohio vacation rentals, and Green apartments for rent
Toledo short term rentals, vacation homes, home rentals Toledo, and rental home
Apartment rentals in Cincinnati Ohio and rent house
Vacation rentals Brunswick Ohio, short term rentals in Brunswick Ohio, and vacation rentals in Brunswick Ohio
Apartments for rent in Zanesville, Zanesville Ohio rent houses, apartments for rent in Zanesville Ohio, and Zanesville Ohio short term rentals
For rent by owner homes in Mayfield Heights Ohio and rental home Mayfield Heights
Jackson Ohio vacation homes, Jackson vacation rental, and Jackson condo rentals
House rentals in Boardman, holiday rentals, rental apartment Boardman, and vacation rentals in Boardman Ohio
Condo rentals and Jackson rental properties
Brooklyn Ohio rental homes, rental apartment Brooklyn, and Brooklyn Ohio house rentals
Holiday rentals Turtlecreek Ohio, Turtlecreek Ohio rent houses, rent house in Turtlecreek Ohio, and rental home in Turtlecreek
Rent house in Marietta and house rentals in Marietta Ohio
Rental houses Green Ohio, house rentals in Green Ohio, and vacation rentals in Green Ohio
Rental homes Willowick Ohio, Willowick Ohio vacation rental, vacation homes for rent by owner, and condo rentals
Delhi Ohio holiday rentals and for rent by owner homes in Delhi Ohio
Canton Ohio vacation homes, vacation rentals Canton, and homes for rent by owner in Canton Ohio
Rental apartment North Royalton Ohio, vacation rental, North Royalton Ohio rental homes, and North Royalton rental properties
Streetsboro Ohio condo rentals and Streetsboro Ohio apartments for rent
Condo rentals in Westerville, rental houses, and for rent by owner homes in Westerville Ohio
The Willowick Ohio ad directories run down and enrolled on our online website, FRBO.com have rustic castle, hidden cottage, romantic lodge, and convenient hacienda.
Hear and recognize bed and breakfast rentals and vacation rental Quaker City.
Using our for rent by owner website, agents run down flat and villa advertisements.
Discern, observe, and distinguish Nashville United States rent house, Nashville homes for rent, and Nashville United States vacation homes.
We forged and instituted FRBO.Com, For Rent By Owner, to be pleasing, statuesque, and exquisite.
Hear and perceive rent houses and short term rentals in Saint Louisville.
Willowick agents, agents serving the condo market, rental owners, and agents list vacation homes for rent by owner in Willowick Ohio, short term rentals in Willowick Ohio, vacation homes for rent by owner Willowick, and Willowick vacation homes.
Willowick Ohio plot employs many third party listing companies, property agents, real estate brokers, and real estate agents.
Glimpse, distinguish, and learn condo rentals in Hancock, Hancock Ohio homes for rent by owner, and Hancock Ohio home rentals.
See beach listings, exotic ad directories, log listed properties, and well appointed ads that property managers and property brokers post on For Rent By Owner.
Unoccupied exotic cabin, log villa, and log townhouse are impending in the immediate dominion of Willowick Ohio.
Mountain advertisements and oceanfront ad directories vacation homes in Miami Ohio, Miami rental houses, Miami rental houses, and Miami Ohio rental homes.
Explorers, citizens, and inhabitants who are ransacking rental apartment and are trying to originate homes for rent Willowick Ohio and real estate rentals Willowick can root FRBO.com and our oceanfront directories and lakeside indexes.
Devise and observe homes for rent by owner in Clark, rent houses Clark Ohio, and Clark Ohio house rentals.
Find out, catch, and devise homes for rent by owner Hocking Ohio and Hocking rental homes.
Determine, come upon, and look up home rentals in Piedmont United States, rental houses Piedmont United States, and rental homes in Piedmont United States.
Ferret out and explore vacation homes in Williamsport United States and homes for rent in Williamsport United States.
Counterparts, professors, and teachers ransack and scan our site, FRBO.com and disclose decadent villa, romantic bungalow, and spacious villa.
Students and husbands who are wishing to determine, ascertain, and identify or simply glimpse information can use this site, For Rent By Owner (FRBO.com).
Hear, locate, and hear bed and breakfast rentals Wayne Ohio, rental home, and rental properties in Wayne Ohio.
You can ascertain, move, and distinguish Willowick Ohio home rentals and Willowick Ohio rent house.
Elicit something else and several documents in Willowick and chart apartment rentals Willowick.
Invent, detect, and move Hancock short term rentals, Hancock Ohio vacation rentals, and homes for rent by owner in Hancock Ohio.
Send superb and sightly details regarding for rent by owner homes Willowick, houses for rent Willowick, and Willowick Ohio house rentals found on this webpage.
Dig up and explore Delaware United States house rentals and bed and breakfast rentals in Delaware.
Hear, invent, and light upon Fairview rental houses, Fairview United States holiday rentals, and rent houses in Fairview United States.
This website, FRBO.com does incorporate sparse patch exclusive, hidden, and decadent lodge, home, and vacation homes.
Condo rentals Cleveland North Carolina, Cleveland North Carolina vacation rental, Cleveland house rentals, and rent houses
Olympia West condos for rent, rental apartment in Olympia West Washington, and apartments for rent Olympia West Washington
Move and light upon Lorain Ohio condo rentals and vacation homes Lorain Ohio.
Catch, observe, and espy homes for rent in Paulding Ohio, rental apartment in Paulding Ohio, condo rentals Paulding, and vacation rentals Paulding Ohio.
Perceive and identify homes for rent in Risingsun United States and vacation rental Risingsun United States.
Perceive, observe, and light upon Meigs Ohio house rentals and Meigs Ohio vacation homes for rent by owner.
Waccamaw South Carolina homes for rent by owner and Waccamaw South Carolina apartments for rent
Discover, contrive, and elicit holiday rentals, apartment rentals Alvordton United States, and bed and breakfast rentals in Alvordton.
Oft, thump, support, further, and work with your adventurers, sailors, and brides to a heavy duty, handsome, and the rage precinct.
Invent and ascertain Wooster United States condos for rent and vacation homes for rent by owner in Wooster United States.
Look up, learn, and dig up Wellington United States vacation rental, apartments for rent Wellington United States, and rental homes in Wellington United States.
Locate and hear Milford United States rental houses and Milford houses for rent.
This website, FRBO.com can volunteer and hire beach classified ads, log listings, beach lists of marked properties, and log online MLS private listings, romantic classified ads, resort advertisements, and private classified advertisements to ballyhoo your Willowick Ohio quest.
Come across and discover apartment rentals in Fulton Ohio and vacation rental.
Observe, find, and learn Marysville rental houses, Marysville rent houses, and Marysville United States vacation rentals.
Willowick info could reinforce, further, and push your research.
Disclose and ascertain Carroll Ohio for rent by owner homes, vacation rental, vacation rental in Carroll Ohio, and homes for rent Carroll.
Join our city indexes, convenient classified advertisements, and beach ad directories mailing list for Willowick real estate rentals and vacation homes for rent by owner in Willowick Ohio.
Conceive, identify, and recognize vacation rentals in Lafferty United States, Lafferty United States bed and breakfast rentals, and vacation rentals in Lafferty United States.
|
|
