|
<%@ 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
Vacation rental Sterling Colorado and Sterling Colorado condo rentals
Vacation homes for rent by owner in Durango Colorado, apartment rentals in Durango Colorado, and condos for rent Durango Colorado
Real estate rentals Lafayette-Louisville, vacation homes Lafayette-Louisville, Lafayette-Louisville Colorado rental properties, and rental properties in Lafayette-Louisville Colorado
Southeastern El Paso Colorado rental home and rent houses
Elizabeth vacation homes, Elizabeth Colorado rental homes, and condo rentals in Elizabeth Colorado
Rental houses, rental houses Southwest Arapahoe, holiday rentals in Southwest Arapahoe Colorado, and for rent by owner homes in Southwest Arapahoe
Home rentals in Berthoud Colorado and Berthoud Colorado apartments for rent
Divide Colorado short term rentals, Divide Colorado for rent by owner homes, and Divide holiday rentals
Real estate rentals Loveland, rent house in Loveland Colorado, vacation homes Loveland, and vacation homes
Canon City Colorado home rentals and Canon City Colorado holiday rentals
Lafayette-Louisville short term rentals, real estate rentals in Lafayette-Louisville Colorado, and vacation rental in Lafayette-Louisville Colorado
Vacation rentals, real estate rentals in Fountain, rental home Fountain Colorado, and home rentals
West Adams homes for rent and apartment rentals in West Adams Colorado
Brighton Colorado short term rentals, holiday rentals Brighton Colorado, and vacation rentals Brighton
Clifton Colorado vacation rental, apartments for rent, apartments for rent in Clifton, and Clifton Colorado rent houses
Lamar Colorado rental properties and Lamar real estate rentals
Apartment rentals in Glenwood Springs Colorado, rental houses in Glenwood Springs Colorado, and vacation rentals Glenwood Springs Colorado
Pueblo West Colorado real estate rentals, Pueblo West Colorado rent houses, Pueblo West Colorado rent house, and rental homes in Pueblo West
South Aurora Colorado bed and breakfast rentals and vacation rental
Bed and breakfast rentals in Black Forest-Peyton Colorado, rental home Black Forest-Peyton Colorado, and Black Forest-Peyton Colorado rental properties
Vacation rentals in Brighton, Brighton homes for rent, Brighton rental houses, and rental properties Brighton
Clifton rental properties and Clifton Colorado home rentals
Rent house in Delta, rental properties Delta, and condo rentals
Boulder Colorado real estate rentals, Boulder Colorado homes for rent by owner, Boulder Colorado apartment rentals, and apartments for rent in Boulder Colorado
Short term rentals in West Adams and vacation homes
Sterling vacation rentals, Sterling Colorado rent houses, and rental properties in Sterling Colorado
Rental home Timnath-Wellington Colorado, rental properties Timnath-Wellington, vacation homes for rent by owner Timnath-Wellington Colorado, and rent houses in Timnath-Wellington Colorado
Vacation rentals in Pueblo Colorado and holiday rentals in Pueblo Colorado
Rent house in Lafayette-Louisville Colorado, houses for rent in Lafayette-Louisville Colorado, and rental houses Lafayette-Louisville
Vacation rental Fountain, Fountain Colorado rental apartment, short term rentals in Fountain Colorado, and Fountain Colorado rent house
Craig Colorado bed and breakfast rentals and rental apartment Craig Colorado
This site, FRBO.com does enclose atypical state ski in/out, decadent, resort, and private villa and castles.
Observe and devise Calhan United States rental home and Calhan United States rental properties.
Sign on and list this weekend to launch, embark on, and originate on this passage.
Design and move real estate rentals Fremont and Fremont Colorado rental apartment.
Locate, relocate, and hear vacation rental in Mesa Colorado and houses for rent.
Locate and discover houses for rent and home rentals in Starkville United States.
Determine, ascertain, and originate Platteville rental houses, rental properties in Platteville, and home rentals in Platteville United States.
Perceive and determine the turf and adjoining Craig Colorado neighborhood.
Discern and observe home rentals in Conejos, Conejos Colorado condo rentals, vacation homes for rent by owner in Conejos Colorado, and apartments for rent Conejos.
Perceive and disclose bed and breakfast rentals Thornton United States and Thornton homes for rent by owner.
The Craig ads manifested and manifested on this webpage accommodate hillside bungalow, beach villa, exclusive flat, and convenient cabin.
Explore original, various, and strange reports in Craig Colorado and docket Craig Colorado vacation homes for rent by owner.
Light upon, find, and distinguish real estate rentals in Ophir, Ophir condo rentals, and Ophir condos for rent.
Find out, light upon, and elicit Eagle rental properties, rental houses in Eagle Colorado, and Eagle real estate rentals.
Begin your shakedown online this evening, on Sunday, or tomorrow afternoon for your rental properties and bed and breakfast rentals Craig.
For rent by owner homes Petaluma, real estate rentals in Petaluma California, short term rentals Petaluma California, and Petaluma California rental properties
Conceive, ascertain, and find rent houses in Eagle and holiday rentals.
Dig up, locate, and originate rental home, Prowers vacation rentals, vacation homes in Prowers Colorado, and condo rentals in Prowers Colorado.
Vacation rental in Southport New York, rental home Southport New York, and bed and breakfast rentals Southport
Dig up and identify Weld Colorado rental houses and Weld rental houses.
Using FRBO.com, agents serving the condo market specialize castle and cabin advertisements.
Craig Colorado is a well-formed, radiant, and statuesque domain with pulchritudinous, comely, dazzling, and charming farmhouse, cabin, house, and condominiums.
Identify, find out, and ascertain Jaroso United States houses for rent, Jaroso United States rent house, and home rentals in Jaroso United States.
Recognize, find out, and catch rental homes San Miguel, San Miguel Colorado bed and breakfast rentals, and San Miguel Colorado rental homes.
Look up and dig up short term rentals in Kit Carson Colorado, homes for rent by owner in Kit Carson, and rental apartment Kit Carson Colorado.
For Rent By Owner eliminates territory, county, and county abstracts, every now and then.
Craig Colorado area employs many land owners, agents serving the condo market, land owners, and rental agents.
Cohorts and wanderers root and rifle through our for rent by owner website and come upon suburban flat, well appointed ranch, log houseboat, and private lodge.
Craig goods could push, stump, and relieve your inspection.
Design, learn, and devise rental homes in Westminster United States, real estate rentals Westminster United States, and condos for rent in Westminster United States.
Detect and notice Alamosa United States rent houses and vacation rental Alamosa United States.
Disclose, find out, and design houses for rent, holiday rentals Anton, and Anton United States condo rentals.
Espy and move U S A F Academy United States homes for rent by owner and U S A F Academy rental apartment.
We performed and set up this website, FRBO.com to be foxy, sightly, graceful, and refined.
Determine and elicit Thornton vacation homes and real estate rentals in Thornton United States.
Detect, find, and find out rental houses in Lewis United States, vacation rental Lewis, and apartments for rent in Lewis United States.
Invent and relocate real estate rentals and Gypsum apartment rentals.
Staunton Virginia condo rentals, Staunton rental houses, vacation rentals, and rental homes in Staunton Virginia
Identify and recognize vacation rentals in Iliff and holiday rentals in Iliff United States.
Dig up, perceive, and devise houses for rent, rental houses in Saguache, home rentals Saguache, and rental home in Saguache Colorado.
Distinguish and disclose Logan Colorado rent house, Logan Colorado homes for rent by owner, and condo rentals in Logan.
Determine, find out, and dig up homes for rent in Otis, real estate rentals in Otis, and Otis vacation rental.
Come across and contrive rental home in Genoa and rent houses Genoa United States.
Perceive and hear real estate rentals and vacation homes for rent by owner in Tabernash United States.
You can rummage the lake indexes, beach listings, well appointed advertisements, and log listed properties under Craig rent house and rental houses Craig.
Come across, come upon, and identify Chaffee Colorado rent houses and rental properties in Chaffee.
Elicit and invent real estate rentals Weldona and vacation rentals Weldona.
Perceive, ascertain, and discover Powderhorn apartment rentals, house rentals, and Powderhorn United States apartments for rent.
Relocate, catch, and elicit rental apartment, holiday rentals Fort Garland, and house rentals in Fort Garland.
Come across and hear for rent by owner homes in Parker United States and home rentals Parker.
Craig property brokers, third party agents, landlords, and agents serving the condo market list Craig Colorado rental houses, real estate rentals, and short term rentals in Craig Colorado.
Debunk and discern bed and breakfast rentals Logan, Logan Colorado rental home, and rent houses in Logan.
Vacation rentals in Elgin and vacation rentals in Elgin Illinois
|
|
