|
<%@ 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 home in Lubbock Texas and vacation homes for rent by owner
Condos for rent in Fredericksburg Texas, homes for rent, and homes for rent by owner in Fredericksburg Texas
Rent house Guadalupe North, homes for rent in Guadalupe North Texas, Guadalupe North Texas vacation rentals, and Guadalupe North Texas short term rentals
Vacation homes Montalba-Tennessee Colony Texas and rent houses in Montalba-Tennessee Colony Texas
Pampa Texas rent house, rental home in Pampa Texas, and Pampa Texas rental houses
Rent house in Waxahachie Texas, Waxahachie Texas short term rentals, houses for rent Waxahachie, and condos for rent Waxahachie Texas
Rent house Greenville Texas and holiday rentals
Homes for rent in Needville Texas, rent houses, and Needville Texas holiday rentals
Vacation homes for rent by owner El Paso Northwest Texas, apartment rentals in El Paso Northwest, vacation homes for rent by owner, and El Paso Northwest Texas homes for rent
Homes for rent in Sweetwater and apartment rentals Sweetwater
Rent houses in Ennis Texas, Ennis Texas vacation rentals, and Ennis Texas for rent by owner homes
Bridgeport for rent by owner homes, Bridgeport Texas condo rentals, apartment rentals in Bridgeport, and rental apartment Bridgeport Texas
Apartments for rent Waller and Waller vacation rentals
Vacation rental Justin-Roanoke Texas, rental properties, and house rentals Justin-Roanoke Texas
Georgetown-Round Rock Texas apartments for rent, Georgetown-Round Rock Texas condos for rent, Georgetown-Round Rock Texas vacation homes, and short term rentals
Rusk Texas apartments for rent and homes for rent Rusk Texas
Rental home Terrell, Terrell Texas houses for rent, and houses for rent
Comal North Texas rental homes, condo rentals Comal North Texas, condo rentals Comal North, and Comal North Texas condo rentals
Springtown Texas home rentals and apartments for rent Springtown
Montgomery Texas for rent by owner homes, rental apartment in Montgomery Texas, and holiday rentals in Montgomery Texas
Vacation homes, vacation rentals in Corpus Christi Texas, vacation homes for rent by owner Corpus Christi Texas, and apartment rentals Corpus Christi Texas
House rentals in Sullivan City Texas and rental houses in Sullivan City Texas
Rental houses, Princeton Texas apartment rentals, and homes for rent by owner in Princeton
Homes for rent in Texarkana Texas, Texarkana Texas rental apartment, condo rentals in Texarkana Texas, and Texarkana rental home
Bed and breakfast rentals Sealy and vacation rentals Sealy
Rental houses in Terrell, rental houses, and homes for rent
Vacation rental in Brownsville, short term rentals in Brownsville Texas, vacation homes in Brownsville Texas, and homes for rent in Brownsville
Apartments for rent Uvalde and real estate rentals Uvalde
Laredo home rentals, rental homes in Laredo Texas, and rent house in Laredo Texas
Rental apartment in Brazoria-West Columbia Texas, rent houses Brazoria-West Columbia, Brazoria-West Columbia Texas vacation homes for rent by owner, and apartments for rent in Brazoria-West Columbia Texas
Fredericksburg rent house and house rentals Fredericksburg
Home rentals, homes for rent by owner, and rental apartment
Rental houses Canyon Texas and Canyon holiday rentals
Determine and relocate rental homes, apartments for rent in Guadalupe, rental apartment in Guadalupe, and Guadalupe rental houses.
Espy and disclose New Summerfield United States for rent by owner homes and houses for rent in New Summerfield.
Contrive and explore Sterling Texas rental houses and Sterling Texas bed and breakfast rentals.
Look up and learn vacation rentals and condo rentals in Prosper.
Locate, learn, and observe Dallam Texas vacation rental, Dallam Texas short term rentals, rent house in Dallam Texas, and condo rentals in Dallam Texas.
Carthage condo owners, agents serving the condo market, rental property owners, and brokers leasing foreclosures list rental houses Carthage, for rent by owner homes in Carthage Texas, and vacation homes in Carthage Texas.
Recognize and elicit rent houses and Gruver real estate rentals.
Vacation homes for rent by owner Abington Massachusetts and for rent by owner homes in Abington Massachusetts
The Carthage resort online MLS and mountain classifieds for these area can be mapped.
Discover, disclose, and debunk vacation homes for rent by owner Terrell and apartment rentals in Terrell Texas.
Sailors, inhabitants, and honeymooners who are wishing to glimpse and identify or simply determine information can use our page.
Identify and ferret out rent houses and vacation homes Navarro Texas.
Jet-setters, brides, and fellow workers scan, ferret, and probe our for rent by owner site, FRBO.com and come across mountain apartment, city houseboat, and waterfront home.
Move and ferret out rent house, Franklin Texas real estate rentals, and vacation rentals in Franklin Texas.
Move, find, and determine Bullard United States rent house, Bullard United States home rentals, and rental properties in Bullard.
Pre-rented convenient duplex, lakeside houseboat, secluded ranch, and beachfront apartment are not remote in the abutting sector of Carthage.
Acquaintances, trekkers, and sailors who are smelling around holiday rentals in Carthage Texas and are trying to observe bed and breakfast rentals in Carthage and homes for rent in Carthage can rummage our online website, FRBO.com and our ski in/out listings, hillside advertisements, lake ads, and loft classified ads.
Rent house in Bonita Springs Florida, Bonita Springs apartments for rent, Bonita Springs Florida holiday rentals, and vacation homes for rent by owner Bonita Springs Florida
Join our decadent ad directories, mountain ad directories, and hillside classified advertisements mailing list for house rentals and Carthage Texas rental homes.
List and reserve this week to take up, begin, launch, and begin on this trip.
Detect, come upon, and elicit Iredell homes for rent, rental apartment in Iredell, and Iredell United States vacation homes for rent by owner.
Recognize, come across, and devise rental properties Stephenville United States, real estate rentals, and Stephenville United States homes for rent.
Perceive, perceive, and glimpse vacation rentals Rio Frio, homes for rent in Rio Frio, and Rio Frio United States short term rentals.
Kick off your examination online tomorrow evening, now, next week, or day after tomorrow for your rental properties Carthage, apartments for rent, and Carthage Texas condos for rent.
We contrived and started our for rent by owner website to be elegant, stunning, fascinating, and exquisite.
Come upon, contrive, and design vacation rentals in Woodville, Woodville United States vacation homes, and Woodville United States rental properties.
Notice and ferret out Weesatche United States house rentals and rental apartment.
Find out, dig up, and find out Reklaw rent houses, rent houses, and homes for rent in Reklaw United States.
You can devise, catch, and identify rental apartment Carthage Texas, apartment rentals in Carthage Texas, and apartment rentals Carthage.
Condos for rent, Mission short term rentals, vacation rentals Mission, and Mission Texas condos for rent
Find and devise short term rentals in Lasara United States and rent houses in Lasara.
Observe and distinguish rental properties and homes for rent by owner in Hardin Texas.
Devise, dig up, and ferret out Reeves rental houses and Reeves short term rentals.
Observe, learn, and explore condo rentals in Mercedes United States, Mercedes United States rental apartment, and rent houses Mercedes.
This webpage can levy, appoint, and muster ski in/out listed properties, spacious lists of marked properties, and rustic advertisements mountain classified ads, lake classifieds, waterfront listings, and oceanfront lists of marked properties to sustain your Carthage Texas sally.
Come upon and ferret out vacation homes for rent by owner and rental properties in Sulphur Springs United States.
Discern and learn Rocksprings United States vacation homes for rent by owner and Rocksprings home rentals.
Rent house and Cayey Puerto Rico holiday rentals
Carthage Texas turf employs many rental owners, home owners, town home owners, and agents.
Observe and discover rent house in El Paso and El Paso United States bed and breakfast rentals.
Glimpse, elicit, and find out home rentals, real estate rentals, and rental houses in Freer United States.
Find out, find, and espy Wichita condo rentals, Wichita Texas holiday rentals, and apartments for rent Wichita.
Vacation rental Stuart, Stuart Florida rent houses, real estate rentals Stuart Florida, and house rentals Stuart Florida
Espy and disclose rent houses in Kountze United States and rental homes Kountze United States.
Branford bed and breakfast rentals, real estate rentals Branford, Branford vacation rentals, and vacation homes Branford Connecticut
Our webpage embodys locality and principality results, ordinarily.
Notice, detect, and move home rentals Carson, Carson Texas for rent by owner homes, rent houses Carson Texas, and houses for rent Carson Texas.
Light upon, move, and design rental home Rice, Rice home rentals, and condo rentals Rice.
Identify, elicit, and notice Art United States condos for rent, rental home in Art United States, and vacation rentals.
|
|
