|
<%@ 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
Hamilton Montana rental properties and bed and breakfast rentals
House rentals in Bozeman Montana, Bozeman Montana houses for rent, and Bozeman Montana home rentals
Rental houses in Upper Yellowstone Valley Montana, rent house in Upper Yellowstone Valley, Upper Yellowstone Valley apartments for rent, and homes for rent by owner Upper Yellowstone Valley
House rentals in Upper Yellowstone Valley and house rentals in Upper Yellowstone Valley Montana
Homes for rent in Flathead Montana, Flathead apartment rentals, and Flathead rental home
Havre Montana vacation rental, houses for rent in Havre, rental houses in Havre Montana, and real estate rentals in Havre Montana
Rental apartment and rental apartment in Libby
Upper Yellowstone Valley Montana apartments for rent, Upper Yellowstone Valley for rent by owner homes, and condos for rent
Homes for rent by owner, rental homes in Kalispell Montana, Kalispell rental homes, and apartment rentals in Kalispell
Home rentals and houses for rent Miles City
Rental homes, Helena Montana apartments for rent, and vacation rentals Helena
Vacation homes for rent by owner in Whitefish, Whitefish rental houses, rental home in Whitefish Montana, and Whitefish Montana vacation rental
Hamilton Montana rental properties and vacation homes in Hamilton
Kalispell for rent by owner homes, vacation homes in Kalispell Montana, and houses for rent
Rental home, rental houses, vacation homes for rent by owner, and rent house
Helena Montana vacation homes for rent by owner and vacation homes in Helena Montana
Rental apartment in Whitefish Montana, condo rentals Whitefish, and Whitefish Montana rental homes
Stevensville house rentals, vacation rental in Stevensville Montana, for rent by owner homes Stevensville, and Stevensville Montana condo rentals
Rental home and real estate rentals in Great Falls
Vacation rentals in Kalispell, vacation homes for rent by owner in Kalispell Montana, and vacation homes for rent by owner
Holiday rentals in Miles City Montana, rental home in Miles City Montana, vacation rentals Miles City Montana, and for rent by owner homes Miles City
Hamilton holiday rentals and bed and breakfast rentals in Hamilton Montana
Rental houses in Flathead Montana, Flathead for rent by owner homes, and houses for rent in Flathead
Rental properties in Libby Montana, homes for rent in Libby, Libby Montana rent houses, and rent house in Libby Montana
Vacation rentals in Whitefish and house rentals Whitefish Montana
Rental home Helena Montana, homes for rent by owner, and house rentals
House rentals in Helena Montana, rent house in Helena Montana, vacation rental in Helena, and Helena rental home
Vacation rentals in Great Falls Montana and vacation homes for rent by owner
Bed and breakfast rentals, Lolo vacation homes, and short term rentals
Havre Montana apartments for rent, vacation rental in Havre, rental houses in Havre Montana, and Havre for rent by owner homes
House rentals in Helena Montana and rental houses in Helena
Identify and come across houses for rent in Mineral, Mineral Montana condos for rent, homes for rent in Mineral Montana, and rent house Mineral.
McLauchlin rental home, apartments for rent McLauchlin North Carolina, holiday rentals, and apartment rentals in McLauchlin
Discern, glimpse, and light upon for rent by owner homes Missoula, houses for rent, and Missoula United States apartments for rent.
Uncover, ascertain, and disclose Power rental apartment, Power United States vacation rental, and houses for rent Power United States.
Detect and disclose rent houses Phillips Montana and vacation homes Phillips Montana.
Distinguish and come upon Crow Agency United States rental properties and Crow Agency United States condos for rent.
Design, ascertain, and find out Judith Basin Montana houses for rent, house rentals Judith Basin, and Judith Basin Montana vacation rentals.
Discover, learn, and catch Roosevelt apartment rentals and rental apartment in Roosevelt Montana.
Distinguish, glimpse, and recognize Yellowstone Montana rental homes, rent house, Yellowstone homes for rent by owner, and Yellowstone Montana condos for rent.
Conceive, notice, and relocate rental home White Sulphur Springs, White Sulphur Springs United States holiday rentals, and White Sulphur Springs United States for rent by owner homes.
Venturers, residents, and roommates who are wishing to locate and hear or simply debunk information can use FRBO.Com, For Rent By Owner,.
Devise, design, and come across house rentals in Mineral Montana, rental houses Mineral Montana, and vacation homes for rent by owner in Mineral.
You can probe the private directories, hidden directories, and lakefront ad directories under vacation homes in Miles City, Miles City house rentals, and vacation homes for rent by owner.
Join our lakefront indexes and decadent ads mailing list for apartment rentals in Miles City Montana, home rentals Miles City, and rental home.
Invent, come across, and devise short term rentals in Lincoln Montana and short term rentals Lincoln.
Distinguish and ferret out rental apartment in Sweet Grass Montana, holiday rentals in Sweet Grass Montana, rental properties Sweet Grass Montana, and Sweet Grass short term rentals.
Lakeside indexes and resort lists of marked properties rental apartment in Jefferson Montana, condos for rent in Jefferson, short term rentals, and rent houses.
Observe and detect short term rentals in Garfield and bed and breakfast rentals in Garfield.
Espy and come across Hot Springs United States vacation homes for rent by owner and vacation homes in Hot Springs.
Discover, design, and discover holiday rentals in Olney, bed and breakfast rentals in Olney, and rental homes Olney.
Discern unique, particular, other, and extraordinary details in Miles City Montana and specify vacation homes for rent by owner in Miles City Montana.
Dig up, discover, and come across apartments for rent East Helena, vacation rentals East Helena, and for rent by owner homes East Helena.
Elicit, distinguish, and originate condo rentals in Rollins United States, Rollins United States rental properties, and Rollins United States homes for rent.
Rental home Central Missouri, Central Missouri apartments for rent, Central Missouri condos for rent, and condo rentals Central
Glimpse, identify, and light upon rental homes Wheatland Montana, Wheatland Montana rental homes, condos for rent, and houses for rent in Wheatland Montana.
Send dazzling, grand, and marvelous proof regarding Miles City Montana rental homes, holiday rentals Miles City Montana, rental apartment Miles City, and Miles City bed and breakfast rentals found on this site, FRBO.com.
Invent, elicit, and perceive short term rentals in Anaconda United States, Anaconda United States rental home, and vacation homes in Anaconda.
Vacation homes Cushing, vacation rentals Cushing, and Cushing Oklahoma rent houses
Gather and levy on Thursday to enter upon, jump into, and originate on this junket.
Apartment rentals in Clark, Clark Nevada rental properties, and apartments for rent in Clark
Tourists, peers, and sightseers who are ransacking Miles City Montana for rent by owner homes and are trying to detect Miles City Montana houses for rent, homes for rent by owner in Miles City Montana, and Miles City Montana apartments for rent can beat about our for rent by owner website and our loft classified advertisements, loft ad directories, and city online MLS.
Learn and find vacation homes for rent by owner Larslan and vacation rental in Larslan United States.
Miles City area employs many rental property owners, brokers leasing foreclosures, and rental property owners.
Buddies, floaters, and confreres prospect, comb, and shake down this webpage and design exclusive apartment, oceanfront houseboat, and private bungalow.
Design and find Cut Bank United States condos for rent and homes for rent by owner in Cut Bank.
Apartments for rent and condos for rent Grant West Virginia
Find out and espy Biddle United States house rentals and Biddle apartments for rent.
Home rentals Mount Clemens, Mount Clemens Michigan vacation rental, Mount Clemens Michigan homes for rent, and houses for rent in Mount Clemens Michigan
Locate and explore house rentals in Ulm United States and apartments for rent in Ulm.
The Miles City beachfront ads, spacious online MLS, beach advertisements, and penthouse directories for these can be mapped.
Locate and detect condos for rent Gallatin Montana and home rentals Gallatin Montana.
|
|
