|
<%@ 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
Rent houses in Woodbury and condo rentals in Woodbury
Vacation homes South St Paul Minnesota, homes for rent South St Paul, and South St Paul Minnesota homes for rent
Houses for rent in Mounds View Minnesota, Mounds View Minnesota house rentals, Mounds View Minnesota rental properties, and rent house in Mounds View Minnesota
Fairmont Minnesota homes for rent and Fairmont Minnesota for rent by owner homes
Bed and breakfast rentals in Worthington, Worthington rental homes, and Worthington Minnesota houses for rent
Mankato Minnesota houses for rent, real estate rentals in Mankato Minnesota, short term rentals in Mankato Minnesota, and vacation rental
Rental homes in North St Paul Minnesota and North St Paul Minnesota bed and breakfast rentals
Marshall Minnesota short term rentals, condo rentals in Marshall, and home rentals in Marshall Minnesota
Apartment rentals in Albert Lea, Albert Lea Minnesota vacation rentals, Albert Lea Minnesota rental apartment, and Albert Lea Minnesota house rentals
Vacation rentals Champlin and condo rentals Champlin Minnesota
Willmar Minnesota homes for rent by owner, home rentals Willmar, and Willmar rent house
Apartment rentals Stillwater, Stillwater rental home, rental apartment in Stillwater Minnesota, and house rentals Stillwater
Rental homes in Fairmont and rental homes Fairmont
Homes for rent by owner St Cloud Minnesota, vacation rentals, and vacation homes for rent by owner in St Cloud Minnesota
Duluth Minnesota rental homes, bed and breakfast rentals in Duluth Minnesota, rent house Duluth, and Duluth house rentals
Move and perceive apartment rentals Flensburg and holiday rentals in Flensburg United States.
Identify and move Yellow Medicine homes for rent and Yellow Medicine Minnesota rental homes.
Peers and adventurers grub and scrutinize this webpage and ascertain lake condominium and hidden home.
Ascertain, light upon, and come upon bed and breakfast rentals in Avoca, rental properties in Avoca, and home rentals Avoca.
Light upon and dig up the dominion and next Champlin Minnesota vicinity.
Get going your inquest online on Saturday, on Monday, or on Sunday for your vacation homes for rent by owner in Champlin Minnesota and Champlin Minnesota house rentals.
Conceive, explore, and elicit Wabasha Minnesota real estate rentals, apartment rentals Wabasha Minnesota, Wabasha Minnesota bed and breakfast rentals, and homes for rent Wabasha.
You can run down the beach classified advertisements and oceanfront directories under vacation homes in Champlin, Champlin Minnesota house rentals, and holiday rentals.
Generally, cooperate, further, and assist your explorers, peers, and gamblers to a interesting and beckoning patch.
We created, generated, and organized our site, FRBO.com to be refined, lovely, symmetrical, and statuesque.
Join our romantic ad directories, hillside classified advertisements, decadent classified advertisements, and lakefront advertisements mailing list for vacation rental Champlin and vacation homes in Champlin Minnesota.
The Champlin Minnesota ads registered and inscribed on our website, FRBO.com encompass exclusive castle, beach chalet, and resort flat.
Unused lake townhouse, exclusive duplex, ski in/out chalet, and log timeshare are nearest in the convenient territory of Champlin Minnesota.
Find, catch, and locate real estate rentals in Swift Minnesota, Swift apartment rentals, and Swift Minnesota vacation homes.
You can contrive and glimpse Champlin vacation rentals and Champlin apartment rentals.
Well appointed classifieds and lakeside classified advertisements rental properties in Wright, holiday rentals Wright Minnesota, rental home, and Wright rent house.
Champlin is a divine, stunning, and wonderful territory with grand and shapely apartment, chalet, and chalets.
|
|
