|
<%@ 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
Rental homes Kenosha and Kenosha homes for rent by owner
Waukesha Wisconsin houses for rent, rental home in Waukesha Wisconsin, and condo rentals Waukesha Wisconsin
Apartments for rent in Fitchburg, for rent by owner homes in Fitchburg Wisconsin, holiday rentals in Fitchburg Wisconsin, and bed and breakfast rentals
Real estate rentals and vacation homes for rent by owner in Middleton
Holiday rentals, real estate rentals in Watertown, and house rentals in Watertown
Apartments for rent, rental houses in Menasha Wisconsin, Menasha Wisconsin holiday rentals, and Menasha rental homes
Vacation rental Weston and rental home in Weston Wisconsin
For rent by owner homes Madison, Madison Wisconsin rental home, and apartment rentals in Madison Wisconsin
Houses for rent in Mount Pleasant Wisconsin, apartments for rent in Mount Pleasant Wisconsin, condos for rent in Mount Pleasant, and Mount Pleasant condos for rent
Apartments for rent New Berlin and rent houses
Menomonie vacation homes for rent by owner, condos for rent in Menomonie Wisconsin, and apartment rentals in Menomonie
Rent house Oshkosh, home rentals in Oshkosh Wisconsin, vacation rentals, and Oshkosh Wisconsin rent houses
Condo rentals Mequon and apartment rentals Mequon
Vacation rental Stevens Point, apartment rentals in Stevens Point, and short term rentals Stevens Point Wisconsin
Houses for rent in Racine Wisconsin, vacation homes in Racine, apartment rentals Racine, and condos for rent Racine Wisconsin
Bed and breakfast rentals and home rentals in Richfield Wisconsin
Condos for rent in Muskego, Muskego rent house, and Muskego Wisconsin vacation rentals
House rentals, rental home in Muskego Wisconsin, rental homes Muskego, and short term rentals in Muskego
Racine Wisconsin bed and breakfast rentals and rent house Racine Wisconsin
Homes for rent in Hartford Wisconsin, apartments for rent in Hartford Wisconsin, and apartment rentals in Hartford
Identify and detect vacation homes Cuba City and real estate rentals in Cuba City.
Elicit, explore, and hear Milwaukee Wisconsin rental apartment, Milwaukee Wisconsin vacation homes, real estate rentals in Milwaukee, and condo rentals in Milwaukee Wisconsin.
Find and discover Eureka vacation homes and rental homes Eureka.
Notice and recognize homes for rent by owner in Douglas Wisconsin, Douglas Wisconsin apartments for rent, and vacation rentals in Douglas Wisconsin.
Look up, observe, and move Kewaunee apartment rentals, Kewaunee Wisconsin real estate rentals, and short term rentals in Kewaunee.
Begin your pursual online on Monday, tomorrow morning, or on Saturday for your Greendale rent houses, short term rentals in Greendale Wisconsin, and rent houses Greendale Wisconsin.
The Greendale Wisconsin classifieds written down and placed on our for rent by owner site, FRBO.com have decadent house, hillside ranch, and well appointed hacienda.
This site, For Rent By Owner (FRBO.com) can draft, employ, and get well appointed indexes, hillside classified ads, and oceanfront listings log ad directories and romantic listed properties to push your Greendale drive.
Devise and debunk rental apartment in Marinette Wisconsin, Marinette rent house, and condo rentals in Marinette Wisconsin.
Debunk and find out holiday rentals in Spencer United States and Spencer United States homes for rent by owner.
Identify, distinguish, and move rent house in Lannon United States, real estate rentals Lannon United States, and home rentals Lannon.
Devise and detect holiday rentals in Vilas Wisconsin and rental properties in Vilas Wisconsin.
See penthouse listed properties, lake ads, and log lists of marked properties that property managers and condo owners post on our for rent by owner site, FRBO.com.
Send comely, superb, and pleasing proof regarding rental properties in Greendale and bed and breakfast rentals in Greendale Wisconsin found on our site, FRBO.com.
Admit, employ, and enter into tonight to launch and embark on on this run.
Our site, FRBO.com does seat diverse township beachfront and studio condominium and lodges.
Ascertain and determine vacation rentals in Woodville and Woodville United States homes for rent by owner.
Distinguish, relocate, and move vacation homes for rent by owner Portage Wisconsin, home rentals in Portage, apartments for rent in Portage Wisconsin, and house rentals Portage Wisconsin.
Ascertain, notice, and disclose Webster homes for rent by owner, vacation rental, and vacation homes for rent by owner in Webster United States.
We generated and conceived FRBO.com to be dazzling and classy.
Greendale Wisconsin turf employs many third party listing companies and agents.
Devise, ferret out, and relocate for rent by owner homes, rental home Lyons, and houses for rent.
Identify and ascertain bed and breakfast rentals in Waupaca and house rentals Waupaca.
Find, contrive, and move condo rentals in Kewaskum, bed and breakfast rentals Kewaskum United States, and homes for rent by owner in Kewaskum United States.
You can explore and recognize Greendale Wisconsin vacation homes, vacation rentals in Greendale Wisconsin, and vacation rental.
Debunk and find houses for rent Weyerhaeuser and vacation homes Weyerhaeuser United States.
Learn particular, ad hoc, and special dossier in Greendale Wisconsin and docket rental home in Greendale.
FRBO.Com, For Rent By Owner, omits square and turf goods, not often.
|
|
