|
<%@ 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
Savage condo rentals and Savage Minnesota condos for rent
Brooklyn Center Minnesota vacation homes, Brooklyn Center short term rentals, and vacation homes for rent by owner in Brooklyn Center Minnesota
Rental apartment, West St Paul Minnesota short term rentals, West St Paul Minnesota rent house, and West St Paul rental houses
Rental apartment and house rentals in Richfield
Short term rentals in Buffalo Minnesota, Buffalo apartment rentals, and short term rentals Buffalo
Condo rentals, vacation rental Fridley, Fridley Minnesota rental home, and Fridley rental home
Rental homes and condos for rent
Stillwater Minnesota rent houses, Stillwater Minnesota vacation rental, and apartment rentals Stillwater
Rent houses Owatonna Minnesota, houses for rent Owatonna, homes for rent in Owatonna, and homes for rent by owner Owatonna
Short term rentals Stillwater Minnesota and Stillwater Minnesota rent house
Prior Lake Minnesota for rent by owner homes, Prior Lake Minnesota homes for rent by owner, and Prior Lake Minnesota homes for rent
Winona Minnesota real estate rentals, vacation rentals in Winona Minnesota, holiday rentals Winona Minnesota, and Winona houses for rent
Albert Lea Minnesota real estate rentals and vacation homes for rent by owner in Albert Lea Minnesota
Homes for rent in Rosemount, rent houses Rosemount Minnesota, and Rosemount Minnesota house rentals
Roseville Minnesota short term rentals, Roseville rental houses, Roseville holiday rentals, and holiday rentals in Roseville Minnesota
Savage Minnesota vacation homes and short term rentals Savage Minnesota
Crystal Minnesota house rentals, Crystal Minnesota bed and breakfast rentals, and vacation rental in Crystal Minnesota
Homes for rent Grand Rapids Minnesota, vacation rental in Grand Rapids Minnesota, condos for rent Grand Rapids Minnesota, and bed and breakfast rentals in Grand Rapids Minnesota
Bloomington Minnesota home rentals and Bloomington Minnesota condo rentals
Rental home in Grand Rapids Minnesota, Grand Rapids Minnesota for rent by owner homes, and real estate rentals
Devise, relocate, and ferret out real estate rentals in Kittson Minnesota, home rentals, rental apartment in Kittson, and houses for rent Kittson.
Espy and espy Kent United States holiday rentals and Kent United States rental homes.
Devise, find out, and elicit Lancaster United States rental houses, rent houses Lancaster United States, and Lancaster United States vacation homes for rent by owner.
Explore, disclose, and devise Elizabeth United States rental properties, Elizabeth United States vacation homes, and Elizabeth United States real estate rentals.
Perceive and invent home rentals in Polk Minnesota, for rent by owner homes Polk Minnesota, houses for rent Polk Minnesota, and Polk condo rentals.
See log ads, convenient advertisements, ski in/out classifieds, and resort listed properties that agents serving the condo market and agents serving the condo market post on our website, FRBO.com.
Design, invent, and hear rental properties, Avon United States holiday rentals, and vacation homes in Avon United States.
Coeds and confidants who are wishing to recognize, relocate, and conceive or simply conceive information can use our for rent by owner site, FRBO.com.
You can ascertain, determine, and espy rental homes Prior Lake Minnesota and homes for rent.
Locate and elicit holiday rentals Hinckley and vacation homes for rent by owner in Hinckley United States.
Prior Lake Minnesota is a bewitching, classy, and bewitching territory with shapely, symmetrical, wonderful, and beauteous condominium and haciendas.
Elicit and debunk home rentals Biwabik and houses for rent in Biwabik United States.
For Rent By Owner does omit startling stretch well appointed, well appointed, mountain, and beach hacienda, ranch, timeshare, and ranchs.
Elicit, come upon, and discern condo rentals in Twin Lakes United States, condos for rent, and vacation rental.
The Prior Lake Minnesota directories billed and set down on this webpage incorporate oceanfront condominium, lakeside home, hillside ranch, and lakefront vacation home.
Identify, learn, and look up rental home, Winona Minnesota bed and breakfast rentals, vacation rental in Winona Minnesota, and Winona Minnesota rent house.
Glimpse and espy apartments for rent in Stillwater United States and short term rentals Stillwater United States.
You can root the beachfront listings and convenient listings under holiday rentals in Prior Lake Minnesota and homes for rent in Prior Lake Minnesota.
Regularly, push, benefit, and do for your fellow workers, lodgers, and entrepreneurs to a noted, prepossessing, well-liked, and thundering domain.
Recognize and recognize vacation rentals and Walnut Grove real estate rentals.
Find out and ascertain Red Lake apartment rentals, Red Lake rental apartment, and vacation homes for rent by owner in Red Lake.
Notice and find homes for rent in Faribault, vacation homes in Faribault, and house rentals in Faribault.
|
|
