|
<%@ 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" %>
|
Minnesota Rental Links
Bed and breakfast rentals Rosemount Minnesota and holiday rentals Rosemount Minnesota
Condo rentals Fairmont Minnesota, Fairmont Minnesota rental apartment, and real estate rentals in Fairmont Minnesota
Bed and breakfast rentals St Cloud, vacation rental in St Cloud, St Cloud Minnesota vacation homes, and home rentals in St Cloud
Homes for rent Vadnais Heights and vacation homes for rent by owner
Apple Valley rent house, rent house, and rent house in Apple Valley Minnesota
Ramsey Minnesota for rent by owner homes, rental home Ramsey, holiday rentals Ramsey, and Ramsey Minnesota houses for rent
Houses for rent Marshall and vacation rental in Marshall
Richfield vacation rental, rental apartment, and bed and breakfast rentals in Richfield
Rental home, Savage Minnesota vacation homes, rental home in Savage, and rental apartment
Bed and breakfast rentals in Inver Grove Heights and homes for rent Inver Grove Heights
Bed and breakfast rentals in Brooklyn Park, houses for rent Brooklyn Park Minnesota, and short term rentals in Brooklyn Park Minnesota
Vacation rentals Cottage Grove Minnesota, short term rentals in Cottage Grove Minnesota, rental apartment in Cottage Grove Minnesota, and vacation homes
Traveling agents, venturers, and traveling men who are seeking Crystal vacation homes and are trying to find house rentals Crystal Minnesota and for rent by owner homes in Crystal Minnesota can chase after this extensive website, FRBO.com and our private listed properties and resort advertisements.
Come across, ferret out, and espy vacation rentals in Lincoln Minnesota and vacation rentals in Lincoln Minnesota.
Join our ski in/out classified ads and hidden ad directories mailing list for rent house Crystal Minnesota and short term rentals in Crystal.
Recognize, disclose, and identify home rentals in Fisher United States, rent houses Fisher United States, and vacation rentals Fisher.
Contrive and notice Cass Minnesota house rentals, vacation homes for rent by owner in Cass Minnesota, and bed and breakfast rentals in Cass Minnesota.
Observe and move Littlefork short term rentals and apartment rentals in Littlefork United States.
Discover and dig up Beltrami Minnesota homes for rent and vacation rentals Beltrami.
Espy, look up, and elicit bed and breakfast rentals, vacation homes for rent by owner in Leota United States, and rental homes in Leota United States.
Recognize and identify rent house in New Munich and apartments for rent.
The Crystal romantic indexes and private classifieds for these neighborhood can be mapped.
Debunk, discover, and locate vacation homes in Albert Lea United States, Albert Lea United States real estate rentals, and rent houses Albert Lea.
Explore and originate the sector and adjoining Crystal Minnesota territory.
Explore, invent, and devise houses for rent in Blaine United States, rental homes Blaine United States, and Blaine United States houses for rent.
Glimpse and light upon Dumont United States short term rentals and Dumont United States vacation rental.
Our webpage can embody and gather romantic listings, well appointed online MLS, beachfront online MLS, and oceanfront ads mountain directories and well appointed listings to do for your Crystal traverse.
Bedmates and occupiers quest, prospect, and scour this extensive website, FRBO.com and invent suburban cabin, rustic castle, log chalet, and lake villa.
Uncover, distinguish, and invent East Grand Forks United States apartment rentals, home rentals East Grand Forks, and for rent by owner homes in East Grand Forks United States.
Learn and contrive vacation homes Hallock United States and Hallock apartments for rent.
|
|
