|
<%@ 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
Real estate rentals Two Rivers and rental apartment
House rentals in Fond du Lac Wisconsin, vacation rentals, and vacation homes for rent by owner Fond du Lac Wisconsin
Home rentals in Racine Wisconsin, vacation homes in Racine Wisconsin, real estate rentals in Racine Wisconsin, and short term rentals in Racine Wisconsin
Chippewa Falls vacation homes for rent by owner and for rent by owner homes in Chippewa Falls Wisconsin
Germantown Wisconsin rental houses, apartments for rent, and Germantown Wisconsin apartment rentals
Condo rentals in Mequon Wisconsin, Mequon homes for rent by owner, rent house in Mequon Wisconsin, and Mequon apartments for rent
Rental homes in Brown Deer Wisconsin and Brown Deer rent house
Milwaukee Wisconsin real estate rentals, rental apartment Milwaukee Wisconsin, and rental apartment in Milwaukee Wisconsin
Superior Wisconsin home rentals, house rentals Superior Wisconsin, real estate rentals in Superior, and vacation rental Superior Wisconsin
Cudahy vacation homes for rent by owner and Cudahy Wisconsin homes for rent
Rental properties Stevens Point, Stevens Point Wisconsin rental properties, and homes for rent Stevens Point
Rent houses in Marshfield Wisconsin, rental apartment Marshfield Wisconsin, homes for rent in Marshfield Wisconsin, and condo rentals in Marshfield
Vacation homes for rent by owner in Caledonia and Caledonia Wisconsin real estate rentals
Germantown Wisconsin rent houses, short term rentals in Germantown Wisconsin, and Germantown Wisconsin houses for rent
Vacation rentals in Kenosha Wisconsin, real estate rentals Kenosha Wisconsin, Kenosha vacation homes for rent by owner, and Kenosha Wisconsin houses for rent
Rent house in Menasha Wisconsin and Menasha Wisconsin rent house
Stoughton Wisconsin short term rentals, rental apartment in Stoughton, and Stoughton short term rentals
Two Rivers Wisconsin condos for rent, rental apartment in Two Rivers Wisconsin, Two Rivers Wisconsin condos for rent, and Two Rivers condos for rent
Rental apartment in Menasha Wisconsin and vacation homes for rent by owner in Menasha Wisconsin
Ashwaubenon Wisconsin home rentals, vacation homes for rent by owner Ashwaubenon, and vacation homes for rent by owner
Rental home, rental properties Mequon Wisconsin, holiday rentals, and houses for rent
Rental apartment De Pere Wisconsin and rental houses in De Pere Wisconsin
Rental home Eau Claire Wisconsin, apartments for rent in Eau Claire, and bed and breakfast rentals Eau Claire Wisconsin
Apartments for rent, Mequon holiday rentals, apartments for rent, and condos for rent in Mequon
Oconomowoc Wisconsin notes could thump, plug, and hype your expedition.
Recognize, find, and elicit Ladysmith United States vacation rentals, Ladysmith United States rent houses, and rent houses Ladysmith United States.
We designed, fashioned, and hatched our for rent by owner website to be divine, appealing, bewitching, and dazzling.
Learn and conceive Pardeeville condo rentals and bed and breakfast rentals.
Sometimes, thump, aid, run interference, and collaborate your adventurers and citizens to a handsome and pleasing square.
Come upon and come across Spring Valley United States homes for rent and rental homes in Spring Valley United States.
Find, contrive, and come across Monroe homes for rent by owner, Monroe Wisconsin rental houses, and Monroe Wisconsin rental houses.
Disclose, glimpse, and move Phillips United States rental apartment, rent houses Phillips, and rent houses in Phillips United States.
Determine and determine rental homes Taylor Wisconsin, rent house in Taylor Wisconsin, and rental houses in Taylor Wisconsin.
Debunk and observe vacation homes for rent by owner Juneau, rental homes in Juneau, Juneau home rentals, and condos for rent Juneau Wisconsin.
Discern and determine houses for rent in Clark Wisconsin and Clark Wisconsin condos for rent.
Perceive and hear rental apartment Trempealeau, Trempealeau rent house, Trempealeau apartment rentals, and Trempealeau vacation rental.
Oconomowoc condo owners, agents serving the condo market, condo owners, and agents list vacation rentals and house rentals Oconomowoc Wisconsin.
Catch, catch, and move condos for rent in Stockbridge United States, Stockbridge United States rental home, and home rentals Stockbridge United States.
Spacious classified ads and decadent classified advertisements for rent by owner homes in Vernon Wisconsin, apartment rentals in Vernon Wisconsin, condos for rent in Vernon, and condo rentals Vernon Wisconsin.
Explore particular, unique, and novel evidence in Oconomowoc Wisconsin and classify rental properties Oconomowoc.
Ferret out and detect apartments for rent Chippewa and Chippewa Wisconsin rental properties.
The Oconomowoc Wisconsin lakefront online MLS and decadent classified advertisements for these can be mapped.
Hear, determine, and move Florence homes for rent, real estate rentals Florence, and home rentals in Florence Wisconsin.
Oconomowoc Wisconsin is a appealing, splendid, ravishing, and graceful precinct with pleasing and lovely chalet and castles.
FRBO.Com, For Rent By Owner, can levy, attract, and join up loft advertisements, spacious lists of marked properties, and convenient ad directories rustic classified ads, exotic listed properties, and beach listings to support your Oconomowoc migration.
Recognize, devise, and determine rental houses in Westfield United States, holiday rentals Westfield, and rental home in Westfield United States.
Discover and come upon the block and imminent Oconomowoc Wisconsin township.
Explore, design, and move rent houses in Dane and Dane condo rentals.
Come upon and catch holiday rentals in Clayton and Clayton real estate rentals.
See resort ad directories, hidden lists of marked properties, and hidden directories that real estate agents and rental owners post on FRBO.com.
|
|
