Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:29:48.743' ,`MLSNumber` = '36385922' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = 'Dona Angell' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.294655' ,`Longitude` = '-95.563877' ,`PhotoCount` = '29' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '484500.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hidden Peak' ,`StreetNumber` = '135' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 36385922 - Built by Highland Homes - Ready Now! ~ Beautiful floor plan features an enhanced outdoor living area, pendant lighting over the kitchen island, built in appliances, painted kitchen cabinets, 8\' doors throughout 1st floor, master bay window in master bedroom, blinds throughout, Quartz countertops, Blinds and Sprinkler System!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '29/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 40\' and 50\'' ,`TaxAmount` = '' ,`TaxRate` = '2.9' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '204976256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:06:28.840' ,`MLSNumber` = '52927968' ,`ListAgentFullName` = 'Wendy Cline' ,`ListOfficeName` = 'Wendy Cline Properties Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758840' ,`Longitude` = '-96.376778' ,`PhotoCount` = '49' ,`PostalCode` = '78933' ,`RoomCount` = '16' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Lehrmann' ,`StreetNumber` = '1331' ,`StreetSuffix` = 'Road' ,`City` = 'Cat Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the Simple Country Life! Located just 45 minutes outside of Houston, on a 2 Acre Lot, this 2,850 sqft Modern Farmhouse looks like it is straight out of a Magazine! 10\' Ceilings, Hard Wood Floors, New Insulated Glass Front Windows, 3 Primary Bedrooms with On-Suite Baths, and a Kitchen with tons of Cabinet Space and a 9’x6’ Pantry with Built in Shelving for Optimized Organization! Work from Home in the Private office and Park all of your toys in the 30’x40’ Fully Insulated, Detached Garage with 3 10’x10’ Roll Up doors. In recent years there have been planted Live Oaks, Magnolia Trees, Ash, Crepe Myrtle Trees, Blue Berry & Black Berry Bushes, Plum, Orange & Peach Trees. Enjoy Cooking Out on the back porch during the daytime and Amazing Sunsets on the front porch at night. Newly Installed Galvalume Standing Seam Metal Roof, Wood Burning Fire Place, a 230 foot Deep Well with a 10’x12’ Well House, New Concrete Slab on Front Porch, both Water Heaters Replaced in 2018, and Much More!' ,`Acres` = '2' ,`Area` = '56' ,`BuilderName` = 'SIERRA CLASSIC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A-396 A LINK 2.000 AC & HOUSE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'A W Linke Surv Abs #396' ,`TaxAmount` = '5811' ,`TaxRate` = '1.5459' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '207211978' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:27:00.243' ,`MLSNumber` = '45185574' ,`ListAgentFullName` = 'Kelli Untermeyer' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.458998' ,`Longitude` = '-94.617398' ,`PhotoCount` = '50' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '845000.00' ,`Status` = 'Active' ,`StreetName` = 'Trinidad' ,`StreetNumber` = '2298' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beachfront bliss is what this meticulously maintained \"Little Pink House\" will give you. Outdoors you\'ll find a concrete patio area with sand shower, shell cleaning sink, built in picnic table. cargo lift and a fully fenced yard. The large deck is partially covered. When you walk into this tastefully furnished and decorated home, you won\'t want to leave. Each bedroom has it\'s own bath and there is half bath for guests. Cabinets galore, island w/wet bar, a beverage cooler and two refrigerators compliment the kitchen. Cozy up by the fireplace on cool Winter days while gazing out the windows at the Gulf of Mexico. This established rental is selling furnished.' ,`Acres` = '0.7531' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 3 BLK 1 SANDPIPER BEACH' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '32801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sandpiper Beach' ,`TaxAmount` = '8202' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '207522876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:20:57.020' ,`MLSNumber` = '44839933' ,`ListAgentFullName` = 'Asiya Qureshi' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538129' ,`Longitude` = '-95.592502' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '15' ,`ListPrice` = '2690000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow' ,`StreetNumber` = '5403' ,`StreetSuffix` = 'Road' ,`City` = 'Sugar Land' ,`BathsFull` = '9' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '8412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite waterfront Estate on 3+ acres in Private Pecan Manor Community. Gated entry with paved circular driveway. Magnificent entry doors lead to grand foyer with double staircases. Luxurious Great room w/soaring ceilings, antique stain glass windows, 2 story fireplace and designer chandeliers. Gourmet Chef\'s kitchen w/extended quartzite island, upscale appliances & custom cabinetry. Open concept living/dining have panoramic views of backyard. Stately floor plan 3 w/ensuite bedrooms downstairs. Primary Suite w/sitting area, spa like bath and his & her closets. Upstairs features 3 ensuite bedrooms, game room & huge Bonus room. Backyard Oasis with Resort style pool, expansive deck & kitchen. Detached (2565 sq.ft) guest house w/2 beds, 2 baths, kitchen, living, dining, & media room. Finest schools, lowest taxes, & great accessibility. Whole house generator, energy efficient geo thermal cooling & heating, tankless water heaters & much more! Entertainers Paradise! Option to buy furnished!' ,`Acres` = '3.05' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '0' ,`Legal` = '0054 WM S LITTLE, TRACT 19, ACRES 3.05, PECAN MANOR' ,`LotDesciption` = 'Cul-De-Sac,Water View,Wooded' ,`LotSize` = '132858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Ranch,Spanish,Split Level' ,`Subdivision` = 'Wm S Little' ,`TaxAmount` = '36885' ,`TaxRate` = '1.6629' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '207738814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:43:56.620' ,`MLSNumber` = '93923514' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947090' ,`Longitude` = '-95.777487' ,`PhotoCount` = '30' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '674853.00' ,`Status` = 'Active' ,`StreetName` = 'Legume' ,`StreetNumber` = '11107' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes-New Construction! Welcome home to your stunning NEW Preston III plan with a large open gable covered patio in the beautiful Master-Planned community of Bridgeland. Your NEW certified energy-efficient home boast top-notch design features including a dramatic tiered rotunda, luxurious 24x12in tile flooring, 8ft doors, and large 7in baseboards. Your dream open kitchen with a Texas-sized island features Graphite Quartz countertops & quality, modern cabinetry. Relax in your 2 story living room with a wall of energizing, energy-efficient windows, 36in gas log fireplace with remote, and stunning views of the rotunda and of your spacious backyard. The study with 8\' French doors & formal dining is on the 1st floor. The game room, Surround Sound Wired Media, & secondary bedrooms and baths are up! Cul-de-sac homesite with spacious backyard. You\'ll love this plan and neighborhood.' ,`Acres` = '0.21' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 BRIDGELAND PRAIRIELAND VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.46' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '208189561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:24:48.943' ,`MLSNumber` = '92030807' ,`ListAgentFullName` = 'David Gloger' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554125' ,`Longitude` = '-95.242289' ,`PhotoCount` = '7' ,`PostalCode` = '77581' ,`RoomCount` = '7' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Creek' ,`StreetNumber` = '2113' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Numerous updates throughout the home including new A/C, interior lighting, flooring, interior paint, roof, counter tops, window blinds, bathrooms, appliances and so much more. Fantastic split ranch style floor plan with large sunroom. This home is centrally located in the heart of Pearland with easy access to Beltway 8 and I45. Convenient to local schools, shopping and restaurants in minutes. No MUD or HOA!' ,`Acres` = '0.2261' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODCREEK SEC 3 (PEARLAND), BLOCK 2, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodcreek Sec 1-2-2a-3-4 Pear' ,`TaxAmount` = '5597' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '208764787' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:22:32.020' ,`MLSNumber` = '3727114' ,`ListAgentFullName` = 'Pamela Gabriel' ,`ListOfficeName` = 'Sand N Sea Properties, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.278494' ,`Longitude` = '-94.827980' ,`PhotoCount` = '23' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '270000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Saladia' ,`StreetNumber` = '2209' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious home is currently a vacation rental. Sits on 3 lots. Home is centrally located, near shopping, restaurants and more. Easy walk or bike ride to the beach and more. All rooms are large and spacious. Home is newly renovated. Kitchen updated with stainless appliances, cabinets and granite counters. Updated plumbing in bathroom area. Over sized fully fenced back yard with fire-pit. Additional Aramco window covers for added protection. Garage with work space. Home is perfect for vacation home, rental property, week-end getaway or full time residence. This beachy cottage is a successful vacation rental on Airbnb. Refrigerator, washer and dryer to stay with home. Furnishings negotiable.' ,`Acres` = '0.0707' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR S 40 FT OF LOTS 10,11 & 12 (10-3)' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '3078' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Colorado' ,`TaxAmount` = '3492' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705509' WHERE `Matrix_Unique_ID` = '208822852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:59:38.407' ,`MLSNumber` = '77722736' ,`ListAgentFullName` = 'Lynn Anderson' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = 'Emmanuel Nnabuo' ,`SellingOfficeName` = 'NB Elite Realty' ,`Latitude` = '29.841891' ,`Longitude` = '-95.717151' ,`PhotoCount` = '23' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '279900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Windcroft Hollow' ,`StreetNumber` = '20002' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2205' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New beautiful carpet in all bedrooms and the living/dining room. New water heater. Freshly painted and professionally cleaned. All 3 toilets have been replaced. Primary bedroom downstairs. Kitchen is large with a breakfast area included. Yard is fenced and has a patio. Game room upstairs with nook for TV. Great house for a family.' ,`Acres` = '0.1171' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 WINDSTONE COLONY SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Windstone Colony Sec 07' ,`TaxAmount` = '5672' ,`TaxRate` = '2.781' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209081659' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:44:40.250' ,`MLSNumber` = '73423722' ,`ListAgentFullName` = 'Juan Luis Macedo' ,`ListOfficeName` = 'MRG Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085342' ,`Longitude` = '-95.593249' ,`PhotoCount` = '39' ,`PostalCode` = '77375' ,`RoomCount` = '3' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Hufsmith Kohrville' ,`StreetNumber` = '22118' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNRESTRICTED COMMERCIAL Ideal for office in the front and warehouse /shop in the back with a separate entrance..\r\nWarehouse has 1,700 sqft and 16 feet tall with air condition. Heavily traveled street for good exposure for any business Plenty\r\nof additional room behind home for parking or business work etc.)--10 to 15 minutes to The Woodlands and excellent access to\r\nHwy 99...' ,`Acres` = '0.728' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 487A 487A-1 487B & 487B-2 TOMBALL OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '31712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BERNSHAUSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Blk 126 Tomball' ,`TaxAmount` = '5918' ,`TaxRate` = '2.1373' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209129222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:44:44.730' ,`MLSNumber` = '85837805' ,`ListAgentFullName` = 'Katherine Ware' ,`ListOfficeName` = 'Goldmount Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.333238' ,`Longitude` = '-95.550059' ,`PhotoCount` = '34' ,`PostalCode` = '77304' ,`RoomCount` = '3' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Timbers' ,`StreetNumber` = '2111' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 2 full bath home features an open floor plan, vinyl wood plank flooring throughout and is located minutes from Lake Conroe. Home is being sold as is, but new carpet and fresh paint will make this home like new! Schedule your appointment to view today, this one will go quick!' ,`Acres` = '0.1494' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Short Sale,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S974402 - THE WOODS OF CONROE 02, BLOCK 1, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6506' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woods Of Conroe 02' ,`TaxAmount` = '7037' ,`TaxRate` = '3.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209568308' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:37:45.407' ,`MLSNumber` = '59338477' ,`ListAgentFullName` = 'Lacy Glaspie' ,`ListOfficeName` = 'Mainstream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.196305' ,`Longitude` = '-95.120533' ,`PhotoCount` = '27' ,`PostalCode` = '77372' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Rio Blanco' ,`StreetNumber` = '27684' ,`StreetSuffix` = 'Drive' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2547' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 3-bathroom home on a 1.2-acre lot in the Rio Vista subdivision. Home features a spacious family room, high ceilings, fireplace, granite counter tops, formal dining, primary suite with huge walk-in closet, backyard has a covered patio with ceiling fan. Neighborhood features security patrol. Sold AS IS.' ,`Acres` = '1.21' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Real Estate Owned' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 3, LOT 34, ACRES 1.21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '52708' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '6552' ,`TaxRate` = '1.9783' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209575324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:37:04.830' ,`MLSNumber` = '42810562' ,`ListAgentFullName` = 'Jeanette Avellaneda' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748095' ,`Longitude` = '-95.603968' ,`PhotoCount` = '32' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashford Hollow' ,`StreetNumber` = '1722' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '****OPEN HOUSE MONDAY SEPTEMBER 5,2022 9:00 a.m. - 11:00 a.m****NEVER FLOODED! Beautiful single story home. This home has been remodeled with new flooring. Seller will be repainting before sale. Quick access to I-10 and close to shopping centers. Spacious detached garage offers extra space for storage. Don\'t miss out and schedule your appointment today!' ,`Acres` = '0.1928' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 11 ASHFORD SOUTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford South Sec 03' ,`TaxAmount` = '5052' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209831656' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:14:31.340' ,`MLSNumber` = '83814133' ,`ListAgentFullName` = 'Matthew Gullo' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763224' ,`Longitude` = '-95.705615' ,`PhotoCount` = '46' ,`PostalCode` = '77094' ,`RoomCount` = '17' ,`ListPrice` = '835000.00' ,`Status` = 'Active' ,`StreetName` = 'Foxtree' ,`StreetNumber` = '19310' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Drive onto Foxtree into an enchanted treelined street in Windsor Park Estates w/ timeless appeal! Marvel at this custom home w/ generous sized rooms throughout the intricate floor plan. Surrounded by high ceilings, hardwood floors, and the stone fireplace adds a blissful elegance to the living room. The culinary kitchen is a dream with the Sub-zero built-in fridge, two dishwashers, two ovens, and cooktop island. Your guests have plenty of options to come together from the upstairs media room to the downstairs family room to gather around the piano. There\'s plenty of storage space especially in the primary suite walk-in closet with custom shelving and drawers. Enjoy the dedicated guest suite that\'s on the other side of the home, away from the secondary bedrooms, with its own full bathroom and office space. Relax in the large backyard and take advantage of the private pool, pizza oven, or bonus exercise room behind the 3 car garage. This beautifully custom designed Katy home awaits you!' ,`Acres` = '0.3488' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 WINDSOR PARK ESTATES SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15192' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windsor Park Estates Sec 02' ,`TaxAmount` = '12443' ,`TaxRate` = '2.2423' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209890676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:57:25.980' ,`MLSNumber` = '60665315' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Cindy Watson' ,`SellingOfficeName` = 'Woodlands Realty, LLC' ,`Latitude` = '30.158148' ,`Longitude` = '-95.609462' ,`PhotoCount` = '14' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '340240.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lavender Lane' ,`StreetNumber` = '10022' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely brand NEW DR Horton Home!! Excellent location in Montgomery County! Lovely two story plan with designer details at every corner! Awesome game room space upstairs! Wonderful layout with open living spaces and modern finishes! Beautiful island kitchen with granite countertops and white cabinetry! Nice primary bedroom suite with spa like bath! Includes a useful covered patio and landscape package! Hurry and call TODAY!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 5 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Enclave at Dobbin' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705510' WHERE `Matrix_Unique_ID` = '209917138' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:15:38.047' ,`MLSNumber` = '93897764' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059976' ,`Longitude` = '-95.393413' ,`PhotoCount` = '34' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Stoney' ,`StreetNumber` = '2014' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1782' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This GORGEOUS 3 bedroom home has it all!! Massive family room(great for hosting small gatherings, open kitchen concept with Granite Countertops, bricked accents, beautiful cabinetry, wood laminate flooring, a large culdesac lot with lots of backyard space! Seconds away from I-45! Minutes from the Woodlands, etc! Hurry! This one won\'t last!' ,`Acres` = '0.1745' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 36 NORTH SPRING SEC 10' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Spring Sec 10' ,`TaxAmount` = '4618' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210058893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:49:21.343' ,`MLSNumber` = '3063493' ,`ListAgentFullName` = 'Shane McDermott' ,`ListOfficeName` = 'Coldwell Banker TGRE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.002547' ,`Longitude` = '-95.223414' ,`PhotoCount` = '32' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '1649000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewater Hwy County Road' ,`StreetNumber` = '5342' ,`StreetSuffix` = '' ,`City` = 'Freeport' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING BEACHFRONT HOME WITH UNOBSTRUCTED VIEWS OF GULF AND GALVESTON BAY!! - 5 Bedroom / 5 bath recently remodeled highraised home on large beachfront lot. Built in 2007, the home\'s layout & location makes it an ideal vacation rental w a long history of impressive income on the books. Spacious kitchen with a large island, granite countertops & stainless appliances opens to impressive living room w vaulted ceilings, gas fireplace & stunning views of the Gulf. The 5 bedroom 5 bath design allows it to accommodate both large & small groups. Grand first floor master bedroom has large unobstructed views of the water, private deck access & large master bath w jacuzzi tub. Additional primary suite on first floor w private bath, 3 additional bedrooms and game room on the second floor. Located on Bluewater Highway between Galveston & Surfside beach, short drive to the amazing Red Snapper Inn Restaurant, this grand home offers a true Gulf Coast experience. Living Galveston... it\'s a lifestyle' ,`Acres` = '0.8916' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEAHORSE ESTATES (A0029 S F AUSTIN) LOT 25' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '38838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Seahorse Estates' ,`TaxAmount` = '10190' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210130331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:41:58.310' ,`MLSNumber` = '60115765' ,`ListAgentFullName` = 'Fatima Dedic' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028653' ,`Longitude` = '-95.317051' ,`PhotoCount` = '50' ,`PostalCode` = '77338' ,`RoomCount` = '15' ,`ListPrice` = '339799.00' ,`Status` = 'Active' ,`StreetName` = 'Fox Hillside' ,`StreetNumber` = '21230' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE!2018.4BR,2.5BTH,lg 2car garage,cvrd porch,lg 2car driveway+MORE!Home was built by Foxwood Builders.Beautifully positioned,this home BEAMS w/NAT. LIGHT!!Many upgds:IMPRESSIVE 30 ct roof mnt 9.44KW!!Solar Panel Systm-Freedom Forever,25yr wty!!Installed 2020.Entire home Wtr Softener Systm Whirpool WHES44 LL44 & WTR Fltr Systm Pelican PC600!Rubbermaid 7X7ft Resin shed on 10X10 ft cement slab. SimpliSafe Hme Secty System,10X15 ft bckyrd area covered w/landscape stones.STAINLESS STEEL BUILT IN GE appliances:microwave,gas stove top w/owen,dishwshr.CLASSY side by side GE refrigerator!!Are you a professional who travels for work,an avid golfer,bird watcher,horseback rider,cyclist,nature admirer, a stay at home parent w/ the children who likes shopping & discovering an upscale restaurants & new cuisine?If so, you NEED to see this home!Seller accepting CASH OFFERS!!!GREAT RENTAL POTENTIAL!THIS HOME HAS IT ALL!! Minutes to GORGEOUS trails,golf club,parks,George Bush Airport,US-59,I-45,Hardy' ,`Acres` = '0.1117' ,`Area` = '12' ,`BuilderName` = 'Foxwood Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 FOXWOOD SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4887' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '310' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,No Photos/No Videos' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210142863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:04:17.843' ,`MLSNumber` = '3840172' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014744' ,`Longitude` = '-93.834893' ,`PhotoCount` = '24' ,`PostalCode` = '77611' ,`RoomCount` = '7' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Devillier' ,`StreetNumber` = '329' ,`StreetSuffix` = '' ,`City` = 'Bridge City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique gem located in Bridge City-ISD! Soothing coastal hues with vaulted ceilings to allow natural light. Upstairs kitchen with elevated views to the second floor outdoor patio. Make yourself a cup of coffee or a cocktail and step right out to the deck to enjoy your birds eye view of the property. Freshened up and ready for you! Pack up and call this one HOME!' ,`Acres` = '0.64' ,`Area` = '50' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 11 DEVILLIER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '29316' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '367 - Bridge City' ,`SchoolElementary` = 'BRIDGE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BRIDGE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Devillier' ,`TaxAmount` = '2632' ,`TaxRate` = '2.3141' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210231796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:44:28.210' ,`MLSNumber` = '29705427' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947670' ,`Longitude` = '-95.777879' ,`PhotoCount` = '13' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '684867.00' ,`Status` = 'Active' ,`StreetName` = 'Legume' ,`StreetNumber` = '11119' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes-New Construction! Welcome home to the beautiful Hopkins III plan w/ added 8ft double front doors, , and an extended covered patio on a cul-de-sac street. Your NEW certified energy-efficient home boasts top-notch design features including a dramatic tiered rotunda foyer, luxurious tile, 8\' doors & large baseboards downstairs. Large open island kitchen w/ Valley White quartz countertops, quality Kentmoore white cabinetry & stainless appliances. 2 story Living room with a wall of energy-efficient windows features a gas log fireplace with remote. Study w/ 8ft double doors. Stunning master suite & bath with centerpiece freestanding tub. Game room & media room upstairs. Full security system and much more! A masterpiece of a home in the amazing & sought-after Master-Planned Bridgeland Community.' ,`Acres` = '0.19' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 BRIDGELAND PRAIRIELAND VILLAGE SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.46' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210340277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:31:31.470' ,`MLSNumber` = '14431474' ,`ListAgentFullName` = 'Eliosa Sanchez' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699510' ,`Longitude` = '-95.075335' ,`PhotoCount` = '11' ,`PostalCode` = '77351' ,`RoomCount` = '11' ,`ListPrice` = '999900.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn' ,`StreetNumber` = '724' ,`StreetSuffix` = 'Lane' ,`City` = 'Livingston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3213' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction home in gated community in Lake Livingston Texas, to be completed end of September 2022 with an open concept floor plan. This house has 5 bedrooms, 4 1/2 bath, 3 oversize car garage, covered front porch, covered patio, perfect for entertaining family and friends. Subdivision has easy access to Lake Livingston, has boat ramp to launch your boat and enjoy fishing, water sports and etc. Subdivision also has pool, tennis court, valley ball, club house, playground. Also has available condos to rent for overnight stays.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'TX Imperial Cons LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MEMORIAL POINT BLK 8 LOT 43 & 44' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Point' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210471848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:48:19.563' ,`MLSNumber` = '87221005' ,`ListAgentFullName` = 'Charles Schrader' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812431' ,`Longitude` = '-95.063060' ,`PhotoCount` = '11' ,`PostalCode` = '77562' ,`RoomCount` = '5' ,`ListPrice` = '164000.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '314' ,`StreetSuffix` = 'Street' ,`City` = 'Highlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1322' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect starter home located on a large corner lot. Home will have a new roof installed prior to closing. Needs a little tlc but is move in ready. Large rooms and plenty of storage.' ,`Acres` = '0.2296' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S 1/2 OF LTS 2A & 2B BLK 23 HIGHLANDS TOWNSITE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highlands Townsite' ,`TaxAmount` = '3402' ,`TaxRate` = '2.575' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705511' WHERE `Matrix_Unique_ID` = '210593104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:11:25.843' ,`MLSNumber` = '71332355' ,`ListAgentFullName` = 'Sarah Coburn' ,`ListOfficeName` = 'Stone\'s Throw Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.597054' ,`Longitude` = '-95.438511' ,`PhotoCount` = '22' ,`PostalCode` = '75844' ,`RoomCount` = '4' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'An County Road 1773' ,`StreetNumber` = '356' ,`StreetSuffix` = '' ,`City` = 'Grapeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy country living in this farmhouse style home located on 3.735 acres. The open concept kitchen and living area offer high vaulted ceilings with an oversized breakfast bar and modern ceiling fan. The split bedroom layout provides privacy to the primary bedroom and suite. The primary bath has a walk in shower, freestanding soaking tub and double sinks. The massive walk in closet has custom shelving and storage. The secondary bedrooms are on the opposite side of the home with access to the second bath. Front and back porches offer large expanses for relaxing and enjoying the property. Additional acreage adjoining the property is available. Whether you are looking for a country home or a weekend getaway you don’t want to miss this country home with a modern twist.' ,`Acres` = '3.735' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Elkhart Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COLBY MOREHEAD S/D #10 LOT 12' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '160300' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '65 - Slocum' ,`SchoolElementary` = 'SLOCUM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SLOCUM HIGH SCHOOL' ,`SchoolMiddle` = 'SLOCUM HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Colby Morehead Sub #10' ,`TaxAmount` = '196' ,`TaxRate` = '1.7418' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '210622171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:00:02.307' ,`MLSNumber` = '98429969' ,`ListAgentFullName` = 'Tamarah Curtis' ,`ListOfficeName` = 'Creighton Realty Partners, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.181195' ,`Longitude` = '-95.823773' ,`PhotoCount` = '31' ,`PostalCode` = '77355' ,`RoomCount` = '4' ,`ListPrice` = '234900.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '138' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peaceful country setting close to town in a picturesque neighborhood with a park overlooking a large fishing pond and community pool. This 3 bedroom/2 full bath home is situated on a .69 ACRE lot with many shade trees & huge storage shed/workshop. Roof was replaced 1 year ago and some updated paint inside.' ,`Acres` = '0.69' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S636000 OAK HOLLOW BLK 6 LOT 31 ACRES .69 S# PH0711706A HUD#' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '30056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hollow' ,`TaxAmount` = '2536' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '210710043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:41:04.443' ,`MLSNumber` = '67412854' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949121' ,`Longitude` = '-95.779370' ,`PhotoCount` = '21' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '644832.00' ,`Status` = 'Active' ,`StreetName` = 'Painted Lady' ,`StreetNumber` = '21218' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes-New Construction! Welcome home to your stunning NEW Preston III plan with a large open gable covered patio in the beautiful Master-Planned community of Bridgeland. Your NEW certified energy-efficient home boast top-notch design features including a dramatic tiered rotunda, luxurious 36x6in Herringbone pattern tile flooring, 8ft doors, and large 7in baseboards. Your dream open kitchen with a Texas-sized island features Valley White Quartz countertops & quality, Kentmoore cabinetry. Relax in your 2-story living room with a wall of energizing, energy-efficient windows, 36in gas log fireplace with remote, and stunning views of the rotunda and of your spacious backyard. The study with 8\' French doors & formal dining is on the 1st floor. The game room, Surround Sound Wired Media, & secondary bedrooms and baths are up! You\'ll love this plan and neighborhood.' ,`Acres` = '0.18' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 BRIDGELAND PRAIRIELAND VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.46' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '210773461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:31:36.250' ,`MLSNumber` = '32549143' ,`ListAgentFullName` = 'Joni Wolfswinkel' ,`ListOfficeName` = 'Real Property Management Prefe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028860' ,`Longitude` = '-95.444848' ,`PhotoCount` = '6' ,`PostalCode` = '77090' ,`RoomCount` = '4' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Oak' ,`StreetNumber` = '17920' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors! Property sold individually or as rental package. Text agent for details. SPACIOUS HOME WITH 3 LARGE BEDROOMS AND 3 BATHS! HUGE LIVING ROO WITH BRICK FIREPLACE FOR COZY NIGHTS. BEAUTIFUL WOOD FLOORS IN LIVING ROOM. ADORABLE KITCHEN WITH LOTS OF STORAGE. 3 CAR DETACHED GARAGE AND PATIO! VERY CONVENIENT LOCATION WITH EASY ACCESS TO I-45, BELTWAY 8,DINING AND SHOPPING NEARBY' ,`Acres` = '0.5466' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 & TR 9A BLK J PINE OAK FOREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23809' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BAMMEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Oak Forest Sec 01' ,`TaxAmount` = '4981' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '210878037' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:02:51.563' ,`MLSNumber` = '62660154' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810836' ,`Longitude` = '-95.406836' ,`PhotoCount` = '21' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '813500.00' ,`Status` = 'Active' ,`StreetName` = '27th St' ,`StreetNumber` = '537' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home with timeless architecture by Titan Homes. Thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. This is a hardworking, functional yet elegant show home. \r\n\r\nIndependent drive, expansive first floor living, elevator capable, oversize backyard, chef’s kitchen, grand master suite and massive game room. Let this elegant home showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Titan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 30, BLK 18' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '211010348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:44:53.330' ,`MLSNumber` = '14446625' ,`ListAgentFullName` = 'Linda Bone' ,`ListOfficeName` = 'Texans Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.025140' ,`Longitude` = '-95.415637' ,`PhotoCount` = '18' ,`PostalCode` = '77073' ,`RoomCount` = '0' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Mill' ,`StreetNumber` = '906' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2143' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful home with recent updates including beautiful wood floors. Home has been well taken care of by previous owner. Backyard is an oasis. This home was originally a 4 bedroom home but the owner elected to transform it into a primary bedroom with a guest suite with handicap access. Could easily be converted back to 3 or 4 bedrooms. This one you must see for yourself.' ,`Acres` = '0.287' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Probate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 INVERNESS FOREST SEC 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '675' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Inverness Forest Sec 01' ,`TaxAmount` = '4030' ,`TaxRate` = '2.5234' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '211135401' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:56:25.297' ,`MLSNumber` = '37604680' ,`ListAgentFullName` = 'Monica Montez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810837' ,`Longitude` = '-95.406761' ,`PhotoCount` = '20' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '813500.00' ,`Status` = 'Active' ,`StreetName` = '27th St' ,`StreetNumber` = '535' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home with timeless architecture by Titan Homes. Thoughtful design, exquisite finishes, tastefully executed intricate craftsmanship. This is a hardworking, functional yet elegant show home. \r\n\r\nIndependent drive, expansive first floor living, elevator capable, oversize backyard, chef’s kitchen, grand master suite and massive game room. Let this elegant home showcase your lifestyle.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Titan Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 31, BLK 18' ,`LotDesciption` = 'Other' ,`LotSize` = '3275' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Mediterranean,Spanish' ,`Subdivision` = 'Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705512' WHERE `Matrix_Unique_ID` = '211135755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:42:10.617' ,`MLSNumber` = '42362824' ,`ListAgentFullName` = 'Travis Edmunds' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.948135' ,`Longitude` = '-95.777655' ,`PhotoCount` = '13' ,`PostalCode` = '77433' ,`RoomCount` = '16' ,`ListPrice` = '689638.00' ,`Status` = 'Active' ,`StreetName` = 'Legume' ,`StreetNumber` = '11130' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes-New Construction! Welcome home to the NEW 5 Bedroom Carter IX plan w/ 2 bedrooms down. Your NEW certified energy-efficient home boast top-notch design features including a dramatic tiered rotunda, luxurious tile flooring, 8ft doors, & large 7in base trim which give the home a custom feel. The spacious open island kitchen has beautiful quartz countertops & quality cabinetry. The living room features a wall of energizing, energy-efficient windows, 36in gas log fireplace with remote and stunning views of the tiered rotunda in the living room. Study w/ 8ft double doors and formal dining on the 1st floor. Game room, media & 3 additional bedrooms upstairs. Spacious backyard with covered patio and no back neighbors in the beautiful sought-after Master-Planned community of Bridgeland!' ,`Acres` = '0.17' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 BRIDGELAND PRAIRIELAND VILLAGE SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.46' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705513' WHERE `Matrix_Unique_ID` = '211297864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:39:56.130' ,`MLSNumber` = '33831628' ,`ListAgentFullName` = 'Amanda Ham' ,`ListOfficeName` = 'AE Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.021630' ,`Longitude` = '-95.543074' ,`PhotoCount` = '38' ,`PostalCode` = '77379' ,`RoomCount` = '6' ,`ListPrice` = '424999.00' ,`Status` = 'Active' ,`StreetName` = 'Pheasant Glen' ,`StreetNumber` = '8115' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home zoned to highly acclaimed Klein ISD, located on a tree-lined street & just a short walk to the community center with \"mini Splashtown\", pool, fitness center, tennis courts, & park! 3062 sqft, 4 bedrooms, 3.5 baths with a large upstairs gameroom. The home is on a large lot with a long drive way, detached garage, and a beautiful pool. The formal dining, wet bar, and backyard make this home ideal for entertaining. Keep the kids upstairs with their 3 rooms, 2 bathrooms and a huge gameroom. This kitchen has an island and is a chef\'s gas stove. The master has 2 huge closets, a garden tub and a walk in shower. Great schools and has all the Memorial Northwest Amenities. The kiddos could walk to and from school. Make your appointment. This is owner occupied and will require at least 1 hour notice.' ,`Acres` = '0.2204' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 40 MEMORIAL NORTHWEST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest Sec 15' ,`TaxAmount` = '6372' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705513' WHERE `Matrix_Unique_ID` = '211449514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T09:06:52.580' ,`MLSNumber` = '94998099' ,`ListAgentFullName` = 'David Alvarado Listak' ,`ListOfficeName` = 'JWang Properties' ,`SellingAgentFullName` = 'Peter Gambertoglio' ,`SellingOfficeName` = 'Jason Mitchell Real Estate LLC' ,`Latitude` = '29.894356' ,`Longitude` = '-95.340392' ,`PhotoCount` = '16' ,`PostalCode` = '77039' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Fall Meadow' ,`StreetNumber` = '11735' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a first time home buyers dream! Properties under $250,000 in the Houston Metro area are nearly impossible to find. One that has been fully renovated to this extent, can only be referred to as: AN OUTSTANDING INVESTMENT. This property has been completely renovated. All systems: plumbing, electrical HVAC are new. It has a new roof , new HVAC, new kitchen, new 12 mm laminate floors throughout and porcelain tile in the wet areas, new doors, new baseboards, casing and trim, new appliances, new bathrooms, new texture and new paint (interior and exterior). New all fenced in back yard. Newly re-finished extended carport. All this work was finished on May of 2022. This property is in an area that has experienced incredible growth and great properties like this don\'t last long on the market. Minutes from downtown and close to major highways to be anywhere very conveniently. So don\'t wait! Schedule a showing asap.' ,`Acres` = '0.1591' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 13 HIGH MEADOWS SEC 9 R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'STEPHENS ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'MEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'High Meadows Sec 09 R/P' ,`TaxAmount` = '4629' ,`TaxRate` = '2.9881' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705513' WHERE `Matrix_Unique_ID` = '211451876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:05:23.643' ,`MLSNumber` = '20584500' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681778' ,`Longitude` = '-95.836917' ,`PhotoCount` = '8' ,`PostalCode` = '77406' ,`RoomCount` = '18' ,`ListPrice` = '709578.00' ,`Status` = 'Active' ,`StreetName` = 'Lyra Glen' ,`StreetNumber` = '10502' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Carter VI, Elevation KS) CURRENTLY BEING BUILT. Two Story cul-de-sac lot. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 35 BLK 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12672' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705513' WHERE `Matrix_Unique_ID` = '211853291' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','211941452','1663705513','211941452','2022-09-01T08:53:05.780','69887300','Harith Nelson','Redfin Corporation','','','29.942657','-95.641215','35','77429','9','279500.00','Active','Pennland','14431','Lane','Cypress','2','0','3','1760','Single-Family','Lovely single-story home with lots of charming details! Bright and cheery open concept living room flows easily into the kitchen featuring a breakfast bar, SS appliances, lots of cabinet and counter space, and an attached breakfast room with lots of natural light. Retreat to the extra-large primary bedroom with a spacious seating area that would make a great home office, reading nook, or nursery space. En-suite bath has dual sinks and large walk-in closet. Two more ample secondary bedrooms share a bath with dual sinks in a separate hallway for the ultimate in privacy! Don\'t miss the fully fenced backyard with a covered patio, perfect for entertaining! Recently replaced roof, AC, water heater, and disposal. Never flooded! Located in the highly rated Cy Fair School District. Conveniently located with easy access to highways, parks, shopping, and dining!','0.1188','10','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cypress North','Central Electric,Central Gas','1','LT 14 BLK 2 CYPRESS CHASE','Cleared','5175','Appraisal District','','375','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','LAMKIN ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Cypress Chase','4252','2.438','Public Sewer,Public Water','2006','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:49:13.067' ,`MLSNumber` = '33419233' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.770055' ,`Longitude` = '-94.958952' ,`PhotoCount` = '16' ,`PostalCode` = '77521' ,`RoomCount` = '8' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Thyme' ,`StreetNumber` = '4217' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2222' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 CROCKETT PARK' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '345' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Park' ,`TaxAmount` = '5549' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705513' WHERE `Matrix_Unique_ID` = '211987106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T08:04:21.870' ,`MLSNumber` = '33692106' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683905' ,`Longitude` = '-95.836706' ,`PhotoCount` = '27' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '464748.00' ,`Status` = 'Active' ,`StreetName` = 'Ashlesha' ,`StreetNumber` = '10803' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Terrace, Elevation A). CURRENTLY UNDER CONSTRUCTION. Two story. 4 bedrooms. 3.5 baths. Spacious island kitchen open to informal dining room and family room. Primary suite with large walk in closet. Large Game Room and three additional bedrooms upstairs. Covered patio and attached 2 car garage. Candela offers new homes for sale in Richmond, Texas. The community is the perfect combination of small-town charm and easy access to big city conveniences. Take a stroll through Downtown Historic Richmond, visit the Imperial Farmer\'s Market and enjoy the great outdoors at Brazos Bend State Park. Major employers in Houston, Katy and Sugar Land are only a short commute away. Great restaurants, and local and big box retail offerings are all close by. Visit Candela today to find your new home!' ,`Acres` = '0.1186' ,`Area` = '37' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 3, LOT 44' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.15' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705513' WHERE `Matrix_Unique_ID` = '211987676' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212028278','1663705513','212028278','2022-09-01T09:41:52.023','16522731','Amy Shelton','Fife Realty','','','30.125151','-95.461903','37','77380','8','419900.00','Active','N Dreamweaver','170','Circle','The Woodlands','2','1','4','2544','Single-Family','!!NEWLY RENOVATED!! Please see ADDITIONAL INFO PAGE!!This 4 bedroom 2.5 bathroom will surprise you at every turn. BONUS ROOM how about two!! You will love the neat and fun additions that have been added to make this home MOST comfortable. Space and Storage are no issue here. Did I mention RENOVATIONS?! Paint, flooring, kitchen cabinets, back splash and counter tops have turned this home into a GEM!! NEW NEW NEW Stainless Steel Appliances!! ATTIC SPACES, there are two all with wood flooring. Both attics have modern, metal stairs with built-in insulation. \r\nEasy access to I45 and 99! The Woodlands Pools and community offer entertainment for all ages. You will know your close when you see the beautiful tall trees that make The Woodlands a staple community. DO NOT MISS OUT!! This home will not last long!!','0.17','15','','','','','Sellers Disclosure','','','','The Woodlands','Central Gas','0','WDNLDS VIL GROGANS ML 65, BLOCK 3, LOT 15','Other','7412','Appraisal District','','','0','','2','','0','','','','','Composition','11 - Conroe','SAM HAILEY ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Seller','2','Traditional','WDNLDS VIL GROGANS ML','7380','2.18','Public Sewer,Public Water','1994','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212063036','1663705514','212063036','2022-09-01T08:13:14.403','56788904','Bobbie Alexander','Alexander Properties','','','29.908762','-95.753693','18','77433','9','473151.00','Active','Riverton Ridge','8811','Road','Cypress','3','0','4','2414','Single-Family','MLS#56788904 November Completion - The Darling Collection 4201 I3 plan at This modern two story home features an open-concept family and dining areas with magnificent high ceilings! Beautiful windows flood the family and dining rooms with natural light showing off the flooring throughout the main living areas. The island kitchen is as alluring as it is functional, featuring built-in appliances and omega stone countertops. Rounding out this home is a walk-in utility room, mud room, owner\'s suite and guest bedroom downstairs, two bedrooms with full bathroom and game room upstairs. Structural options added to 8811 Riverton Ridge Road include: a covered outdoor living, open railing, alternate owner\'s bath layout, optional sink at bath three, gas line.','0.122','25','Taylor Morrison','','Electric Dryer Connections,Washer Connections','','Mud','1','','0','Cypress South','Central Gas','1','Lot 3, Block 3 of Avalon at Cypress Section 1','Subdivision Lot','5346','Survey','','1200','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','BRIDGELAND HIGH SCHOOL','SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','2','Contemporary/Modern','Avalon at Cypress 40\'s','','3.59','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212063377','1663705514','212063377','2022-09-01T08:22:21.243','67730148','Ronnie Matthews','D.R. Horton Homes','','','30.232808','-95.705226','8','77354','4','305915.00','Active','BIRCH SHADOWS COURT','40563','','Magnolia','2','0','4','1750','Single-Family','Exceptional Open Concept 4 bedroom 1 story home! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!','','15','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Magnolia/1488 West','Central Gas','1','16/5/5','Subdivision Lot','6647','Other','','750','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Mill Creek','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212063779','1663705514','212063779','2022-09-01T08:36:43.997','2507949','Ronnie Matthews','D.R. Horton Homes','','','30.232586','-95.705312','15','77354','4','312490.00','Active','BIRCH SHADOWS COURT','40503','','Magnolia','2','0','4','1868','Single-Family','Exceptional Open Concept 4 bedroom 1 story home! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!','','15','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Magnolia/1488 West','Central Gas','1','1/5/5','Subdivision Lot','6991','Other','','750','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Mill Creek','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212064567','1663705514','212064567','2022-09-01T08:55:00.483','2845620','Ronnie Matthews','D.R. Horton Homes','','','30.232141','-95.705054','8','77354','5','346990.00','Active','BIRCH SHADOWS COURT','40511','','Magnolia','2','1','4','2561','Single-Family','Brand NEW Exceptional 2 story Express Home in the best location!! This beautiful Open Concept home has a large kitchen that is open to the family room & dining room! Primary suite offers a HUGE walk in closet! Features include 30\" Flat panel maple cabinets w/ crown molding, exotic granite, 4 burner gas cooktop w/ SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting, Blinds and more! Large covered patio overlooks the private fenced backyard! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!','','15','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Magnolia/1488 West','Central Gas','1','3/5/5','Subdivision Lot','6916','Other','','750','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','MAGNOLIA PARKWAY ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Mill Creek','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212065813','1663705514','212065813','2022-09-01T09:24:53.103','89656164','Nancy Lawrence','Lawrence Realty','','','31.307263','-95.488010','48','75835','4','619000.00','Active','State Highway 7','557','','Crockett','2','1','4','4800','Single-Family','Once you drive through the cedar gates, you will meander your way to this beautiful home nestled in mature shade trees on 6.783-acres. This move-in-ready home has been hand touched by the owner. From the moment you enter the foyer, you will be amazed with the beautiful hardwood floors, vast living space, and game room complete with a bar and a wall of windows to bring the outside in. The main home is comprised of four bedrooms and two and one-half baths. In addition to these bedrooms are large walk-in closets and vast vanity areas. Off the living area and game room, you will find the formal dining room that is placed perfectly next to the amazing sunlit kitchen with gorgeous granite countertops and beautiful views overlooking the property. Just off the kitchen, is a covered walkway that leads to the two-car garage apartment. The apartment is complete with a full bedroom, loft area that could be used as a second bedroom, full bath, living room, and quaint kitchen. Call today!','6.783','41','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace,Wood Burning Fireplace','2','Crockett Area','Central Electric,Central Gas,Heat Pump','0','F JOHNSON AB 46 6.783 AC','Wooded','295467','Appraisal District','','','0','','2','Double Oven','0','','','Gas Range','','Composition','57 - Crockett','CROCKETT ELEMENTARY SCHOOL (CROCKETT)','CROCKETT HIGH SCHOOL (CROCKETT)','CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)','Appointment Required','Seller','1','Ranch','NA','4778','1.8725','Public Water,Septic Tank','0','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212066062','1663705514','212066062','2022-09-01T09:23:19.833','64795601','Bobbie Alexander','Alexander Properties','','','29.708890','-95.871267','14','77441','9','583009.00','Active','Rising Moon','28722','Lane','Fulshear','2','1','3','2487','Single-Family','MLS#64795601 Built by Taylor Morrison, November Completion! An adorable front porch perfect for relaxing evening chats is a welcoming start, followed by an impressive foyer. Tucked near the foyer is a study with a half bath just steps away. Further down the foyer the heart of this home opens to the kitchen, dining and gathering room. The island kitchen is the perfect place to entertain guests while cooking and spending time together before retreating to the large gathering room overlooked by a wall of windows. Two equally sized guest rooms share a hall bath, and the owner\'s suite features separate closets, dual vanities and large walk-in shower. Home is close out section and no back neighbors! Bonterra is a master-planned community designed for 55+ home buyers who are ready to take advantage of the lifestyle that’s possible with resort style living. Structural options for 28722 Rising Moon Lane include: walk in shower at owner\'s bath, extended owner\'s suite, fireplace, study.','','30','Taylor Morrison','','Electric Dryer Connections,Washer Connections','','Approved Seniors Project,Exclusions,HOA First Right of Refusal,Home Protection Plan,Mud,Other Disclosures,Special Addendum','1','Gaslog Fireplace','1','Katy - Southwest','Central Gas','1','Lot 3 Block 1','Cul-De-Sac,Subdivision Lot','7520','Appraisal District','','2925','1','To Be Built/Under Construction','3','Electric Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','HUGGINS ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Bonterra at Cross Creek Ranch 60\'s','','3.37','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212067482','1663705514','212067482','2022-09-01T09:40:43.383','89797943','Bobbie Alexander','Alexander Properties','','','30.084764','-95.596364','32','77375','9','457676.00','Active','Raburn Run','1242','Lane','Tomball','2','1','3','2448','Single-Family','MLS#89797943 REPRESENTATIVE PHOTOS ADDED! Built by Taylor Morrison, Ready October - The beautiful Jasmine at Raburn Reserve is a two-story home design featuring a welcoming entry and a study with double doors for a great office space. As you go into the home, it opens to a sunny designer kitchen, dining area and gathering room with high ceilings. In the kitchen you find a large breakfast bar and step-in pantry. Your owner\'s suite is positioned for privacy at the back of the home, provides a peaceful haven where you can relax at the end of the day. Upstairs has a loft style game room two bedrooms and a bathroom along with a media room. Structural options added to 1242 Raburn Run Lane include: Media room, covered outdoor living 1, open stair railing and study.','','14','Taylor Morrison','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Tomball','Central Gas','1','LOT 32, BLOCK 2, OF RABURN RESERVE SEC. 1','Corner','7990','Survey','','760','1','To Be Built/Under Construction','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','TOMBALL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','2','Traditional','Raburn Reserve 50\'s','','2.436','Public Sewer,Public Water','2022','Builder'); --> New record created successfully