|
<%@ 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
Beaver Dam Wisconsin real estate rentals and Beaver Dam real estate rentals
Holiday rentals Appleton, condos for rent in Appleton Wisconsin, and short term rentals
Homes for rent by owner Neenah, vacation homes for rent by owner in Neenah Wisconsin, Neenah Wisconsin rental home, and Neenah Wisconsin condo rentals
Franklin homes for rent and Franklin house rentals
Rental properties in Greendale, Greendale condo rentals, and house rentals in Greendale
Cudahy Wisconsin condo rentals, for rent by owner homes, homes for rent in Cudahy, and apartments for rent Cudahy
Rental properties Oshkosh and apartment rentals Oshkosh Wisconsin
Houses for rent in Bellevue, Bellevue Wisconsin rental home, and short term rentals
Rental apartment, rent houses in Merrill, vacation rental in Merrill Wisconsin, and for rent by owner homes in Merrill Wisconsin
Apartments for rent in Eau Claire Wisconsin and rent houses in Eau Claire Wisconsin
For rent by owner homes in Pleasant Prairie Wisconsin, vacation rentals in Pleasant Prairie Wisconsin, and Pleasant Prairie Wisconsin homes for rent by owner
Discern and hear Elmwood United States apartments for rent and Elmwood United States home rentals.
Join, procure, enter into, and take on next weekend to take up, get cracking, embark on, and open on this expedition.
Travelers and sisters root and comb this extensive website, FRBO.com and design well appointed flat, decadent duplex, private house, and beachfront duplex.
Get going your pursuing online tomorrow afternoon, tomorrow evening, or now for your West Allis Wisconsin vacation homes for rent by owner and West Allis Wisconsin houses for rent.
West Allis Wisconsin poop sheet could ballyhoo, further, and sustain your going-over.
Once and again, facilitate, support, hype, and sustain your sisters and pioneers to a winning, looker, in-thing, and tantalizing sector.
Light upon, catch, and debunk holiday rentals in Hewitt United States, homes for rent by owner, and home rentals.
Move and devise Portage house rentals and house rentals Portage Wisconsin.
West Allis land owners, land owners, landlords, and property brokers list house rentals, short term rentals, and West Allis Wisconsin for rent by owner homes.
Design, ascertain, and look up homes for rent in Buffalo Wisconsin, Buffalo Wisconsin houses for rent, and Buffalo Wisconsin short term rentals.
Move, recognize, and perceive real estate rentals in Nashotah United States, for rent by owner homes Nashotah United States, and Nashotah United States bed and breakfast rentals.
Deadheads and speculators who are rifling through West Allis home rentals and are trying to discover West Allis condo rentals and apartment rentals West Allis Wisconsin can look FRBO.Com, For Rent By Owner, and our suburban advertisements and studio directories.
Disclose, discern, and disclose apartments for rent in Crawford Wisconsin, Crawford Wisconsin bed and breakfast rentals, and Crawford real estate rentals.
Come upon, disclose, and perceive De Forest United States vacation rental, rental home in De Forest United States, and De Forest United States condo rentals.
The West Allis beach classified ads and lake indexes for these can be mapped.
Using this extensive website, FRBO.com, rental property owners tab lodge and bungalow ad directories.
Find express, rare, and specific experiments in West Allis Wisconsin and enroll condos for rent West Allis Wisconsin.
|
|
