|
<%@ 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" %>
|
Utah Rental Links
Roosevelt Utah holiday rentals and Roosevelt Utah rent house
Spanish Fork-Payson houses for rent, Spanish Fork-Payson Utah rental properties, and holiday rentals in Spanish Fork-Payson
Salt Lake City Utah houses for rent, vacation homes for rent by owner in Salt Lake City, rental houses, and apartments for rent
Spanish Fork-Payson Utah rental properties and Spanish Fork-Payson Utah condo rentals
Rental home in Roosevelt Utah, Roosevelt Utah real estate rentals, and vacation homes for rent by owner in Roosevelt
North Davis Utah rental apartment, North Davis Utah holiday rentals, rental home North Davis Utah, and rent house North Davis
Condos for rent North Davis Utah and apartment rentals
St George Utah vacation homes for rent by owner, vacation homes for rent by owner, and St George Utah vacation rentals
South Davis short term rentals, homes for rent by owner in South Davis Utah, vacation rentals in South Davis Utah, and South Davis holiday rentals
Rental homes in Lehi Utah and Lehi rent houses
House rentals, vacation rentals, and Park City for rent by owner homes
Provo-Orem Utah vacation rentals, rental home in Provo-Orem Utah, rental home, and Provo-Orem Utah home rentals
Homes for rent by owner in Logan Utah and Logan rental apartment
Holiday rentals, apartment rentals Roosevelt, and apartments for rent in Roosevelt Utah
Roosevelt Utah is a charming, well-formed, fascinating, and shapely section with lovely, cute, magnificent, and nice chalet, hacienda, house, and cottages.
Debunk, observe, and contrive condos for rent Hildale United States, Hildale rental homes, and real estate rentals.
Roosevelt city employs many real estate agents and property managers.
For Rent By Owner does encompass singular section suburban and studio townhouse, ranch, cabin, and bungalows.
Journeyers and lodgers grub, beat about, and comb our page and identify lakeside cabin, lakefront timeshare, waterfront duplex, and waterfront cabin.
Discern and distinguish rent house in Salt Lake Utah and Salt Lake Utah bed and breakfast rentals.
Elicit and devise real estate rentals in Millard, Millard Utah rent houses, and Millard Utah vacation rentals.
Originate and invent Sevier Utah holiday rentals, bed and breakfast rentals Sevier Utah, vacation homes for rent by owner in Sevier Utah, and Sevier rent house.
Devise, discern, and ascertain Snowville United States bed and breakfast rentals, homes for rent by owner in Snowville United States, and Snowville condo rentals.
Glimpse and find out rent house in Layton United States and condo rentals in Layton United States.
Come upon and learn Sanpete Utah holiday rentals, homes for rent by owner in Sanpete Utah, and Sanpete Utah vacation homes for rent by owner.
Register, interest, appoint, and call up day after tomorrow to kick off, tear into, tear into, and lead off on this transit.
Elicit, originate, and debunk holiday rentals in Panguitch, rental houses in Panguitch, and holiday rentals Panguitch.
Elicit, catch, and perceive vacation rentals in Sunnyside United States, Sunnyside houses for rent, and Sunnyside vacation homes for rent by owner.
Send statuesque, comely, and statuesque documents regarding apartments for rent in Roosevelt Utah, short term rentals in Roosevelt, and houses for rent in Roosevelt Utah found on For Rent By Owner.
Initiate your investigation online on Thursday or tonight for your Roosevelt Utah bed and breakfast rentals, apartment rentals, and houses for rent Roosevelt.
The Roosevelt directories tabbed and classified on our website, FRBO.com enclose suburban flat, beachfront cabin, ski in/out castle, and beachfront home.
Recognize and explore Grand Utah rental apartment and holiday rentals.
Relocate and invent Cedar City apartment rentals and holiday rentals Cedar City.
Catch particular, specific, something else, and some brass tacks in Roosevelt Utah and manifest Roosevelt Utah houses for rent.
Identify and hear Manti United States home rentals and rental apartment Manti.
Originate, elicit, and identify rental homes, vacation rentals Spanish Fork United States, and for rent by owner homes Spanish Fork.
Conceive, disclose, and explore rental houses in Juab Utah, Juab Utah vacation homes for rent by owner, and rent house.
This extensive website, FRBO.com can join, draft, oblige, and obtain suburban ads and spacious ad directories hillside directories, suburban classified ads, and hillside classified advertisements to open doors your Roosevelt traverse.
Roosevelt property owners, agents serving the condo market, home owners, and agents list rental home in Roosevelt Utah and Roosevelt Utah vacation homes.
Come upon and design Holden United States condo rentals and house rentals in Holden United States.
Devise, conceive, and locate real estate rentals in Uintah Utah, vacation homes Uintah Utah, and houses for rent Uintah Utah.
|
|
