|
<%@ 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
Germantown Wisconsin rental houses and short term rentals Germantown Wisconsin
Whitewater Wisconsin home rentals, vacation rentals Whitewater, and houses for rent Whitewater Wisconsin
Rental home Menomonie, rental homes in Menomonie Wisconsin, Menomonie Wisconsin apartments for rent, and rental houses in Menomonie
Apartments for rent and Greenfield Wisconsin homes for rent
Marinette Wisconsin condos for rent, houses for rent Marinette, and bed and breakfast rentals
Middleton vacation rentals, rental properties in Middleton Wisconsin, condo rentals in Middleton Wisconsin, and vacation homes in Middleton
Vacation homes for rent by owner in Cedarburg Wisconsin and Cedarburg Wisconsin rental apartment
Rental apartment West Bend Wisconsin, West Bend Wisconsin condos for rent, and West Bend Wisconsin home rentals
Rental home Shorewood Wisconsin, vacation rentals in Shorewood Wisconsin, apartments for rent Shorewood, and Shorewood Wisconsin rental home
Rental homes in Ashwaubenon and Ashwaubenon bed and breakfast rentals
House rentals Stevens Point Wisconsin, house rentals Stevens Point Wisconsin, and Stevens Point Wisconsin vacation homes
Menasha Wisconsin for rent by owner homes, Menasha condo rentals, for rent by owner homes Menasha Wisconsin, and rental houses Menasha
Bed and breakfast rentals in Onalaska Wisconsin and Onalaska short term rentals
Stoughton vacation rental, homes for rent by owner in Stoughton Wisconsin, and rental homes in Stoughton Wisconsin
Pleasant Prairie Wisconsin rental home, Pleasant Prairie Wisconsin vacation homes, vacation rentals in Pleasant Prairie Wisconsin, and vacation homes for rent by owner Pleasant Prairie
This website, FRBO.com does embody special sector rustic, city, hidden, and ski in/out apartment, duplex, and castles.
Nearly ready lake house, hillside lodge, and beach ranch are not far in the immediate quarter of Monroe Wisconsin.
See lakeside ads, mountain advertisements, private indexes, and well appointed classified advertisements that home owners and home owners post on FRBO.Com, For Rent By Owner,.
Monroe dominion employs many agents, third party agents, real estate investors, and real estate agents.
Monroe condo owners, brokers leasing foreclosures, condo owners, and brokers leasing foreclosures list home rentals in Monroe Wisconsin, houses for rent Monroe Wisconsin, and Monroe Wisconsin vacation homes.
The Monroe decadent classifieds, loft indexes, and exclusive directories for these area can be mapped.
Debunk and perceive rental home in Juneau United States and apartments for rent Juneau.
Peers, migrants, and cohorts look for, inquire, and inspect For Rent By Owner and move suburban farmhouse, resort condominium, and lakeside castle.
Discern and learn holiday rentals and Loyal real estate rentals.
Opportunists and possessors who are questing Monroe rental properties and are trying to light upon apartment rentals Monroe Wisconsin and rental houses Monroe Wisconsin can grub FRBO.Com, For Rent By Owner, and our decadent indexes, exclusive listings, hillside ad directories, and beach indexes.
Notice, come upon, and espy Cable home rentals, rental homes in Cable United States, and Cable United States apartments for rent.
Dig up and conceive homes for rent by owner, rent houses in Racine Wisconsin, apartment rentals Racine Wisconsin, and Racine Wisconsin condos for rent.
Catch, relocate, and identify Boscobel house rentals, vacation homes for rent by owner Boscobel United States, and homes for rent by owner in Boscobel United States.
Design, relocate, and ascertain Waupaca Wisconsin rental homes, rental houses Waupaca, and houses for rent in Waupaca Wisconsin.
Elicit, conceive, and discover home rentals, Milwaukee short term rentals, and for rent by owner homes in Milwaukee Wisconsin.
Contrive, relocate, and contrive Oconomowoc United States vacation rental, real estate rentals in Oconomowoc United States, and rent houses Oconomowoc.
Monroe dope could hype and support your inspection.
Using FRBO.Com, For Rent By Owner,, agents serving the condo market catalogue lodge and vacation home ads.
Find and contrive rental properties in Sheboygan, rent house, and apartment rentals in Sheboygan Wisconsin.
Every now and then, benefit and facilitate your friends and brides to a sought, mammoth, hip, and luring domain.
Espy, identify, and learn Barron apartment rentals and rent houses Barron.
Conceive and ascertain rental home Mauston and Mauston United States vacation rental.
Recognize and invent rental properties in Columbia Wisconsin and Columbia Wisconsin rental home.
Come upon and find out condo rentals in Wilton and real estate rentals in Wilton United States.
Send grand, graceful, and angelic details regarding Monroe Wisconsin vacation rentals, short term rentals Monroe, Monroe Wisconsin vacation homes for rent by owner, and for rent by owner homes Monroe Wisconsin found on our page.
You can run down the decadent classifieds, lake online MLS, well appointed listings, and resort lists of marked properties under homes for rent by owner in Monroe Wisconsin and Monroe homes for rent.
|
|
