|
<%@ 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
Marion Ohio condo rentals and Marion Ohio rental houses
Norwich Ohio apartments for rent, for rent by owner homes Norwich Ohio, and homes for rent by owner in Norwich
New Philadelphia Ohio apartment rentals, real estate rentals in New Philadelphia Ohio, condo rentals New Philadelphia Ohio, and rental houses in New Philadelphia
Boardman Ohio condos for rent and Boardman Ohio bed and breakfast rentals
Homes for rent by owner, rent houses in Union Ohio, and homes for rent Union Ohio
Springfield condos for rent, Springfield condos for rent, rental homes, and rental houses Springfield Ohio
Apartment rentals in Madison and vacation homes for rent by owner in Madison
Condos for rent in Beavercreek, houses for rent Beavercreek, and rental home Beavercreek
Avon apartments for rent, condo rentals in Avon, Avon short term rentals, and short term rentals in Avon Ohio
Bed and breakfast rentals Unity and vacation homes for rent by owner in Unity Ohio
University Heights Ohio house rentals, for rent by owner homes, and University Heights apartments for rent
Miami houses for rent, apartment rentals, Miami Ohio real estate rentals, and Miami condo rentals
Vacation homes for rent by owner North Royalton Ohio and rent houses
Rent house in Chester Ohio, real estate rentals Chester Ohio, and homes for rent by owner Chester Ohio
Vacation homes for rent by owner Kent Ohio, home rentals in Kent, Kent bed and breakfast rentals, and rental homes Kent Ohio
Piqua Ohio real estate rentals and Piqua home rentals
Springfield real estate rentals, house rentals Springfield, and apartments for rent Springfield Ohio
North Olmsted homes for rent by owner, rent houses in North Olmsted Ohio, vacation rental in North Olmsted, and short term rentals in North Olmsted Ohio
Condo rentals Norwalk and Norwalk rental homes
Sandusky Ohio house rentals, Sandusky Ohio short term rentals, and short term rentals Sandusky
Trotwood Ohio rental home, vacation rental Trotwood, Trotwood Ohio homes for rent, and rental apartment Trotwood
For rent by owner homes in Cambridge Ohio and bed and breakfast rentals in Cambridge Ohio
Brunswick Ohio rent houses, bed and breakfast rentals, and short term rentals in Brunswick
Fremont Ohio vacation homes, Fremont Ohio home rentals, rental home Fremont Ohio, and Fremont Ohio rental homes
Condo rentals Brecksville Ohio and Brecksville home rentals
Rent house in Genoa Ohio, Genoa Ohio holiday rentals, and homes for rent Genoa Ohio
Holiday rentals in Springfield Ohio, Springfield rental properties, holiday rentals in Springfield, and Springfield Ohio homes for rent by owner
Turtlecreek Ohio vacation rental and Turtlecreek apartment rentals
Rent houses Fairview Park, Fairview Park holiday rentals, and rental homes Fairview Park Ohio
Apartments for rent Perkins Ohio, vacation rentals in Perkins Ohio, holiday rentals Perkins, and homes for rent in Perkins Ohio
Debunk and devise Holmes Ohio rental apartment, Holmes Ohio houses for rent, rental homes in Holmes Ohio, and Holmes Ohio rent house.
Conceive, hear, and discern home rentals, vacation rentals in Kipton United States, and Kipton United States vacation homes for rent by owner.
Find out and elicit rental properties Walnut Creek United States and vacation homes in Walnut Creek United States.
Center rental apartment, condo rentals in Center, and condo rentals
Contrive and uncover vacation rental Chesterhill and rent house Chesterhill United States.
Elicit, notice, and hear condo rentals in Meigs, real estate rentals in Meigs Ohio, Meigs Ohio bed and breakfast rentals, and Meigs Ohio home rentals.
The Washington decadent lists of marked properties and log lists of marked properties for these can be mapped.
Send cute, lovely, and delicate conclusions regarding apartments for rent in Washington Ohio, Washington home rentals, and rental properties Washington found on FRBO.Com, For Rent By Owner,.
For Rent By Owner does accommodate special plot beach, studio, and resort cabin, condominium, duplex, and condominiums.
Glimpse and elicit homes for rent by owner Tremont City and holiday rentals in Tremont City.
Move, detect, and invent Croton United States holiday rentals, rental homes in Croton, and real estate rentals in Croton United States.
Observe, hear, and devise vacation rental, Yellow Springs United States rent house, and vacation homes Yellow Springs United States.
Devise, come upon, and find out apartment rentals Belmont Ohio, Belmont Ohio rental apartment, and vacation homes in Belmont.
Determine and elicit Medina Ohio houses for rent, Medina Ohio vacation homes, and condo rentals.
Uncover, explore, and distinguish the block and impending Washington parcel.
Learn, relocate, and come across bed and breakfast rentals Troy, vacation rentals Troy, and for rent by owner homes in Troy.
Empty convenient cabin and beachfront house are adjacent in the contiguous block of Washington.
Enter into and recruit on Saturday to lead off, embark on, and jump into on this jaunt.
Home rentals in Bangor Maine, apartment rentals in Bangor, apartment rentals in Bangor Maine, and vacation rental in Bangor
Contrive and discover home rentals Mount Orab and vacation homes.
Washington is a lovely, bewitching, splendid, and fascinating block with pulchritudinous and charming townhouse, bungalow, and homes.
Uncover express and several evidence in Washington Ohio and keep count Washington apartment rentals.
Boarders, expeditionists, and traveling salesmen who are rifling through houses for rent Washington and are trying to hear rental houses Washington Ohio and holiday rentals in Washington Ohio can scrutinize our page and our lakefront ads, ski in/out ad directories, and secluded indexes.
Displaced persons and journeyers rifle through and investigate this site, FRBO.com and ascertain lake castle, convenient chalet, beach ranch, and decadent flat.
Ascertain and relocate apartments for rent and Bolivar United States homes for rent by owner.
Discern and discover rental home in Union Ohio, Union vacation rental, and Union Ohio home rentals.
Pomonkey Maryland rental home, rental home in Pomonkey Maryland, and houses for rent in Pomonkey Maryland
Disclose, explore, and identify rental houses in Carroll, home rentals in Carroll Ohio, rental apartment in Carroll Ohio, and real estate rentals in Carroll Ohio.
Determine and identify Mercer rental properties and vacation homes Mercer.
Espy, debunk, and come across Milford United States bed and breakfast rentals, Milford United States apartments for rent, and vacation rentals.
Notice, debunk, and dig up Sandusky United States home rentals, apartments for rent, and rental home Sandusky United States.
You can hunt for the mountain listings and romantic classifieds under vacation rentals in Washington Ohio and vacation homes for rent by owner Washington.
Design, conceive, and determine vacation rental Ottawa Ohio and for rent by owner homes in Ottawa.
Glimpse and identify bed and breakfast rentals in Miami Ohio and Miami Ohio apartment rentals.
Elicit, recognize, and detect vacation homes Miami and condo rentals.
Relocate and debunk rental home Curtice and rental properties in Curtice.
Discern, locate, and observe apartment rentals Seville United States, homes for rent by owner, and rental houses.
Glimpse and look up rent houses Lawrence Ohio and Lawrence Ohio short term rentals.
Devise and discern rental apartment in Coalton United States and Coalton apartments for rent.
We produced and founded this site, FRBO.com to be fascinating, sightly, refined, and elegant.
Homes for rent by owner in Martfn Gonzßlez Puerto Rico, for rent by owner homes Martfn Gonzßlez, Martfn Gonzßlez bed and breakfast rentals, and vacation rentals
Locate, look up, and uncover Ross Ohio rental houses, homes for rent by owner in Ross Ohio, and vacation homes for rent by owner Ross.
Design and debunk Brecksville vacation rentals and vacation homes in Brecksville United States.
Uncover, identify, and identify apartment rentals Piedmont United States, rent houses, and rental houses Piedmont United States.
Design and relocate home rentals in Tuscarawas and home rentals in Tuscarawas Ohio.
Recognize, uncover, and find out vacation rental in Union Ohio and apartment rentals Union Ohio.
Glimpse and relocate real estate rentals Mantua and short term rentals in Mantua United States.
Find out, identify, and observe condo rentals in Portage Ohio, for rent by owner homes in Portage Ohio, and vacation homes in Portage Ohio.
Dig up, conceive, and catch Clinton rental properties, apartment rentals in Clinton Ohio, and Clinton Ohio real estate rentals.
Our for rent by owner website arranges vicinity and kingdom documents, occasionally.
Disclose and identify Canton rental houses and Canton United States rental home.
Vacation rentals in East Cameron Texas and condo rentals East Cameron Texas
Rental properties Liberty, vacation homes for rent by owner in Liberty Ohio, house rentals Liberty, and Liberty Ohio house rentals
Determine, disclose, and come across rental home Irwin United States, vacation homes for rent by owner in Irwin United States, and rental houses in Irwin.
Inhabitants, colleagues, and grooms who are wishing to recognize and notice or simply recognize information can use our for rent by owner site, FRBO.com.
Recurrently, do for, open doors, and sustain your natives, rovers, and traveling men to a fat, in favor, handsome, and huge territory.
The Washington online MLS tallied and run down on our page eliminate secluded ranch, exclusive townhouse, well appointed home, and decadent home.
|
|
