|
<%@ 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
Sun Prairie Wisconsin home rentals and apartment rentals Sun Prairie Wisconsin
Caledonia Wisconsin real estate rentals, rental apartment in Caledonia Wisconsin, and real estate rentals in Caledonia Wisconsin
Bed and breakfast rentals in Pleasant Prairie, apartments for rent Pleasant Prairie Wisconsin, Pleasant Prairie apartments for rent, and rental homes Pleasant Prairie
Richfield Wisconsin vacation homes for rent by owner and vacation homes for rent by owner in Richfield Wisconsin
Houses for rent Merrill Wisconsin, rental apartment, and apartment rentals in Merrill Wisconsin
Houses for rent in Fond du Lac Wisconsin, rental homes, vacation homes for rent by owner in Fond du Lac Wisconsin, and homes for rent by owner Fond du Lac Wisconsin
Condo rentals and vacation rental Menasha
Eau Claire Wisconsin vacation rental, rent house Eau Claire, and Eau Claire Wisconsin rental homes
Short term rentals in Marshfield Wisconsin, Marshfield vacation homes for rent by owner, apartment rentals, and vacation homes
Marshfield condos for rent and Marshfield rental houses
Bed and breakfast rentals Caledonia, Caledonia apartments for rent, and Caledonia rental apartment
Hartford apartments for rent, condo rentals in Hartford Wisconsin, Hartford homes for rent by owner, and Hartford Wisconsin apartments for rent
Short term rentals in Menomonie Wisconsin and rental home in Menomonie
Rental apartment in Fitchburg Wisconsin, Fitchburg Wisconsin vacation rentals, and condo rentals in Fitchburg
Homes for rent Chippewa Falls Wisconsin, bed and breakfast rentals Chippewa Falls, Chippewa Falls Wisconsin rent house, and vacation homes for rent by owner
Real estate rentals in Menomonie Wisconsin and rental homes Menomonie
Condo rentals Eau Claire, Eau Claire Wisconsin short term rentals, and home rentals
Rental homes in South Milwaukee Wisconsin, bed and breakfast rentals, rent house in South Milwaukee, and South Milwaukee Wisconsin vacation homes
Grand Chute Wisconsin rental homes and vacation rentals
Homes for rent, rental apartment Neenah, and home rentals
Rental houses Grafton Wisconsin, rent house Grafton Wisconsin, rental houses in Grafton, and Grafton rental homes
Homes for rent and vacation homes for rent by owner
Rental houses in Appleton Wisconsin, vacation rental Appleton Wisconsin, and holiday rentals Appleton
Whitefish Bay Wisconsin real estate rentals, rent houses in Whitefish Bay Wisconsin, condo rentals, and Whitefish Bay Wisconsin rent house
Vacation rentals in Weston Wisconsin and vacation homes in Weston
Vacation rentals in Monroe, vacation homes for rent by owner Monroe Wisconsin, and rental properties
Vacation rentals in Brown Deer Wisconsin, apartment rentals Brown Deer Wisconsin, Brown Deer Wisconsin short term rentals, and house rentals
Vacation homes Little Chute Wisconsin and condo rentals in Little Chute
Condo rentals in La Crosse, condos for rent in La Crosse, and vacation rental La Crosse
Espy, determine, and contrive short term rentals Milltown United States, bed and breakfast rentals Milltown, and vacation homes for rent by owner in Milltown United States.
Othello Washington vacation rentals, Othello for rent by owner homes, house rentals in Othello Washington, and apartment rentals
Originate, learn, and light upon Durand United States real estate rentals, rental houses in Durand United States, and houses for rent Durand United States.
Come upon, identify, and recognize for rent by owner homes, rent house Green Valley, and homes for rent by owner in Green Valley United States.
Catch and learn home rentals in Grant and Grant bed and breakfast rentals.
Milwaukee third party agents, property agents, and landlords list Milwaukee Wisconsin homes for rent, homes for rent by owner in Milwaukee, Milwaukee Wisconsin rental homes, and rent house in Milwaukee Wisconsin.
Dig up and learn rent house Butte des Morts United States and vacation rentals in Butte des Morts.
Contrive, ferret out, and locate vacation homes Kiel United States, holiday rentals Kiel, and short term rentals in Kiel.
Shelby charter Michigan condo rentals and home rentals Shelby charter Michigan
Relocate and elicit homes for rent by owner in Mount Hope United States and rental home in Mount Hope United States.
Rental apartment in Holland Michigan, house rentals, and vacation rentals in Holland Michigan
Find, identify, and locate vacation rentals in Door Wisconsin, Door Wisconsin vacation rental, and condos for rent.
Hear, ferret out, and conceive Green Lake rental properties, rental houses in Green Lake United States, and apartment rentals Green Lake United States.
Notice and determine real estate rentals in Kennan United States and rental home in Kennan.
Milwaukee Wisconsin square employs many property owners, real estate investors, real estate agents, and home owners.
This webpage can obtain, enter into, appoint, and enter into private lists of marked properties, convenient classified advertisements, resort online MLS, and private classified advertisements exotic lists of marked properties, private lists of marked properties, and resort classifieds to do for your Milwaukee Wisconsin tour.
Distinguish and identify apartment rentals in Franklin United States and Franklin real estate rentals.
Locate, determine, and explore Centuria home rentals, Centuria United States home rentals, and for rent by owner homes Centuria United States.
Using this site, FRBO.com, real estate investors specify apartment, cottage, chalet, and ranch advertisements.
Residers, coeds, and residers who are wishing to catch, perceive, and explore or simply elicit information can use this site, For Rent By Owner (FRBO.com).
Glimpse, devise, and ferret out Eleva United States condos for rent, Eleva United States house rentals, and home rentals in Eleva United States.
Observe, learn, and invent rent houses in Door Wisconsin, vacation homes for rent by owner in Door Wisconsin, and Door Wisconsin bed and breakfast rentals.
Devise, look up, and observe Outagamie Wisconsin home rentals, Outagamie Wisconsin apartment rentals, and condo rentals Outagamie Wisconsin.
Observe, design, and ascertain rental properties in Arena United States, Arena rent house, and Arena United States condo rentals.
The Milwaukee Wisconsin directories written down and specialized on For Rent By Owner incorporate lake cabin and penthouse apartment.
Milwaukee is a magnificent, gorgeous, radiant, and charming tract with admirable and nice apartment and houses.
Milwaukee Wisconsin figures could abet, plug, and cooperate your perquisition.
Catch and learn apartment rentals Camp Douglas and short term rentals.
You can invent and discern holiday rentals in Milwaukee Wisconsin, homes for rent in Milwaukee, and rental apartment in Milwaukee Wisconsin.
Ferret out, dig up, and uncover holiday rentals Rusk Wisconsin, rental properties, homes for rent Rusk, and Rusk vacation rental.
Relocate, ferret out, and notice Clark home rentals and holiday rentals in Clark Wisconsin.
You can shake down the rustic directories and suburban classified ads under rental homes in Milwaukee Wisconsin and vacation homes.
|
|
