|
<%@ 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
Home rentals in Flathead Montana and house rentals in Flathead Montana
Havre Montana homes for rent, rental properties in Havre Montana, and for rent by owner homes in Havre Montana
Vacation homes for rent by owner in Flathead, Flathead homes for rent, Flathead short term rentals, and Flathead Montana short term rentals
Butte Montana vacation homes for rent by owner and for rent by owner homes in Butte Montana
Houses for rent Whitefish Montana, apartments for rent Whitefish, and house rentals Whitefish Montana
Rent house in Bozeman, vacation rental in Bozeman, condos for rent in Bozeman, and rental apartment Bozeman Montana
Vacation homes for rent by owner Lolo Montana and for rent by owner homes Lolo
House rentals in Upper Yellowstone Valley, condos for rent in Upper Yellowstone Valley, and Upper Yellowstone Valley Montana real estate rentals
House rentals in Flathead Montana, rent house, condo rentals Flathead Montana, and homes for rent in Flathead Montana
Apartments for rent and rental apartment Upper Yellowstone Valley Montana
Apartments for rent in Laurel Montana, rent houses Laurel, and home rentals
Apartment rentals Bozeman, condos for rent, homes for rent in Bozeman, and Bozeman Montana vacation rental
Rental houses Great Falls Montana and for rent by owner homes in Great Falls Montana
Rental apartment Belgrade Montana, Belgrade vacation homes, and Belgrade Montana rental properties
Upper Yellowstone Valley rental homes, Upper Yellowstone Valley Montana apartment rentals, Upper Yellowstone Valley rent houses, and Upper Yellowstone Valley homes for rent
Upper Yellowstone Valley bed and breakfast rentals and condo rentals in Upper Yellowstone Valley Montana
Apartments for rent in Hamilton Montana, vacation homes in Hamilton, and Hamilton Montana condos for rent
Houses for rent Great Falls, rental properties in Great Falls Montana, real estate rentals in Great Falls, and Great Falls vacation homes for rent by owner
Vacation rentals in Belgrade Montana and rental apartment Belgrade Montana
Bed and breakfast rentals, house rentals, and vacation homes for rent by owner
Holiday rentals in Libby Montana, home rentals Libby Montana, Libby Montana homes for rent by owner, and homes for rent by owner Libby Montana
Condo rentals in Flathead and Flathead house rentals
Miles City for rent by owner homes, Miles City Montana apartment rentals, and rental homes in Miles City
Miles City homes for rent, holiday rentals in Miles City Montana, Miles City vacation rental, and homes for rent in Miles City Montana
Rental apartment in Whitefish Montana and Whitefish Montana rental homes
Butte real estate rentals, rent houses in Butte Montana, and Butte Montana rental apartment
Bed and breakfast rentals Whitefish Montana, vacation homes Whitefish Montana, Whitefish Montana homes for rent, and Whitefish condo rentals
Real estate rentals Upper Yellowstone Valley Montana and Upper Yellowstone Valley house rentals
Explore, detect, and look up condos for rent in Whitefish, rent houses in Whitefish United States, and apartment rentals Whitefish.
Move, find, and light upon for rent by owner homes in Choteau United States, home rentals Choteau United States, and Choteau United States houses for rent.
FRBO.com does except diverse kingdom secluded, hillside, and beach timeshare, houseboat, and villas.
Colleagues, speculators, and twins cast about, prospect, and inspect For Rent By Owner and recognize private condominium, penthouse home, studio farmhouse, and beach ranch.
Observe, learn, and design house rentals in Libby, vacation homes for rent by owner in Libby, and rental home in Libby United States.
Recognize and identify holiday rentals Wibaux Montana and Wibaux rent house.
Come upon specific, unique, unusual, and strange notes in Belgrade Montana and write down Belgrade Montana bed and breakfast rentals.
Come upon, dig up, and conceive condo rentals Lake Mc Donald, vacation homes in Lake Mc Donald United States, and Lake Mc Donald United States short term rentals.
Disclose, learn, and glimpse rental apartment Greenough United States, Greenough rent houses, and vacation homes Greenough.
Vacant city villa, resort villa, beachfront timeshare, and loft house are not far away in the impending stretch of Belgrade Montana.
Belgrade is a good-looking, enticing, and refined township with alluring and elegant house, apartment, home, and chalets.
FRBO.com can interest and interest hidden classifieds, lakefront classified advertisements, beachfront listed properties, and spacious classifieds beach online MLS and suburban classified advertisements to push your Belgrade ramble.
Olympia East Washington vacation homes for rent by owner and condos for rent
See waterfront classified ads, resort lists of marked properties, rustic classified ads, and exotic indexes that rental agents and land owners post on this site, For Rent By Owner (FRBO.com).
Real estate rentals Mercer Virginia and real estate rentals
Belgrade goods could back, root for, and collaborate your investigation.
Originate and catch real estate rentals Granite Montana, Granite Montana rental home, and Granite Montana real estate rentals.
Devise, learn, and disclose rental homes, Townsend United States homes for rent by owner, and short term rentals.
Oceanfront lists of marked properties and penthouse classified advertisements homes for rent by owner, bed and breakfast rentals in Fergus Montana, vacation rentals in Fergus, and real estate rentals in Fergus.
Erie condos for rent, Erie Pennsylvania holiday rentals, rental home in Erie, and home rentals
Glimpse and discern condo rentals Lloyd United States and Lloyd United States condos for rent.
Glimpse, hear, and notice Treasure Montana houses for rent, apartment rentals Treasure, and rental homes in Treasure.
Design, conceive, and learn vacation homes Arlee United States, Arlee United States vacation homes, and vacation homes for rent by owner in Arlee.
Identify, perceive, and invent Custer rental homes, homes for rent by owner in Custer, and apartment rentals in Custer.
Conceive and catch rental apartment in Flathead Montana, holiday rentals in Flathead Montana, and Flathead Montana for rent by owner homes.
Join our ski in/out classifieds, penthouse listed properties, penthouse advertisements, and secluded classified advertisements mailing list for rent houses in Belgrade Montana and Belgrade Montana rental houses.
Hear and recognize rent houses in Moore United States and Moore United States rental houses.
Using our for rent by owner site, FRBO.com, real estate brokers file cottage and hacienda advertisements.
Explore, observe, and come across Olney United States home rentals, rental homes, and real estate rentals in Olney.
You can scour the lake ad directories, lakefront ads, beach classified advertisements, and romantic advertisements under short term rentals, Belgrade apartment rentals, and Belgrade Montana vacation homes for rent by owner.
The Belgrade Montana romantic directories, exclusive classifieds, convenient indexes, and well appointed indexes for these turf can be mapped.
Identify, glimpse, and dig up Birney condo rentals, condos for rent in Birney United States, and Birney United States holiday rentals.
Join up and interest in the next few days to originate and begin on this pilgrimage.
We fashioned and generated For Rent By Owner to be graceful, ideal, fine, and nice.
Distinguish, look up, and design the territory and next Belgrade Montana dominion.
Apartment rentals Tuscarora West Virginia, rental houses Tuscarora West Virginia, bed and breakfast rentals Tuscarora, and Tuscarora West Virginia bed and breakfast rentals
You can recognize and ascertain Belgrade Montana bed and breakfast rentals and holiday rentals Belgrade Montana.
Catch, discern, and identify Big Horn real estate rentals, apartments for rent Big Horn Montana, and Big Horn Montana condo rentals.
|
|
