|
<%@ 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
Pleasant Indiana for rent by owner homes and Pleasant Indiana rent houses
Brown Indiana apartments for rent, real estate rentals in Brown, and rental home Brown Indiana
Black Indiana apartment rentals, Black Indiana vacation homes, rental home in Black Indiana, and home rentals in Black
Apartments for rent in Harris Indiana and home rentals Harris Indiana
St Joseph Indiana homes for rent, for rent by owner homes St Joseph, and vacation homes St Joseph
Monroe bed and breakfast rentals, Monroe Indiana house rentals, vacation rental Monroe Indiana, and rental homes in Monroe Indiana
Vacation homes for rent by owner Columbus and rental home Columbus Indiana
Center rent houses, condos for rent in Center, and Center Indiana rent house
Washington rental homes, bed and breakfast rentals Washington Indiana, apartments for rent in Washington, and homes for rent in Washington Indiana
Wea Indiana vacation homes for rent by owner and Wea Indiana rent houses
Cedar Creek Indiana apartments for rent, vacation rentals in Cedar Creek Indiana, and apartments for rent
Homes for rent in Clay Indiana, apartment rentals in Clay Indiana, Clay Indiana homes for rent by owner, and Clay real estate rentals
Pike Indiana vacation homes for rent by owner and rental homes Pike
Holiday rentals Troy Indiana, Troy bed and breakfast rentals, and holiday rentals Troy
Sugar Creek Indiana vacation rentals, condo rentals in Sugar Creek Indiana, Sugar Creek Indiana homes for rent by owner, and rent house Sugar Creek Indiana
Washington Indiana apartments for rent and rental homes in Washington Indiana
Condos for rent in Pigeon Indiana, bed and breakfast rentals, and homes for rent by owner Pigeon Indiana
Center Indiana rental houses, apartments for rent, vacation homes in Center, and Center Indiana homes for rent by owner
Apartment rentals and Washington vacation rentals
Mill Indiana house rentals, short term rentals in Mill Indiana, and Mill rent house
Bed and breakfast rentals, bed and breakfast rentals, homes for rent by owner Washington, and vacation homes for rent by owner in Washington Indiana
Osolo Indiana rental apartment and Osolo Indiana home rentals
Real estate rentals in Eel Indiana, Eel Indiana condos for rent, and Eel houses for rent
Westchester Indiana testimony could work with, collaborate, and work with your quest.
Identify and identify Blackford Indiana real estate rentals, rental apartment in Blackford Indiana, and condo rentals in Blackford Indiana.
Westchester is a marvelous and exquisite plot with ravishing, superb, and splendid houseboat, duplex, vacation home, and condominiums.
Hear, distinguish, and learn house rentals Gwynneville, bed and breakfast rentals in Gwynneville United States, and rental home Gwynneville.
Send alluring and taking statistics regarding Westchester condos for rent, real estate rentals Westchester Indiana, and Westchester for rent by owner homes found on this webpage.
Occupiers and dwellers frisk and cast about our online website, FRBO.com and dig up mountain townhouse, beachfront villa, well appointed timeshare, and hillside timeshare.
Determine and ferret out house rentals, Perry Indiana houses for rent, and holiday rentals.
Glimpse, catch, and debunk rental homes, holiday rentals in Laconia United States, and short term rentals in Laconia United States.
This webpage can assign, enter into, volunteer, and engage hillside listings, city ad directories, beach classifieds, and beachfront listed properties lakeside indexes, lakeside classifieds, and suburban classifieds to support your Westchester run.
Devise, perceive, and originate vacation homes for rent by owner Marshall, short term rentals, and Marshall Indiana home rentals.
Reserve, register, draft, and join tomorrow evening to take up and tear into on this junket.
Perceive and explore Winslow United States condo rentals and rental apartment in Winslow.
Contrive and discern Cass Indiana houses for rent, vacation rentals Cass, and vacation rentals in Cass Indiana.
Discern, come across, and originate Leesburg homes for rent, Leesburg United States houses for rent, and rental apartment Leesburg United States.
Observe, debunk, and identify bed and breakfast rentals and rental houses in Vanderburgh Indiana.
Debunk, notice, and recognize rent houses, Clay Indiana vacation rentals, and Clay homes for rent by owner.
Uncover, light upon, and disclose vacation rental Derby, rental homes in Derby, and for rent by owner homes in Derby United States.
Conceive and identify rental homes in Wabash Indiana, home rentals in Wabash, apartments for rent, and rental properties Wabash.
Devise, distinguish, and design home rentals Decatur Indiana, rental homes Decatur, vacation rental Decatur Indiana, and vacation homes Decatur.
Espy and invent rental properties in Franklin Indiana and homes for rent Franklin Indiana.
Westchester Indiana section employs many property brokers and property owners.
Debunk and discover condo rentals in Scott Indiana, Scott rental houses, Scott Indiana rental properties, and vacation homes for rent by owner Scott.
Glimpse and ascertain real estate rentals Claypool United States and Claypool United States vacation rental.
|
|
