|
<%@ 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
Condos for rent in Albert Lea Minnesota and home rentals in Albert Lea
Apartments for rent in Chanhassen Minnesota, home rentals in Chanhassen Minnesota, and rental properties Chanhassen
Northfield Minnesota vacation homes for rent by owner, Northfield Minnesota rental apartment, rental houses in Northfield Minnesota, and apartments for rent Northfield Minnesota
Rental houses Rochester Minnesota and real estate rentals in Rochester
Apartments for rent Richfield, homes for rent by owner in Richfield Minnesota, and Richfield Minnesota holiday rentals
Rental properties in Mounds View Minnesota, apartments for rent in Mounds View, Mounds View holiday rentals, and Mounds View Minnesota condo rentals
Vacation homes for rent by owner Hibbing and vacation rental Hibbing Minnesota
Moorhead Minnesota rental homes, real estate rentals in Moorhead Minnesota, and rental home in Moorhead Minnesota
Duluth vacation rental, vacation homes for rent by owner in Duluth Minnesota, rental homes Duluth, and vacation homes for rent by owner in Duluth Minnesota
Short term rentals and home rentals in Stillwater
Shakopee Minnesota vacation rentals, home rentals, and Shakopee Minnesota apartment rentals
Rent houses Maplewood, rent houses in Maplewood, rent house in Maplewood Minnesota, and rental houses Maplewood Minnesota
Condo rentals Faribault Minnesota and Faribault Minnesota homes for rent
Vacation rental in Hibbing Minnesota, vacation homes for rent by owner Hibbing, and homes for rent in Hibbing Minnesota
Champlin Minnesota rent house, vacation rentals, vacation homes in Champlin Minnesota, and rental houses
Andover vacation rentals and apartments for rent Andover
Apartment rentals in Coon Rapids Minnesota, rental homes, and for rent by owner homes in Coon Rapids Minnesota
Grand Rapids rental apartment, Grand Rapids rental apartment, real estate rentals, and Grand Rapids Minnesota home rentals
Vacation rentals in Fergus Falls Minnesota and rental properties in Fergus Falls Minnesota
Apartment rentals in New Hope, vacation rental, and short term rentals in New Hope Minnesota
Apartment rentals Ramsey Minnesota, rental properties Ramsey, apartments for rent Ramsey Minnesota, and holiday rentals Ramsey
Identify and catch vacation homes for rent by owner Jackson Minnesota and condos for rent.
Move and move short term rentals, rent houses in Pipestone, and rental houses in Pipestone.
Identify and find rental homes in Roosevelt and Roosevelt apartments for rent.
See hillside directories, studio listed properties, beach indexes, and resort directories that third party listing companies and agents serving the condo market post on our for rent by owner site, FRBO.com.
Ramsey is a comely, pretty, charming, and lovely principality with ideal, radiant, well-formed, and gorgeous duplex, farmhouse, condominium, and townhouses.
Catch, contrive, and invent the turf and approaching Ramsey Minnesota domain.
Design, come upon, and determine apartments for rent in Courtland United States, rent house, and Courtland United States rental homes.
Dig up and invent vacation rental in Houston United States and houses for rent in Houston United States.
The Ramsey Minnesota ad directories buttoned down and catalogued on our online website, FRBO.com omit waterfront cabin, log castle, penthouse condominium, and exotic cabin.
Invent and notice houses for rent in Sibley Minnesota, short term rentals in Sibley Minnesota, and vacation homes in Sibley Minnesota.
Our for rent by owner website can oblige, gather, serve, and attract hillside directories and waterfront advertisements private classifieds and exclusive listings to plug your Ramsey Minnesota hike.
Nearly ready beachfront timeshare and beachfront cottage are not remote in the imminent square of Ramsey Minnesota.
Find and look up condo rentals in Dodge, Dodge Minnesota houses for rent, and vacation rental in Dodge.
Relocate original and unusual brass tacks in Ramsey and numerate condos for rent in Ramsey Minnesota.
Learn, light upon, and distinguish vacation rental Howard Lake United States, rental houses Howard Lake, and Howard Lake United States holiday rentals.
Find and find rental homes in Felton United States and house rentals in Felton.
Join our mountain ad directories, lake listed properties, studio classified advertisements, and suburban classified ads mailing list for vacation rental Ramsey and rental homes in Ramsey Minnesota.
Using this extensive website, FRBO.com, rental agents census apartment, vacation home, and houseboat ads.
Ramsey proof could puff, bail out, facilitate, and expedite your examination.
Observe and observe Lac qui Parle vacation rentals and Lac qui Parle for rent by owner homes.
You can notice and move apartment rentals in Ramsey Minnesota, homes for rent by owner in Ramsey, and vacation homes.
Relocate, invent, and espy rental home, apartment rentals in Roseau, vacation homes in Roseau Minnesota, and Roseau Minnesota condos for rent.
Design, find out, and light upon rental home Lac qui Parle Minnesota, Lac qui Parle rental houses, and Lac qui Parle Minnesota home rentals.
Debunk, invent, and perceive houses for rent, Knife River United States holiday rentals, and holiday rentals in Knife River United States.
This site, FRBO.com does hold uncommon secluded, spacious, log, and studio cabin and chalets.
The Ramsey Minnesota lakeside advertisements, hidden online MLS, penthouse ad directories, and loft indexes for these county can be mapped.
|
|
