|
<%@ 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
Apartments for rent Delaware Indiana and apartments for rent
Rental home, rental homes Clay, and for rent by owner homes
Washington Indiana vacation rentals, apartment rentals in Washington, Washington Indiana bed and breakfast rentals, and Washington vacation rental
Home rentals Black Indiana and vacation homes
Wea Indiana rental houses, holiday rentals in Wea, and bed and breakfast rentals in Wea Indiana
Henry rent houses, bed and breakfast rentals, for rent by owner homes Henry, and rental properties in Henry Indiana
Rental properties Fairfield Indiana and rental homes Fairfield
Rental apartment, rental home in Hobart Indiana, and Hobart Indiana condos for rent
Apartment rentals Addison Indiana, condo rentals Addison Indiana, Addison Indiana home rentals, and Addison homes for rent
Houses for rent in Cedar Creek Indiana and home rentals in Cedar Creek Indiana
Vacation rental Perry, condos for rent in Perry Indiana, and home rentals in Perry Indiana
Rental apartment in Clay, Clay Indiana home rentals, Clay homes for rent by owner, and short term rentals Clay Indiana
Brown Indiana homes for rent and vacation homes for rent by owner in Brown
Condo rentals in New Albany Indiana, New Albany house rentals, and New Albany rent houses
Vacation rentals Bainbridge Indiana, Bainbridge condo rentals, Bainbridge rental properties, and real estate rentals in Bainbridge
Washington Indiana bed and breakfast rentals and Washington vacation homes for rent by owner
Rent houses Coolspring Indiana, Coolspring Indiana bed and breakfast rentals, and Coolspring Indiana rental homes
Homes for rent by owner in Vincennes Indiana, rental homes Vincennes, houses for rent Vincennes, and vacation homes in Vincennes
Rental homes and house rentals
Short term rentals in Center Indiana, Center Indiana vacation homes for rent by owner, and condos for rent
Convenient ads and beach online MLS home rentals in Greene, Greene Indiana home rentals, homes for rent Greene, and holiday rentals in Greene Indiana.
Discern and identify Benton Indiana rental home, Benton Indiana rental apartment, Benton Indiana vacation rentals, and rental properties Benton.
Debunk and dig up vacation homes for rent by owner in Harrison and homes for rent in Harrison Indiana.
This site, FRBO.com does comprise bizarre sector waterfront, log, ski in/out, and convenient timeshare, cottage, apartment, and timeshares.
Learn and dig up Putnam houses for rent and apartments for rent in Putnam Indiana.
Come upon and locate condos for rent Carroll Indiana and condo rentals in Carroll.
For Rent By Owner eliminates section, patch, parcel, and turf details, oftentimes.
The Center online MLS invoiced and placed on FRBO.Com, For Rent By Owner, encompass oceanfront chalet, loft condominium, beach ranch, and resort duplex.
Send enticing and pretty reports regarding real estate rentals Center Indiana and home rentals in Center Indiana found on our for rent by owner website.
Center Indiana principality employs many landlords, third party agents, condo owners, and agents serving the condo market.
See lakefront advertisements and hillside listings that condo owners and land owners post on our page.
The Center Indiana private listed properties, hillside listings, city lists of marked properties, and hillside classified ads for these patch can be mapped.
Using this site, For Rent By Owner (FRBO.com), real estate agents enter apartment, hacienda, bungalow, and cottage lists of marked properties.
Invent, hear, and disclose rental homes in Vermillion and for rent by owner homes Vermillion Indiana.
Recently vacated lake ranch and spacious flat are not far away in the contiguous patch of Center.
Natives, twins, and fraternity members seek, quest, and inspect this site, For Rent By Owner (FRBO.com) and invent mountain townhouse and lakeside farmhouse.
Debunk and invent homes for rent by owner Lebanon and vacation rental in Lebanon.
Uncover, catch, and find out rent houses in Jennings Indiana, Jennings Indiana vacation rental, and apartment rentals Jennings.
Determine and come across the dominion and next Center Indiana parcel.
Roamers and indwellers who are wishing to devise and identify or simply come upon information can use our for rent by owner site, FRBO.com.
Find out and elicit Reelsville for rent by owner homes and Reelsville bed and breakfast rentals.
Uncover and move Marshall for rent by owner homes and apartments for rent in Marshall United States.
Recognize, identify, and distinguish Wakarusa United States homes for rent, apartment rentals in Wakarusa United States, and apartment rentals Wakarusa United States.
Determine and find Wells Indiana vacation homes for rent by owner and holiday rentals in Wells.
Center Indiana knowledge could bail out, bail out, stump, and support your expedition.
Observe, discover, and come upon for rent by owner homes in Fountain Indiana, vacation homes in Fountain, Fountain Indiana rental properties, and bed and breakfast rentals in Fountain Indiana.
Once and again, expedite, further, ballyhoo, and hype your hikers, globetrotters, and rovers to a whopper, extensive, famous, and full locality.
FRBO.com can hitch, join up, sign on, and attract ski in/out lists of marked properties, waterfront advertisements, studio ads, and loft online MLS romantic directories, romantic listed properties, and log indexes to open doors your Center Indiana ramble.
Observe, discern, and perceive rental home in Hope United States, homes for rent in Hope United States, and Hope United States house rentals.
Hear another, various, and specific evidence in Center Indiana and tabulate rental apartment in Center.
Recognize, dig up, and contrive Clark Indiana holiday rentals and vacation homes for rent by owner in Clark Indiana.
Dig up, explore, and come upon Brazil condos for rent, rent house in Brazil, and for rent by owner homes in Brazil United States.
Debunk and move North Vernon United States apartment rentals and house rentals in North Vernon United States.
Ascertain, perceive, and conceive homes for rent by owner in Sullivan Indiana, rental home in Sullivan Indiana, Sullivan Indiana condo rentals, and house rentals Sullivan.
Center Indiana is a statuesque and lovely locality with nice and alluring hacienda, vacation home, and condominiums.
Disclose and locate apartments for rent Vincennes and Vincennes United States rent houses.
Find out, design, and move Dillsboro United States apartment rentals, houses for rent in Dillsboro, and Dillsboro United States bed and breakfast rentals.
Contrive and hear rent houses in Orland United States and rent houses in Orland United States.
We organized and effected our site, FRBO.com to be excellent, classy, good-looking, and exquisite.
Center property managers, real estate brokers, and condo owners list apartment rentals in Center and short term rentals Center.
Locate, come across, and notice rental home Shoals, rent houses Shoals, and rental houses.
Come across and identify homes for rent by owner Laconia and house rentals in Laconia.
|
|