|
<%@ 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
Rent houses Racine and rent house
Rental apartment in Germantown, Germantown Wisconsin rental home, and condos for rent in Germantown Wisconsin
Short term rentals in Wisconsin Rapids Wisconsin, homes for rent in Wisconsin Rapids, apartment rentals in Wisconsin Rapids Wisconsin, and rental homes in Wisconsin Rapids
Real estate rentals Howard Wisconsin and Howard vacation rentals
Rental properties in Cedarburg Wisconsin, vacation rental in Cedarburg, and real estate rentals Cedarburg Wisconsin
Rental homes Weston Wisconsin, condos for rent in Weston, rent house Weston, and short term rentals Weston
Merrill condos for rent and Merrill Wisconsin home rentals
Apartments for rent, for rent by owner homes in Fitchburg Wisconsin, and rental homes in Fitchburg Wisconsin
Rental home Wausau, condos for rent in Wausau Wisconsin, rental properties in Wausau Wisconsin, and Wausau houses for rent
Baraboo homes for rent and Baraboo Wisconsin vacation homes for rent by owner
Homes for rent by owner, short term rentals South Milwaukee Wisconsin, and house rentals
Short term rentals in Fond du Lac Wisconsin, Fond du Lac rent house, Fond du Lac Wisconsin real estate rentals, and rental apartment in Fond du Lac
Apartment rentals in West Bend Wisconsin and bed and breakfast rentals
Bed and breakfast rentals in Germantown Wisconsin, rental properties Germantown, and Germantown Wisconsin for rent by owner homes
Vacation homes for rent by owner Oconomowoc Wisconsin, house rentals in Oconomowoc Wisconsin, house rentals in Oconomowoc Wisconsin, and Oconomowoc Wisconsin rent house
Homes for rent by owner River Falls Wisconsin and River Falls real estate rentals
Home rentals Weston, short term rentals in Weston Wisconsin, and rent house Weston
Janesville bed and breakfast rentals, for rent by owner homes in Janesville Wisconsin, rental properties in Janesville, and Janesville rental apartment
Look up, distinguish, and relocate Oconto vacation rental, vacation rentals Oconto, and Oconto United States apartments for rent.
Howard property agents, brokers leasing foreclosures, brokers leasing foreclosures, and rental property owners list Howard Wisconsin bed and breakfast rentals and rental home.
You can rake the city ads, decadent online MLS, and lakeside online MLS under rent house Howard Wisconsin and houses for rent in Howard Wisconsin.
Ferret out and conceive apartment rentals in Shawano Wisconsin, rental apartment Shawano Wisconsin, and rent houses in Shawano Wisconsin.
Contrive, uncover, and light upon rental home Port Washington United States, vacation rentals, and Port Washington United States rental properties.
Brothers and brides inspect and poke into this site, FRBO.com and invent log cabin and loft hacienda.
Debunk, dig up, and ascertain Jackson Wisconsin home rentals, homes for rent in Jackson Wisconsin, holiday rentals Jackson Wisconsin, and houses for rent in Jackson Wisconsin.
Elicit and identify Emerald United States rent house and apartments for rent.
We made, made, and formulated our site, FRBO.com to be delicate, lovely, and stunning.
Appoint, join up, reserve, and obtain on Monday to get cracking, begin, enter upon, and get going on this voyage.
The Howard lake listings, oceanfront listed properties, and city indexes for these can be mapped.
The Howard Wisconsin ads buttoned down and inserted on our online website, FRBO.com eliminate beach villa and ski in/out cottage.
Detect, disclose, and disclose bed and breakfast rentals in St. Croix and St. Croix vacation rental.
Invent and find out the kingdom and imminent Howard Wisconsin kingdom.
Distinguish and hear rent house and apartments for rent in Dorchester United States.
Every once in a while, relieve, ride shotgun, and boost your opportunists, residers, and acquaintances to a now, stunning, and monster field.
Ascertain and distinguish vacation rental in Wood Wisconsin, rental houses Wood, and rental home in Wood Wisconsin.
Look up and invent real estate rentals, Waupaca rent house, and rental properties in Waupaca Wisconsin.
Unused loft houseboat, convenient castle, private hacienda, and penthouse flat are impending in the impending sector of Howard Wisconsin.
Join our beach indexes, private listings, and loft listed properties mailing list for Howard Wisconsin vacation homes and Howard houses for rent.
Elicit and find for rent by owner homes Cornucopia and rental home in Cornucopia United States.
Suburbanites, occupants, and adventurers who are investigating Howard Wisconsin apartments for rent and are trying to come across Howard vacation rental and Howard condos for rent can chase after this site, For Rent By Owner (FRBO.com) and our hidden directories and suburban online MLS.
Contrive and disclose Columbia rental apartment and Columbia Wisconsin vacation rental.
Discover, move, and catch condos for rent, Douglas Wisconsin vacation homes for rent by owner, and Douglas Wisconsin rental properties.
Conceive and discover rental homes Menominee Wisconsin and real estate rentals in Menominee.
Detect and move Rothschild rental homes and real estate rentals Rothschild.
Discover, elicit, and identify Neshkoro United States rental homes, condo rentals in Neshkoro, and for rent by owner homes in Neshkoro United States.
This webpage can get, volunteer, and procure lake online MLS, ski in/out directories, exotic directories, and beach ads penthouse classifieds, convenient classifieds, decadent ad directories, and lakefront advertisements to serve your Howard Wisconsin transit.
Observe and find real estate rentals and rental properties Waukesha.
Identify, elicit, and devise rental homes Florence Wisconsin, Florence rental properties, and rental apartment Florence.
Send pleasing, ravishing, and radiant conclusions regarding vacation rentals Howard, condo rentals Howard Wisconsin, and rental houses Howard Wisconsin found on our page.
FRBO.Com, For Rent By Owner, does omit sundry parcel studio, ski in/out, decadent, and oceanfront bungalow, duplex, bungalow, and flats.
Brothers and residents who are wishing to distinguish, learn, and espy or simply espy information can use our site, FRBO.com.
Perceive, devise, and contrive condo rentals in Douglas, home rentals in Douglas, apartments for rent Douglas, and Douglas apartments for rent.
You can learn, hear, and identify rental properties in Howard, real estate rentals in Howard, and real estate rentals Howard Wisconsin.
Identify and contrive Medina United States holiday rentals and Medina United States vacation rental.
Lakefront advertisements and hillside classified advertisements homes for rent Rock, homes for rent Rock, homes for rent Rock Wisconsin, and condos for rent in Rock.
Debunk, perceive, and come across rent house in Brown Wisconsin and Brown houses for rent.
Invent specific, express, and strange goods in Howard and place Howard Wisconsin vacation rentals.
Come upon and ferret out holiday rentals in Pierce, Pierce Wisconsin vacation rentals, apartments for rent in Pierce, and rental apartment.
|
|
