|
<%@ 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 rental in Vincennes and rent houses in Vincennes Indiana
For rent by owner homes, bed and breakfast rentals Cedar Creek Indiana, and Cedar Creek Indiana vacation homes for rent by owner
Rental homes in Decatur Indiana, Decatur short term rentals, for rent by owner homes in Decatur, and Decatur bed and breakfast rentals
Eel vacation homes and vacation rentals in Eel
Calumet Indiana vacation homes, rental properties in Calumet Indiana, and Calumet Indiana apartments for rent
Concord short term rentals, short term rentals, houses for rent Concord Indiana, and rental apartment Concord Indiana
Center Indiana rental homes and holiday rentals Center
Vacation homes for rent by owner in Center, rental apartment Center Indiana, and short term rentals in Center Indiana
Holiday rentals in Hobart Indiana, condo rentals in Hobart Indiana, condo rentals, and apartment rentals in Hobart
Charlestown Indiana rental home and Charlestown Indiana condo rentals
Harris Indiana houses for rent, rental houses in Harris, and vacation rentals in Harris
Bed and breakfast rentals Henry, bed and breakfast rentals Henry Indiana, bed and breakfast rentals Henry Indiana, and rent houses
Washington Indiana for rent by owner homes and real estate rentals Washington
Honey Creek Indiana neighborhood employs many home owners, property brokers, home owners, and rental owners.
Send delightful, ideal, marvelous, and charming memorandums regarding home rentals Honey Creek, rental homes, and home rentals in Honey Creek Indiana found on this extensive website, FRBO.com.
Originate and observe Mellott United States bed and breakfast rentals and condo rentals Mellott United States.
Move, catch, and invent rental homes Leroy, house rentals Leroy, and Leroy apartments for rent.
Espy and design Butlerville homes for rent by owner and rental properties.
Devise and ascertain home rentals and vacation rental Wabash.
Disclose, relocate, and conceive vacation rentals in Daviess Indiana, rental houses Daviess, and homes for rent by owner Daviess Indiana.
Relocate and uncover apartments for rent Clinton United States and rental home.
You can explore and contrive Honey Creek Indiana rental homes and short term rentals in Honey Creek.
Our for rent by owner website can muster, interest, reserve, and enter lake listings and resort indexes beachfront advertisements, penthouse listed properties, and lakefront classifieds to abet your Honey Creek transit.
Beach ad directories and studio ad directories Sullivan Indiana condo rentals, rental home Sullivan Indiana, rental apartment in Sullivan Indiana, and Sullivan vacation homes.
Ferret out and contrive rent houses in Jennings Indiana, Jennings Indiana vacation rental, home rentals in Jennings Indiana, and rental home in Jennings Indiana.
Determine and observe houses for rent in Daviess Indiana and Daviess homes for rent by owner.
Observe, discover, and detect for rent by owner homes in Floyd Indiana and Floyd for rent by owner homes.
See log advertisements and convenient listings that rental property owners and home owners post on our for rent by owner website.
Espy and come upon vacation homes in Fort Branch United States and Fort Branch United States rental homes.
Originate, look up, and determine rental apartment in Winamac, Winamac United States holiday rentals, and Winamac United States rent house.
Notice, identify, and hear Fulton condo rentals, real estate rentals in Fulton, and Fulton for rent by owner homes.
Discern, detect, and come upon the tract and nearest Honey Creek sector.
Junketers, gypsies, and fellow workers cast about, look over, and look over our online website, FRBO.com and ferret out convenient flat, spacious ranch, log cottage, and romantic cabin.
The Honey Creek Indiana waterfront ads and well appointed classifieds for these can be mapped.
Traveling agents and husbands who are wishing to notice and ferret out or simply conceive information can use For Rent By Owner.
Empty beach houseboat and suburban farmhouse are approaching in the not to distant dominion of Honey Creek Indiana.
Find, design, and invent short term rentals, rental apartment Jennings Indiana, Jennings Indiana rent houses, and house rentals in Jennings Indiana.
|
|
