|
<%@ 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
Havre Montana short term rentals and Havre for rent by owner homes
Bozeman Montana vacation homes for rent by owner, Bozeman rental properties, and homes for rent by owner Bozeman
Flathead Montana homes for rent, Flathead homes for rent by owner, apartment rentals in Flathead Montana, and Flathead Montana condos for rent
Lolo Montana rental properties and Lolo Montana rental houses
Great Falls apartment rentals, vacation homes for rent by owner in Great Falls, and vacation homes for rent by owner in Great Falls Montana
Great Falls Montana for rent by owner homes, rental apartment in Great Falls Montana, apartment rentals, and rent house in Great Falls Montana
Hamilton Montana rental home and for rent by owner homes Hamilton Montana
House rentals Hamilton Montana, vacation rental in Hamilton Montana, and rental homes in Hamilton
Vacation rental in Bozeman Montana, Bozeman bed and breakfast rentals, for rent by owner homes Bozeman, and for rent by owner homes in Bozeman
Billings Montana condos for rent and rent houses in Billings Montana
Embody, join up, hitch, and interest this week to kick off, inaugurate, and lead off on this run.
Send superb, admirable, and divine whole story regarding homes for rent by owner Missoula and vacation homes for rent by owner in Missoula Montana found on FRBO.com.
Disclose, identify, and perceive vacation rental in Carter Montana and Carter vacation homes.
Beachfront ad directories and exclusive classified ads Judith Basin Montana real estate rentals, rent house Judith Basin, Judith Basin Montana homes for rent, and rental homes Judith Basin Montana.
Kick off your inquest online this week, tomorrow evening, in the morning, or tomorrow morning for your Missoula real estate rentals and rental apartment in Missoula.
Missoula Montana info could sustain, expedite, reinforce, and plug your inquiry.
Dig up, locate, and ferret out house rentals in Garfield, rental home Garfield Montana, and Garfield Montana apartments for rent.
Relocate and locate rental homes in Browning and vacation homes in Browning United States.
Discern and catch homes for rent by owner Hill and rental properties in Hill.
Occupiers, speculators, and peers ransack and search for our site, FRBO.com and discern romantic villa and hillside villa.
The Missoula decadent lists of marked properties and exotic classified advertisements for these parcel can be mapped.
Identify and identify real estate rentals Garfield and short term rentals Garfield Montana.
You can find, dig up, and invent houses for rent and rental apartment in Missoula Montana.
Missoula home owners, brokers leasing foreclosures, property managers, and agents serving the condo market list bed and breakfast rentals in Missoula, Missoula Montana home rentals, and Missoula rent houses.
Dig up, notice, and detect Coram vacation homes, Coram rental homes, and Coram condo rentals.
Contrive, devise, and uncover apartment rentals, condo rentals, Prairie Montana vacation homes for rent by owner, and Prairie Montana rental properties.
Locate specialized, diverse, and specific results in Missoula Montana and keep count holiday rentals Missoula.
Contrive, determine, and distinguish vacation rental in Hill, vacation homes for rent by owner Hill, and houses for rent.
The Missoula Montana listed properties polled and booked on our webpage consist of lake home and exotic vacation home.
Glimpse and debunk apartment rentals Cascade, condos for rent in Cascade Montana, rental properties, and rental home.
See romantic advertisements, secluded directories, resort directories, and convenient classifieds that property agents and property managers post on our site, FRBO.com.
We phrased and spawned this extensive website, FRBO.com to be beauteous and alluring.
|
|
