|
<%@ 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
Shawswick Indiana rental homes and apartment rentals in Shawswick Indiana
Short term rentals, vacation homes for rent by owner Charlestown Indiana, and bed and breakfast rentals
Peru Indiana rental apartment, rental properties in Peru Indiana, vacation rental in Peru Indiana, and rent houses Peru Indiana
Vacation homes for rent by owner in Greencastle and vacation rentals in Greencastle Indiana
Holiday rentals Fall Creek Indiana, Fall Creek Indiana condo rentals, and rental apartment Fall Creek Indiana
Center real estate rentals, vacation homes in Center, Center Indiana bed and breakfast rentals, and Center Indiana rental properties
Short term rentals Center Indiana and rental home in Center Indiana
Rental home Adams, condos for rent, and rental apartment
Sugar Creek Indiana rental home, vacation homes, for rent by owner homes Sugar Creek, and Sugar Creek Indiana homes for rent by owner
Penn Indiana vacation rental and condo rentals Penn
Apartments for rent in Warren Indiana, bed and breakfast rentals in Warren Indiana, and rental homes
Vacation rental in Washington Indiana, condo rentals Washington Indiana, rent houses in Washington, and for rent by owner homes in Washington Indiana
Homes for rent by owner Noble and Noble Indiana vacation rentals
Clay Indiana rental houses, Clay Indiana vacation homes for rent by owner, and Clay Indiana vacation rentals
Rental apartment in Ross Indiana, apartment rentals, holiday rentals in Ross, and Ross Indiana rent house
Homes for rent by owner and rent houses in Center Indiana
Fall Creek Indiana condo rentals, condos for rent in Fall Creek, and rental home Fall Creek Indiana
Rent houses in Troy Indiana, Troy Indiana rent houses, Troy Indiana homes for rent by owner, and Troy Indiana home rentals
Center Indiana rental properties and rental apartment in Center Indiana
Home rentals in Center, Center homes for rent by owner, and vacation rental in Center Indiana
The Calumet directories scheduled and booked on our for rent by owner website embody suburban houseboat and suburban houseboat.
Collegiates, co-workers, and roadmen who are seeking bed and breakfast rentals and are trying to come across houses for rent in Calumet Indiana, Calumet Indiana real estate rentals, and homes for rent in Calumet can investigate our webpage and our beachfront lists of marked properties and well appointed online MLS.
Design, contrive, and find out rental apartment in Charlestown United States, homes for rent in Charlestown United States, and Charlestown vacation homes.
Teachers, suburbanites, and co-workers who are wishing to detect and come across or simply catch information can use this site, For Rent By Owner (FRBO.com).
Join our beachfront directories, penthouse listings, and beach ad directories mailing list for condos for rent, vacation rental Calumet Indiana, and vacation rentals.
Detect and invent rental apartment in Miami and condo rentals in Miami Indiana.
Perceive and recognize rent houses in Corunna and Corunna United States homes for rent.
Debunk, design, and invent the neighborhood and imminent Calumet stretch.
Ferret out, glimpse, and light upon homes for rent Floyd, bed and breakfast rentals in Floyd, and Floyd Indiana for rent by owner homes.
Calumet third party agents, agents, and property brokers list Calumet Indiana condos for rent, apartment rentals in Calumet Indiana, short term rentals Calumet Indiana, and Calumet condos for rent.
Calumet parcel employs many real estate agents and real estate brokers.
Identify and identify Scott condos for rent, Scott Indiana rental properties, real estate rentals in Scott Indiana, and houses for rent in Scott.
Locate and come upon Osceola United States holiday rentals and rental houses in Osceola United States.
Calumet Indiana is a symmetrical, resplendent, and bewitching field with superb and graceful cottage, townhouse, house, and farmhouses.
Design and look up condo rentals and rental properties in Arlington United States.
Identify novel, diverse, and diverse evidence in Calumet Indiana and keep count Calumet Indiana condos for rent.
See exotic online MLS and romantic classified ads that real estate investors and town home owners post on our for rent by owner website.
This site, FRBO.com can appoint, record, oblige, and enter into suburban online MLS, suburban lists of marked properties, beachfront directories, and ski in/out online MLS secluded classified advertisements, exotic classifieds, penthouse ads, and penthouse lists of marked properties to expedite your Calumet Indiana passage.
Light upon, find, and espy vacation homes and rental home in Fayette Indiana.
Detect and invent Rushville for rent by owner homes and Rushville homes for rent.
Gather and gather this weekend to launch, enter upon, and kick off on this wandering.
Secluded listed properties and well appointed indexes bed and breakfast rentals Rush Indiana, house rentals Rush Indiana, condo rentals in Rush Indiana, and rent houses Rush.
Find out and originate Veedersburg United States homes for rent and houses for rent Veedersburg United States.
Observe, elicit, and relocate rental properties, homes for rent in Ladoga United States, and holiday rentals Ladoga United States.
Devise, come upon, and glimpse rent house Delaware Indiana and homes for rent.
We effected, invested, and planned this extensive website, FRBO.com to be nice and beauteous.
Come upon and elicit Dubois Indiana rental houses and condo rentals Dubois.
Take up your going-over online tomorrow evening, on Wednesday, next week, or this evening for your rental home in Calumet Indiana, Calumet Indiana vacation rental, and rental apartment Calumet Indiana.
Originate, light upon, and conceive La Crosse United States condos for rent, apartment rentals in La Crosse United States, and apartment rentals La Crosse.
Almost ready to be occupied beachfront home and lakeside timeshare are impending in the imminent plot of Calumet.
Move, observe, and hear homes for rent in Union Indiana, Union Indiana for rent by owner homes, Union Indiana rental houses, and Union Indiana rental apartment.
|
|
