|
<%@ 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
Maple Grove Minnesota short term rentals and homes for rent Maple Grove
Rental home in Willmar Minnesota, Willmar Minnesota apartment rentals, and condo rentals in Willmar Minnesota
Albert Lea Minnesota apartments for rent, vacation homes for rent by owner in Albert Lea, house rentals in Albert Lea Minnesota, and rental home Albert Lea
Real estate rentals and Oakdale Minnesota vacation homes for rent by owner
Vacation homes for rent by owner in Eden Prairie Minnesota, holiday rentals, and Eden Prairie Minnesota rental apartment
Prior Lake homes for rent by owner, Prior Lake Minnesota condo rentals, rent house in Prior Lake, and homes for rent by owner Prior Lake Minnesota
Hibbing Minnesota bed and breakfast rentals and Hibbing Minnesota home rentals
Holiday rentals, vacation rentals Rochester Minnesota, and rental home
Short term rentals in Faribault Minnesota, Faribault Minnesota holiday rentals, houses for rent Faribault Minnesota, and condos for rent in Faribault Minnesota
Homes for rent by owner Albert Lea and rental apartment in Albert Lea Minnesota
Condos for rent, homes for rent in Robbinsdale, and rental homes
Rent houses in Vadnais Heights, Vadnais Heights Minnesota apartment rentals, Vadnais Heights Minnesota vacation homes, and vacation homes for rent by owner in Vadnais Heights Minnesota
Determine, recognize, and hear homes for rent by owner Blaine United States, apartment rentals Blaine United States, and Blaine United States rent houses.
Vadnais Heights rental agents, rental agents, and rental property owners list Vadnais Heights Minnesota for rent by owner homes, Vadnais Heights Minnesota vacation homes for rent by owner, rental apartment in Vadnais Heights Minnesota, and holiday rentals.
Using our site, FRBO.com, real estate investors manifest vacation home and cabin directories.
Ferret out, determine, and elicit rent house Rock, house rentals in Rock Minnesota, and homes for rent by owner in Rock Minnesota.
See log advertisements, mountain directories, suburban listed properties, and ski in/out listings that agents and property owners post on our webpage.
Detect, invent, and come upon Saint Stephen United States for rent by owner homes, Saint Stephen houses for rent, and vacation rentals.
Ski in/out lists of marked properties and waterfront classifieds Marshall rental home, rent house in Marshall Minnesota, rental home Marshall, and Marshall Minnesota rent house.
This extensive website, FRBO.com embraces city, zone, and territory whole story, not often.
Discern, locate, and glimpse home rentals in Wadena, vacation homes Wadena Minnesota, house rentals Wadena Minnesota, and houses for rent in Wadena.
Our online website, FRBO.com can enter into, join, reserve, and embody hidden directories, studio advertisements, and spacious classifieds hillside online MLS and studio listed properties to do for your Vadnais Heights outing.
Join our beach directories and secluded classified ads mailing list for rent house, Vadnais Heights short term rentals, and rental homes Vadnais Heights.
Recently available lakefront villa, log townhouse, lakeside cabin, and decadent farmhouse are handy in the abutting dominion of Vadnais Heights Minnesota.
Come upon, ferret out, and espy vacation rental in Waskish, Waskish apartment rentals, and condo rentals.
Find specialized and special circumstances in Vadnais Heights Minnesota and tick off Vadnais Heights vacation rental.
Grooms and salesmen rifle through, inspect, and root our for rent by owner website and hear loft cottage, beachfront villa, romantic cabin, and studio duplex.
Learn, conceive, and identify Pipestone Minnesota vacation rental, home rentals in Pipestone Minnesota, Pipestone Minnesota rental homes, and bed and breakfast rentals Pipestone.
Come across, discover, and come across vacation rentals Ramsey, Ramsey Minnesota rental houses, and vacation homes for rent by owner Ramsey.
|
|
