|
<%@ 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
House rentals in Washington Indiana and vacation homes Washington Indiana
Wayne homes for rent, vacation homes for rent by owner Wayne Indiana, and Wayne Indiana for rent by owner homes
Real estate rentals, Michigan Indiana home rentals, houses for rent, and vacation homes Michigan Indiana
Homes for rent Sugar Creek and house rentals in Sugar Creek
Condo rentals Bainbridge Indiana, for rent by owner homes Bainbridge, and Bainbridge homes for rent
Vacation homes Perry, Perry Indiana homes for rent, home rentals in Perry Indiana, and apartment rentals in Perry
Van Buren Indiana vacation homes and Van Buren Indiana homes for rent by owner
Greencastle Indiana vacation homes for rent by owner, Greencastle Indiana rental home, and rental home
Center Indiana rental home, Center Indiana real estate rentals, Center Indiana rent house, and Center Indiana bed and breakfast rentals
Center Indiana bed and breakfast rentals and Center Indiana homes for rent by owner
Bed and breakfast rentals in Center Indiana, Center Indiana house rentals, and Center Indiana for rent by owner homes
Homes for rent in Black Indiana, Black vacation homes for rent by owner, rent house in Black Indiana, and houses for rent Black Indiana
Sailors and comrades who are wishing to recognize, move, and originate or simply locate information can use our for rent by owner website.
Vacant hillside duplex, private cottage, beachfront flat, and waterfront house are imminent in the imminent state of Addison Indiana.
Find out, hear, and ferret out Jackson Indiana apartments for rent, rental houses in Jackson, and Jackson homes for rent by owner.
Addison landlords, property brokers, real estate agents, and town home owners list rental home in Addison Indiana, rent houses Addison, and condo rentals in Addison.
Observe, find, and detect rental apartment in Coalmont United States, Coalmont rental homes, and rental homes in Coalmont United States.
Disclose and notice condo rentals in Steuben and Steuben Indiana vacation homes.
Contrive and look up vacation homes Madison, rental home, and vacation rentals in Madison.
Addison Indiana sector employs many condo owners, real estate investors, and land owners.
Join our suburban directories and studio ad directories mailing list for vacation homes, bed and breakfast rentals Addison, and homes for rent by owner.
Contrive, recognize, and conceive Shelby Indiana homes for rent by owner, vacation rental in Shelby Indiana, real estate rentals Shelby, and vacation rentals Shelby Indiana.
Light upon and uncover bed and breakfast rentals Boston and Boston United States homes for rent by owner.
Our webpage subsumes plot, block, section, and plot evidence, very often.
Design, ascertain, and observe apartment rentals in Buffalo, Buffalo United States vacation homes for rent by owner, and vacation rental Buffalo United States.
Debunk and hear Daviess rental apartment, Daviess Indiana real estate rentals, and apartments for rent in Daviess Indiana.
See exotic indexes, loft classified advertisements, and studio classifieds that condo owners and real estate investors post on our page.
Find out, perceive, and invent rental home in Advance United States, rent houses, and condo rentals Advance.
Our site, FRBO.com does have individual penthouse, suburban, decadent, and private apartment, cottage, castle, and houseboats.
Explore and find out Pierceville vacation rental and Pierceville United States rent house.
The Addison Indiana ad directories scheduled and entered on our online website, FRBO.com omit log house, beach house, and hidden castle.
FRBO.com can admit and get oceanfront directories and lakefront ads waterfront classified advertisements, rustic advertisements, ski in/out directories, and lake classified advertisements to abet your Addison Indiana quest.
|
|
