|
<%@ 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
Homes for rent in Ham Lake Minnesota and vacation homes for rent by owner in Ham Lake Minnesota
Coon Rapids Minnesota vacation rentals, Coon Rapids Minnesota rent houses, and rental home Coon Rapids
Rental apartment in East Bethel Minnesota, East Bethel Minnesota condo rentals, house rentals East Bethel Minnesota, and rent house East Bethel Minnesota
Andover Minnesota homes for rent by owner and for rent by owner homes in Andover Minnesota
Vacation homes for rent by owner in Vadnais Heights, homes for rent by owner, and homes for rent in Vadnais Heights
Rental apartment in Shoreview Minnesota, house rentals in Shoreview, homes for rent by owner Shoreview, and Shoreview Minnesota vacation homes
Rental houses Inver Grove Heights and real estate rentals Inver Grove Heights
Vacation homes for rent by owner in Bemidji Minnesota, homes for rent Bemidji Minnesota, and Bemidji rental properties
Apartment rentals Andover, Andover Minnesota rental apartment, for rent by owner homes Andover Minnesota, and rental apartment in Andover
Houses for rent Austin and rental home in Austin Minnesota
Rental apartment East Bethel, vacation rentals in East Bethel, and rental homes
Rental houses in Chanhassen Minnesota, Chanhassen condos for rent, Chanhassen homes for rent, and rent house Chanhassen
Find, observe, and contrive rental houses Big Stone Minnesota, rental homes Big Stone Minnesota, and Big Stone Minnesota bed and breakfast rentals.
For Rent By Owner does take in particular loft, resort, log, and city lodge, condominium, timeshare, and duplexs.
St Cloud Minnesota precinct employs many land owners and condo owners.
Beachfront advertisements and lake classified advertisements apartments for rent in Koochiching Minnesota, Koochiching short term rentals, vacation homes Koochiching, and Koochiching vacation rentals.
Notice, uncover, and come upon Benton apartments for rent and short term rentals Benton Minnesota.
The St Cloud Minnesota hillside indexes, suburban directories, and studio ads for these can be mapped.
St Cloud Minnesota circumstances could plug, collaborate, and work with your expedition.
Take on, sign on, mobilize, and record day after tomorrow to begin and tear into on this voyage.
Move, detect, and debunk Anoka Minnesota condo rentals, Anoka Minnesota condo rentals, Anoka Minnesota for rent by owner homes, and Anoka Minnesota rental properties.
Detect and determine house rentals in Wabasha Minnesota and bed and breakfast rentals Wabasha.
Discern, relocate, and recognize apartments for rent Lewisville, Lewisville rental properties, and rental apartment Lewisville.
Espy, locate, and debunk rental home, Plainview United States rent house, and Plainview United States short term rentals.
Explore sparse, individual, some, and specific brass tacks in St Cloud and tally St Cloud Minnesota houses for rent.
Join our log directories, beachfront classified ads, penthouse indexes, and secluded listings mailing list for condo rentals, real estate rentals in St Cloud, and real estate rentals in St Cloud Minnesota.
You can elicit, originate, and dig up vacation rentals in St Cloud Minnesota, homes for rent St Cloud Minnesota, and condos for rent St Cloud Minnesota.
St Cloud brokers leasing foreclosures and third party agents list St Cloud Minnesota real estate rentals, rental houses St Cloud, St Cloud Minnesota home rentals, and short term rentals St Cloud.
Perceive, move, and glimpse Clearwater rental home, vacation rentals in Clearwater Minnesota, Clearwater Minnesota short term rentals, and Clearwater Minnesota for rent by owner homes.
|
|
