|
<%@ 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
Whitewater Wisconsin condo rentals and apartments for rent in Whitewater
Baraboo Wisconsin apartment rentals, rental properties in Baraboo, and Baraboo Wisconsin house rentals
Vacation rental in Fort Atkinson Wisconsin, rental home in Fort Atkinson, bed and breakfast rentals Fort Atkinson, and Fort Atkinson Wisconsin vacation homes
Condo rentals in Menomonie Wisconsin and vacation rentals in Menomonie Wisconsin
South Milwaukee Wisconsin vacation homes, condo rentals, and rental home in South Milwaukee
Homes for rent by owner, apartments for rent in Greenfield, for rent by owner homes Greenfield Wisconsin, and rent houses Greenfield
Apartment rentals in Cudahy and Cudahy Wisconsin houses for rent
Holiday rentals in Baraboo Wisconsin, condos for rent, and apartment rentals Baraboo
Homes for rent in Hartford Wisconsin, holiday rentals in Hartford Wisconsin, for rent by owner homes Hartford, and rental houses in Hartford Wisconsin
Janesville holiday rentals and Janesville house rentals
Apartment rentals Fond du Lac Wisconsin, holiday rentals in Fond du Lac Wisconsin, and Fond du Lac Wisconsin for rent by owner homes
Catch and move rental houses and Crawford Wisconsin rental home.
Send alluring, comely, admirable, and enticing proof regarding apartment rentals in Two Rivers, bed and breakfast rentals Two Rivers, Two Rivers house rentals, and vacation rental in Two Rivers Wisconsin found on this site, For Rent By Owner (FRBO.com).
Embark on your going-over online this evening, day after tomorrow, or in the morning for your Two Rivers Wisconsin vacation homes and Two Rivers Wisconsin vacation homes for rent by owner.
Move and come across holiday rentals and bed and breakfast rentals.
Our site, FRBO.com does comprise unusual territory lake and city chalet, bungalow, condominium, and chalets.
You can disclose, design, and locate rental home Two Rivers, real estate rentals in Two Rivers Wisconsin, and Two Rivers apartments for rent.
Light upon, dig up, and devise rental homes Wautoma United States, Wautoma United States condos for rent, and Wautoma United States vacation homes.
Using our site, FRBO.com, landlords tab ranch, duplex, bungalow, and castle directories.
We fabricated and initiated our for rent by owner website to be symmetrical, nice, and elegant.
Ascertain, learn, and perceive Neillsville rental homes, rental home Neillsville, and apartment rentals Neillsville United States.
Join our oceanfront listings, exclusive indexes, lake listed properties, and lakefront advertisements mailing list for homes for rent by owner in Two Rivers Wisconsin and bed and breakfast rentals in Two Rivers.
Find, ascertain, and recognize the patch and handy Two Rivers turf.
Conceive, identify, and originate Marinette Wisconsin vacation homes, Marinette Wisconsin vacation rentals, apartments for rent, and Marinette Wisconsin home rentals.
Two Rivers rental agents, town home owners, condo owners, and third party listing companies list bed and breakfast rentals in Two Rivers and rental properties in Two Rivers.
Dig up and devise home rentals in Dunn Wisconsin, Dunn Wisconsin rental properties, and holiday rentals in Dunn Wisconsin.
Two Rivers field employs many real estate investors, property owners, and real estate investors.
Our webpage comprises quarter, section, and tract brass tacks, not seldom.
|
|
