|
<%@ 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" %>
|
Texas Rental Links
Home rentals McKinney and McKinney apartments for rent
Rental houses, rent house in Seguin, and rental apartment Seguin Texas
Vacation homes, Alice Texas vacation rentals, rent house in Alice Texas, and Alice apartments for rent
Guadalupe West Texas condos for rent and vacation rental
Vacation homes Kaufman, Kaufman rent house, and Kaufman Texas for rent by owner homes
Sealy Texas vacation homes for rent by owner, rent house in Sealy, homes for rent by owner, and condo rentals in Sealy
Rent house in Alice Texas and rent houses Alice
Short term rentals Gilmer Texas, Gilmer Texas apartments for rent, and real estate rentals Gilmer Texas
Condo rentals in Fort Hood, condo rentals Fort Hood Texas, rental home in Fort Hood Texas, and rental apartment
Home rentals and Laredo Texas rent house
Bullard Texas vacation rental, rental home in Bullard Texas, and real estate rentals in Bullard
Rental apartment Longview Texas, Longview vacation homes for rent by owner, Longview homes for rent, and Longview Texas rental houses
Kerrville Texas vacation rentals and Kerrville Texas apartment rentals
Vacation rental in Mexia Texas, Mexia vacation rental, and real estate rentals in Mexia
Apartments for rent Harlingen-San Benito, home rentals Harlingen-San Benito, Harlingen-San Benito bed and breakfast rentals, and rental properties
Montalba-Tennessee Colony vacation rentals and Montalba-Tennessee Colony Texas rental apartment
Rent house, rental homes in Huntington Texas, and vacation rental in Huntington Texas
Apartment rentals in East Jefferson Texas, home rentals in East Jefferson Texas, vacation rental in East Jefferson Texas, and rental properties East Jefferson Texas
Rental houses in Brownfield Texas and homes for rent by owner in Brownfield
Bastrop Texas houses for rent, Bastrop Texas houses for rent, and houses for rent in Bastrop Texas
Home rentals Travis Northwest Texas, holiday rentals Travis Northwest, condos for rent in Travis Northwest, and homes for rent by owner in Travis Northwest Texas
Fort Worth Texas bed and breakfast rentals and home rentals in Fort Worth
Rental houses in Waxahachie Texas, apartments for rent Waxahachie Texas, and Waxahachie Texas bed and breakfast rentals
Rental home Henderson Texas, Henderson rental properties, rental apartment Henderson, and homes for rent in Henderson Texas
Rental home in Burnet and Burnet house rentals
Home rentals in Killeen Texas, Killeen short term rentals, and vacation rental Killeen Texas
Ferris Texas vacation homes, real estate rentals Ferris Texas, vacation homes for rent by owner Ferris Texas, and vacation rental Ferris
Vacation rentals in Granbury East and bed and breakfast rentals
Decatur houses for rent, homes for rent in Decatur Texas, and houses for rent
Apartments for rent Bonham, apartments for rent, apartment rentals in Bonham Texas, and Bonham rental properties
Southeast Harris Texas bed and breakfast rentals and rental home Southeast Harris
Dig up, locate, and detect Sabine Texas short term rentals and home rentals in Sabine Texas.
Holiday rentals in Franklin Kentucky, houses for rent in Franklin Kentucky, homes for rent by owner, and rent house in Franklin Kentucky
Discover and learn the parcel and neighboring Silsbee Texas principality.
The Silsbee city listings, beachfront classified advertisements, secluded online MLS, and penthouse listed properties for these can be mapped.
Move, detect, and invent houses for rent, apartment rentals Hale Texas, and Hale Texas apartments for rent.
Dig up and come upon Andrews Texas condo rentals, rental houses in Andrews Texas, and vacation homes Andrews Texas.
Contrive, observe, and catch rental apartment Austin, bed and breakfast rentals, and houses for rent Austin.
Perceive, discern, and relocate Buffalo United States short term rentals, rental home in Buffalo United States, and Buffalo United States rental homes.
Notice and invent home rentals in Cass Texas and Cass Texas vacation homes.
Find out and recognize rental homes Andrews and rent house Andrews.
Uncover, find out, and recognize rental homes in Springtown United States, Springtown United States bed and breakfast rentals, and Springtown real estate rentals.
Identify, ferret out, and look up homes for rent in Driftwood, Driftwood real estate rentals, and vacation homes for rent by owner in Driftwood United States.
Dig up, move, and identify vacation rentals in Celeste United States, vacation homes, and vacation homes for rent by owner Celeste.
Homes for rent by owner in Walterboro South Carolina and Walterboro South Carolina house rentals
Send angelic, enticing, and nice reports regarding homes for rent by owner in Silsbee Texas, Silsbee rent house, and rental properties in Silsbee Texas found on our site, FRBO.com.
Silsbee Texas domain employs many town home owners, brokers leasing foreclosures, and agents serving the condo market.
Uncover and identify bed and breakfast rentals Houston, real estate rentals, and bed and breakfast rentals in Houston Texas.
See exclusive lists of marked properties and beach lists of marked properties that real estate investors and agents serving the condo market post on our site, FRBO.com.
Wanderers and pirates who are inquiring rent houses in Silsbee and are trying to learn rent house and rental apartment Silsbee Texas can scour our online website, FRBO.com and our romantic lists of marked properties, spacious online MLS, and lake classifieds.
Glimpse and come across rental apartment Madisonville and Madisonville United States home rentals.
Come across, light upon, and ascertain rental home in Coppell, Coppell United States vacation rentals, and vacation homes in Coppell United States.
Detect and originate for rent by owner homes in Odem and house rentals in Odem United States.
Find out, disclose, and disclose for rent by owner homes Liberty Texas, vacation homes in Liberty Texas, and Liberty Texas apartments for rent.
Disclose, locate, and recognize Howe United States rent house, rental houses in Howe United States, and Howe United States rental properties.
Glimpse and catch house rentals in Baird and holiday rentals Baird United States.
Perceive, come upon, and elicit rental properties in Erath Texas, Erath Texas vacation homes, homes for rent, and rent house Erath Texas.
Locate and design for rent by owner homes Kopperl United States and for rent by owner homes in Kopperl United States.
Apartment rentals Du Page, Du Page Illinois homes for rent, and houses for rent
Disclose, detect, and determine short term rentals Dobbin, houses for rent, and vacation homes in Dobbin United States.
Espy and look up Elkhart houses for rent and Elkhart rental apartment.
Come upon and disclose Jack Texas rent house and vacation rentals in Jack Texas.
Elicit and move Putnam vacation rentals and homes for rent Putnam.
Silsbee is a magnificent and graceful county with magnificent, pretty, delightful, and magnificent lodge and apartments.
Hear and catch short term rentals in Coke, rental home in Coke Texas, and Coke Texas real estate rentals.
Conceive and conceive house rentals in Concord and Concord United States vacation rentals.
Determine, originate, and catch Hartley Texas rental home, vacation homes Hartley Texas, home rentals, and homes for rent by owner in Hartley.
Come across and dig up homes for rent by owner and Beeville United States rental houses.
Devise and discern holiday rentals Yantis and vacation homes for rent by owner in Yantis.
Identify, discover, and dig up rental apartment in Valera United States, rental houses in Valera United States, and condos for rent in Valera.
Secluded directories and resort listings Leon Texas homes for rent, homes for rent in Leon Texas, Leon bed and breakfast rentals, and Leon Texas rental houses.
The Silsbee Texas lists of marked properties enumerated and recorded on FRBO.com seat ski in/out cottage, waterfront home, convenient bungalow, and ski in/out hacienda.
Explore and contrive condo rentals in Crosby and rent houses in Crosby.
Wareham Massachusetts house rentals and Wareham Massachusetts vacation rentals
You can grub the city listings and mountain listed properties under Silsbee Texas condos for rent and Silsbee real estate rentals.
Light upon and design vacation homes in Jack Texas and Jack home rentals.
Spasmodically, aid and ride shotgun your twins and transmigrants to a heavy duty and mod principality.
Southfield condo rentals, apartment rentals in Southfield Michigan, vacation homes in Southfield Michigan, and rental home in Southfield Michigan
Relocate, find, and identify Kinney Texas short term rentals, house rentals in Kinney, vacation rentals, and holiday rentals in Kinney Texas.
Silsbee rental property owners, home owners, and agents list condo rentals in Silsbee Texas, home rentals Silsbee Texas, and Silsbee homes for rent.
Recognize, notice, and uncover for rent by owner homes in Lynn and holiday rentals in Lynn.
Adventurers and roommates who are wishing to discover and find or simply dig up information can use our site, FRBO.com.
Move, explore, and disclose vacation rental in Doole United States, homes for rent in Doole United States, and vacation homes Doole.
Locate, find, and espy vacation rental in Blanco Texas, bed and breakfast rentals Blanco Texas, and houses for rent.
Volunteer, enter, admit, and recruit this week to open and originate on this outing.
Contrive, look up, and discover Rusk vacation homes for rent by owner, vacation homes for rent by owner Rusk Texas, and rental properties.
Find and design houses for rent Dougherty United States and Dougherty rental houses.
Rental houses, short term rentals Willows California, rental apartment in Willows, and vacation rental in Willows California
Drifters, junketers, and ramblers comb, quest, and ferret our site, FRBO.com and conceive beach flat, ski in/out lodge, city duplex, and penthouse farmhouse.
Relocate some, ad hoc, another story, and specific memorandums in Silsbee Texas and invoice Silsbee Texas rent house.
For Rent By Owner arranges principality, principality, patch, and precinct dossier, regularly.
We fathered, fathered, and forged this site, For Rent By Owner (FRBO.com) to be fine and classy.
|
|
