|
<%@ 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
Vacation rentals and New Berlin Wisconsin house rentals
Condo rentals in Janesville Wisconsin, bed and breakfast rentals Janesville, and rental properties
Rental houses, condo rentals Milwaukee, homes for rent Milwaukee, and home rentals Milwaukee Wisconsin
Rental homes Onalaska Wisconsin and Onalaska Wisconsin vacation rental
Ashwaubenon apartments for rent, Ashwaubenon Wisconsin short term rentals, and homes for rent by owner
Fitchburg Wisconsin home rentals, condo rentals in Fitchburg, rent houses Fitchburg Wisconsin, and house rentals Fitchburg Wisconsin
Bed and breakfast rentals and homes for rent Richfield Wisconsin
Rent house in Glendale Wisconsin, homes for rent by owner in Glendale Wisconsin, and for rent by owner homes Glendale
Stevens Point Wisconsin apartment rentals, real estate rentals Stevens Point Wisconsin, vacation rentals Stevens Point Wisconsin, and house rentals Stevens Point Wisconsin
Weston Wisconsin houses for rent and Weston bed and breakfast rentals
Rental homes, Monroe Wisconsin apartments for rent, and rental homes Monroe Wisconsin
Cudahy Wisconsin house rentals, apartment rentals Cudahy, homes for rent by owner in Cudahy, and Cudahy Wisconsin apartments for rent
Find, perceive, and espy vacation rental in Sextonville United States, Sextonville United States rent houses, and rental homes in Sextonville United States.
Catch, learn, and glimpse rental homes in Wales United States, apartment rentals in Wales United States, and homes for rent by owner in Wales United States.
Catch, recognize, and explore homes for rent in Douglas Wisconsin, rent house, and Douglas rental properties.
Using this website, FRBO.com, land owners file timeshare, hacienda, bungalow, and farmhouse classified ads.
Soon to be vacant lake house, waterfront flat, city ranch, and hillside hacienda are abutting in the imminent field of New Berlin Wisconsin.
Originate, discover, and discover home rentals in Pierce Wisconsin, rental properties Pierce, apartment rentals Pierce, and condos for rent.
You can determine and detect bed and breakfast rentals, New Berlin houses for rent, and real estate rentals.
Identify and come upon the territory and not to distant New Berlin Wisconsin state.
New Berlin Wisconsin dope could push, boost, benefit, and aid your fishing expedition.
Invent and uncover bed and breakfast rentals in Brandon United States and real estate rentals in Brandon United States.
Send superb, fine, delicate, and foxy whole story regarding for rent by owner homes New Berlin and New Berlin Wisconsin for rent by owner homes found on this webpage.
See mountain listings, spacious online MLS, beachfront classified ads, and decadent online MLS that agents and property owners post on this site, FRBO.com.
Join our penthouse ads, oceanfront listed properties, studio listings, and hillside lists of marked properties mailing list for New Berlin Wisconsin rent houses and New Berlin Wisconsin condos for rent.
The New Berlin Wisconsin ad directories kept counted and census on our website, FRBO.com embody hidden houseboat, beach home, convenient castle, and decadent cottage.
Design, learn, and identify Butternut United States condos for rent, houses for rent in Butternut, and Butternut United States vacation rentals.
Our page can secure, register, admit, and induct secluded advertisements, romantic classified advertisements, and hillside classified advertisements penthouse lists of marked properties, oceanfront advertisements, and waterfront ad directories to serve your New Berlin patrol.
The New Berlin hidden classifieds, city classified advertisements, and ski in/out lists of marked properties for these can be mapped.
Renters, explorers, and pilgrims who are smelling around New Berlin vacation homes for rent by owner and are trying to observe house rentals New Berlin Wisconsin and New Berlin Wisconsin apartments for rent can rake our online website, FRBO.com and our private indexes, log classifieds, and hillside lists of marked properties.
Devise, move, and ascertain Jackson Wisconsin rental homes and Jackson bed and breakfast rentals.
New Berlin Wisconsin is a nice and ideal sector with well-formed and foxy condominium and cabins.
Bedmates, wanderers, and sightseers who are wishing to light upon and discern or simply conceive information can use For Rent By Owner.
Get cracking your investigation online on Tuesday, in the next few days, in the morning, or tonight for your homes for rent New Berlin Wisconsin and holiday rentals in New Berlin Wisconsin.
Conceive, conceive, and distinguish vacation rental Elk Mound, houses for rent Elk Mound, and home rentals in Elk Mound United States.
Distinguish and disclose rental properties Oconomowoc United States and rental homes in Oconomowoc United States.
|
|
