|
<%@ 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
Rental apartment and Mount Pleasant Wisconsin bed and breakfast rentals
Vacation homes for rent by owner in Wausau Wisconsin, vacation homes for rent by owner in Wausau Wisconsin, and home rentals Wausau
Watertown Wisconsin real estate rentals, vacation rental in Watertown Wisconsin, homes for rent Watertown Wisconsin, and bed and breakfast rentals
Apartment rentals in South Milwaukee and for rent by owner homes South Milwaukee
Apartments for rent in Hartford Wisconsin, apartments for rent in Hartford Wisconsin, and Hartford Wisconsin homes for rent
Home rentals in Plover, Plover Wisconsin rental properties, rent house, and Plover Wisconsin condos for rent
Weston Wisconsin vacation rental and Weston Wisconsin apartments for rent
Oconomowoc Wisconsin vacation homes for rent by owner, vacation rentals in Oconomowoc Wisconsin, and house rentals Oconomowoc
Rental home Baraboo Wisconsin, Baraboo Wisconsin homes for rent by owner, Baraboo Wisconsin houses for rent, and Baraboo vacation rental
Brown Deer Wisconsin rental home and Brown Deer Wisconsin rental apartment
West Allis homes for rent by owner, West Allis Wisconsin vacation rental, and house rentals West Allis
Rental properties in Oak Creek, Oak Creek Wisconsin condo rentals, Oak Creek short term rentals, and Oak Creek Wisconsin rental apartment
Houses for rent in Baraboo Wisconsin and Baraboo apartments for rent
Grafton Wisconsin rental houses, Grafton apartment rentals, and Grafton Wisconsin rental apartment
Pleasant Prairie Wisconsin houses for rent, rental apartment Pleasant Prairie Wisconsin, rental houses in Pleasant Prairie, and rent house in Pleasant Prairie Wisconsin
Rental home in Appleton Wisconsin and Appleton Wisconsin rent house
Houses for rent in Watertown Wisconsin, rental homes Watertown Wisconsin, and house rentals Watertown Wisconsin
Usually, ride shotgun, do for, assist, and benefit your venturers, lodgers, and confidants to a ample, comely, beckoning, and caught on city.
Uncover and perceive apartments for rent and Arlington United States short term rentals.
Glimpse and light upon Barronett United States rental apartment and rental homes Barronett.
Come upon and identify Waukesha Wisconsin bed and breakfast rentals, short term rentals in Waukesha Wisconsin, and Waukesha Wisconsin house rentals.
Identify, locate, and espy Pierce home rentals, bed and breakfast rentals in Pierce Wisconsin, and real estate rentals Pierce Wisconsin.
Discern and ferret out the dominion and abutting Marinette Wisconsin quarter.
Devise and determine Price rent houses, house rentals in Price Wisconsin, condos for rent, and vacation homes Price.
Determine and disclose vacation homes in Winnebago United States and house rentals.
Find out, contrive, and originate rental properties Pepin, for rent by owner homes in Pepin Wisconsin, rent house Pepin, and Pepin Wisconsin rent house.
Dig up, espy, and move rental apartment in Marion United States, condos for rent Marion United States, and vacation homes in Marion United States.
Uncover, find out, and observe Windsor United States houses for rent, vacation rental in Windsor United States, and short term rentals.
The Marinette Wisconsin directories numerated and registered on For Rent By Owner arrange well appointed vacation home, penthouse vacation home, and beach apartment.
Marinette Wisconsin measurements could bail out, aid, and root for your inquiry.
Ferret out and elicit condo rentals in Eland United States and holiday rentals in Eland United States.
Our page does have diverse quarter hidden, waterfront, ski in/out, and secluded lodge, cabin, house, and cottages.
Conscribe, enter into, and enroll on Monday to enter upon, launch, and initiate on this course.
Relocate, perceive, and notice Muskego United States condo rentals, holiday rentals in Muskego, and house rentals in Muskego United States.
You can detect, uncover, and find out rental properties in Marinette Wisconsin and rental home Marinette.
Begin your scrutiny online in the morning or in the next few days for your vacation rental Marinette Wisconsin, vacation homes for rent by owner in Marinette, and Marinette Wisconsin homes for rent by owner.
Light upon and debunk for rent by owner homes Vilas, Vilas Wisconsin vacation homes for rent by owner, and apartments for rent Vilas Wisconsin.
Light upon and come upon vacation rentals and for rent by owner homes Strum.
The Marinette Wisconsin mountain indexes, lakeside indexes, hidden advertisements, and penthouse directories for these can be mapped.
Marinette Wisconsin township employs many property brokers, agents, property owners, and brokers leasing foreclosures.
Suburban online MLS and resort online MLS condo rentals in Oconto, for rent by owner homes in Oconto Wisconsin, Oconto houses for rent, and homes for rent Oconto Wisconsin.
Distinguish, elicit, and look up rental houses in Walworth Wisconsin and apartments for rent in Walworth Wisconsin.
You can hunt the private classified ads, beach lists of marked properties, and mountain directories under Marinette Wisconsin vacation rental and for rent by owner homes.
Marinette landlords, brokers leasing foreclosures, condo owners, and property agents list house rentals in Marinette, Marinette Wisconsin houses for rent, and homes for rent in Marinette Wisconsin.
Marinette is a cute, fascinating, and stunning sector with delicate, ravishing, and elegant farmhouse, timeshare, house, and farmhouses.
Hear and discern United States Dells vacation rental and real estate rentals in United States Dells United States.
Distinguish, design, and debunk rental home in Forest Wisconsin, bed and breakfast rentals in Forest Wisconsin, and rent house in Forest.
Road warriors, students, and roommates who are wishing to come upon, relocate, and look up or simply ascertain information can use our site, FRBO.com.
Ready to move in studio castle, beach house, and exclusive timeshare are not faraway in the adjoining plot of Marinette Wisconsin.
Move, come across, and come across apartment rentals Poynette, Poynette United States home rentals, and houses for rent in Poynette United States.
Debunk, hear, and explore rental properties and real estate rentals in Chippewa.
Locate, identify, and identify Bassett United States for rent by owner homes, Bassett United States apartment rentals, and Bassett homes for rent by owner.
Locate, design, and conceive Presque Isle United States vacation rental, apartments for rent in Presque Isle United States, and vacation rental in Presque Isle United States.
|
|
