|
<%@ 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" %>
|
Indiana Rental Links
Vacation homes for rent by owner in Washington and rental properties in Washington
Bed and breakfast rentals in Penn Indiana, apartments for rent Penn, and condo rentals Penn
Apartments for rent in Centre, bed and breakfast rentals Centre Indiana, Centre Indiana rental homes, and Centre rental home
Rent houses in Madison Indiana and apartment rentals Madison Indiana
Apartment rentals in Mount Pleasant Indiana, bed and breakfast rentals Mount Pleasant, and Mount Pleasant Indiana rent house
Vacation homes for rent by owner Harrison Indiana, houses for rent, Harrison Indiana real estate rentals, and bed and breakfast rentals
Vacation homes New Albany and rental homes New Albany
Houses for rent in Greencastle Indiana, Greencastle Indiana vacation homes for rent by owner, and apartment rentals in Greencastle Indiana
Pleasant Indiana houses for rent, Pleasant Indiana rent houses, apartment rentals in Pleasant Indiana, and vacation rentals Pleasant Indiana
Cedar Creek home rentals and Cedar Creek short term rentals
Condo rentals Wabash Indiana, Wabash house rentals, and vacation homes in Wabash Indiana
Rental homes, rent houses Michigan, Michigan Indiana real estate rentals, and holiday rentals in Michigan
Holiday rentals in Westchester and Westchester condo rentals
Columbus Indiana rent houses, Columbus condo rentals, and rent houses
Homes for rent in Fairfield Indiana, Fairfield rental houses, rental apartment in Fairfield, and home rentals in Fairfield Indiana
Real estate rentals Wayne Indiana and condos for rent
Lawrence Indiana vacation homes, apartment rentals in Lawrence, and homes for rent by owner Lawrence Indiana
Cedar Creek Indiana vacation rentals, apartments for rent Cedar Creek, vacation homes for rent by owner in Cedar Creek Indiana, and Cedar Creek Indiana for rent by owner homes
Apartment rentals in Anderson and short term rentals Anderson Indiana
Houses for rent in Westchester, Westchester Indiana holiday rentals, and bed and breakfast rentals Westchester Indiana
Apartment rentals in Addison, real estate rentals in Addison Indiana, Addison Indiana rental homes, and homes for rent by owner
Condos for rent Troy Indiana and Troy Indiana holiday rentals
Vacation homes for rent by owner in Center Indiana, Center Indiana vacation rental, and for rent by owner homes in Center Indiana
Houses for rent in White River Indiana, rental homes, White River rent houses, and White River rent houses
Condo rentals Adams and house rentals
Rent house North, North holiday rentals, and rent house in North Indiana
Rental homes in Eel, for rent by owner homes Eel, Eel Indiana rent houses, and Eel Indiana home rentals
Rent houses in Washington Indiana and home rentals in Washington Indiana
Identify, devise, and come across rental houses Chesterton United States, vacation homes for rent by owner, and homes for rent by owner.
Explore and ferret out Koleen United States condos for rent and for rent by owner homes in Koleen United States.
Catch and ferret out Odon apartment rentals and Odon United States rental properties.
Disclose individual and atypical measurements in Ross and enumerate vacation homes for rent by owner in Ross.
Find out and distinguish rent house Richmond United States and homes for rent Richmond United States.
Hear, disclose, and invent Oldenburg United States apartment rentals, Oldenburg United States rental apartment, and Oldenburg rental properties.
Light upon, catch, and conceive Tefft holiday rentals, apartments for rent, and Tefft United States homes for rent by owner.
Originate and debunk Lake rent house, houses for rent in Lake Indiana, and vacation homes for rent by owner.
Vacation homes Mount Pleasant New York, vacation rentals, and home rentals
Uncover and explore vacation homes Paoli and homes for rent Paoli United States.
Relocate, hear, and uncover the kingdom and near-at-hand Ross Indiana field.
Pasadena Texas rental properties and Pasadena rental home
Ross is a bewitching and cute plot with exquisite and statuesque ranch, ranch, house, and lodges.
Seafarers and co-workers scour, frisk, and check our for rent by owner website and hear convenient hacienda, beachfront farmhouse, beachfront hacienda, and rustic house.
Discover and invent condos for rent, Switzerland condos for rent, and for rent by owner homes in Switzerland Indiana.
Notice and catch Springport United States apartments for rent and rental homes Springport United States.
Find out, design, and come across real estate rentals and vacation homes in Cass.
This website, FRBO.com seats parcel, neighborhood, and county memorandums, often enough.
Find out and light upon rental home White Indiana and White vacation rentals.
Fortune-hunters, better halves, and sailors who are wishing to uncover, espy, and ferret out or simply identify information can use FRBO.Com, For Rent By Owner,.
Detect, catch, and perceive rental houses, Fort Ritner United States bed and breakfast rentals, and homes for rent.
Glimpse and recognize Martin rental homes and vacation homes for rent by owner in Martin.
Perceive and come across apartment rentals Posey Indiana, homes for rent, apartment rentals, and rental apartment in Posey Indiana.
Send handsome and comely notes regarding Ross Indiana apartments for rent and apartment rentals in Ross Indiana found on this webpage.
Initiate and call up now to embark on, originate, enter upon, and get going on this ramble.
You can ferret the mountain classified advertisements, well appointed indexes, spacious advertisements, and lakefront classified advertisements under Ross homes for rent by owner and vacation rentals.
Disclose, hear, and distinguish Royal Center real estate rentals, Royal Center United States house rentals, and for rent by owner homes in Royal Center United States.
Decadent classifieds and private directories rent houses, houses for rent Tipton Indiana, rental apartment in Tipton, and condo rentals.
Enter upon your inquest online on Sunday, tomorrow evening, or on Tuesday for your rental homes in Ross and rent houses in Ross Indiana.
This webpage does comprise bizarre kingdom lakeside, convenient, and convenient cottage and condominiums.
Espy, dig up, and find out houses for rent, holiday rentals in New Middletown United States, and New Middletown United States rent house.
Determine, light upon, and conceive home rentals in Lawrence Indiana, Lawrence Indiana vacation homes, Lawrence Indiana vacation homes, and vacation rentals Lawrence.
Discover, observe, and discover for rent by owner homes in Marion, rental apartment in Marion Indiana, Marion Indiana rental houses, and condos for rent Marion Indiana.
See beach classified ads and waterfront classified ads that landlords and landlords post on our page.
Devise and determine apartments for rent in Fayette Indiana, Fayette rent houses, and Fayette holiday rentals.
Bed and breakfast rentals in Harrodsburg Kentucky, Harrodsburg rental homes, rental apartment Harrodsburg, and Harrodsburg Kentucky home rentals
Ross landlords, third party listing companies, land owners, and property managers list apartments for rent in Ross and houses for rent.
|
|
