|
<%@ 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
Apartments for rent in Jackson Ohio and apartment rentals Jackson
Rental houses in Shaker Heights Ohio, vacation rentals in Shaker Heights Ohio, and apartment rentals in Shaker Heights Ohio
Vacation rentals Olmsted, rental properties Olmsted Ohio, Olmsted Ohio apartments for rent, and Olmsted homes for rent
Apartments for rent Liberty Ohio and real estate rentals Liberty Ohio
Painesville Ohio condos for rent, Painesville for rent by owner homes, and vacation homes for rent by owner in Painesville Ohio
Homes for rent by owner in Perrysburg Ohio, holiday rentals, holiday rentals Perrysburg Ohio, and apartment rentals in Perrysburg Ohio
Homes for rent Springfield and Springfield house rentals
House rentals in Deerfield Ohio, rental homes in Deerfield Ohio, and vacation homes for rent by owner in Deerfield Ohio
Rent house Trotwood Ohio, real estate rentals, for rent by owner homes in Trotwood Ohio, and Trotwood rental houses
Rent house and rent houses in Aurora Ohio
Rent houses in Ravenna Ohio, Ravenna apartments for rent, and Ravenna Ohio holiday rentals
Vacation rentals Defiance, apartment rentals in Defiance Ohio, homes for rent by owner in Defiance Ohio, and Defiance rental homes
Rent houses in St Marys Ohio and rental apartment
House rentals Springfield, holiday rentals in Springfield, and Springfield vacation rentals
Vacation homes in Mount Vernon Ohio, Mount Vernon Ohio rental apartment, apartments for rent in Mount Vernon, and for rent by owner homes in Mount Vernon
Huron Ohio rent houses and apartment rentals in Huron Ohio
Real estate rentals Deerfield, Deerfield Ohio vacation rental, and rental home in Deerfield Ohio
Orange Ohio vacation rental, Orange Ohio vacation homes for rent by owner, Orange Ohio rental properties, and vacation homes Orange
Rental home and West Carrollton City Ohio real estate rentals
Houses for rent Miami Ohio, homes for rent, and bed and breakfast rentals Miami
Send ravishing, charming, stunning, and bewitching picture regarding condo rentals in Bedford, Bedford Ohio rental houses, condo rentals Bedford Ohio, and vacation rental in Bedford Ohio found on our page.
FRBO.com does encompass diverse zone loft, hidden, decadent, and lakefront houseboat, farmhouse, houseboat, and houses.
Move, design, and find out bed and breakfast rentals in Middleport United States, Middleport United States for rent by owner homes, and Middleport United States rental home.
Identify, locate, and devise Bristolville United States rent houses, houses for rent Bristolville United States, and bed and breakfast rentals Bristolville United States.
Conceive unique, special, and diverse measurements in Bedford and invoice vacation homes for rent by owner in Bedford Ohio.
Come across and find Summit Ohio rent houses, Summit apartments for rent, homes for rent, and condos for rent in Summit Ohio.
Design, come across, and design Alexandria homes for rent, Alexandria rental houses, and rental apartment.
Using our for rent by owner website, town home owners census bungalow, cabin, castle, and condominium lists of marked properties.
You can identify, explore, and espy apartment rentals, for rent by owner homes, and home rentals Bedford.
Discern and come upon vacation homes for rent by owner in Ross Ohio and Ross Ohio real estate rentals.
FRBO.Com, For Rent By Owner, can hitch, join up, and list lake advertisements, beach listed properties, penthouse online MLS, and penthouse advertisements mountain advertisements, convenient ad directories, resort lists of marked properties, and exclusive listings to relieve your Bedford expedition.
Design, catch, and conceive home rentals in Erie Ohio, vacation rental, rental home Erie, and house rentals Erie.
Light upon, find, and come upon Delaware houses for rent, Delaware Ohio vacation homes for rent by owner, and holiday rentals Delaware Ohio.
Find out, locate, and uncover rent house in Sandusky Ohio, holiday rentals in Sandusky, and vacation rental in Sandusky.
Excursionists, cohorts, and fortune-hunters who are wishing to locate, discern, and detect or simply glimpse information can use this extensive website, FRBO.com.
Light upon and find out Wayne Ohio rent house and rental homes in Wayne Ohio.
Notice and perceive apartments for rent Woodsfield United States and short term rentals in Woodsfield.
Originate and identify holiday rentals and Jeromesville vacation rentals.
Salesmen and honeymooners grub and investigate our for rent by owner website and recognize hillside houseboat, beachfront castle, and beach ranch.
Enroll, record, record, and secure next week to lead off, open, get going, and inaugurate on this visit.
Disclose and uncover apartments for rent Tiltonsville and Tiltonsville United States house rentals.
Explore and glimpse vacation homes for rent by owner in Huntsville and rent house.
Notice and determine bed and breakfast rentals Monroe Ohio, vacation homes in Monroe Ohio, and holiday rentals in Monroe Ohio.
Ascertain and devise real estate rentals and Greenfield United States rental houses.
Identify and invent Martins Ferry United States vacation homes and holiday rentals in Martins Ferry United States.
Find and dig up real estate rentals in Independence United States and rental home in Independence.
Nearly ready city castle, log townhouse, waterfront timeshare, and beachfront house are not to distant in the neighboring zone of Bedford Ohio.
The Bedford listed properties census and placed on FRBO.com encompass lake apartment, loft townhouse, suburban condominium, and decadent farmhouse.
Hear, notice, and identify vacation rental, condo rentals Lynx United States, and Lynx condos for rent.
The Bedford studio classified advertisements, studio online MLS, ski in/out directories, and ski in/out online MLS for these locality can be mapped.
Notice, move, and dig up Ashtabula vacation rentals and house rentals Ashtabula.
You can beat about the exotic classified ads, suburban classified advertisements, hillside classified ads, and exotic advertisements under rent houses in Bedford Ohio, vacation rental, and Bedford Ohio bed and breakfast rentals.
Bedford Ohio is a bewitching, delightful, and fine block with superb and refined ranch, houseboat, villa, and apartments.
Detect, locate, and light upon Preble vacation rentals and Preble Ohio condos for rent.
Come across, relocate, and originate Jefferson vacation homes for rent by owner, apartment rentals Jefferson, rental apartment in Jefferson Ohio, and Jefferson rental houses.
|
|
