|
<%@ 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 rentals Richland and Richland Indiana real estate rentals
Fairfield rental home, apartment rentals Fairfield, and apartment rentals in Fairfield Indiana
Rent house, Ross Indiana vacation rental, homes for rent by owner Ross Indiana, and Ross apartment rentals
Rental properties in Vincennes Indiana and Vincennes rent house
Bed and breakfast rentals, St Joseph Indiana bed and breakfast rentals, and condos for rent
New Albany vacation homes for rent by owner, rental homes in New Albany Indiana, New Albany Indiana rental home, and rental houses in New Albany
Condo rentals in Portage Indiana and Portage Indiana vacation homes for rent by owner
Holiday rentals Washington Indiana, home rentals, and apartment rentals in Washington
Vacation rentals in Anderson Indiana, Anderson Indiana apartments for rent, home rentals in Anderson Indiana, and vacation homes in Anderson Indiana
Vacation homes for rent by owner in Center Indiana and Center Indiana rent house
Center condo rentals, rental houses in Center Indiana, and houses for rent
Vacation rentals Harris Indiana, apartment rentals in Harris Indiana, condo rentals in Harris Indiana, and rental houses
Wayne Indiana condos for rent and rental properties
Washington Indiana condos for rent, Washington condo rentals, and Washington Indiana rent houses
Rental homes in Perry, apartment rentals in Perry, Perry vacation homes for rent by owner, and Perry Indiana homes for rent by owner
Eel Indiana vacation rental and for rent by owner homes in Eel Indiana
Clay Indiana houses for rent, condo rentals, and Clay Indiana home rentals
Rental home, Bainbridge Indiana rent house, apartments for rent Bainbridge, and for rent by owner homes Bainbridge Indiana
Home rentals in Pike Indiana and Pike Indiana rental home
Short term rentals in Jeffersonville Indiana, homes for rent in Jeffersonville, and homes for rent by owner in Jeffersonville
Addison holiday rentals, rent houses in Addison Indiana, vacation rental in Addison Indiana, and Addison Indiana apartment rentals
Huntington rental home and Huntington Indiana rental properties
Rental houses in Brown Indiana, apartment rentals, and rent houses in Brown Indiana
Condos for rent in Ohio, Ohio apartments for rent, holiday rentals in Ohio Indiana, and rent houses in Ohio Indiana
Wea Indiana rental homes and vacation rental Wea Indiana
Disclose and recognize house rentals in North Vernon and North Vernon United States vacation rental.
Notice and debunk Walton United States rental home and Walton United States homes for rent.
Learn, originate, and identify vacation rentals in New Ross United States, New Ross vacation homes for rent by owner, and vacation homes New Ross United States.
See loft indexes and exotic classified advertisements that real estate brokers and third party listing companies post on our for rent by owner site, FRBO.com.
Our for rent by owner website can join, procure, and volunteer mountain ad directories, convenient directories, loft ads, and oceanfront advertisements penthouse lists of marked properties and convenient classified ads to serve your Fall Creek Indiana outing.
Hear, come across, and light upon Wolcott United States holiday rentals, Wolcott United States for rent by owner homes, and rent house Wolcott United States.
FRBO.Com, For Rent By Owner, does enclose sundry vicinity mountain and private chalet, duplex, cottage, and villas.
Using this extensive website, FRBO.com, property brokers keep count cabin, condominium, chalet, and villa indexes.
Find out and ascertain real estate rentals in West Lebanon United States and West Lebanon United States holiday rentals.
Come across, hear, and move bed and breakfast rentals Jasper Indiana, apartment rentals in Jasper, apartment rentals Jasper Indiana, and Jasper Indiana homes for rent by owner.
Fall Creek rental owners, real estate investors, and rental agents list home rentals in Fall Creek, homes for rent by owner, rental homes Fall Creek, and real estate rentals in Fall Creek Indiana.
Fall Creek Indiana facts could cooperate, support, further, and ballyhoo your inquest.
Glimpse and detect rental properties in Canaan United States and rental home Canaan.
Our site, FRBO.com embraces township, vicinity, area, and field results, spasmodically.
Enter upon your pursuance online this week, next week, or this week for your rental apartment in Fall Creek and Fall Creek Indiana homes for rent.
Observe, come across, and determine vacation homes Lewisville, rental homes, and home rentals in Lewisville United States.
Send classy, fine, appealing, and beauteous circumstances regarding houses for rent Fall Creek, Fall Creek Indiana apartments for rent, Fall Creek rental properties, and Fall Creek Indiana rental properties found on our online website, FRBO.com.
Discover and ascertain for rent by owner homes in Orange, Orange Indiana for rent by owner homes, condos for rent in Orange, and Orange Indiana rent houses.
Fall Creek Indiana kingdom employs many third party agents, property managers, property owners, and property brokers.
The Fall Creek Indiana exotic classified advertisements, hidden listed properties, romantic classified ads, and rustic ad directories for these can be mapped.
Glimpse and determine rental houses in Linton United States and Linton United States vacation rental.
Explore and learn for rent by owner homes Memphis and Memphis rent house.
You can invent, espy, and distinguish Fall Creek Indiana home rentals and apartments for rent in Fall Creek Indiana.
Perinton New York rent house, vacation rentals in Perinton New York, holiday rentals in Perinton, and Perinton New York apartment rentals
Move, look up, and dig up vacation homes for rent by owner Lagrange, Lagrange homes for rent, and homes for rent in Lagrange.
Debunk, move, and uncover Fulton United States house rentals, rent house Fulton United States, and rent house in Fulton.
Debunk, detect, and discern Miami Indiana short term rentals, rental houses Miami, and condo rentals in Miami Indiana.
Employ and place this week to get going, originate, lead off, and initiate on this crossing.
You can rifle through the city online MLS, studio online MLS, penthouse online MLS, and beach classified advertisements under Fall Creek Indiana apartment rentals, Fall Creek Indiana rental properties, and rent house in Fall Creek.
We invented and generated our for rent by owner website to be sightly, well-formed, admirable, and sublime.
Discover and espy Newport homes for rent and Newport United States apartment rentals.
Contrive and move rent houses and holiday rentals in Washington.
Find out and identify rental home and rent houses.
Discover diverse and distinct scoop in Fall Creek Indiana and inventory apartments for rent in Fall Creek Indiana.
Fall Creek Indiana is a delightful, delicate, admirable, and elegant stretch with angelic, dazzling, and beauteous chalet, castle, duplex, and cottages.
For rent by owner homes in De Pere and De Pere Wisconsin apartment rentals
Find, relocate, and invent apartment rentals in Harrison Indiana and rental properties Harrison Indiana.
Brothers, traveling salesmen, and salesmen who are raking bed and breakfast rentals and are trying to conceive Fall Creek Indiana apartment rentals, Fall Creek Indiana rental properties, and rent house in Fall Creek can comb FRBO.Com, For Rent By Owner, and our lakefront listed properties, ski in/out listed properties, lakeside listings, and well appointed lists of marked properties.
Distinguish and devise short term rentals in Scott and Scott Indiana vacation homes.
Observe and uncover rent houses in Elkhart Indiana, holiday rentals in Elkhart Indiana, and houses for rent.
Come across, devise, and uncover home rentals in Donaldson, Donaldson United States vacation rental, and Donaldson United States homes for rent.
Recognize, identify, and notice Reelsville United States rental houses, condo rentals Reelsville, and condo rentals in Reelsville.
Conceive, ferret out, and glimpse for rent by owner homes, Hayden bed and breakfast rentals, and Hayden rent houses.
Originate, find, and espy rental homes, short term rentals in Union Indiana, and rental apartment in Union Indiana.
Disclose and originate bed and breakfast rentals in Pierceton and short term rentals.
Elicit and find out Floyd home rentals, real estate rentals in Floyd, and rent houses Floyd.
Notice and explore Star City United States rental homes and for rent by owner homes Star City.
|
|
