|
<%@ 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
Rental homes in Andover Minnesota and condo rentals Andover
Blaine Minnesota vacation homes for rent by owner, Blaine Minnesota homes for rent, and house rentals
Vacation rental in Stillwater Minnesota, Stillwater Minnesota vacation homes for rent by owner, vacation homes for rent by owner in Stillwater Minnesota, and home rentals Stillwater
Grand Rapids Minnesota for rent by owner homes and apartments for rent
Grand Rapids rental properties, Grand Rapids Minnesota homes for rent by owner, and homes for rent by owner Grand Rapids
Rental homes in Fairmont Minnesota, apartments for rent in Fairmont, Fairmont Minnesota rental properties, and Fairmont home rentals
Vacation homes Blaine Minnesota and Blaine Minnesota condos for rent
Columbia Heights Minnesota for rent by owner homes, home rentals Columbia Heights, and condos for rent in Columbia Heights Minnesota
For rent by owner homes in Stillwater Minnesota, house rentals Stillwater, Stillwater rental home, and apartment rentals in Stillwater Minnesota
Bemidji rental houses and real estate rentals
Rental home in Andover Minnesota, homes for rent in Andover Minnesota, and Andover Minnesota short term rentals
West St Paul condo owners, real estate brokers, third party listing companies, and rental owners list West St Paul home rentals and home rentals.
Determine, discover, and discern apartment rentals, houses for rent, apartments for rent in Kandiyohi Minnesota, and homes for rent.
Locate and come upon vacation homes for rent by owner in Wabasha Minnesota, rental properties in Wabasha, short term rentals in Wabasha Minnesota, and Wabasha apartments for rent.
The West St Paul lakeside classifieds and well appointed classified advertisements for these precinct can be mapped.
Pre-rented well appointed hacienda and suburban villa are not far in the immediate domain of West St Paul Minnesota.
Join our romantic listings and beach advertisements mailing list for real estate rentals in West St Paul Minnesota, West St Paul Minnesota rental home, and West St Paul Minnesota holiday rentals.
Transmigrants, twins, and wanderers who are wishing to find, find, and glimpse or simply distinguish information can use our page.
Notice, come across, and distinguish rental apartment in New Market United States, vacation homes in New Market United States, and homes for rent by owner in New Market United States.
Observe and find bed and breakfast rentals Avon United States and Avon home rentals.
Often, expedite and back your explorers and fellow workers to a spinach, beautiful, pleasant, and hunk county.
Look up and come across vacation homes in Saint Stephen United States and homes for rent Saint Stephen.
We actualize and made this website, FRBO.com to be marvelous, fascinating, and pretty.
Espy, disclose, and find apartment rentals in Blue Earth Minnesota and holiday rentals.
Distinguish and devise Granada United States rental homes and vacation rental in Granada United States.
Find out, ferret out, and relocate Big Stone Minnesota condo rentals and bed and breakfast rentals.
Discern, locate, and recognize rent houses, holiday rentals Crow Wing, and for rent by owner homes Crow Wing Minnesota.
Locate, come upon, and light upon vacation rentals, rental home Houston, and for rent by owner homes Houston.
Learn and locate Lakeland United States homes for rent and Lakeland United States houses for rent.
Obtain and inscribe on Tuesday to take up, lead off, and kick off on this route.
Send admirable, fine, and delightful brass tacks regarding homes for rent by owner in West St Paul Minnesota, rent house in West St Paul, and vacation homes West St Paul found on this extensive website, FRBO.com.
West St Paul Minnesota notes could reinforce and reinforce your going-over.
West St Paul Minnesota is a grand and statuesque kingdom with well-formed and alluring timeshare, apartment, house, and timeshares.
Observe and learn Brown Minnesota bed and breakfast rentals and vacation homes Brown.
You can prospect the well appointed ads and ski in/out classified ads under vacation homes West St Paul Minnesota and condos for rent in West St Paul.
Using our webpage, rental owners enumerate flat, cottage, and flat indexes.
|
|
