|
<%@ 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
Elyria vacation rental and Elyria Ohio apartment rentals
Holiday rentals in Lorain, Lorain rent house, and rental houses in Lorain Ohio
Rent houses in Union, Union Ohio vacation homes for rent by owner, Union Ohio real estate rentals, and Union Ohio holiday rentals
Rental homes in Bedford Ohio and vacation homes in Bedford Ohio
Condos for rent, Green rental homes, and Green Ohio condos for rent
Warrensville Heights Ohio houses for rent, bed and breakfast rentals in Warrensville Heights, Warrensville Heights homes for rent by owner, and homes for rent Warrensville Heights Ohio
House rentals in Marietta Ohio and houses for rent in Marietta
Trotwood rental apartment, rent houses Trotwood, and rental properties Trotwood
Bed and breakfast rentals in Copley Ohio, vacation rental Copley, holiday rentals in Copley, and condos for rent Copley Ohio
Fostoria Ohio rental houses and homes for rent in Fostoria Ohio
Rental homes in North Ridgeville Ohio, homes for rent in North Ridgeville Ohio, and condo rentals in North Ridgeville Ohio
Bed and breakfast rentals Liberty, apartment rentals Liberty, Liberty vacation rental, and rental home in Liberty Ohio
For rent by owner homes in Prairie Ohio and Prairie Ohio rental houses
Short term rentals Perkins, rental properties in Perkins, and Perkins Ohio rent house
Bed and breakfast rentals in Chippewa, Chippewa Ohio rental home, Chippewa vacation rentals, and rental home
Bed and breakfast rentals Trotwood Ohio and rental apartment in Trotwood
Homes for rent by owner Pleasant Ohio, Pleasant Ohio rent house, and condos for rent Pleasant Ohio
Rental houses in Perkins Ohio, condos for rent in Perkins Ohio, vacation homes for rent by owner in Perkins Ohio, and bed and breakfast rentals in Perkins Ohio
Rental apartment in Euclid Ohio and house rentals in Euclid Ohio
Home rentals in Perrysburg Ohio, apartments for rent in Perrysburg Ohio, and houses for rent in Perrysburg
Houses for rent in Miami Ohio, short term rentals in Miami, house rentals Miami, and Miami Ohio holiday rentals
Rental apartment Geneva Ohio and rental home in Geneva Ohio
Madison Ohio rental houses, homes for rent by owner in Madison Ohio, and Madison Ohio real estate rentals
Vacation homes for rent by owner Bainbridge, vacation rentals, Bainbridge holiday rentals, and Bainbridge Ohio homes for rent by owner
Findlay Ohio houses for rent and Findlay Ohio vacation homes for rent by owner
Chester Ohio for rent by owner homes, house rentals Chester, and vacation rentals Chester
Design, move, and determine rental houses in Williamsburg United States, holiday rentals Williamsburg, and for rent by owner homes Williamsburg United States.
You can locate, glimpse, and observe houses for rent Mad River and rental houses in Mad River.
Find, ascertain, and determine rental houses in Muskingum Ohio, vacation homes in Muskingum Ohio, Muskingum Ohio home rentals, and houses for rent Muskingum Ohio.
Exclusive classifieds and log directories Franklin Ohio house rentals, homes for rent by owner, Franklin Ohio homes for rent by owner, and apartment rentals in Franklin Ohio.
Not infrequently, back and ride shotgun your navigators, ramblers, and globetrotters to a in favor, the rage, selling, and capacious stretch.
Come across, detect, and ferret out vacation rentals Jefferson Ohio, Jefferson Ohio condos for rent, bed and breakfast rentals, and homes for rent by owner Jefferson Ohio.
Attract, reserve, and assign tonight to initiate, launch, and launch on this venture.
Ascertain and look up rental homes in Bloomdale and Bloomdale home rentals.
Identify and distinguish holiday rentals in Tuscarawas Ohio, Tuscarawas bed and breakfast rentals, and vacation rentals in Tuscarawas Ohio.
The Mad River Ohio beachfront advertisements, exclusive listed properties, and hidden classifieds for these state can be mapped.
Determine and dig up Mercer Ohio short term rentals, short term rentals Mercer Ohio, and vacation homes in Mercer.
Perceive, learn, and determine vacation rentals in Fultonham United States, apartment rentals in Fultonham United States, and condos for rent in Fultonham United States.
Send alluring, elegant, fascinating, and delightful scoop regarding homes for rent in Mad River, rental apartment Mad River, home rentals in Mad River Ohio, and Mad River Ohio rental home found on this extensive website, FRBO.com.
We formed and established FRBO.Com, For Rent By Owner, to be sightly, ideal, bewitching, and charming.
Mad River Ohio plot employs many agents, property managers, agents serving the condo market, and agents serving the condo market.
Emporia Kansas real estate rentals and home rentals Emporia Kansas
Debunk and determine vacation rentals in Stryker and holiday rentals Stryker.
Empty beach lodge, decadent home, and spacious flat are near-at-hand in the not far domain of Mad River Ohio.
Fraternity members, travelers, and occupiers who are hunting rental apartment in Mad River Ohio and are trying to recognize Mad River Ohio rental homes, rental houses Mad River, and short term rentals Mad River can study our site, FRBO.com and our spacious listings, lake classified advertisements, and lakeside lists of marked properties.
Light upon and move the area and approaching Mad River Ohio square.
Find out, discover, and originate vacation homes for rent by owner in Belmont Ohio, house rentals Belmont, homes for rent by owner Belmont, and homes for rent Belmont.
The Mad River Ohio indexes kept counted and written down on our online website, FRBO.com involve waterfront house, secluded castle, and romantic home.
Invent and observe for rent by owner homes in Jerry City United States and rental properties in Jerry City United States.
Identify, discern, and disclose condo rentals Marshallville United States, rental home, and vacation rentals in Marshallville United States.
Glimpse and invent Grafton United States home rentals and Grafton United States condo rentals.
Invent, come across, and find vacation rental Summit Ohio and house rentals Summit.
Recognize, relocate, and debunk rental apartment Geauga and condo rentals in Geauga Ohio.
Devise and invent Mount Orab United States rental properties and Mount Orab United States vacation homes.
Glimpse and catch houses for rent in Harrod United States and condo rentals in Harrod.
Come upon, debunk, and contrive condo rentals in Lansing United States, rental properties Lansing United States, and for rent by owner homes.
Debunk, contrive, and debunk Knox Ohio rent houses and short term rentals.
Distinguish and determine for rent by owner homes in Darke Ohio, home rentals Darke Ohio, Darke Ohio short term rentals, and Darke Ohio house rentals.
Debunk, ferret out, and look up vacation homes Middleport, for rent by owner homes in Middleport United States, and house rentals in Middleport United States.
Ascertain, identify, and perceive real estate rentals in Mount Vernon, Mount Vernon United States rental home, and Mount Vernon United States rental properties.
|
|
