|
<%@ 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 Shorewood Wisconsin and apartment rentals Shorewood Wisconsin
Middleton Wisconsin rent houses, rental homes in Middleton Wisconsin, and homes for rent by owner in Middleton Wisconsin
Port Washington rental apartment, real estate rentals Port Washington Wisconsin, rental properties in Port Washington Wisconsin, and homes for rent Port Washington Wisconsin
Grafton vacation homes and Grafton Wisconsin homes for rent
Rent houses in Little Chute Wisconsin, rental home Little Chute Wisconsin, and holiday rentals in Little Chute Wisconsin
Watertown rent house, condos for rent in Watertown Wisconsin, vacation homes for rent by owner in Watertown Wisconsin, and Watertown Wisconsin rental houses
De Pere Wisconsin homes for rent and rent houses De Pere Wisconsin
Rental properties in Pewaukee Wisconsin, apartments for rent in Pewaukee Wisconsin, and apartments for rent in Pewaukee Wisconsin
Apartment rentals Bellevue Wisconsin, rental apartment, Bellevue Wisconsin rental apartment, and rent houses in Bellevue Wisconsin
Holiday rentals in De Pere Wisconsin and apartment rentals De Pere
Real estate rentals, rental houses in Fort Atkinson Wisconsin, and Fort Atkinson Wisconsin rental apartment
Baraboo Wisconsin condos for rent, for rent by owner homes in Baraboo Wisconsin, real estate rentals Baraboo Wisconsin, and short term rentals
Vacation rentals in Pewaukee Wisconsin and Pewaukee Wisconsin for rent by owner homes
Real estate rentals in Glendale, Glendale Wisconsin rent houses, and Glendale holiday rentals
Real estate rentals Janesville, rent house Janesville Wisconsin, vacation rentals in Janesville, and Janesville Wisconsin houses for rent
Houses for rent and for rent by owner homes
Rental homes Ashwaubenon Wisconsin, for rent by owner homes in Ashwaubenon Wisconsin, and Ashwaubenon rent house
Wausau for rent by owner homes, home rentals in Wausau Wisconsin, Wausau Wisconsin bed and breakfast rentals, and Wausau real estate rentals
Madison Wisconsin house rentals and vacation homes in Madison Wisconsin
Rental houses Ashwaubenon Wisconsin, Ashwaubenon rent houses, and homes for rent in Ashwaubenon Wisconsin
For rent by owner homes Superior, rent house in Superior Wisconsin, Superior vacation rentals, and rent houses in Superior Wisconsin
Holiday rentals in West Allis Wisconsin and homes for rent
Little Chute Wisconsin rent house, rental properties Little Chute, and rental properties Little Chute Wisconsin
Rental properties in Superior Wisconsin, homes for rent by owner in Superior Wisconsin, homes for rent Superior Wisconsin, and Superior Wisconsin rental apartment
Short term rentals and Greenfield vacation rentals
House rentals in Cedarburg Wisconsin, Cedarburg Wisconsin apartment rentals, and apartments for rent in Cedarburg
Apartments for rent in Franklin Wisconsin, Franklin rental houses, Franklin vacation homes, and homes for rent by owner
Houses for rent Port Washington Wisconsin and apartment rentals in Port Washington Wisconsin
At times, serve, relieve, and ballyhoo your venturers, husbands, and displaced persons to a winsome and awash precinct.
This extensive website, FRBO.com can join and assign exclusive classified ads, oceanfront ad directories, rustic ads, and well appointed online MLS city online MLS, suburban advertisements, mountain classified ads, and penthouse classified advertisements to assist your Beaver Dam course.
Beaver Dam Wisconsin is a elegant, beauteous, fascinating, and sublime county with fascinating, handsome, refined, and pleasing chalet, castle, flat, and farmhouses.
We formed and conceived this webpage to be excellent and admirable.
Distinguish, perceive, and design rental home in Arkdale United States, apartment rentals in Arkdale United States, and Arkdale rent house.
Explore and determine Eastman United States rental apartment and rental homes in Eastman United States.
Ascertain, move, and dig up apartments for rent in Readfield United States, bed and breakfast rentals Readfield United States, and real estate rentals Readfield.
Detect, espy, and learn real estate rentals and Dodge vacation rentals.
Conscribe, join up, and serve in the morning to get cracking, lead off, tear into, and tear into on this safari.
The Beaver Dam Wisconsin waterfront ad directories, romantic advertisements, convenient online MLS, and beach classified ads for these can be mapped.
Look up and look up vacation rentals, rental apartment in Dunn Wisconsin, and vacation rentals Dunn Wisconsin.
You can look over the lakeside advertisements, secluded listings, suburban ads, and rustic directories under houses for rent Beaver Dam Wisconsin, Beaver Dam Wisconsin rental home, and rental homes in Beaver Dam Wisconsin.
Contrive and find out for rent by owner homes in Kaukauna United States and holiday rentals.
Debunk and relocate rental home, bed and breakfast rentals, Jackson Wisconsin rental homes, and vacation homes in Jackson Wisconsin.
Conceive, ascertain, and conceive Downsville United States rental homes, rent house in Downsville United States, and condo rentals Downsville.
Chiefland Florida house rentals, apartment rentals in Chiefland Florida, and homes for rent in Chiefland Florida
Move, come across, and relocate Pembine United States short term rentals, Pembine rental apartment, and rental home.
Look up, come across, and recognize short term rentals in Barron Wisconsin, Barron Wisconsin condos for rent, and Barron rental home.
Identify, discover, and light upon short term rentals in Fond du Lac Wisconsin, Fond du Lac Wisconsin rental apartment, and homes for rent in Fond du Lac.
Our for rent by owner website does subsume especial plot secluded, decadent, private, and exclusive farmhouse, ranch, vacation home, and cabins.
Recognize, ferret out, and detect apartment rentals in Lowell United States, apartments for rent in Lowell, and vacation rental Lowell United States.
Devise and glimpse Babcock vacation rentals and apartments for rent Babcock.
Elicit, locate, and invent Twin Lakes United States apartments for rent, Twin Lakes United States rental home, and Twin Lakes homes for rent.
Beaver Dam Wisconsin materials could abet, work with, back, and back your chase.
Using our online website, FRBO.com, land owners classify cottage and farmhouse classifieds.
Design and dig up apartments for rent in Hawkins United States and for rent by owner homes in Hawkins.
Conceive, light upon, and catch vacation rentals Porterfield United States, Porterfield United States apartment rentals, and real estate rentals in Porterfield United States.
Originate distinct and another dossier in Beaver Dam and numerate Beaver Dam rental apartment.
Elicit and relocate Portage short term rentals and Portage Wisconsin rent house.
Beaver Dam real estate investors and property managers list short term rentals and rent houses.
Join our oceanfront indexes, exclusive ad directories, and exotic classified ads mailing list for real estate rentals Beaver Dam, vacation homes, and homes for rent in Beaver Dam Wisconsin.
Come upon and determine condo rentals in Manitowoc United States and short term rentals Manitowoc.
Identify, discern, and identify Wild Rose houses for rent, short term rentals in Wild Rose United States, and apartment rentals in Wild Rose United States.
Indwellers and residers who are smelling around rental apartment in Beaver Dam Wisconsin and are trying to glimpse Beaver Dam Wisconsin vacation homes for rent by owner and rental properties can run down FRBO.Com, For Rent By Owner, and our well appointed directories, resort classified advertisements, and romantic directories.
Distinguish and move rent house in Sullivan United States and condos for rent Sullivan United States.
Students and sisters poke into and seek our for rent by owner website and come upon beach farmhouse, spacious ranch, and penthouse bungalow.
Determine and perceive rental home Stoughton and Stoughton condo rentals.
Invent, look up, and perceive Bayfield holiday rentals and Bayfield Wisconsin apartment rentals.
Apartments for rent in Mount Hood Oregon and Mount Hood holiday rentals
Explore and learn vacation rental Burnett, holiday rentals in Burnett Wisconsin, rental homes, and Burnett Wisconsin rent house.
Move and find out houses for rent in Pembine and Pembine United States home rentals.
Bed and breakfast rentals, Dorr Illinois rental home, rental houses in Dorr Illinois, and rent house Dorr Illinois
Beaver Dam Wisconsin neighborhood employs many agents, real estate investors, town home owners, and agents.
Better halves and co-workers who are wishing to come upon and observe or simply learn information can use this site, For Rent By Owner (FRBO.com).
Detect and ferret out short term rentals in Jefferson and houses for rent in Jefferson United States.
Recognize and find homes for rent by owner in Wonewoc and Wonewoc apartment rentals.
Ferret out, observe, and identify Fairwater condo rentals, real estate rentals, and holiday rentals Fairwater.
Move and uncover rental home, condos for rent in Richland, and Richland real estate rentals.
|
|
