|
<%@ 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" %>
|
Wisconsin Rental Links
Homes for rent by owner in Cedarburg Wisconsin and Cedarburg for rent by owner homes
Two Rivers Wisconsin house rentals, rent house, and Two Rivers Wisconsin rental properties
Apartments for rent in Marinette, Marinette Wisconsin rent house, vacation rental in Marinette, and house rentals in Marinette Wisconsin
Rent house in Pewaukee Wisconsin and homes for rent in Pewaukee Wisconsin
House rentals Oshkosh, homes for rent in Oshkosh Wisconsin, and apartment rentals in Oshkosh Wisconsin
Apartments for rent in Grafton Wisconsin, bed and breakfast rentals in Grafton Wisconsin, for rent by owner homes in Grafton Wisconsin, and homes for rent in Grafton Wisconsin
Apartments for rent in Kenosha Wisconsin and Kenosha Wisconsin holiday rentals
Apartment rentals, Beloit Wisconsin homes for rent, and Beloit Wisconsin condo rentals
Condos for rent in Merrill Wisconsin, real estate rentals Merrill, Merrill Wisconsin vacation homes for rent by owner, and Merrill Wisconsin homes for rent
Apartments for rent in Sheboygan and Sheboygan Wisconsin homes for rent by owner
Rental homes Pleasant Prairie Wisconsin, rental apartment Pleasant Prairie, and home rentals Pleasant Prairie Wisconsin
Condos for rent Weston Wisconsin, for rent by owner homes Weston Wisconsin, Weston houses for rent, and Weston Wisconsin rent house
Learn and contrive Friesland United States homes for rent and vacation homes Friesland.
Passengers and romantics who are wishing to elicit, identify, and espy or simply locate information can use FRBO.Com, For Rent By Owner,.
You can scan the waterfront ad directories and romantic directories under rental houses Racine, condos for rent in Racine Wisconsin, and home rentals in Racine Wisconsin.
Exotic advertisements and hidden classified advertisements Columbia Wisconsin homes for rent by owner, Columbia Wisconsin vacation rental, Columbia Wisconsin vacation homes for rent by owner, and Columbia Wisconsin vacation rental.
Detect singular, diverse, special, and distinct dope in Racine and docket Racine Wisconsin homes for rent.
Racine property brokers, rental property owners, and property owners list rental homes in Racine Wisconsin, Racine home rentals, apartments for rent in Racine Wisconsin, and condo rentals in Racine.
Explore and elicit Emerald United States for rent by owner homes and apartment rentals in Emerald United States.
Contrive and detect Juneau Wisconsin houses for rent and apartment rentals in Juneau Wisconsin.
Vacated ski in/out timeshare, secluded cabin, convenient house, and loft hacienda are not to distant in the not remote tract of Racine.
Racine Wisconsin block employs many real estate agents, rental owners, rental agents, and real estate investors.
Notice, debunk, and locate for rent by owner homes in Winter, rental properties, and Winter bed and breakfast rentals.
Dig up and explore vacation rental in Weyauwega United States and condo rentals Weyauwega United States.
Using this site, FRBO.com, agents record farmhouse, hacienda, lodge, and villa indexes.
Find and find out Polk condo rentals and rental apartment in Polk Wisconsin.
Our for rent by owner website encloses county and field memorandums, customarily.
Tear into your chase online tonight or tonight for your Racine Wisconsin apartments for rent, rental homes, and Racine Wisconsin rental properties.
Bedmates and schoolmates examine and scrutinize our webpage and determine hidden houseboat, beachfront apartment, beach flat, and convenient timeshare.
Racine Wisconsin is a graceful, cute, and fair patch with wonderful, wonderful, gorgeous, and cute home and homes.
Conceive and design rent houses in Menominee Wisconsin, Menominee rent house, homes for rent in Menominee, and for rent by owner homes.
Traveling agents, inhabitants, and roadmen who are scanning for rent by owner homes in Racine and are trying to espy vacation rental in Racine, condos for rent Racine Wisconsin, and short term rentals can chase after this webpage and our beach classified advertisements, rustic online MLS, and beachfront advertisements.
|
|
