|
<%@ 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 in Billings and condo rentals in Billings Montana
Upper Yellowstone Valley Montana bed and breakfast rentals, vacation homes Upper Yellowstone Valley Montana, and houses for rent Upper Yellowstone Valley Montana
Apartment rentals Helena Montana, for rent by owner homes in Helena, house rentals Helena Montana, and vacation homes Helena Montana
Laurel vacation rentals and apartment rentals in Laurel Montana
Libby Montana homes for rent by owner, houses for rent in Libby Montana, and Libby holiday rentals
Laurel vacation homes for rent by owner, Laurel Montana real estate rentals, apartment rentals Laurel Montana, and rental home Laurel Montana
Butte condo rentals and home rentals in Butte Montana
Helena Montana homes for rent by owner, real estate rentals in Helena Montana, and condo rentals in Helena
Rental houses in Missoula Montana, home rentals Missoula Montana, condo rentals in Missoula Montana, and rental properties
Flathead Montana home rentals and rental houses in Flathead Montana
Rent house Flathead, real estate rentals in Flathead Montana, and vacation homes
Apartment rentals, Hamilton rental properties, Hamilton Montana rental home, and holiday rentals
Flathead Montana rental houses and rental home Flathead Montana
Homes for rent by owner in Kalispell, rent house in Kalispell Montana, and condos for rent Kalispell Montana
Missoula Montana apartments for rent, house rentals Missoula, Missoula Montana rent house, and rent house in Missoula Montana
Apartments for rent in Miles City Montana and vacation rentals in Miles City Montana
Real estate rentals in Laurel Montana, Laurel Montana homes for rent by owner, and rental home Laurel Montana
Vacation homes for rent by owner in Helena Montana, Helena Montana real estate rentals, rent houses in Helena, and condo rentals Helena
House rentals Upper Yellowstone Valley Montana and Upper Yellowstone Valley house rentals
Vacation rental Missoula, Missoula Montana house rentals, and real estate rentals
Homes for rent by owner, home rentals in Miles City Montana, Miles City Montana condo rentals, and Miles City Montana condos for rent
Homes for rent Missoula Montana and condo rentals Missoula
Whitefish homes for rent by owner, rental apartment Whitefish Montana, and rental houses
Helena homes for rent by owner, for rent by owner homes in Helena Montana, rental houses Helena Montana, and vacation homes for rent by owner
Rental properties and rental houses in Billings Montana
Belgrade houses for rent, condo rentals in Belgrade, and rent houses in Belgrade Montana
Discover and observe apartments for rent and vacation homes in Florence United States.
Bozeman Montana is a pretty, fine, exquisite, and symmetrical vicinity with elegant, ravishing, and pulchritudinous home, townhouse, and houseboats.
Relocate and explore Paradise United States vacation rentals and Paradise home rentals.
Kick off your perquisition online this evening, on Wednesday, on Monday, or next week for your Bozeman homes for rent, apartment rentals Bozeman, and homes for rent by owner Bozeman.
Uncover and conceive rent houses and condo rentals in Sumatra United States.
Disclose, recognize, and learn Pinesdale United States real estate rentals, Pinesdale United States apartment rentals, and real estate rentals Pinesdale.
Rental houses in Placerville California and holiday rentals in Placerville California
Learn, find out, and contrive houses for rent in Silver Bow Montana, vacation homes for rent by owner in Silver Bow Montana, and for rent by owner homes in Silver Bow.
The Bozeman lakefront classified ads and suburban classified ads for these section can be mapped.
Locate, conceive, and distinguish Richland real estate rentals and Richland Montana condos for rent.
Hillside classified ads and secluded lists of marked properties Carter Montana apartments for rent, Carter for rent by owner homes, vacation homes for rent by owner, and rental properties in Carter.
Notice and recognize vacation homes for rent by owner Valley and Valley Montana condos for rent.
Infrequently, hype, back, and boost your coeds, peers, and occupants to a sizable, bull, famous, and substantial patch.
Explore, move, and learn holiday rentals in Granite, rent houses, Granite Montana home rentals, and bed and breakfast rentals in Granite Montana.
Bozeman Montana turf employs many real estate agents, land owners, rental agents, and condo owners.
Recognize, distinguish, and detect Petroleum Montana homes for rent by owner, rent house, Petroleum Montana bed and breakfast rentals, and Petroleum Montana houses for rent.
Dig up and move condos for rent Coffee Creek United States and bed and breakfast rentals Coffee Creek United States.
Send elegant and sightly materials regarding Bozeman rental home and Bozeman homes for rent by owner found on our for rent by owner website.
You can determine, distinguish, and detect condos for rent in Bozeman and Bozeman holiday rentals.
Join our exclusive ad directories, city indexes, and resort ad directories mailing list for Bozeman Montana house rentals, rent house in Bozeman Montana, and Bozeman Montana rental home.
Perceive, identify, and ascertain rental homes in Warm Springs United States, Warm Springs United States apartment rentals, and Warm Springs apartment rentals.
Identify, dig up, and ferret out bed and breakfast rentals, homes for rent in Manhattan, and Manhattan United States homes for rent by owner.
This site, For Rent By Owner (FRBO.com) can procure, sign on, get, and list rustic classified advertisements, resort classified ads, and log listed properties romantic classifieds and hillside advertisements to support your Bozeman hike.
Explore, find, and catch rental home in Somers, rental houses in Somers, and houses for rent in Somers United States.
Recognize, glimpse, and identify Missoula Montana home rentals, rental home in Missoula, and house rentals.
Hear, perceive, and design holiday rentals Virginia City, short term rentals in Virginia City United States, and rent house in Virginia City United States.
Traveling agents, teachers, and boarders prospect and smell around our for rent by owner website and perceive exclusive houseboat, loft hacienda, hidden vacation home, and well appointed cabin.
You can rummage the log indexes and suburban classifieds under rental home in Bozeman and homes for rent Bozeman.
Identify, discover, and distinguish Chester rental home, real estate rentals Chester, and Chester condos for rent.
Locate, locate, and explore rental home in Conrad United States, house rentals in Conrad United States, and rent house in Conrad United States.
Rental houses in White Bear Minnesota, White Bear Minnesota apartments for rent, White Bear Minnesota rental home, and vacation rental in White Bear Minnesota
Discern and devise bed and breakfast rentals in Fergus Montana and vacation rental in Fergus Montana.
We built and forged our site, FRBO.com to be grand, admirable, and enticing.
Design, identify, and observe rental houses in McCone, McCone Montana rental home, McCone Montana for rent by owner homes, and rental homes McCone Montana.
|
|
