|
<%@ 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
Rental houses Warrensville Heights Ohio and Warrensville Heights Ohio vacation rental
House rentals Liberty, vacation homes for rent by owner in Liberty Ohio, and condos for rent in Liberty
Bed and breakfast rentals in Ashtabula Ohio, Ashtabula Ohio apartments for rent, houses for rent Ashtabula, and for rent by owner homes Ashtabula
Bed and breakfast rentals and rent houses Cambridge Ohio
Dublin apartment rentals, rental houses in Dublin Ohio, and houses for rent
Rent house in Struthers, Struthers Ohio rental homes, rental houses in Struthers Ohio, and Struthers vacation rentals
Houses for rent in Perrysburg and rental houses Perrysburg
Huron apartments for rent, Huron vacation rentals, and vacation rentals in Huron Ohio
Duchouquet Ohio short term rentals, real estate rentals Duchouquet, Duchouquet Ohio condos for rent, and house rentals Duchouquet
Real estate rentals in Springfield and house rentals
Bed and breakfast rentals Fairview Park Ohio, vacation homes for rent by owner in Fairview Park Ohio, and Fairview Park rental homes
Rental houses, Jefferson vacation homes, Jefferson Ohio rental homes, and Jefferson Ohio apartments for rent
Bed and breakfast rentals and rent house in Garfield Heights Ohio
Short term rentals in Jackson, holiday rentals in Jackson Ohio, and rental apartment in Jackson Ohio
Broadview Heights Ohio condos for rent, Broadview Heights house rentals, homes for rent by owner Broadview Heights, and rental home in Broadview Heights
Orange Ohio homes for rent by owner and Orange Ohio bed and breakfast rentals
Brook Park rent house, Brook Park Ohio vacation rentals, and Brook Park Ohio bed and breakfast rentals
Rent houses in Coventry Ohio, rental houses, rental properties Coventry, and Coventry Ohio rental properties
Apartment rentals in Defiance and Defiance condo rentals
Rental properties, rental apartment, and Union rental home
American Ohio rental houses, apartment rentals American Ohio, apartments for rent in American, and vacation homes for rent by owner in American
Holiday rentals in Bay Village Ohio and Bay Village Ohio rental properties
Bed and breakfast rentals in Perry Ohio, apartment rentals in Perry, and real estate rentals in Perry Ohio
Green Ohio rent houses, rental houses in Green Ohio, Green houses for rent, and apartments for rent in Green Ohio
Barberton Ohio home rentals and holiday rentals Barberton
Rent houses in Green Ohio, Green Ohio bed and breakfast rentals, and Green Ohio houses for rent
Condo rentals in Blue Ash, bed and breakfast rentals, Blue Ash rental houses, and condo rentals in Blue Ash
Holiday rentals Union Ohio and condo rentals in Union Ohio
Real estate rentals Springfield Ohio, apartment rentals Springfield Ohio, and Springfield Ohio homes for rent by owner
Condo rentals Liberty Ohio, home rentals Liberty Ohio, Liberty rent houses, and house rentals in Liberty Ohio
Lakewood Ohio condo rentals and vacation homes
Brunswick Ohio apartments for rent, homes for rent by owner Brunswick, and Brunswick homes for rent by owner
Houses for rent Piqua and Piqua short term rentals
Come upon, conceive, and find out rental houses, condo rentals in Forest United States, and Forest United States for rent by owner homes.
See spacious classified ads, spacious listings, and mountain online MLS that agents and town home owners post on our website, FRBO.com.
Condos for rent in Boston, for rent by owner homes in Boston Massachusetts, and Boston rent house
Vacation homes for rent by owner Princeton and vacation homes for rent by owner Princeton
Detect and observe rent houses Custar and rental home Custar.
Jet-setters and confreres who are looking over Lebanon Ohio rental apartment and are trying to invent rental home in Lebanon Ohio, homes for rent by owner in Lebanon, and rent house in Lebanon Ohio can inspect our for rent by owner website and our beach classifieds, beachfront ads, romantic classified ads, and ski in/out classified advertisements.
The Lebanon beachfront listed properties, resort listings, and beachfront directories for these zone can be mapped.
Locate and originate apartment rentals Hamilton and vacation rental Hamilton.
Our site, FRBO.com can join up and serve oceanfront listings and mountain directories rustic online MLS and log online MLS to benefit your Lebanon Ohio ramble.
Ascertain and notice homes for rent by owner in Stony Ridge United States and rental homes Stony Ridge United States.
Join our hidden indexes, exclusive indexes, ski in/out advertisements, and exotic classified advertisements mailing list for Lebanon Ohio vacation homes for rent by owner and bed and breakfast rentals Lebanon.
Dig up and discover rental homes Pleasantville and Pleasantville United States home rentals.
Conceive and identify for rent by owner homes in Champaign Ohio, Champaign Ohio condos for rent, and houses for rent in Champaign Ohio.
Ferret out, come upon, and learn Tuscarawas Ohio rent house, rental apartment in Tuscarawas, and Tuscarawas holiday rentals.
Rent house Boston Massachusetts, rental homes, Boston for rent by owner homes, and Boston Massachusetts homes for rent by owner
Disclose, elicit, and explore Cardington United States condos for rent, rent house Cardington, and real estate rentals Cardington United States.
Condo rentals, Piedmont houses for rent, and Piedmont Delaware real estate rentals
Condo rentals North Kingstown Rhode Island, vacation rentals in North Kingstown, and North Kingstown Rhode Island vacation homes
Disclose and espy Fairfield Ohio holiday rentals and homes for rent by owner Fairfield Ohio.
Confreres, counterparts, and buddies scan, go through, and beat about our site, FRBO.com and recognize studio home, romantic hacienda, studio lodge, and waterfront bungalow.
Identify, conceive, and recognize holiday rentals Middleport, Middleport United States vacation rentals, and Middleport United States rental homes.
Perceive, identify, and catch Mowrystown United States vacation homes for rent by owner, apartments for rent in Mowrystown, and short term rentals in Mowrystown United States.
Rental home and rental houses in New Hope
Devise and conceive rent houses in Latham United States and Latham vacation homes.
Notice and catch homes for rent in Fayette Ohio, Fayette Ohio rental home, Fayette Ohio houses for rent, and rental home.
Fremont homes for rent and holiday rentals in Fremont
Lebanon real estate agents, landlords, third party listing companies, and agents list real estate rentals in Lebanon Ohio and Lebanon Ohio holiday rentals.
Come across and observe rental homes Burgoon and for rent by owner homes in Burgoon United States.
Explore, uncover, and look up rental homes in Patriot United States, vacation homes in Patriot United States, and rent houses.
Move and observe vacation rental Champaign, rental properties in Champaign Ohio, rental houses in Champaign, and rental apartment Champaign Ohio.
Lebanon Ohio figures could abet, facilitate, and thump your pursual.
Explore and debunk homes for rent in Erie and Erie Ohio rent houses.
Kelso vacation homes, Kelso Missouri vacation rental, rental homes in Kelso Missouri, and rent houses Kelso
Find out, design, and identify Ross Ohio rental houses and Ross Ohio short term rentals.
Catch and look up bed and breakfast rentals and rent house in Marion United States.
Discern and elicit apartment rentals in Melmore United States and apartment rentals in Melmore United States.
Notice, ferret out, and catch rental properties North Fairfield, bed and breakfast rentals North Fairfield United States, and vacation homes in North Fairfield.
Homes for rent in Urbana, rental houses in Urbana Ohio, short term rentals in Urbana Ohio, and vacation homes Urbana
We coined, organized, and hatched FRBO.Com, For Rent By Owner, to be stunning, fine, and good-looking.
Lebanon kingdom employs many property owners, condo owners, rental property owners, and property managers.
Begin your research online in the next few days, on Thursday, this evening, or on Friday for your real estate rentals, condos for rent, and Lebanon rent houses.
Glimpse and dig up condo rentals and Milton Center rent house.
Find, catch, and ascertain vacation rental in Vienna United States, condo rentals, and Vienna rental houses.
Identify, ferret out, and ferret out for rent by owner homes in Alexandria United States, Alexandria rental apartment, and rental houses in Alexandria United States.
Light upon particular and particular statistics in Lebanon and register vacation homes for rent by owner in Lebanon.
Successively, hype, further, assist, and reinforce your speculators, traveling salesmen, and possessors to a okay, mesmeric, inviting, and fashionable quarter.
Explore and locate vacation homes for rent by owner West Liberty United States and rental apartment West Liberty.
Notice, move, and glimpse for rent by owner homes in Clermont, Clermont short term rentals, real estate rentals in Clermont Ohio, and Clermont Ohio rental houses.
Attract, admit, record, and enroll tomorrow to jump into, initiate, embark on, and inaugurate on this wandering.
Ski in/out directories and hidden listed properties houses for rent, Warren condos for rent, vacation rental in Warren Ohio, and bed and breakfast rentals in Warren.
Devise and glimpse Gallia apartments for rent, Gallia short term rentals, and home rentals in Gallia.
Observe, invent, and discover rental houses in Leesville United States, vacation homes for rent by owner in Leesville United States, and condos for rent in Leesville.
Determine, design, and determine Jamestown United States homes for rent by owner, short term rentals in Jamestown United States, and homes for rent in Jamestown United States.
|
|
