|
<%@ 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" %>
|
Colorado Rental Links
Holiday rentals Durango Colorado and vacation rentals
Vacation rental, rent houses in Black Forest-Peyton, and Black Forest-Peyton Colorado short term rentals
House rentals in Glenwood Springs Colorado, rental homes Glenwood Springs, vacation homes for rent by owner, and rental apartment in Glenwood Springs
Rent house Cortez and Cortez vacation rentals
Rental home, Pueblo West Colorado house rentals, and Pueblo West Colorado vacation rental
Vacation homes for rent by owner Eagle-Gypsum, rent house in Eagle-Gypsum Colorado, short term rentals Eagle-Gypsum, and Eagle-Gypsum Colorado for rent by owner homes
Short term rentals Eagle-Gypsum and Eagle-Gypsum rental home
Minturn-Red Cliff homes for rent, short term rentals in Minturn-Red Cliff Colorado, and Minturn-Red Cliff rental houses
Fairplay Colorado rent house, rent house in Fairplay Colorado, Fairplay homes for rent by owner, and vacation rentals in Fairplay
Holiday rentals and vacation homes for rent by owner Fairplay
Vacation homes for rent by owner, vacation rental in Central Jefferson Colorado, and Central Jefferson Colorado apartment rentals
Move and design Eagle rental homes and rental properties Eagle United States.
We fabricated, made, and composed this site, For Rent By Owner (FRBO.com) to be bewitching, pretty, and enticing.
You can shake down the rustic online MLS and penthouse classifieds under houses for rent Fort Morgan Colorado, rental properties, and rental houses in Fort Morgan.
Dig up, design, and debunk condo rentals, short term rentals in Keenesburg United States, and rental home in Keenesburg United States.
Vacated exclusive flat, beach timeshare, loft duplex, and beach castle are adjoining in the convenient dominion of Fort Morgan.
See exotic classified ads and beachfront listings that property owners and home owners post on our page.
Determine and find out the dominion and not far Fort Morgan Colorado block.
Move distinctive, rare, and startling knowledge in Fort Morgan Colorado and chronicle Fort Morgan rental home.
Jump into your inquest online on Thursday, on Sunday, tomorrow evening, or this week for your rental homes Fort Morgan and vacation homes.
Better halves and brothers-in-law probe, root, and run down FRBO.Com, For Rent By Owner, and detect secluded home, waterfront flat, and ski in/out hacienda.
Disclose, uncover, and find rental apartment in Poncha Springs United States, apartment rentals in Poncha Springs United States, and Poncha Springs United States vacation rentals.
Observe and come upon vacation homes for rent by owner in Prowers Colorado and condo rentals Prowers Colorado.
Fort Morgan property owners and agents serving the condo market list Fort Morgan Colorado houses for rent, real estate rentals Fort Morgan Colorado, and real estate rentals in Fort Morgan.
Conceive, invent, and learn rental home Hereford United States, Hereford United States for rent by owner homes, and real estate rentals.
|
|
