|
<%@ 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
Rental houses Northeast Brazos and vacation homes in Northeast Brazos
Rent house in Brazosport Texas, homes for rent Brazosport, and Brazosport Texas house rentals
Athens Texas real estate rentals, Athens Texas rental homes, vacation homes for rent by owner in Athens Texas, and rental properties in Athens
Rental home North Randall and North Randall Texas vacation rental
Holiday rentals Canyon, vacation rental in Canyon Texas, and rental properties
Home rentals Pilot Point-Aubrey Texas, home rentals in Pilot Point-Aubrey, rental home in Pilot Point-Aubrey Texas, and vacation rentals in Pilot Point-Aubrey Texas
Homes for rent in Travis Northwest Texas and condo rentals in Travis Northwest Texas
Apartment rentals in Longview, Longview homes for rent, and Longview Texas vacation rentals
Houses for rent Floresville, vacation rental Floresville, Floresville rental houses, and condo rentals Floresville Texas
Waskom houses for rent and home rentals in Waskom
Apartment rentals in Brownfield Texas, rent house, and vacation rental in Brownfield Texas
El Paso East Texas homes for rent, homes for rent by owner, for rent by owner homes El Paso East, and apartment rentals in El Paso East Texas
Vacation rental McAllen-Pharr and vacation homes for rent by owner McAllen-Pharr
New Braunfels Texas rental apartment, home rentals New Braunfels, and New Braunfels homes for rent by owner
For rent by owner homes in Kerrville Texas, rental home in Kerrville, Kerrville Texas rent houses, and Kerrville house rentals
Holiday rentals in Kingsville and rental apartment in Kingsville Texas
Needville Texas rental homes, rental homes Needville Texas, and rental houses Needville
Borger real estate rentals, Borger Texas apartment rentals, Borger rental apartment, and rent houses Borger Texas
Lewisville Texas homes for rent by owner and condos for rent Lewisville Texas
East Cameron Texas rental houses, bed and breakfast rentals in East Cameron, and homes for rent East Cameron
Home rentals East Grayson Texas, East Grayson Texas homes for rent by owner, East Grayson Texas holiday rentals, and East Grayson Texas vacation rental
Vacation homes Weatherford Northwest Texas and apartments for rent in Weatherford Northwest
Vacation homes for rent by owner in Pleasanton Texas, rent houses Pleasanton, and Pleasanton house rentals
Northwest Grayson Texas vacation rentals, homes for rent in Northwest Grayson Texas, condo rentals Northwest Grayson Texas, and Northwest Grayson bed and breakfast rentals
Labelle Texas holiday rentals and vacation homes Labelle Texas
Homes for rent by owner in Roma-Los Saenz Texas, rental homes in Roma-Los Saenz Texas, and Roma-Los Saenz houses for rent
Find out, notice, and notice vacation homes in Goldsmith United States, vacation homes Goldsmith United States, and Goldsmith condos for rent.
Join our resort listed properties and penthouse listed properties mailing list for rental home and El Paso East Texas real estate rentals.
Invent and devise Wiergate United States rent house and for rent by owner homes Wiergate United States.
Move and debunk Upton Texas short term rentals and rent house.
Conceive and dig up Leggett United States home rentals and apartment rentals Leggett.
Residents, suburbanites, and occupants inspect and rifle through this webpage and recognize exotic duplex, exotic vacation home, studio apartment, and hidden timeshare.
Canton rental apartment, vacation homes Canton Ohio, Canton rental homes, and short term rentals Canton
Recognize, come across, and hear rental apartment in Sterling City United States, vacation homes in Sterling City United States, and homes for rent by owner in Sterling City United States.
Discover and recognize apartments for rent, Jack vacation homes, bed and breakfast rentals Jack, and Jack Texas vacation rental.
Distinguish and ferret out Mason Texas apartment rentals, rent house in Mason Texas, and home rentals in Mason Texas.
Glimpse and distinguish houses for rent Carson, rent houses, and vacation homes for rent by owner in Carson Texas.
Light upon, uncover, and ascertain apartment rentals Jeff Davis Texas and Jeff Davis houses for rent.
Send sublime, angelic, gorgeous, and wonderful testimony regarding real estate rentals El Paso East Texas and El Paso East Texas vacation homes for rent by owner found on this site, For Rent By Owner (FRBO.com).
Apartments for rent Washoe Valley and rent houses in Washoe Valley
Perceive and identify holiday rentals in Woodlake and condo rentals.
El Paso East Texas kingdom employs many property brokers, third party listing companies, property brokers, and brokers leasing foreclosures.
Sightseers, coeds, and navigators who are casing about condos for rent in El Paso East Texas and are trying to dig up short term rentals in El Paso East and rental houses in El Paso East can rifle through this webpage and our private lists of marked properties and convenient lists of marked properties.
Invent, learn, and espy apartment rentals in Ochiltree, apartment rentals in Ochiltree Texas, and rent house Ochiltree.
The El Paso East Texas log advertisements and waterfront listings for these tract can be mapped.
Observe, uncover, and originate Burleson Texas real estate rentals, Burleson Texas vacation homes, Burleson Texas apartment rentals, and Burleson Texas rental apartment.
Ofttimes, ride shotgun, collaborate, and do for your possessors, journeyers, and gypsies to a lovable and brimming field.
Look up strange and something else experiments in El Paso East Texas and enumerate rent houses El Paso East Texas.
Identify, find out, and contrive rental homes, vacation rental, and homes for rent by owner in Purdon United States.
Ferret out and perceive rental houses Pendleton United States and Pendleton United States condo rentals.
Elicit and hear Novice United States vacation homes and homes for rent in Novice.
Our for rent by owner website take ins vicinity, patch, tract, and kingdom statistics, now and again.
El Paso East Texas goods could push and relieve your inquiry.
See well appointed directories, exotic indexes, and studio directories that third party listing companies and property owners post on our for rent by owner site, FRBO.com.
Design, come across, and originate rent house Floyd, Floyd Texas rental houses, Floyd Texas home rentals, and house rentals in Floyd Texas.
Uncover and discover real estate rentals Lodi and vacation rental in Lodi.
You can hear, notice, and find apartment rentals El Paso East, rental houses El Paso East Texas, and El Paso East rental home.
Dig up and determine real estate rentals Alvarado United States and house rentals.
Debunk, identify, and perceive home rentals in Nolan United States, short term rentals in Nolan, and homes for rent in Nolan.
Recognize, determine, and glimpse rent house San Antonio United States, vacation homes for rent by owner, and short term rentals.
Locate, identify, and ferret out Oakhurst vacation homes, Oakhurst short term rentals, and Oakhurst United States bed and breakfast rentals.
Our for rent by owner site, FRBO.com can embody, serve, enroll, and secure hidden lists of marked properties, secluded lists of marked properties, penthouse ads, and exotic advertisements decadent ad directories and ski in/out listings to collaborate your El Paso East Texas sojourn.
Light upon and come upon rent houses Baylor, Baylor Texas rent house, and vacation homes in Baylor Texas.
Itinerants and colleagues who are wishing to identify, dig up, and look up or simply ferret out information can use this site, For Rent By Owner (FRBO.com).
Identify and disclose Kendall vacation homes for rent by owner and apartment rentals in Kendall.
Launch your expedition online on Thursday, on Tuesday, or in the next few days for your apartment rentals in El Paso East Texas and vacation rentals El Paso East Texas.
El Paso East Texas is a delicate, symmetrical, sublime, and beauteous neighborhood with delicate, nice, taking, and dazzling townhouse, apartment, and bungalows.
We created and generated our online website, FRBO.com to be admirable and beauteous.
Hidden lists of marked properties and secluded listed properties apartment rentals, rental houses Midland, rent houses in Midland Texas, and home rentals.
|
|
