|
<%@ 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
House rentals in Bemidji Minnesota and homes for rent in Bemidji
Red Wing Minnesota apartment rentals, rental houses in Red Wing Minnesota, and rent houses in Red Wing Minnesota
Rental houses, rental home in Mounds View, apartment rentals in Mounds View, and real estate rentals in Mounds View
Homes for rent by owner and apartment rentals in Brooklyn Park Minnesota
Eagan Minnesota bed and breakfast rentals, holiday rentals in Eagan, and homes for rent by owner in Eagan
Rental houses in White Bear, rental properties in White Bear Minnesota, bed and breakfast rentals in White Bear Minnesota, and White Bear Minnesota vacation homes
Rental houses Fergus Falls and Fergus Falls holiday rentals
Short term rentals Shakopee Minnesota, Shakopee Minnesota rental houses, and Shakopee rental homes
Short term rentals in Brooklyn Park Minnesota, Brooklyn Park Minnesota bed and breakfast rentals, rent houses Brooklyn Park, and rent house in Brooklyn Park
Short term rentals Fairmont and homes for rent Fairmont
Apartment rentals, homes for rent, and Vadnais Heights Minnesota for rent by owner homes
Light upon and hear Freeborn Minnesota holiday rentals and vacation rentals Freeborn Minnesota.
Design and debunk apartments for rent in Jackson and rent houses in Jackson.
Hear, look up, and come upon the vicinity and convenient Golden Valley Minnesota field.
Find and debunk Inver Grove Heights United States houses for rent and Inver Grove Heights United States real estate rentals.
Send lovely, magnificent, and shapely evidence regarding Golden Valley holiday rentals and home rentals in Golden Valley Minnesota found on this site, For Rent By Owner (FRBO.com).
Ferret out and dig up short term rentals Grey Eagle United States and rental apartment.
Join our beach directories and waterfront listed properties mailing list for homes for rent Golden Valley, rent houses in Golden Valley, and apartment rentals in Golden Valley Minnesota.
Studio lists of marked properties and ski in/out listed properties condo rentals in Big Stone, condos for rent in Big Stone, condo rentals in Big Stone Minnesota, and vacation rental in Big Stone.
Golden Valley town home owners and property brokers list short term rentals Golden Valley Minnesota, short term rentals in Golden Valley Minnesota, short term rentals in Golden Valley, and Golden Valley Minnesota homes for rent by owner.
The Golden Valley Minnesota directories specialized and scheduled on this webpage omit mountain castle, ski in/out bungalow, exotic bungalow, and decadent hacienda.
Perceive, identify, and find out Mound United States rental properties, rental houses in Mound United States, and condo rentals Mound.
This webpage does consist of specific township lake, lake, resort, and decadent home, condominium, and villas.
Habitants, explorers, and traveling women who are investigating Golden Valley condo rentals and are trying to identify vacation homes Golden Valley, Golden Valley real estate rentals, and houses for rent Golden Valley can shake down our for rent by owner site, FRBO.com and our city listed properties, mountain classified ads, and beachfront indexes.
|
|
