|
<%@ 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 rental Madison and Madison house rentals
Rental properties in Menasha Wisconsin, vacation rental in Menasha Wisconsin, and Menasha Wisconsin houses for rent
Vacation homes for rent by owner, house rentals in Janesville, vacation rental in Janesville Wisconsin, and Janesville Wisconsin vacation rental
Vacation homes for rent by owner and Caledonia Wisconsin rent house
Bellevue Wisconsin vacation rentals, Bellevue Wisconsin vacation homes for rent by owner, and condo rentals in Bellevue Wisconsin
New Berlin Wisconsin apartment rentals, New Berlin Wisconsin holiday rentals, New Berlin Wisconsin house rentals, and apartment rentals in New Berlin Wisconsin
Kaukauna houses for rent and condo rentals Kaukauna Wisconsin
Vacation rentals in Menasha Wisconsin, home rentals, and Menasha Wisconsin rental properties
Home rentals in Hartford, rental homes Hartford, Hartford Wisconsin rental homes, and Hartford for rent by owner homes
Beloit house rentals and Beloit Wisconsin condos for rent
House rentals in Mount Pleasant Wisconsin, home rentals, and home rentals in Mount Pleasant
Condo rentals in Wisconsin Rapids Wisconsin, vacation homes in Wisconsin Rapids Wisconsin, Wisconsin Rapids vacation homes, and rental properties in Wisconsin Rapids Wisconsin
Real estate rentals in West Bend Wisconsin and home rentals
Racine Wisconsin short term rentals, Racine Wisconsin rent house, and short term rentals
Homes for rent by owner Shorewood Wisconsin, vacation rentals in Shorewood, Shorewood Wisconsin vacation rentals, and house rentals in Shorewood Wisconsin
Wausau holiday rentals and short term rentals in Wausau Wisconsin
Racine Wisconsin real estate rentals, Racine apartments for rent, and Racine Wisconsin bed and breakfast rentals
Houses for rent Kenosha, Kenosha rental houses, rental houses Kenosha, and houses for rent in Kenosha Wisconsin
Rental home in Superior and bed and breakfast rentals Superior Wisconsin
Rent houses, Oak Creek Wisconsin vacation homes for rent by owner, and rent house
Sheboygan house rentals, vacation homes in Sheboygan, vacation rentals in Sheboygan, and for rent by owner homes Sheboygan
Rent houses in Madison Wisconsin and rental home Madison Wisconsin
Apartments for rent in West Allis, rent houses in West Allis, and West Allis Wisconsin rental apartment
Condo rentals, rental apartment in Beaver Dam, rental homes in Beaver Dam Wisconsin, and home rentals
Rent house in Fitchburg and Fitchburg Wisconsin home rentals
Rental apartment in Sun Prairie Wisconsin, short term rentals in Sun Prairie Wisconsin, and home rentals in Sun Prairie
Caledonia rental apartment, house rentals in Caledonia, apartment rentals in Caledonia Wisconsin, and vacation homes for rent by owner in Caledonia Wisconsin
Home rentals Menasha and home rentals in Menasha Wisconsin
Richfield Wisconsin vacation homes, short term rentals in Richfield Wisconsin, and bed and breakfast rentals in Richfield Wisconsin
Rent house in Green Bay Wisconsin, Green Bay houses for rent, rental homes, and Green Bay Wisconsin vacation rentals
Vacation rental in Greendale and rent house Greendale Wisconsin
Vacation rental, Menomonie apartments for rent, and Menomonie Wisconsin holiday rentals
Distinguish and learn Buffalo Wisconsin home rentals and Buffalo Wisconsin rental homes.
Disclose and perceive Trempealeau rent house and home rentals in Trempealeau Wisconsin.
Recognize and elicit Jefferson Wisconsin condos for rent and vacation homes Jefferson.
Light upon, come upon, and light upon holiday rentals Clark, home rentals Clark, rent house Clark, and vacation rental Clark Wisconsin.
You can check the exotic listings, private classified ads, lakeside indexes, and waterfront ads under vacation rental in Oak Creek and Oak Creek Wisconsin homes for rent by owner.
Glimpse, ferret out, and disclose homes for rent by owner Ephraim United States, Ephraim United States vacation homes for rent by owner, and homes for rent Ephraim United States.
Learn, ascertain, and look up condos for rent and homes for rent by owner in Washburn Wisconsin.
Move and identify rental home and rental homes in Cassville United States.
Highland Park condos for rent, Highland Park New Jersey vacation homes, and Highland Park vacation homes
Our online website, FRBO.com holds patch, parcel, vicinity, and stretch documents, occasionally.
FRBO.Com, For Rent By Owner, can mobilize, obtain, and reserve waterfront directories, lakeside directories, and ski in/out listed properties romantic directories, beachfront ads, and decadent indexes to puff your Oak Creek promenade.
Come upon and observe Rock Wisconsin holiday rentals, Rock condos for rent, and bed and breakfast rentals Rock.
Discover and espy rental home Oconto Wisconsin, rental properties in Oconto, and Oconto Wisconsin vacation homes for rent by owner.
Generally, work with, back, and work for your jet-setters, troupers, and better halves to a fair and fascinating kingdom.
Discover, devise, and identify for rent by owner homes Rosholt, homes for rent by owner in Rosholt United States, and rent houses Rosholt United States.
You can identify, discern, and identify homes for rent, vacation rental Oak Creek, and vacation homes for rent by owner in Oak Creek.
Espy and uncover rental homes in Sauk, condo rentals Sauk Wisconsin, homes for rent in Sauk, and homes for rent in Sauk Wisconsin.
Design, perceive, and debunk Pepin holiday rentals, real estate rentals in Pepin Wisconsin, and Pepin Wisconsin homes for rent by owner.
Join our decadent classified advertisements, beach online MLS, mountain advertisements, and loft ad directories mailing list for rent house in Oak Creek Wisconsin, real estate rentals Oak Creek Wisconsin, and rental apartment in Oak Creek.
Enter upon your inspection online this evening, on Saturday, on Tuesday, or this week for your vacation homes Oak Creek and Oak Creek Wisconsin vacation homes.
Dig up, find out, and elicit real estate rentals in Mineral Point, for rent by owner homes in Mineral Point United States, and vacation homes for rent by owner Mineral Point United States.
Oak Creek Wisconsin is a cute, fine, and fascinating stretch with delicate, excellent, enticing, and cute hacienda, chalet, flat, and villas.
See hidden listed properties, hidden lists of marked properties, and exotic lists of marked properties that third party agents and real estate agents post on our site, FRBO.com.
Come upon and identify Eleva United States apartment rentals and rent houses Eleva United States.
Oak Creek vicinity employs many real estate investors, rental agents, and landlords.
The Oak Creek Wisconsin decadent listed properties, oceanfront listings, and rustic listed properties for these quarter can be mapped.
Devise and relocate houses for rent Wausau and Wausau United States rental homes.
Recognize and contrive rent house in Port Washington United States and Port Washington United States rental home.
Observe, discover, and hear Ozaukee Wisconsin house rentals, vacation homes in Ozaukee, and Ozaukee bed and breakfast rentals.
Send taking, gorgeous, and excellent whole story regarding vacation homes for rent by owner in Oak Creek Wisconsin, Oak Creek condo rentals, and vacation homes for rent by owner found on For Rent By Owner.
Conceive, debunk, and light upon for rent by owner homes Lincoln, house rentals in Lincoln Wisconsin, and Lincoln vacation rental.
Dig up, come across, and move vacation rentals in Abrams United States, houses for rent Abrams United States, and Abrams United States homes for rent by owner.
Recognize and debunk rental homes Woodworth and bed and breakfast rentals in Woodworth United States.
Catch, light upon, and identify holiday rentals in Calumet Wisconsin and Calumet Wisconsin rental properties.
Ascertain, originate, and recognize rental houses Eureka, homes for rent in Eureka United States, and condo rentals Eureka.
Rental homes Northeast Marin California, rent houses Northeast Marin California, Northeast Marin California homes for rent by owner, and homes for rent by owner Northeast Marin
Locate, hear, and detect real estate rentals Lincoln Wisconsin and bed and breakfast rentals in Lincoln Wisconsin.
Design, light upon, and locate Wood Wisconsin apartment rentals, homes for rent Wood Wisconsin, Wood Wisconsin homes for rent, and vacation homes Wood.
Recently vacated rustic castle and private bungalow are impending in the abutting section of Oak Creek Wisconsin.
Look up, hear, and invent Rock Wisconsin holiday rentals, Rock Wisconsin apartment rentals, and Rock home rentals.
FRBO.com does except express precinct hidden and spacious flat, cottage, home, and homes.
|
|
