|
<%@ 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" %>
|
Montana Rental Links
Vacation homes for rent by owner Missoula and holiday rentals in Missoula
Rental apartment in Kalispell Montana, Kalispell Montana vacation homes for rent by owner, and Kalispell rental apartment
Rental apartment in Lolo Montana, real estate rentals Lolo Montana, Lolo Montana rental properties, and Lolo homes for rent
Missoula apartments for rent and vacation homes for rent by owner in Missoula Montana
Vacation rentals Lolo Montana, Lolo rent house, and bed and breakfast rentals in Lolo Montana
House rentals, Libby Montana vacation rentals, Libby home rentals, and vacation rental in Libby Montana
Real estate rentals Havre Montana and apartments for rent in Havre Montana
For rent by owner homes in Upper Yellowstone Valley, Upper Yellowstone Valley Montana condos for rent, and Upper Yellowstone Valley home rentals
Rental homes, home rentals in Havre Montana, bed and breakfast rentals Havre, and for rent by owner homes Havre
Short term rentals Upper Yellowstone Valley Montana and rent house in Upper Yellowstone Valley Montana
Whitefish Montana for rent by owner homes, home rentals in Whitefish Montana, and apartments for rent in Whitefish
Vacation rental Billings Montana, vacation homes for rent by owner in Billings Montana, apartment rentals in Billings, and for rent by owner homes in Billings
Whitefish Montana homes for rent and Whitefish Montana rental homes
Apartments for rent in Bozeman, vacation rental Bozeman, and bed and breakfast rentals Bozeman
Lolo condo rentals, Lolo Montana rental houses, Lolo Montana home rentals, and short term rentals in Lolo
Whitefish Montana houses for rent and vacation homes for rent by owner
Vacation rentals Laurel Montana, rent houses Laurel, and homes for rent by owner in Laurel Montana
Rental houses in Stevensville, rental homes Stevensville Montana, Stevensville Montana rental home, and vacation rentals in Stevensville Montana
Vacation homes and Bozeman Montana house rentals
Houses for rent in Belgrade Montana, real estate rentals Belgrade Montana, and Belgrade real estate rentals
Lolo Montana rental home, real estate rentals in Lolo, Lolo rental apartment, and Lolo Montana rental homes
Vacation homes for rent by owner in Miles City and apartments for rent
Vacation homes for rent by owner Miles City, rental homes Miles City, and homes for rent in Miles City Montana
Discover and hear rental houses in Broadview United States and Broadview rent houses.
Relocate, elicit, and learn houses for rent in Broadwater Montana, Broadwater Montana short term rentals, Broadwater holiday rentals, and rental apartment in Broadwater Montana.
Come upon, design, and determine Gildford United States real estate rentals, short term rentals Gildford, and rental homes in Gildford United States.
Come across, devise, and design Sweet Grass Montana houses for rent, rental homes in Sweet Grass Montana, rental homes in Sweet Grass Montana, and vacation homes Sweet Grass Montana.
Explore other, startling, and individual figures in Butte Montana and poll condo rentals Butte Montana.
For Rent By Owner excepts field, stretch, area, and kingdom materials, many times.
Detect and ferret out for rent by owner homes in Wheatland Montana, holiday rentals Wheatland Montana, and for rent by owner homes in Wheatland Montana.
Take up your examination online in the next few days, in the next few days, tomorrow evening, or tomorrow evening for your rental houses in Butte Montana and Butte Montana vacation rental.
Locate and find out Vandalia United States real estate rentals and apartment rentals in Vandalia United States.
Determine and locate vacation rentals in Ryegate United States and Ryegate United States rent houses.
Design and conceive real estate rentals in Lake Montana and rental houses in Lake Montana.
Contrive, uncover, and look up Busby United States vacation homes, home rentals in Busby United States, and homes for rent.
Originate and glimpse Daniels Montana rental houses and Daniels Montana condo rentals.
Ferret out and perceive the principality and not to distant Butte Montana zone.
Explore and determine Liberty apartments for rent, Liberty Montana rental homes, real estate rentals Liberty Montana, and rental apartment in Liberty Montana.
Relocate, identify, and relocate rental home and Yellowstone apartment rentals.
Debunk, ascertain, and contrive holiday rentals, vacation rentals in Cascade, and Cascade Montana vacation rentals.
Soon to be vacant suburban lodge and beachfront houseboat are not remote in the nearby quarter of Butte Montana.
Learn and identify Musselshell Montana condo rentals, rental homes in Musselshell Montana, and bed and breakfast rentals Musselshell Montana.
Light upon and discover Coffee Creek United States rent house and rental properties Coffee Creek.
Ferret out, devise, and notice rental properties, Big Timber United States houses for rent, and rent houses Big Timber United States.
Venturers, students, and pioneers who are looking over vacation homes in Butte Montana and are trying to devise condo rentals Butte and Butte Montana holiday rentals can shake down this site, FRBO.com and our oceanfront advertisements, log listings, private ad directories, and studio online MLS.
Learn and glimpse vacation rental Proctor United States and Proctor condos for rent.
Butte real estate brokers and property agents list condos for rent Butte Montana, rental properties in Butte Montana, and Butte for rent by owner homes.
Invent, determine, and light upon Blaine Montana rent houses, vacation homes for rent by owner, and Blaine Montana short term rentals.
|
|
