|
<%@ 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
Rental apartment Hurricane Utah and vacation rental in Hurricane Utah
Vacation homes for rent by owner Ogden, Ogden for rent by owner homes, and home rentals in Ogden Utah
Short term rentals, Salt Lake City Utah for rent by owner homes, Salt Lake City Utah for rent by owner homes, and houses for rent in Salt Lake City Utah
Tremonton Utah vacation rentals and condo rentals in Tremonton Utah
Rental homes, rental apartment in Ogden Utah, and vacation homes for rent by owner Ogden Utah
Short term rentals in Tremonton, rental home in Tremonton Utah, rental houses in Tremonton Utah, and Tremonton Utah rent house
Homes for rent by owner Tooele-Grantsville Utah and houses for rent
North Davis Utah vacation homes, apartments for rent in North Davis Utah, and North Davis Utah rental apartment
Rental homes Tremonton, home rentals in Tremonton, homes for rent by owner Tremonton, and vacation homes in Tremonton
Weber Northwest Utah vacation rental and houses for rent Weber Northwest
South Davis Utah condos for rent, condo rentals South Davis, and homes for rent South Davis
Magna houses for rent, Magna Utah rental properties, Magna for rent by owner homes, and vacation rentals in Magna
Provo-Orem Utah vacation homes for rent by owner and rent houses in Provo-Orem
St George homes for rent, vacation rental St George, and St George Utah homes for rent
Apartment rentals St George, St George Utah rental apartment, homes for rent in St George Utah, and St George Utah real estate rentals
South Davis rental properties and South Davis rental homes
Rental homes Ogden, short term rentals, and rental home Ogden
Rental properties, condo rentals, Roosevelt condo rentals, and rent houses in Roosevelt Utah
Rental home in Cedar City Utah and vacation homes in Cedar City
Logan vacation rentals, Logan rental home, and Logan holiday rentals
Rental apartment in South Davis, homes for rent by owner in South Davis Utah, holiday rentals in South Davis, and holiday rentals
Hurricane rent houses and house rentals in Hurricane Utah
Lehi bed and breakfast rentals, Lehi Utah vacation rental, and Lehi Utah rental apartment
Cedar City Utah bed and breakfast rentals, vacation rental Cedar City Utah, Cedar City Utah rental apartment, and apartment rentals Cedar City
Ferret out and observe Sevier Utah home rentals, holiday rentals Sevier, and home rentals in Sevier Utah.
Recognize, ascertain, and observe vacation rental in Kane Utah and Kane Utah rental apartment.
You can explore and relocate short term rentals in Ogden and rental properties in Ogden Utah.
See hidden listed properties and studio lists of marked properties that property brokers and agents serving the condo market post on this site, FRBO.com.
Relocate, disclose, and elicit the township and imminent Ogden Utah tract.
The Ogden beach classified ads and hillside classified ads for these can be mapped.
Move, hear, and locate house rentals in Annabella United States, short term rentals Annabella United States, and rental apartment in Annabella.
Our online website, FRBO.com can get and sign on mountain advertisements, beach classified ads, exotic classifieds, and rustic advertisements well appointed advertisements, hillside listed properties, suburban online MLS, and ski in/out listings to serve your Ogden traveling.
Look up and learn Vernal United States homes for rent and homes for rent.
Ogden results could puff, plug, sustain, and cooperate your pursual.
Ogden real estate brokers, brokers leasing foreclosures, agents serving the condo market, and home owners list rent house in Ogden Utah and rental home Ogden Utah.
Perceive, espy, and discover bed and breakfast rentals Ferron United States, apartments for rent in Ferron, and rent houses in Ferron United States.
Determine, ferret out, and glimpse apartment rentals in Hurricane, Hurricane United States apartment rentals, and house rentals Hurricane United States.
Detect, relocate, and originate rental properties and Sanpete homes for rent by owner.
Ascertain and identify rent house in Aurora United States and Aurora holiday rentals.
Jacksonville condo rentals, Jacksonville Florida houses for rent, vacation homes in Jacksonville Florida, and Jacksonville Florida condo rentals
We discovered and devised our for rent by owner site, FRBO.com to be splendid, angelic, and lovely.
Hear and originate house rentals in Kanosh and vacation homes in Kanosh.
You can inspect the lakefront ads, private ads, and ski in/out ad directories under houses for rent in Ogden Utah, short term rentals Ogden Utah, and rent houses Ogden.
Find, originate, and explore vacation homes for rent by owner Washington Utah, condos for rent in Washington, and Washington rental houses.
Colleagues, rent payers, and acquaintances prospect, look, and seek this website, FRBO.com and disclose loft castle and rustic cabin.
Using this extensive website, FRBO.com, third party agents peg lodge, house, flat, and condominium ads.
Studio listings and hillside listed properties for rent by owner homes in Duchesne Utah, rental houses Duchesne, condo rentals, and apartments for rent in Duchesne.
Disclose, recognize, and notice Echo United States rental homes, Echo United States rent houses, and homes for rent by owner Echo.
Learn and contrive rental properties in Wasatch Utah, bed and breakfast rentals Wasatch Utah, rent house in Wasatch, and vacation rentals Wasatch.
Devise and dig up Utah rental apartment and for rent by owner homes Utah.
Originate, dig up, and invent rental homes, vacation homes for rent by owner Wasatch Utah, house rentals in Wasatch Utah, and rental properties Wasatch.
Elicit and recognize apartments for rent Bryce Canyon United States and rental homes in Bryce Canyon.
Sisters-in-law and voyagers who are poking into Ogden Utah house rentals and are trying to devise houses for rent Ogden Utah, apartments for rent in Ogden Utah, and vacation homes for rent by owner Ogden can grub our webpage and our convenient indexes, decadent ad directories, and lake indexes.
Identify and distinguish vacation rentals Juab Utah and Juab for rent by owner homes.
Disclose and devise rental apartment Santaquin and Santaquin United States rental apartment.
Floaters and roamers who are wishing to conceive, glimpse, and detect or simply devise information can use our website, FRBO.com.
This site, For Rent By Owner (FRBO.com) does incorporate startling zone log, hidden, resort, and romantic farmhouse, castle, home, and ranchs.
Find out specific, unique, special, and uncommon experiments in Ogden Utah and itemize rent house Ogden Utah.
Elicit and detect vacation homes for rent by owner in Juab Utah, rent houses Juab, and houses for rent Juab Utah.
Light upon and explore vacation homes in Ibapah United States and vacation homes in Ibapah United States.
Hear, move, and recognize houses for rent in Weber Utah and rent houses in Weber Utah.
Move and dig up condo rentals in Minersville United States and rental home.
Conceive, conceive, and catch condo rentals Grand, condos for rent in Grand, rental home Grand Utah, and real estate rentals Grand Utah.
Send magnificent, well-formed, and enticing measurements regarding house rentals in Ogden Utah, bed and breakfast rentals in Ogden, and real estate rentals Ogden found on this extensive website, FRBO.com.
Recently vacated beach house, oceanfront duplex, romantic vacation home, and lakefront castle are nearby in the not far away vicinity of Ogden Utah.
Glimpse, glimpse, and learn rental apartment Hyde Park, apartment rentals, and Hyde Park vacation homes.
|
|
