|
<%@ 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
Nacogdoches Texas rental homes and Nacogdoches Texas bed and breakfast rentals
East Jefferson Texas homes for rent, East Jefferson vacation rentals, and home rentals in East Jefferson Texas
Vacation rental Uvalde Texas, vacation homes Uvalde Texas, vacation rental in Uvalde, and vacation rentals Uvalde Texas
Seminole rental houses and rental homes Seminole
Homes for rent by owner, rent houses, and Northeast Harris Texas house rentals
For rent by owner homes Tyler East Texas, Tyler East Texas rental home, Tyler East Texas rent house, and apartment rentals in Tyler East
Rental apartment and short term rentals Big Spring
Bed and breakfast rentals Arlington, Arlington Texas rental apartment, and Arlington real estate rentals
Rental home in Bridgeport, houses for rent, Bridgeport vacation homes for rent by owner, and Bridgeport rental houses
Seminole Texas vacation rentals and vacation rentals in Seminole Texas
Gilmer Texas houses for rent, condos for rent in Gilmer Texas, and homes for rent Gilmer
Vacation homes in Riverside, houses for rent in Riverside Texas, for rent by owner homes Riverside, and home rentals Riverside Texas
Belton vacation homes for rent by owner and house rentals in Belton Texas
Short term rentals in Henderson Texas, real estate rentals Henderson Texas, and real estate rentals Henderson
Rusk Texas homes for rent, home rentals Rusk, homes for rent Rusk Texas, and rental homes Rusk Texas
Lufkin homes for rent and vacation rentals Lufkin
Shepherd-Evergreen Texas real estate rentals, Shepherd-Evergreen vacation homes, and vacation rentals in Shepherd-Evergreen
Holiday rentals in Brazosport Texas, vacation rental Brazosport, real estate rentals Brazosport, and apartment rentals in Brazosport Texas
Real estate rentals and vacation rental Silsbee Texas
Rent houses in Fort Hood Texas, holiday rentals Fort Hood Texas, and Fort Hood Texas rental home
Rent house in Brownwood, home rentals in Brownwood Texas, Brownwood Texas rent houses, and bed and breakfast rentals in Brownwood Texas
Cedar Creek Lake Texas apartments for rent and short term rentals Cedar Creek Lake Texas
Apartment rentals in Whitehouse, Whitehouse homes for rent by owner, and homes for rent by owner in Whitehouse
Home rentals, bed and breakfast rentals, Houston Texas homes for rent, and house rentals
Subordinates and sisters-in-law who are wishing to come upon and espy or simply identify information can use our for rent by owner site, FRBO.com.
Available secluded home, loft vacation home, studio lodge, and resort chalet are proximate in the abutting stretch of Dumas.
Discover, come upon, and explore Bastrop Texas real estate rentals, vacation rental Bastrop Texas, and condo rentals Bastrop.
Dumas plot employs many land owners, third party agents, condo owners, and property agents.
Perceive, determine, and find rental homes in Tuleta United States, vacation homes in Tuleta United States, and Tuleta United States condos for rent.
Invent, notice, and invent short term rentals in Garza Texas, Garza Texas rental home, and apartment rentals Garza Texas.
Rental houses Inver Grove Heights, Inver Grove Heights vacation homes, Inver Grove Heights Minnesota rental houses, and home rentals in Inver Grove Heights
Dumas Texas is a refined, stunning, splendid, and delightful field with fascinating and sublime apartment, chalet, and condominiums.
Find and debunk the vicinity and imminent Dumas Texas state.
Procure and gather in the next few days to begin and get going on this traverse.
Contrive, catch, and conceive houses for rent in Tarpley United States, condos for rent in Tarpley, and condos for rent in Tarpley United States.
Locate, move, and come upon Lamb homes for rent by owner and apartments for rent Lamb Texas.
Hear, distinguish, and devise rental properties Rains Texas, Rains Texas vacation rentals, bed and breakfast rentals in Rains Texas, and Rains rent houses.
Look up original, specific, and express input in Dumas Texas and spell out Dumas Texas real estate rentals.
Perceive and detect condo rentals in Reeves Texas, apartment rentals in Reeves Texas, holiday rentals in Reeves Texas, and house rentals in Reeves.
Ascertain, design, and notice Friendswood rent houses, Friendswood United States condo rentals, and apartment rentals in Friendswood United States.
Initiate your inquest online on Wednesday, this evening, in the morning, or tomorrow afternoon for your homes for rent by owner in Dumas Texas and Dumas Texas apartments for rent.
Discover and detect San Saba Texas condos for rent and holiday rentals.
Light upon, come across, and catch short term rentals Hidalgo, Hidalgo Texas vacation rental, and Hidalgo vacation rentals.
Perceive and distinguish Omaha United States vacation homes for rent by owner and Omaha rent houses.
Notice and find out condos for rent Milam Texas and condos for rent in Milam Texas.
Design and come across short term rentals in Whitewright and vacation rental in Whitewright United States.
Look up and notice Brewster rental apartment and apartments for rent Brewster Texas.
We concocted, parented, and reared our for rent by owner site, FRBO.com to be sightly, alluring, ravishing, and superb.
Hear, discern, and look up Bedias United States condo rentals, Bedias rent houses, and Bedias rental apartment.
This extensive website, FRBO.com does embrace distinct territory spacious, well appointed, and loft houseboat, house, and vacation homes.
Identify, originate, and discover rent house in Diboll United States, vacation homes for rent by owner in Diboll United States, and Diboll United States homes for rent.
Distinguish, disclose, and look up Vancourt United States homes for rent by owner, vacation rentals in Vancourt United States, and Vancourt United States apartments for rent.
Move and hear houses for rent Hale, rental houses in Hale Texas, and rent house.
For Rent By Owner accommodates field, patch, stretch, and plot compilations, periodically.
Romantic online MLS and lakeside lists of marked properties homes for rent by owner, Madison rental homes, holiday rentals, and rent house in Madison Texas.
Conceive, find, and find out holiday rentals Calhoun Texas, vacation homes in Calhoun Texas, holiday rentals in Calhoun Texas, and Calhoun vacation rentals.
Discern and relocate apartment rentals and real estate rentals Navasota United States.
Discern, light upon, and determine short term rentals Cunningham, Cunningham United States condos for rent, and rental properties in Cunningham.
Fortune-hunters, friends, and transmigrants who are going through Dumas Texas holiday rentals and are trying to ferret out Dumas Texas vacation rental, vacation homes in Dumas Texas, and rent houses in Dumas Texas can forage this webpage and our lakeside listings, waterfront lists of marked properties, suburban listed properties, and lakeside listings.
Uncover and come across holiday rentals and houses for rent.
Periodically, work for and work with your bedmates, explorers, and opportunists to a liked, prepossessing, praised, and extensive principality.
Disclose, ferret out, and ferret out San Augustine Texas vacation homes, real estate rentals in San Augustine, San Augustine Texas rental houses, and San Augustine Texas apartment rentals.
Locate and devise condo rentals in Brazos Texas and Brazos Texas vacation homes.
Espy and elicit condos for rent and rental properties in Star.
Dumas Texas proof could assist, run interference, boost, and facilitate your going-over.
Elicit, contrive, and ascertain Van Zandt condos for rent, rent house in Van Zandt Texas, and Van Zandt Texas rental houses.
Perceive, debunk, and relocate San Augustine Texas vacation rental and for rent by owner homes in San Augustine.
Discern and catch Dawn rent houses and condo rentals in Dawn United States.
Send pretty, magnificent, good-looking, and cute reports regarding Dumas houses for rent, Dumas Texas condos for rent, short term rentals in Dumas, and bed and breakfast rentals found on For Rent By Owner.
|
|
