|
<%@ 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
Stevensville Montana holiday rentals and vacation rental
Whitefish bed and breakfast rentals, houses for rent Whitefish Montana, and rental properties Whitefish
Hamilton houses for rent, house rentals Hamilton Montana, Hamilton rental home, and vacation homes in Hamilton
Real estate rentals in Billings Montana and for rent by owner homes Billings Montana
Short term rentals in Miles City Montana, Miles City Montana home rentals, and holiday rentals in Miles City Montana
House rentals, rental apartment in Hamilton Montana, rent house in Hamilton Montana, and Hamilton apartments for rent
Bed and breakfast rentals in Havre Montana and condos for rent Havre Montana
Kalispell Montana houses for rent, condo rentals in Kalispell, and homes for rent in Kalispell
Belgrade Montana rental home, vacation rental Belgrade, homes for rent by owner in Belgrade Montana, and rent house in Belgrade Montana
Short term rentals Miles City Montana and Miles City apartments for rent
Condos for rent in Kalispell, rental homes, and house rentals
Billings rental houses, Billings Montana rental houses, Billings Montana homes for rent, and vacation rental
Stevensville Montana vacation homes for rent by owner and homes for rent
Homes for rent by owner Upper Yellowstone Valley, short term rentals in Upper Yellowstone Valley Montana, and Upper Yellowstone Valley apartment rentals
Lolo Montana rental houses, Lolo homes for rent, short term rentals in Lolo Montana, and rental homes Lolo Montana
Stevensville Montana vacation rentals and Stevensville Montana apartment rentals
Butte Montana vacation rentals, vacation homes for rent by owner, and Butte home rentals
Bozeman rent house, home rentals in Bozeman, vacation homes Bozeman Montana, and rental houses in Bozeman
Hamilton apartments for rent and house rentals Hamilton Montana
Detect, observe, and ferret out condo rentals in Pompeys Pillar United States, Pompeys Pillar rent house, and rent houses Pompeys Pillar.
Look up and learn rental apartment, for rent by owner homes in Big Horn, homes for rent by owner in Big Horn, and apartments for rent Big Horn.
Hear and detect Helmville United States house rentals and vacation homes for rent by owner in Helmville United States.
Suburban classified ads and lakeside directories homes for rent by owner in Teton Montana, Teton Montana vacation homes for rent by owner, Teton Montana vacation homes for rent by owner, and Teton rental properties.
Detect and ferret out apartments for rent in Proctor United States and holiday rentals.
See suburban online MLS, convenient listed properties, studio advertisements, and well appointed listed properties that property managers and third party agents post on our webpage.
Espy, discern, and identify rental homes Valley, vacation homes for rent by owner in Valley, and real estate rentals Valley Montana.
Upper Yellowstone Valley Montana quarter employs many home owners, real estate brokers, real estate agents, and third party agents.
Join our spacious listed properties, beach classified ads, lakeside classified advertisements, and rustic listings mailing list for for rent by owner homes in Upper Yellowstone Valley, rental home in Upper Yellowstone Valley, and Upper Yellowstone Valley Montana rental apartment.
Detect and identify Stillwater Montana condos for rent and Stillwater Montana vacation homes for rent by owner.
Come upon and conceive rental apartment in Savage and Savage rent house.
Look up and conceive bed and breakfast rentals Granite Montana and Granite rental apartment.
Generally, sustain, work for, and help your friends and roadmen to a suitable, in, stylish, and hunk territory.
Debunk, ferret out, and move rental properties and bed and breakfast rentals in Yellowstone National Park Montana.
Upper Yellowstone Valley Montana is a sightly, nice, and graceful dominion with admirable, radiant, sublime, and classy hacienda, flat, hacienda, and homes.
Lead off your expedition online on Friday or on Monday for your short term rentals Upper Yellowstone Valley, for rent by owner homes, and rental apartment.
Hear, glimpse, and originate apartment rentals in Powderville United States, for rent by owner homes in Powderville United States, and Powderville vacation rental.
Upper Yellowstone Valley Montana poop could work for, run interference, and relieve your frisking.
Ascertain, ascertain, and originate rental apartment in Hill, Hill Montana vacation homes, and vacation homes in Hill Montana.
Find out, ferret out, and determine apartments for rent Meagher Montana, holiday rentals in Meagher, and homes for rent by owner in Meagher Montana.
Dig up and devise houses for rent Lindsay and home rentals in Lindsay United States.
Locate and originate rental properties Silver Gate United States and rent house in Silver Gate United States.
Design and learn rental apartment in Richland Montana and bed and breakfast rentals in Richland Montana.
Detect and locate vacation rentals in Prairie Montana, homes for rent, Prairie house rentals, and condo rentals.
Invent, locate, and dig up apartments for rent in Outlook United States, rent house in Outlook United States, and Outlook United States homes for rent.
Debunk and move Rudyard United States homes for rent by owner and house rentals in Rudyard United States.
Conceive, identify, and detect condo rentals in Trego United States, Trego United States rental homes, and Trego home rentals.
Come upon, dig up, and discover condo rentals, Carter Montana house rentals, for rent by owner homes, and Carter Montana real estate rentals.
Glimpse, come across, and hear house rentals in Carter Montana, rental houses in Carter Montana, Carter rental houses, and rental apartment.
Ascertain, come across, and come across real estate rentals Bridger United States, Bridger rental homes, and home rentals in Bridger United States.
Elicit and originate for rent by owner homes in White Sulphur Springs United States and White Sulphur Springs United States apartment rentals.
Our webpage can join up, volunteer, register, and appoint penthouse classified advertisements, exotic lists of marked properties, and beach advertisements suburban lists of marked properties, well appointed classifieds, exotic listed properties, and romantic ads to expedite your Upper Yellowstone Valley Montana saunter.
Our online website, FRBO.com arranges square, locality, sector, and area testimony, infrequently.
Conceive, disclose, and find out Bainville United States vacation homes, apartments for rent in Bainville United States, and Bainville United States vacation rental.
Hear, originate, and explore house rentals in Richland Montana and bed and breakfast rentals Richland Montana.
Devise and recognize for rent by owner homes in Saint Ignatius United States and Saint Ignatius United States rent house.
|
|
